well few pple dont know those steps and i decided to share them here ;)
- how to change your pc name ?
- how to change your sql server name ?
HOW TO CHANGE YOUR COMPUTER NAME?
Click on the “Change” button to rename the computer, which will pop up this dialog:
Now you can finally change the name of the computer. You could also change the name of the workgroup to something more descriptive as well. You’ll have to reboot after you make this change.
HOW TO CHANGE YOUR SQL SERVER HOST NAME?
1. Open SQL Server Management Studio and click New Query.
2. Type Select @@ServerName to verify that the server name is correct or incorrect. In this example, I changed the Windows 2003 from WIN2K3R2EE to SQL Server. I did not change the name in SQL Server 2005. It will still return the old name. Let’s fix it.
3. Next, type sp_dropserver ‘WIN2K3R2EE’
4. You are now ready to add the correct name by typing sp_addserver 'SQLSERVER', local
5. Restart sql server and the sql server agent by opening a command prompt and typing net stop mssqlserver and net start msssqlserver. To stop and start the sql server agent, type net stop or start sqlserveragent.
.
6. Click New Query in SQL Server Management Studio and type select @@servername to verify everything is correct and you have successfully changed the sql server name.
Reply With Quote
