Thanks for the input people. Turns out the computer was at fault, trying to connect to SQL Server 2000 Developer installed on another computer works fine.
Thanks again.
This may have been due to selecting Windows Authentication during install.
I ran into this trouble a few weeks back. After about 5 reinstalls, installing with Mixed Mode set instead of Windows Authentication fixed the problem.
I wasn't seeing anything in the Event Viewer Logs related to SQL Server when I checked them.
It strikes me odd that when telnet'ing to the server, it takes next to no time, yet it would time out when trying to connect with the DSN driver. I'm still leaning towards it being the DSN connect...
When trying to setup the DSN driver as you suggested, my client config. dialog box was slightly different for TCP/IP. Where you mentioned "Server Name blocks" I assumed it would be the same as "Computer Name" since that is the only other field besides port number.
Having filled out everything...
I installed it myself and used the steps I had used in the past. I had to have it installed such that I could test VB.NET apps.
mixed mode is the auth type(i believe that's what it's called), and i've been trying to log in with sa.
I turned the firewall completely off so the port shouldn't be...
sorry about the bad grammar, I knew I should have proof read it better than I did.
So here's the point form version:
-can't connect to SQL Server2000 developer from another machine.
-can telnet to machine that SQL Server is installed on and on the SQL Server port (1652 for some odd reason on my...
Hey all,
I've been having connecting from a win2k box and a mac box to SQL Server2000 Developer running on winXP using DSN.
So far I haven't been able to figure out the DSN settings to get it to connect. I keep getting cannot find server error messages.
If it is possible, what should the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.