After modifying the server name, SQL Server's configuration processing

1. Confirm that the SQL DB instance server name and server name are the same

2. Use master

4. Go

6. Select @ @servername

8. Select serverproperty (' servername ')

10. ------

12. IF serverproperty (' servername ') <>@ @servername

14. BEGIN

16. DECLARE @server SYSNAME

18. SET @[email protected] @servername

20. EXEC sp_dropserver @[email protected]

22. SET @server =cast(serverproperty (' servername ') as SYSNAME)

24. EXEC sp_addserver @[email protected],@Local=' local '

26. END

28. ELSE

30. PRINT ' instance name is consistent with hostname without modification! '

See article: http://blog.csdn.net/leamonjxl/article/details/6674698

2, encountered an error

Cannot connect to WMI provider. Permission or the server is unreachable. Note This can only be manage SQL Server 2005 servers with SQL Server Configuration Manager.
Invalid class [0x80041010]

Workaround:

Run the cmd command with Administrator C:\Program Files (x86) \microsoft SQL Server\shared>mofcomp "C:\Program Files\Microsoft SQL Server\ Shared\sqlmgmproviderxpsp2up.mof "

See article: Http://wenku.baidu.com/link?url=2ULpQX9ldyFUd1_PbmrBGEAwp99SG9IL40A27CoVbDhlCOXskJ9FYwX_ Og2kbabuevrkijyjf4jzvznvxayjqidpiry-bceticzjyz8liyk

This article is from the "Fishvsfrog" blog, make sure to keep this source http://fishvsfrog.blog.51cto.com/388027/1435266