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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Connection error

Author  Topic 

Pinchy
Starting Member

1 Post

Posted - 2010-12-22 : 09:57:44
SQL Server can be connected from local system but can not be connected from remote system in the network. The error code is 40 from visual studio and 1326 when I try to connect to SQL server from management studio.


Firewall isn't the problem
TCP/IP connection is enabled from SQL server
There are 2 pc terminals that can connect to the SQL server but the 3th one cannot and using the same connection strings so the connection string is right

it is SQL server 2000

any help will be appreciated
thanks

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2010-12-23 : 16:49:36
check account for sql service, it is local system account or domain account.
Go to Top of Page
   

- Advertisement -