Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Login failed for user...

Author  Topic 

leoc50
Yak Posting Veteran

54 Posts

Posted - 2012-12-12 : 14:17:51
Hello All,
I understand that the "BUILTIN\Administrator' group (in 2000 & 2005) gives members sysadmin access to SQL server. In my new role I have to access/gather database info on sql 2000 (as we're preparing to recommend migration). Policies require me to request AD access as administrator on the server, and i has been granted.
BUT, when I try to login onto the sql server instances I simply get 'login failed' (windows authentication).
Is there any other way to login? is there an easy way to find the operator of the sql server? (to request access).

I'm really not sure that there is anything that can be done (besides getting access from that other dba) ...any ideas??

Thanks in advance for any comments!!

- lec

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-12-12 : 15:53:47
If the DBA removed the BUILTIN\Administrators from the sysadmin role, then you'll need to contact the DBA for access.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

leoc50
Yak Posting Veteran

54 Posts

Posted - 2012-12-12 : 16:13:46
Yeah, I was afraid of that! otherwise sql wouldn't be at all secure, right?

The thing is i can't identify the dba from the admin group names (it's a pretty big/global network), the name standards were not implemented on these old servers. Any other tips/tricks?

Anything someone with more 'wintel server' power can do?

Thanks Tara (I used to follow your blogs/articles) :)

- lec
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-12-12 : 16:37:00
There are certainly hacks to get into SQL 2000, however I will not be sharing any. I can't imagine that it's too hard to find the DBA of the server. Whoever granted you local admin should know who administers the SQL Server on that box.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

leoc50
Yak Posting Veteran

54 Posts

Posted - 2012-12-12 : 17:21:49
Believe I've tried the get info from the team that granted access...they really don't know nor care to learn about it (I really meant global as global can be!)

any chance for tips or hints on the hacks (even in a more private chat?)

Thanks!!

- lec
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-12-12 : 17:34:31
Sorry can not help with that for various ethics reasons, but most importantly due to being a Microsoft MVP and SQLTeam moderator.

I would recommend checking what users and groups have local admin on the server and then contacting all members of those. The DBA should be a local admin too...

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

leoc50
Yak Posting Veteran

54 Posts

Posted - 2012-12-13 : 07:32:10
Of course, that makes sense.
Thanks anyway Tara and happy holidays!

- lec
Go to Top of Page
   

- Advertisement -