MSDE Access | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

MSDE Access

Hello, I have installed MSDE in my work station. I have created a userid/password combination. My colleague is trying to connect to my MSDE database using Query Analyzer from another work station which is in the same network as my work station is into. He is getting an error message saying "SQL Server does not exist". Is it possible to access a MSDE database from another computer.
KBA;EN-US;Q328306 to guide you through. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
is your issue resolve ?! which authentication you are using ?! Windows or SQL ? Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami

This is the problem: MSDE defaults to install with no network protocols enabled This is the solution: On the host machine start Server Network Utility: Start > Run > svrnetcn.exe
select TCP/IP and press enable