MSDE ,SSMSE connection

hi friends,

I'll be thankful if anyone solve this problem.

When i developed my application, i used sql 2000 as a server side DB.
Now my client want to install MSDE instead of SQL 2000.

so i uninstall SQL2000 and installed MSDE .

AS we all know, MSDE doesn't have GUI. So i installed Microsoft SQL Server Management Studio Express - Community Technology Preview (CTP)
(includeing xmlparser,windows installer,.net 2.0).

now i could able to view tables and everything. but i couldn't make the connection. Getting error like "SQL server not found. CMPNAME\MSDERELA"
I used same kind of connection string for SQL 2000. Worked well.here what happened?

Connection String : "Data Source = CMPNAME\MSDERELA;Database =TEST; User id ="xxx; Password =xxxx;"

OS: Windows server 2003.
i used VB.NET to develop the apps. (VS2003). Connecting from Pocket PC.

kindly help me to solve this problem.

(Already i posted this in SQL tools forum. i hope this is the right place to post this question. so posting again.)

Thank u!

First I suggest you install the release version of SSMS-E.

Then can you go into the services panel in Windows and see if there are any services that start with MSSQL$, if there are please make sure it is started.

If it is started then please test the connection by using osql from a cmd prompt.

|||

You mean i need to install SSMSE before installing MSDE?

Let me share, what i 've done

1) installed MSDE

2)Windows installer 3.1

3).net framework 2

4)XML Parser

5) SSMSE

6) Start the MSDE agent and enabled TCP/IP.

Only thing is, i didn't check the connection in command prompt.

I checked with apps.

Thanks.

|||

So you know for sure the the MSSQL$ service is running (not the agent service)?

Can you please try connecting using osql from the command line please?