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)
 Linked servers and account lock out

Author  Topic 

scottpt
Posting Yak Master

186 Posts

Posted - 2003-10-08 : 10:30:03
I have one server that links to 14 other server for monitoring purposes. The client is set up with TCP/IP, Named Pipes, and Multi in that order.

The problem I am having is that the servers are set up with the three failed OS logins and lock the account. All servers are set up using the same user name with different passwords. Why is it trying to connect using namedpipes not TCP/IP? Does any one else have this problem?

nr
SQLTeam MVY

12543 Posts

Posted - 2003-10-08 : 11:24:54
see
http://www.nigelrivett.net/NetworkConnectionLibrary.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -