Urgent about connection to MSDE 2000

wk_vigorous

Hi, guys. This is an urgent problem that I can only conncet to MSDE 2000(release A, not sp3 or sp3a) from local computer but can not connect to the one running on remote PC. Every time such information is prompted:"SQL Server doesn't exist or access denied." By the way, the SQL Server service manager running on my PC can start or stop MSDE on both local and remote PC. Help please. Thanks. vigorous

Lost User

wk_vigorous wrote: This is an urgent problem that I can only conncet to MSDE 2000(release A, not sp3 or sp3a) from local computer but can not connect to the one running on remote PC What is the version of your windows operating system? Does your windows install any service pack? wk_vigorous wrote: SQL Server doesn't exist or access denied Try to check the information from here[^] and google. wk_vigorous wrote: This is an urgent problem that I can only conncet to MSDE 2000(release A, not sp3 or sp3a) from local computer but can not connect to the one running on remote PC Try to check the connection library.[^]

A thousand mile of journey, begin with the first step. APO-CEDC Save Children Norway-Cambodia Office

wk_vigorous

The operating system is xp sp2. I thought maybe the firewall block relevant port but even i close the firewall i still can't connet to MSDE. vigorous

Richard Deeming

This is probably an SP2 issue. Have a look at MS KB 841249[^] - How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server. Another problem I have seen is if all protocols are disabled. Run the server network utility (svrnetcn.exe), and make sure you have at least one protocol in the "Enabled protocols" list. http://www.trinet.co.uk/kb.asp?kbid=25[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

wk_vigorous

Thank you very much. It's because the protocol is disabled. Now MSDE could be connected after enable the protocol. vigorous