SQL Server Performance

Installer using short Netbios computername

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by colinr, Feb 28, 2008.

  1. colinr New Member

    Im installing to ctp6 to a vrtual server on a number of servers, seems fine until I get to a server that needs a servername >Netbios length of 15 Chars.
    I have renamed the server as follows, it will connect using (local), . etc Or first 15 chars of computer name. What Do I need to do to enable connection strings where the computername is longer than the netbios name ?
    <code>select
    SERVERPROPERTY('servername')select
    @@SERVERNAMEselect
    * from Sysserverssp_dropserver
    'sql-carEngineAPi'gosp_Addserver
    'sql-carEngineAPi','local'GO
    <Code>
  2. thomas New Member

Share This Page