SQL Server 2000 Unable to connect
Posted on 2006-05-25
Hello, I have done a lot of research on this problem and it is relentless.
We have a windows xp pro sp2 machine trying to connect to sql server 2000 hosted on our windows 2000 domain controller. When trying to connect to SQL Server from the XP machine I get the error:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
Now all the common solutions I have researched do nothing to solve my problem.
I have set the firewall to allow access through port 1433 which is what SQL is using. I have set the alias in client network utility, I have set the settings in server network utility, SQL is not in single user mode, I have updated MDAC to 2.8 sp1 and both computers have file and print sharing turned on. I am stumped, have been for about a week and would really appreciate some answers, thanks.