hexOffender
asked on
Sql Server does not exist or access is denied
I get this error when I am trying to create an odbc connection from a Windows XP PC. The server is Windows 2000 server with Sql 2000. I am able to connect bto this database from my own XP PC but I cannot connect fro my test users PC, even logged in as myself. We are a Novell 6 domain, but all the users are synchronized with AD on another Server. I have created an account for the user on the SQL server, and given all the appropriate permissions. I have synched all the passwords in AD with the NDS Tree. I need some insight here.
ASKER
I forgot to add the SQL server is running in Mixed Mode Authentication. If it helps.
ASKER
yes I can ping the server and I checked the PC firewall is off. The server is behind the pix so I didnt bother checking that, and none of the other SQL boxes have this problem
What version of sql do you have ... SQL 2005 dev edition will not allow remote connections
Also by default 2005 should disallow remote conections ... run sql config manger to check
OKIE.. ping works.
What about telnet. On the bad box ..create a UDL connection file and see if that works. Did u tried connect using IP explicitly mentioning port number. also try with name pipe prot.
thx
VJ
What about telnet. On the bad box ..create a UDL connection file and see if that works. Did u tried connect using IP explicitly mentioning port number. also try with name pipe prot.
thx
VJ
ASKER
It is SQL 2000, not 2005, I tried the UDL file, but it will not work even with my logon Creds. But the error with the UDL file said "Error in initializing Provider [DBNETLIB]ConnectionOpen(C
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are u able to do telnet
thx
VJ
thx
VJ
ASKER
Telnet would not connect either, same with Named Pipes.
ASKER
I was wrong about the Telnet, I was using the default port 1443, but the servewr is configured for 1433, and I can connect via telnet from the PC in question.
ASKER
I have been through the KB(http://support.microsoft.com/default.aspx/kb/328306) article line by line, but no results.
in UDL connection.. give the
tcp:ip address,port number
in place of server name.. see if it helps.
it wud look like
tcp:172.10.5.22,1433
just thinking if name resolution is an issue there (hope u have cheked there are no aliases configured on the local box)
thx
VJ
tcp:ip address,port number
in place of server name.. see if it helps.
it wud look like
tcp:172.10.5.22,1433
just thinking if name resolution is an issue there (hope u have cheked there are no aliases configured on the local box)
thx
VJ
ASKER
VJ,
How would I check for aliases?
How would I check for aliases?
ASKER
I dont think it is a DNS issue because I am able to ping by hostname as well
ASKER
As a workaround I just changed the connection-string of my app to use the sa account, not the best way to do it I know, but for now im only beta testing with one user.
Click start ..run.. CLICONFG... 2nd tab is aliases
thx
VJ
thx
VJ
Also check the firewall settings.