MSDE & SSMSE -CTP connection problem

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?

OS: Windows server 2003.
i used VB.NET to develop the apps.

kindly help me to solve this problem.

why do you need to have a gui interface on the same box. you can connect to it from another SQL client machine/Server.|||

I don't understand ur point.

My server machine has MSDE DB only.

Clients are Pocket PCs.

|||? Hi, I have seen one other person with a problem like this when they created a SQL Server database from Visual Studio. Can you confirm that MSDE is installed as a named instance MSDERELA? Open a command shell window and type the following: SQLCMD -S .\MSDERELA What do you see? If you see a prompt like this: 1> then you are able to connect to the instance using SQLCMD which is a start. I notice that you have a CTP installed. You need to be VERY careful when you later come to uninstall this and go to SSMSE RTM build. There is a specific order in which to uninstall items to achieve a successful uninstall. Andrew Watt MVP <ar_pad@.discussions.microsoft.com> wrote in message news:434cb1f0-4b2c-43c5-97da-5aea1f39295f@.discussions.microsoft.com... 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? OS: Windows server 2003.i used VB.NET to develop the apps. kindly help me to solve this problem.|||

Hi,

Yes. It's a named instance. computername\MSDERelA.

can i use the same cmd? SQLCMD -S .\MSDERELA where can i see these kind of commands?

I followed this order. 1) windows installer

2)dotnetfx.exe

3)msxml6.msi

4) SSMSE

is it correct?

Thanks!

|||

That's the right order to install Management Studio Express.

The command line syntax for sqlcmd is very similar to the syntax for osql. You can get the command line syntax for sqlcmd by typing the following in a command window:

sqlcmd /?

"sqlcmd -S .\msderela -E" will connect to your local msderela instance using Windows authentication. You can type "quit" to exit sqlcmd.

Here's the online help topic for sqlcmd: http://msdn2.microsoft.com/en-us/library/ms165702(SQL.90).aspx

Hope this helps,
Steve