Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 ODBC with windows server 2003 enterprise edition -

Author  Topic 

ravin
Starting Member

1 Post

Posted - 2008-10-13 : 02:31:02
Hi,

I have windows 2003 server (enterprise edition - 32 bit & SP2) with MS Sql 2000 server installed. I wanted to establish ODBC connectivity from windows XP machine to this server but could not succeed. I get some error saying can't connect to this server, permission denied. I checked with netstat -a and sql listens on default port. The software guy told me that windows server should be a domain and client machines should be a member of this domain. Is it true ? Do I need to have AD installed for ODBC connectivity ?

Please help me out. I searched on net for a week but could not find any solution.

I checked with cliconf and TCP/IP and named pipes are enabled. From 2003 server I can establish ODBC without any problem.

Awaiting your solution.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-13 : 03:03:02
Enable TCP/IP in MS SQL 2000
Go to Top of Page
   

- Advertisement -