Win2003 enterprise- SQL2000enterprise - ODBC error -- sql server odbc

Clarise
11/7/2003 5:30:41 PM

On one of our domains we have win2003 enterprise and SQL
2000 enterprise installed. The clients that access this
server are windows 2ooo prof or XP prof. When trying to
connect to the sql2000 server through ODBC. I get the
error [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
SQL Server does not exist or access denied.

I have updated the MDAC to ver 2.8 on the client machines

Thanks in advance for any help I can get,

CGilmore

Invotion
11/11/2003 4:06:01 PM

Have you verified that the client machines can see that
server on the network? How are they loggin in? Can you
use their logins locally on the sql server to access the
database? Double check the usernames and passwords to
make sure they are correct.

Sincerely,
Invotion Engineering Team
Advanced Microsoft Hosting Solutions
http://www.Invotion.com

[quoted text, click to view]

Ranjit
12/8/2003 5:26:51 AM

Hello,

I have the same problem trying to connect via a linked
server from a SQL7.0 machine . HOwever I am able to
connect if I am logged in as Admin but not as a normal
user. Also if connect to the target server, while logged
in as Admin, after that the normal user is also able to
access not before the admin accesses the target objects
first.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server odbc

sql server odbc : Win2003 enterprise- SQL2000enterprise - ODBC error