Results 1 to 3 of 3

Thread: SQL Server MSDE

  1. #1
    Join Date
    Jan 2004

    Question Unanswered: SQL Server MSDE

    I am using SQL Server 2000 MSDE for Test Development of a site in .Net. The MSDE is installed on my workstation and the web site is depolyes on a web server. When I try to access data from the site at the development server, the connection to the SQL Server MSDE fails, saying:
    System.Data.SqlClient.SqlException: SQL Server does not exist or access denied

    But when I access the web site from the same box where the SQL Server MSDE is installed, everything works fine.

    Here is the connection string I am using:

    <add key="DBConnection" value="Data Source=<MyMSDEBoxName>; Initial Catalog=<DatabaseName>; Integrated Security=SSPI;"/>

    I have tried using User Id and Passoword but it failed too!

    Any help will be appreciated.

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    Your connection is just fine, it's the network library that you skip, that causes the issue. You can either replace the reference to the MSDE box (it actually would behave the same way with the real SQL Server BTW) with the IP address, or specify named pipes library in the connection string. To do the latter add ";Network Library=dbnmpntw" to the end of your connection string.

  3. #3
    Join Date
    Aug 2003
    Andover, MA
    Are both machines on the same Domain, and are you logged into that domain? If not, you will need to remove the Integrated Security option, and replace it with a SQL Server username and password.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts