Post reply

I am NOT an A-n-i-m-a-L

  • February 7, 2006 at 10:37 pm

    #189083

    Hi,

    I was having minor problems with the set up and I have just uninstalled and reinstalled and i can not seem to get the server to register now. I keep getting this error..

    no sql server 2005 componets were found on the specified computer. either no componets are installed, or you are not an administrator on this computer. (sqlsac)

    And when i am in the management studio i can not register a server their eaither... i uninstalled everything and reinstalled thinking that i could get a fresh start.. and now i can not reg a server..

    I have os XP and iis on local compuer...  HELP..

    What can i do here?

     

    erik

    Dam again!

  • February 9, 2006 at 8:31 am

    #619811

    First, let's make sure that everything you think is installed is actually installed.

    1. Go to Control Panel -> Add or Remove Program Files.

    2. Scroll down to the entry "Microsoft SQL Server 2005"

    * If you don't see this entry there's a good chance SQL Server is not installed

    3. Select the entry and click "Change"

    4. On this dialog you'll see which components are installed. There servers are listed by instance name followed by which server are installed for that instance. I'd expect to see "Database Engine" listed for the instance you're trying to register.

    * If you don't see any instances listed or you don't see "Database Engine" listed for your instance the server isn't installed.

    5. If you want more details on the instance you can click "Report". This will give you the version, edition, patch level, and language for each server of each instance.

     

    Okay, assuming that everything is installed as you expected let's check if the SQL Server DB service is running.

    1. Go to Control Panel -> Administrative Tools -> Services

    2. Scroll down until you find an entry like "SQL Server (<instance name&gt (e.g. for a default instance it'll look like "SQL Server (MSSQLSERVER)" or for a default install of Express "SQL Server (SQLEXPRESS)").

    3. Check the status of the service. If it's not running start it

    4. If you don't see the service listed, however, in the Control Panel report you saw "Database Engine" list then your installation is corrupted. You should go back to control panel and uninstall SQL Server and then rerun setup.

    If all of these check out and you still cannot register the server, please answer these questions:

    A) Are you trying to register the server from the same machine or a different machine from which SQL Server is running?

    B) Can you connect to the server using SQLCMD?

    Cheers,

    Dan

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply