Connecting to MSDE SQL Server Problems...

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

quantass

Thread Starter
Joined
Aug 20, 2003
Messages
53
I've installed the MSDE SQL Server package onto my Windows 2000 Pro system. Visual Studio .NET 2003 (C#) is my development tool of choice and am using the FCL's SQLConnection class to connect to the "Pubs" database:

SqlConnection connection = new SqlConnection (@"server=localhost\NetSDK;uid=;pwd=;database=pubs");

When installing the MSDE package I used the following parameters within the Setup.ini:

INSTANCENAME="NetSDK"
SAPWD="a"

Unfortunately I keep getting back the error message:
SQL Server does not exist or access denied. I currently have the following Services listed: MSSQL$NETSDK [Started - Automatic], MSSQLServerAdHelper [Stopped - Manual], SQLAgent$NETSDK [Started - Automatic], Distributed Transaction Coordinator [Stopped - Manual]. There is a "SQL Server Service Manager" app in the tasktray however there are no server or services listed in its dropdown boxes.

What am i doing wrong? Is there a clear way to identifying what SQL Server is running and its parameters? I cant seem to find any UI that presents the SQL Server currently running on my machine with properties.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top