Post reply

[Server name] and [Instance name]

  • August 22, 2007 at 8:14 pm

    #118297

    Hi all

    Please tell me about difference between [Server name] and [Instance name]

    copy1.jpg and copy2.jpg

    http://solntai.googlepages.com/copy1.jpg

    http://solntai.googlepages.com/copy2.jpg

    How can i rename [server name] and [instance name]?

    How can i delete one instance on my server?

    Thanks .

  • August 22, 2007 at 11:48 pm

    #728791

    Server name is your machine name; instance name is the same with server name when sql server is installed as a default instance and has got "computer_name\instance_name" name when sql has been installed as a named instance.

    To rename a server follow this link:

    http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/sysdm_ident_change_computer_name.mspx?mfr=true

    To rename a sql server instance read in BOL;

    You cannot delete a sql server instance, you uninstall it.

    good luck

  • August 23, 2007 at 4:21 am

    #728842

    Thanks for your answer.

    But, as the picture i have posted, the server name ( in the red rectangle ) is "lntai\sqlexpress_test", meanwhile, my computer name is "lntai", not "lntai\sqlexpress_test".

    So, as you said, in the connection properties window, the "server name" field must be "lntai".I don't understand this.

    Please explain this to me more clearly.

    Thanks and regards.

  • August 23, 2007 at 5:10 am

    #728850

    It should be as it is in your first screenshot. The second screenshot shows a configuration that is a bit messed up. The server name should be only "Intai", instead of "lntai\sqlexpress_test".

    How did you set up this connection and in what application? Does it work? Generally the connection string is built up by concatenating the server name "\" instance name.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • August 23, 2007 at 8:12 pm

    #729149

    I used default name when install sql server.

    I have some version of SQL on my computer: 2000 , 2005 with two instance.

    When i used osql -L , i can see some soft of: lntai, lntai\sqlexpress, lntai\sqlexpress_test.

    I have used VC++ 2005 to connect to database and everything is alright with all my servers\instances name.

    I think i will reinstall this software to see how can i end up with this.

    Any help is welcome.

    Regards

    SoL

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

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