Post reply

Registering a no named sql server?

  • September 13, 2006 at 3:44 pm

    #62274

    HI. I need to administer a sql server at another site on our network. I went to register that sql server on my enterprise manager and realized that on that sql server box, the server name in that enterprise manager under the heading of 'SQL SERVER GROUP' is '(local) (Windows NT) How can i register a sql server with no real name on my EM? Can I assign a name to this server without losing databases and logins?

    thanks,

    Juanita

  • September 13, 2006 at 4:03 pm

    #660264

    you can register the server with the machine name itself (If it is having a default Instance)

    In the local EM local DB Server will be visible as localhost only

    hope this helps

     

  • September 14, 2006 at 5:59 am

    #660338

    You can give it an alias name using the Client Conectivity Utility.

  • September 14, 2006 at 2:34 pm

    #660517

    Thanks !

    Juanita

  • September 15, 2006 at 2:12 am

    #660607

    The SQL Server does actaully have a name - it just doesn't show in EM. If you open Query Analyser from EM it will be shown at the top of the window, also select @@servername will return the name.

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

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