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.
| Author |
Topic |
|
kamalkishore_in
Yak Posting Veteran
76 Posts |
 Posted - 2001-07-11 : 06:06:14
|
| Hello Gurus,I am facing some problem to connect two servers.I have installed SQL Server 2000 in our main Server and Install another Server 2000 in another Branch Server. When I am tring to connect from Client (The computer does not have SQL Server/Client installed) to the Main server using the following Connection String it connects well.Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=ATAKAG;Data Source=192.168.12.12But when I am trying to connect from a computer which has SQL Server 2000 installed in it it says connection open or Time out.And even when I am trying to create an ODBC for the remote SQL server from branch server it does not connect. where as it connects from the client computer which does not installed SQL server 2000.I noticed that the File SQLSRV32.DLL which is used in creating/Connecting SQL Server 2000, it was different in the Client and the branch Server computer.I tried also installing the Windows 2000 Service Pack 2, but doent help out.I am using Windows 2000 Server and SQL Server 2000.Waiting for solution |
|
|
|
|
|
Two Server Connection