MSDE SQL Server Does Not Exist or Access Denied

From: ItWillbeFixed (mwinbun_at_cox.net)
Date: 06/03/04

  • Next message: Tibor Karaszi: "Re: "exclusive access could not be obtained.." while restoring" 
    Date: 2 Jun 2004 23:49:28 -0700

    I have a seen a lot of these types of posts, but still haven't found a
    concrete answer to the following:

    Note: This is all local to one computer
    1. Windows XP Box w/SP1
    2. MSDE 2000 w/SP3a
    3. Named Pipes - On
    4. TCPIP - On
    5. Security Mode 'Mixed'
    6. Computer was on my network and I unplugged the cable
    7. Using VB.NET Program, I built
    8. Program receives exception: "SQL Server Does Not Exist or Access
    Denied" when trying to connect to the MSDE Server. (Tried (local), IP
    Address, Name of MSDE Instance, etc.)
    9. The security for the database has been opened up to everyone
    (etc.)
    10. User that installed MSDE and the Program is in the Administrators
    Group but not the Administrator.
    11. Program runs fine with the network connected.
    12. UDL File and ODBC connections work just fine; reguardless of the
    condition of the network connection.
    13. The server does not even appear to see the attempt to connect.
    14. Four Q's: 1. Does anybody have any thoughts on this?; 2. Since the
    network is unplugged, but was plugged in when MSDE was
    installed/started does that mean that the local server is unsuable
    after that point?; 3. Could there be some kind of permissions issue
    with the User that is currently being used?; 4. Is there something
    amiss with my connection string? - see below

    I have tried adding 'Trusted_Connection=yes'; using SQL Standard Login
    (User ID=X;Password=123 Since the computer does not have an IP
    Address I haven't tried different ports.

    ConnectionString = "data source=Server123;initial
    catalog=Database123;persist security info=false;integrated
    security=SSPI.

    Any discussion would be helpful at this point.

  • Next message: Tibor Karaszi: "Re: "exclusive access could not be obtained.." while restoring"

    Relevant Pages

    • Re: MSDE cliente connection
      ... When you tried to connect to the MSDE on "server1", ... what security mode did you use? ... error "The server does not exist or access is denied". ... > Server OS: Windows 2000 ...
      (microsoft.public.sqlserver.msde)
    • Re: SQL Runtime Version Setup problems
      ... security issues etc. ... Search on "Configure the server". ... I am trying to install the MSDE version of SQL onto a PC ...
      (microsoft.public.sqlserver.setup)
    • Re: Help with Master/Detail UI in ADPs
      ... No, MSDE is not limited to 5 concurrent users, it is limited to 5 concurrent ... The users whose connection to the server is idle at any moment don't count. ... and from the local temp table to the Detail table on the server for rows ...
      (microsoft.public.access.adp.sqlserver)
    • Re: Unable to connect to SQL 2000 engine on other machine from SSM
      ... how SQLServer-Browser resolves portnumber of MSDE named instance. ... Windows 2003 Server ships with SSEE preinstalled (for ... port information to your client. ...
      (microsoft.public.sqlserver.connect)
    • Re: Unable to connect to SQL 2000 engine on other machine from SSM
      ... Upgrade MSDE to SP4: not ok. ... Windows 2003 Server ships with SSEE preinstalled (for ... > port information to your client. ...
      (microsoft.public.sqlserver.connect)