May 15, 2009 at 12:07 pm
I have a client/server application running Windows 2000.
It can connect to SQL Server 2000 through ADO.NET or ODBC DataSource.
Then I have a new SQL Server 2008 instance. Tried to connect this instance using ODBC datasource(SQL Server Driver) and got following error:
SQL Server does exist or access denied
But I can connect to this SQL Server 2008 instance on another Computer with Windows XP in the same way.
What's the possible reason?
May 15, 2009 at 5:22 pm
Can you ping the SQL Server 2008 server from the client?
Is it a named instance you are trying to hit? If so, have you updated MDAC on the client? If not, Windows 2000's default MDAC does not support named instances.
K. Brian Kelley
@kbriankelley
May 15, 2009 at 5:46 pm
Hi
Did you ensure that TCP/IP and Named Pipes are activated on your SQL Server? Go to "SQL SErver Configuration Manager" -> "SQL Server Network Configuration" -> "Protocols for MSSQLSERVER" and ensure that the protocols are enabled. If they haven't been enabled you have to restart the service.
Greets
Flo
How to Post Data/Code to get the best Help How to Post Performance Problems
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply