Omega Owners Forum
Chat Area => General Discussion Area => Topic started by: TheBoy on 28 January 2010, 20:50:21
-
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
-
phew..will search for some solution, never happened.. :-/
-
breaked if i know what yer on about,doesnt skruntie no abit about this sort of stuff
-
breaked if i know what yer on about,doesnt skruntie no abit about this sort of stuff
;D ;D ;D ;D ;D ;D ;D ;D ;D
No.
-
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)
-
I can ask a friend at work tomorrow if your still stuck
-
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...
-
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.
-
breaked if i know what yer on about,doesnt skruntie no abit about this sort of stuff
;D ;D ;D ;D ;D ;D ;D ;D ;D
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)
-
breaked if i know what yer on about,doesnt skruntie no abit about this sort of stuff
;D ;D ;D ;D ;D ;D ;D ;D ;D
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)
:-X
-
Did it on purpose, you pedantic sod ;D ;D
-
Did it on purpose, you pedantic sod ;D ;D
Noe u dident
-
I can ask a friend at work tomorrow if your still stuck
:P Don`t you want to go 50/50 or ask the audience first? ;D
-
Is it a lost password issue or is a specific error/login failure message been thrown out?
-
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..
-
I can ask a friend at work tomorrow if your still stuck
:P Don`t you want to go 50/50 or ask the audience first? ;D
;D ;D ;D
-
I think this can be useful :)
http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx
-
Blimey. That was a botty twitching moment :o. Bloody backups were corrupted as well :o
Fresh underpants on order....
-
Hoping your problem solved, in the link after they start in maintenance mode they can add an administrative account.. :y
-
Ouch! Sounds like a nasty moment.
Could have been worse though. What if Sammy wasn't lost? :-X
Kevin
-
Ouch! Sounds like a nasty moment.
Could have been worse though. What if Sammy wasn't lost? :-X
Kevin
Fortunately the 2 servers involved are 40 miles away, so quite safe.
IIRC, the ML370 is the one I (suspected) broke my toe on ::)
-
Ouch! Sounds like a nasty moment.
Could have been worse though. What if Sammy wasn't lost? :-X
Kevin
Fortunately the 2 servers involved are 40 miles away, so quite safe.
IIRC, the ML370 is the one I (suspected) broke my toe on ::)
Sounds like it needs a reboot. ;D
-
Ouch! Sounds like a nasty moment.
Could have been worse though. What if Sammy wasn't lost? :-X
Kevin
Fortunately the 2 servers involved are 40 miles away, so quite safe.
IIRC, the ML370 is the one I (suspected) broke my toe on ::)
Sounds like it needs a reboot. ;D
Sounds like TB needs a reboot, may I suggest steel toecaps this time. ;D ;D
-
Switch to Oracle!
Then give me a job. :)
-
Switch to Oracle!
Then give me a job. :)
Oracle on Windows. Errr, no thanks!
-
Switch to Oracle!
Then give me a job. :)
Oracle on Windows. Errr, no thanks!
They've just bought Sun Microsystems - treat yourself to a Unix system. :) :) :)
I am, of course, attempting to be humorous. :)
-
Ouch! Sounds like a nasty moment.
Could have been worse though. What if Sammy wasn't lost? :-X
Kevin
Fortunately the 2 servers involved are 40 miles away, so quite safe.
IIRC, the ML370 is the one I (suspected) broke my toe on ::)
That's a merc 4WD :-/
-
Ouch! Sounds like a nasty moment.
Could have been worse though. What if Sammy wasn't lost? :-X
Kevin
Fortunately the 2 servers involved are 40 miles away, so quite safe.
IIRC, the ML370 is the one I (suspected) broke my toe on ::)
That's a merc 4WD :-/
nope HP ML370 server..name coincidence :y
-
Switch to Oracle!
Then give me a job. :)
Oracle on Windows. Errr, no thanks!
They've just bought Sun Microsystems - treat yourself to a Unix system. :) :) :)
I am, of course, attempting to be humorous. :)
I quite like Solaris. Proper Unix.
Wonder what Oracle will do with it, as they do their own Oracle Linux (basically Redhat with a search and replace done on source to put OEL in place of RHEL!)
-
My SQL knowledge is very limited,
But if it's a dedicated database server, could you not detatch the DB, backup the files - then either reinstall sql, or rebuild the OS from scratch? Is it just an mdf/ldf?
or as others say, hammer..... :y
-
Switch to Oracle!
Then give me a job. :)
Oracle on Windows. Errr, no thanks!
They've just bought Sun Microsystems - treat yourself to a Unix system. :) :) :)
I am, of course, attempting to be humorous. :)
I quite like Solaris. Proper Unix.
Wonder what Oracle will do with it, as they do their own Oracle Linux (basically Redhat with a search and replace done on source to put OEL in place of RHEL!)
Never liked Unix. Or to be more accurate, never found any rational way to communicate with it. It used to fall over all the time. Solaris was at least reliable.
Don't know anything about Oracle Linux - never actually heard of it before. Oracle on Redhat works well, but I don't know a lot about that end of it - I (used to) do logical design work mostly, with occasional bits of PL/SQL when needed. Personally, I never had any problems with Oracle on Windows, but them I'm not a production DBA. :) :) :)
-
Switch to Oracle!
Then give me a job. :)
Oracle on Windows. Errr, no thanks!
They've just bought Sun Microsystems - treat yourself to a Unix system. :) :) :)
I am, of course, attempting to be humorous. :)
I quite like Solaris. Proper Unix.
Wonder what Oracle will do with it, as they do their own Oracle Linux (basically Redhat with a search and replace done on source to put OEL in place of RHEL!)
Never liked Unix. Or to be more accurate, never found any rational way to communicate with it. It used to fall over all the time. Solaris was at least reliable.
Don't know anything about Oracle Linux - never actually heard of it before. Oracle on Redhat works well, but I don't know a lot about that end of it - I (used to) do logical design work mostly, with occasional bits of PL/SQL when needed. Personally, I never had any problems with Oracle on Windows, but them I'm not a production DBA. :) :) :)
Hi Jereboam ,
imho, just download a trial copy of sql 2005 desktop from microsoft site and try it.. its exactly the same as enterprise edition except the db engine.. you will find it quite practical and have many tools.. I guess you wont look back to expensive oracle.. :y
-
Hi Jereboam ,
imho, just download a trial copy of sql 2005 desktop from microsoft site and try it.. its exactly the same as enterprise edition except the db engine.. you will find it quite practical and have many tools.. I guess you wont look back to expensive oracle.. :y
Thanks for the advice. Shortly after I lost my job, I downloaded the Enterprise edition and went through it in detail. I was quite impressed, and learned a bit about what it can do. But working at home on my own isn't going to make me an expert. If I get the opportunity to use it as a Systems Analyst or Designer, I'll know what to do, but I'm never going to achieve DBA skills - don't have that sort of mind.
I was very pleased when the six months trial ran out - I got my PC back again - SQL Server absolutely knackered it. :) :) :)
-
Hi Jereboam ,
imho, just download a trial copy of sql 2005 desktop from microsoft site and try it.. its exactly the same as enterprise edition except the db engine.. you will find it quite practical and have many tools.. I guess you wont look back to expensive oracle.. :y
Thanks for the advice. Shortly after I lost my job, I downloaded the Enterprise edition and went through it in detail. I was quite impressed, and learned a bit about what it can do. But working at home on my own isn't going to make me an expert. If I get the opportunity to use it as a Systems Analyst or Designer, I'll know what to do, but I'm never going to achieve DBA skills - don't have that sort of mind.
I was very pleased when the six months trial ran out - I got my PC back again - SQL Server absolutely knackered it. :) :) :)
Trust me not too much effort required to be an MS SQL DBA.. You already know PL/SQL.. Routine things like back up,recovery, tuning with system parameters is mostly adequate..
I as a programmer learned everything myself from its documentary although took some time and mostly under disaster conditions ;D , briefly you learn very quickly in case of emergency..
Microsoft from time to time makes DBA exams from its books and documentary , you can get a certified DBA level easliy imho.. (but you need to pay money for those exams unfortunately)
ps: Enterprise edition mostly is for multiple CPU servers..Although initial configuration dont utilize too much system source.. You can get this by playing with parameters and configuration..
-
Hi Jereboam ,
imho, just download a trial copy of sql 2005 desktop from microsoft site and try it.. its exactly the same as enterprise edition except the db engine.. you will find it quite practical and have many tools.. I guess you wont look back to expensive oracle.. :y
Thanks for the advice. Shortly after I lost my job, I downloaded the Enterprise edition and went through it in detail. I was quite impressed, and learned a bit about what it can do. But working at home on my own isn't going to make me an expert. If I get the opportunity to use it as a Systems Analyst or Designer, I'll know what to do, but I'm never going to achieve DBA skills - don't have that sort of mind.
I was very pleased when the six months trial ran out - I got my PC back again - SQL Server absolutely knackered it. :) :) :)
Trust me not too much effort required to be an MS SQL DBA.. You already know PL/SQL.. Routine things like back up,recovery, tuning with system parameters is mostly adequate..
I as a programmer learned everything myself from its documentary although took some time and mostly under disaster conditions ;D , briefly you learn very quickly in case of emergency..
Microsoft from time to time makes DBA exams from its books and documentary , you can get a certified DBA level easliy imho.. (but you need to pay money for those exams unfortunately)
ps: Enterprise edition mostly is for multiple CPU servers..Although initial configuration dont utilize too much system source.. You can get this by playing with parameters and configuration..
Trust me not too much effort required to be an MS SQL DBA
Probably true. But the job market in UK is highly competitive, and "book learning" doesn't count for much - they want to see that you have done it before. I've done DBA work when there wasn't anyone else there to do it, but it's not my type of job - you need to remember too many details, and I'm far to old to enjoy that any more. Anyway, although DBAs are well paid, I can earn more doing design and architect work. Or I could before now - there don't seem to be any jobs for me at the moment.
Enterprise edition mostly is for multiple CPU servers..Although initial configuration dont utilize too much system source.. You can get this by playing with parameters and configuration..
Yeah!!! It didn't work at all at first 'cos it demanded all the system resources. I had to shut down the bits I didn't want to use and reconfigure the rest in order find out what it could do. I was very impressed, but I first worked on Oracle in 1986 (as a DBA, believe it or not), and I think I will always want to do things the Oracle way.