Topic:Connecting to MSDE SQL Server Problems... Remainpoint:0
   
PostTime:12/15/2008 9:09:16 PM FloorTop
Lv is 1
Avatar
Level:
1
Professional point:
94
Experience:
1
Thread:
261
Post:
990
Total online time:
1M
Joined date:
4/28/2007 11:41:00 PM
Last Visit:
12/17/2008 12:44:11 AM
Status:
Online
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.
 
     

Sorry, you are not login, click here to login

 

About us | Advertise | Contact us | Partner | Bug Report|Suggesting box|Donation
Home | Forum | Affiliate program| Remote help | Setting | Search | Document | Help | Download|Message

 

Start new topicAdvanced search
Your location: Database -> Sql server