February 6, 2006 at 8:44 am
I have recently setup SQL 2005 Developers Edition on my machine and developed an VB Studio 2005 application around it. I recently moved to deploy it on our network and have seem to run into some problems. When I install SQL 2005 on my server (Win XP Pro) I get this error:
Attempting connection
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
I am able to "see" the SQL server in the list of servers when I try to setup the ODBC connection. Here is what I have done so far...
- I have the security setup to use Windows Authentication and my server is within the domain and I have rights to it.
- I can connect using the Microsoft SQL Server Management Studio Express utility.
- I have verified that TCP/IP is enables as a remote connection option
- I have enabled TCP/IP
- I have verified my username is set to "sysadmin"
- SQLBrowsing Services is started and running.
I also can ping the server/connect to the server using Remote Desktop. I have gone into the Surface Area Configuration and checked to verify that TCP/IP is checked (not TCP/IP and Named Pipes, just TCP/IP). I have File and Print sharing enabled on my server/test XP machine.
The only thing I can think of is that it has something to do with local permissions and/or the firewall deployed with SP2.
Any ideas?
Thanks,
Dan
February 8, 2006 at 8:58 am
Well, I figured it out... thanks for the help!! Just kidding....
You have to allow the SQL .exe files access to pass through the firewall by adding them as exceptions within the firewall settings. Mainly the SQLBroswe.exe and SQLWriter.exe....
The files can be found at the following location...
C:\Program Files\Microsoft SQL Server\90\Shared
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply