Changing the name of your SQL Server
来源:互联网 发布:ui是什么软件 编辑:程序博客网 时间:2024/05/14 10:43
Have you ever had to change the name of a server that has SQL Server installed on it? If you anwered yes, did you know that you also have to change the name in SQL Server? Here are the steps to perform the change.
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.
reference:http://www.techrepublic.com/blog/datacenter/changing-the-name-of-your-sql-server/192
- Changing the name of your SQL Server
- Microsoft® SQL Server 2005: Changing the Paradigm
- [Linux] Touch--Change the time of files after changing your system time
- The changing marketplace of bioinformatics
- Changing the ID of Dynamixel
- YUI Changing the Contents of the DataTable
- Changing the ID of the Dynamixel
- Changing The Size Of An Image
- Changing the sharing of a project
- How to get the SQL Server name (Database server)?
- Changing the hostname or computer name in ubuntu
- SQL Server replication requires the actual server name to make a connection to the server
- Changing the description of the standard SAP fields
- 132 Examine the parameter setting in your database: SQL> SHOW PARAMETER TARGET NAME TYPE VALUE -----
- The server has encountered an error while loading an application during the processing of your reque
- The server has encountered an error while loading an application during the processing of your reque
- 1375 - The Best Name for Your Baby
- UVa1375- The Best Name for Your Baby
- 系统设计与规划--一点总结
- SQL简繁转换
- Thickbox使用中的一些问题
- HTTP/1.1 Cache-Control的理解
- 黑马程序员_java基础加强4
- Changing the name of your SQL Server
- 开始研究MapView
- [转]大型动态应用系统框架
- 比较器
- bean 的内省
- C语言指针详解
- eclipse报错Unhandled event loop exception PermGen space
- jRebel
- C++第5周任务1-2设计默认构造函数,即不指定参数时,默认各边长为1