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
 Old Forums
 CLOSED - General SQL Server
 Conection could be not be established
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

JamesNewZealand
Starting Member

11 Posts

Posted - 02/02/2006 :  02:39:38  Show Profile
When trying to connect to my SQL Server I'm getting the following error:

******************************************

A connection could not be established to (local).

Reason: Logon failed for user.

Please vertify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (local) node) and try again.

******************************************

SQL Server is definately running, but I'm unable to connect.

I've tried changing the ODBC settings but I can't get past the "MIcrosoft SQL Server DNS Configuration" window. I choose "With Windows NT authentication using the network lognin ID" and click "Conect to SQL Server to obtain default setting for the additional congiruation options" and click "Next" but I get stopped by the following error:

connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user machine1\Administrator'

Does anyone have any ideas on what I need to do to fix this? If it helps, this all seems to have started occuring since I changed the Administrator password

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 02/02/2006 :  07:20:04  Show Profile
Welcome to SQLTeam

>>this all seems to have started occuring since I changed the Administrator password

Change the admin password back and it would work. This happened 'cause you choose windows authentication moded during install.
Go to Top of Page

JamesNewZealand
Starting Member

11 Posts

Posted - 02/02/2006 :  14:50:58  Show Profile
Problem is, I can't remember the old administrator password now, any tips?
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 02/02/2006 :  16:12:43  Show Profile
Can you see if a domain admin can connect to the server with his credentials? It sounds as though someone may have dropped the builtin\administrators login. Do you have the sa password, or is the server strictly windows authentication only?
Go to Top of Page

JamesNewZealand
Starting Member

11 Posts

Posted - 02/02/2006 :  16:43:04  Show Profile
Thanks for the response.

Yes I can logon as the 'Administrator' without any problems at all, and SQL Server is running. I just can't connect to it in any shape or for. I've got no idea what the 'sa' password is, and yes windows authentication is being used.
Go to Top of Page

JamesNewZealand
Starting Member

11 Posts

Posted - 02/04/2006 :  17:25:06  Show Profile
Could I get some further help please?
Go to Top of Page

JamesNewZealand
Starting Member

11 Posts

Posted - 02/08/2006 :  04:23:18  Show Profile
I changed it to mixed mode and managed to guess the "sa" password so I'm in!

Someone had changed the Bulletin/Administrators group to "Deny".
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 02/08/2006 :  09:19:31  Show Profile
>> ...so I'm in!

Nice to know
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000