Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    9

    Unanswered: Connecting to MSDE

    I am trying to connect to a MSDE database on server from my desktop using query analyzer. I keep getting the generic "SQL Server does not exist or access denied'

    I have verified the following:
    - the login/password is valid because when I access osql from server I can gain access
    - the registry for Loginmode appears OK - set to 2 - mixed mode

    What else do I need to check...

    Thanks, kgaske

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Did MSDE install as a named instance? Check the service, and see if it is listed as MSSQL$foo. If it is, you connect as servername\foo.

  3. #3
    Join Date
    Aug 2004
    Posts
    9
    No MSDE is not a named instance. Checked the service..

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Can you connect to the server from the server? Maybe no network protocols were enabled.

  5. #5
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by MCrowley
    Can you connect to the server from the server? Maybe no network protocols were enabled.
    I'll second this; what version of MSDE is it? What's the operating system. By default, MSDE 2000 installed on WXP or Win2003 will not enable IP connections. You have to install SP3 (minimum) or SP4. I also recall (from some dim memory) that by default, MSDE does not enable anything but shared memory (ie, localhost) connections.

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

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