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?

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

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