Urgent about connection to MSDE 2000
-
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
-
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
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 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
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
-
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
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
-
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
Thank you very much. It's because the protocol is disabled. Now MSDE could be connected after enable the protocol. vigorous
