[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 312
  • Last Modified:

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.
0
hexOffender
Asked:
hexOffender
  • 9
  • 5
  • 2
  • +1
1 Solution
 
SireesCommented:
Can you ping your server from the test users pc?

Also check the firewall settings.
0
 
hexOffenderAuthor Commented:
I forgot to add the SQL server is running in Mixed Mode Authentication. If it helps.
0
 
hexOffenderAuthor Commented:
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
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
SireesCommented:
0
 
TAB8Commented:
What version of sql do you have  ...    SQL 2005 dev edition will not allow remote connections
0
 
TAB8Commented:
Also by default 2005 should disallow remote conections ...  run sql config manger to check
0
 
vijay4sqlCommented:
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
0
 
hexOffenderAuthor Commented:
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(Connect()). SQL server does not exist or access denied."
0
 
vijay4sqlCommented:
Chek this

Potential causes of the "SQL Server does not exist or access denied" error message
http://support.microsoft.com/default.aspx/kb/328306

thx
VJ
0
 
vijay4sqlCommented:
Are u able to do telnet

thx
VJ
0
 
hexOffenderAuthor Commented:
Telnet would not connect either, same with Named Pipes.
0
 
hexOffenderAuthor Commented:
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.
0
 
hexOffenderAuthor Commented:
I have been through the KB(http://support.microsoft.com/default.aspx/kb/328306) article line by line, but no results.
0
 
vijay4sqlCommented:
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
0
 
hexOffenderAuthor Commented:
VJ,
How would I check for aliases?
0
 
hexOffenderAuthor Commented:
I dont think it is a DNS issue because I am able to ping by hostname as well
0
 
hexOffenderAuthor Commented:
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.
0
 
vijay4sqlCommented:
Click start ..run.. CLICONFG... 2nd tab is aliases

thx
VJ
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 9
  • 5
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now