Post reply

SQL Server 2005 new setup

  • December 26, 2008 at 11:58 pm

    #216874

    Hi,

    I have just downloaded and installed SQL server 2005 on my home desktop. When I first time run the SQL server management studio express, a dialog "connect to server" pop up asking for server name. I have problem to get over this, can anyone help?

    Thanks.

    kha

  • December 27, 2008 at 1:29 am

    #917986

    Make sure that your services are running or just put the dot as servernamen ( . ) and try!

    let me know what next!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • December 27, 2008 at 2:07 am

    #917989

    Hi Dugi,

    Thanks for your response. Please bear with me as I am new to this.

    1) what service(s) to leave it ON and how?

    2) input a "." as the server name still do not help.

  • December 27, 2008 at 6:55 am

    #918016

    kha_ang (12/27/2008)

    Hi Dugi,

    Thanks for your response. Please bear with me as I am new to this.

    1) what service(s) to leave it ON and how?

    2) input a "." as the server name still do not help.

    Ok!

    1) You should check like this:

    Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager

    2) the server name mostly is the name of computer, it happens usually during the first install because you install the default instance! On Configuration Manager you will see the services for the default instances - do a Print Screen just to see the situation on Config Manager!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • December 27, 2008 at 7:18 am

    #918020

    If the setup was completed successfully, Normally you enter the following in server name.

    machineName\InstanceName

    Check out the name of your pc and replace it with machineName and put SQLEXPRESS in place of InstanceName(assume u installed express version).

    If you didnt change any default values during installation, Keep the authentication mode to Windows Authentication and you should be able to connect.


    Pradeep Singh

  • January 1, 2009 at 8:16 pm

    #920075

    Hi Dugi, PS

    Thanks for your messages.

    There was no configuration manager after the configuration tool.

    "Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools >"

    I re-install again and the problem disappeared. Thanks again.

    Regards

    kha

Viewing 6 posts - 1 through 5 (of 5 total)

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