Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[TheBoy]

SQL Server 2005. Windows Authentication only.

Looks like the BUILT IN\Administrators has lost its SQL permissions, cannot log in.  Other accounts don't have any permissions beyond the database they query.

How can I get the Admin account working again

[cem_devecioglu]

phew..will search for some solution, never happened.. :-/

[sexydaz]

breaked if i know what yer on about,doesnt skruntie no abit about this sort of stuff

[STMO999]

breaked if i know what yer on about,doesnt skruntie no abit about this sort of stuff

 

No.

[cem_devecioglu]

solution for worst case,  stop sql server service, copy application database files somewhere else , re-install and add them from management studio (if db files are not huge)

[Jimbob]

I can ask a friend at work tomorrow if your still stuck

[TheBoy]

solution for worst case,  stop sql server service, copy application database files somewhere else , re-install and add them from management studio (if db files are not huge)

Thats what I'm just comtemplating now...

[TheBoy]

I can ask a friend at work tomorrow if your still stuck

Needs to be up right now, so I have time to resetup the replication, and for the replication to do its job before the shop opens in the morning.

[Mr Skrunts]

breaked if i know what yer on about,doesnt skruntie no abit about this sort of stuff

 

No.

Maybe not, the only thing I do when things like this happen is the following, then I go from lost to just totally confused.

http://www.google.co.uk/#hl=en&ei=GvxhS_PbK4_u0wSureyFAg&sa=X&oi=spell&resnum=0&ct=result&cd=1&ved=0CAYQBSgA&q=sql+server+BUILTIN\Administrators+has+lost+its+SQL+permissions&spell=1&fp=472eb943fb1a00a2

Inadvertly the answer might be in this link, but as I jnow sod all about SQL I shant say annother word.  (allthough we all know STOM will - even if it's just to complain about my spelling)

[STMO999]

breaked if i know what yer on about,doesnt skruntie no abit about this sort of stuff

 

No.

Maybe not, the only thing I do when things like this happen is the following, then I go from lost to just totally confused.

http://www.google.co.uk/#hl=en&ei=GvxhS_PbK4_u0wSureyFAg&sa=X&oi=spell&resnum=0&ct=result&cd=1&ved=0CAYQBSgA&q=sql+server+BUILTIN\Administrators+has+lost+its+SQL+permissions&spell=1&fp=472eb943fb1a00a2

Inadvertly the answer might be in this link, but as I jnow sod all about SQL I shant say annother word.  (allthough we all know STOM will - even if it's just to complain about my spelling)

 

[Mr Skrunts]

Did it on purpose, you pedantic sod

[STMO999]

Did it on purpose, you pedantic sod

Noe u dident

[Debs.]

I can ask a friend at work tomorrow if your still stuck

  Don`t you want to go 50/50 or ask the audience first?

[jimbobmccoy]

Is it a lost password issue or is a specific error/login failure message been thrown out?

[cem_devecioglu]

if you are going to make a re-install make a dual authentication so you can log on with both sa and administrator which I always use..