May 4, 2009 at 10:31 am
Hello everybody! I am sure there is something silly I am not doing but wanted to get some advice.
I am trying to setup ODBC connection. I have 2 win2003 servers that are part of a domain and 1 server is the database server. I have installed SQL 2005 onto this box and created a user that is a Domain Administrator. I test an ODBC connection locally on the DB server box and all is well. I then go to the 2nd server and attempt to connect by creating an ODBC and I can't get it to work with Windows Authentication nor for that fact can it work with SQL Authentication with the user I created - Domain/Administrator; but if I attempt connect with SQL Authentication using the sa user it works fine.
Any help is appreciated!
Thanks
DJ
May 12, 2009 at 7:39 am
Are the permissions set the same as the sa account?
May 13, 2009 at 9:26 am
Where did you create the user DomainAdministrator? In Active Directory, on the server, in Sql Server? It makes a difference...
May 13, 2009 at 4:16 pm
Do you get an SSPI error ?
If so read everything you can about SSPI, then give up and use basic SQL authentication.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply