SQL Server Performance Forum – Threads Archive

problem connecting to remote SQL Server

Here is the setup: on a Win2K PC, SQL Server Personnal Edition 2000 is installed. I’ve installed MSDE 2000 on another Win2K PC. Both have the same database locally attached (the whole application required distinct SQL Server from 2 geographical locations. Both server will gather data from their respective site and must be synchronized automatically so that both database have the same informations all the time). On the MSDE PC, I can see the remote SQL Server and I can connect into it (with a third-party software, MSDE Manager). In the SQL Server Service Manager, I effectivly see both servers. But in the first PC, where the SQL Server 2000 is installed, I can’t connect to the MSDE. I don’t see it in the Service Manager neither. Both PCs are logged with the same user/password with administrative privileges. I use NT authentication. From the MSDE, as I said, it’s ok (although I can’t log in the database with the ‘SA’ user, but I don’t care for now), but from the SQL Server, there is no way I can connect to the MSDE. Any idea anyone?? thanks a lot for your help and time, I’d really appreciate. Dominic GagnÃ©,
MontrÃ©al, Qc, Canada

ENsure similar network libraries are used to connect between the servers.
KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003 to handle connections to MSDE. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

If you try using QA from SQl Server 2000 what error do you have?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

I’ve re-installed my SQL Server and removed the instance name. Now, from my SQL Server PC, I see the MSDE in the Service Manager, I can stop and restart the service remotly. But I still can’t register nor connect (with a VB app) on it. When I try to register the MSDE in Enterprise Manager, I see the server, but when I try to connect, it says: "SQL Server does not exist or access denied (ConnectionOpen (Connect())", although both PCs are logged with the same username and both server are configured with the same Logins and users. My VB application can connect on a remote SQL Server but can’t connect on the MSDE (with the same database). What the hell is going on??! <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />

Check Client Network Utility (Sql Tools) and look protocols. Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Then this KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q328306 should help you out to register the service. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks all. I founded out what’s the problem. In MSDE, there is no Enabled Protocols by default. You have to manually active it with the SVRNETCN utility at the command prompt. Now, it work just fine. thanks for your time and help

Glad to know the problem is resolve and I pointed out the cause in my reply above
ENsure similar network libraries are used to connect between the servers. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>