Change Srver Name - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Change Srver Name

Author

Topic

tbrothers
Yak Posting Veteran

83 Posts

Posted - 2009-09-17 : 06:35:41

Hi,

Running SQL 2005, does the SQL server name need to be the same as the server netbios name?

For example, if you right-click My Computer and select Properties and the computer name is MyServer ... If I then run the following two commands will I experience any problems with SQL?

sp_dropserver MyServer
GO
sp_addserver SQLServer01, local
GO

Thanks,
Terry

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2009-09-17 : 16:01:02

You can give server name at time of installation as named instance.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-09-17 : 21:39:19

If you have done default installation ,then yes.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources