March 29, 2008 at 1:18 pm
I am having an issue when I use the ODBC to refer to the SQL Server. When I try to connect the the server that I would like it to refer to I get the following error:
Connection failed
SQL State: '28000
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user Server01\guest.
I have used this particular way on a number of computers and have never had this issue before. I have uninstalled the SQL Server and then reinstalled it but I am getting the same error each time. I have done everything that I can possibly think of. If there are any suggestions please let me know. I am cramped for time.
Thanks
Erica
March 29, 2008 at 4:28 pm
It looks like you are using Integrated Security to connect and the ODBC connection is grabbing the guest user login for the server. Has that login been granted rights onto the SQL Server? This probably worked before because the ODBC connection was using an account in the Server Administrators group which gets automatic SA rights when SQL Server is installed through the Builtin\Administrators group.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 30, 2008 at 8:48 am
Ok I changed the rights and was able to connect to the server. But after doing a backup of the hard-drive. When I started the SQL Server I go the error
SQL Server does not exist or access denied.
ConnectionOpen (Connect()).
I did not change any of the properties on this SQL Server. All I tried to do was restart it.
March 30, 2008 at 10:24 am
this is a connection error; are you getting this when you try to connect or when you start the service?
March 30, 2008 at 11:47 am
I am getting this error when I try to start the local server. i did not change anything all i did was do a hard drive backup. I went back to see what I did. And it will not let me connect to the SQL Server which is probably why I can not start the local server. But, also when I first tried to connect. I saw that I was firewalled which I did turn off.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply