1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Connecting to MSDE SQL Server Problems...

Discussion in 'Software Development' started by quantass, Sep 15, 2003.

Thread Status:
Not open for further replies.
  1. quantass

    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.
     
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 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/165070

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice