Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    14

    Unanswered: MSSqlserver missing

    I installed SQL server 2005 on a win2003 server box.

    When I open the Connect to Server dialog box, I choose server type: Database Engine. There is no Servername listed, so I put in the name of the PC.

    I get a long error message when I try to connect:

    Cannot connect to PCName....
    ...error: 40 - Could not open a connection to SQL Server)...

    When I try to go into the Surface area Configuration, I get this message:
    "No sql server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)"

    I am logged in as Administrator in the PC, so did I do something seriously wrong with the installation?

    In the services window, I can not fine MSSQLserver (not sure if this is relevant).

    regards,
    Jozi68

  2. #2
    Join Date
    Jun 2007
    Location
    Ohio, USA
    Posts
    142
    You are doing this all on the same computer, right?

    Did you try using "(local)" for the server name?

    Did you specify an instance name during the installation?

    For 2005, you're looking for "SQL Server" instead of "MSSQLServer"

  3. #3
    Join Date
    Nov 2007
    Posts
    14
    Standalone PC, no network.
    I tried "(local)", same error.
    Don't think I specified an instance name, not 100% sure though.
    SQL Server is also not in Services (there is nothing SQL-like there)

    If I open SQL Server Configuration Manager,
    there is nothing under SQL Server 2005 Services.
    there is nothing under SQL Server 2005 Network Configuration.

  4. #4
    Join Date
    Jun 2007
    Location
    Ohio, USA
    Posts
    142
    Sounds like the install failed. Either that or you installed the client tools only. What edition is this?

Posting Permissions

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