SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Login failed for user...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

leoc50
Yak Posting Veteran

USA
52 Posts

Posted - 12/12/2012 :  14:17:51  Show Profile  Reply with Quote
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

USA
37143 Posts

Posted - 12/12/2012 :  15:53:47  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
52 Posts

Posted - 12/12/2012 :  16:13:46  Show Profile  Reply with Quote
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

USA
37143 Posts

Posted - 12/12/2012 :  16:37:00  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
52 Posts

Posted - 12/12/2012 :  17:21:49  Show Profile  Reply with Quote
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

USA
37143 Posts

Posted - 12/12/2012 :  17:34:31  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
52 Posts

Posted - 12/13/2012 :  07:32:10  Show Profile  Reply with Quote
Of course, that makes sense.
Thanks anyway Tara and happy holidays!

- lec
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000