Showing posts with label mssql2005. Show all posts
Showing posts with label mssql2005. Show all posts

Thursday, 22 March 2012

connect to MSSQL2005 via ODBC

Installed SQL2005, connect via (the new) SQL Nativ Client ODBC Vers. 2005.90.1399.00 works, just as (the old) SQL Server ODBC-Driver 2000.85.1117.00. Works fine.
But from an other machine -there is no client installed - using driver 2000.85.1117.00 I get the message "Server dosn't exist or access denied"
How I can connect ? It is due to the fact of .NET FRAMEWORK 2 ?
Thanks!Sounds like the 'other' machine is your first network client - check your enabled protocols with SQL Server Configuration Manager.

Also, check your connection details include the instance name if necessary.

Also, what are the OS levels and authentication method?|||Hi, Mulhall. Indeed, it's the first network client W2K, connections to other sql2000 servers are o.k., to SQL2005 tried using TCP/IP-Protocol, tried Named Pipes and all others. Using the standard instance, no named, using SQL-authentication such as win-authentication, tried connection by server-name and by IP-Adress. OS-Ping works normaly.|||Have you verified using the Surface Area Configuration tool that remote connections are enabled?

Thanks
Laurentiu|||Thanks Laurentiu, upon configuration Surface Area Conf.Tool the connection works. I did not know this featureIdea