3

I have SQL 2005 SP4 installed on Win2k8. After I had it setup, we decided to change the name of the computer. In doing so, I think I might have broken something (possibly named pipes?) but I'm not sure as a) I'm not a DBA and b) I'm still in the process of setting this server up, so I can't say it was working before. And I really don't want to start over.

However, when I open up SSMS, the instance name shows the correct computer name, but under logins I have {OLDSERVERNAME}\SQLServer2005MSFTEUser${OLDSERVERNAME}$MSSQLSERVER and I think this is breaking my ability to do remote services connections.

So the question is, how to fix this?

Improve this question

3 Answers 3

Reset to default
4

There are considerations you need to be aware of for SQL when renaming the host machine. Do a

SELECT @@SERVERNAME

and see if it is returning the new machine name. If not, have a look through this MSDN article, follow the directions inside.

Improve this answer
1
  • Thanks. I did as the article said, and the servername now comes back correctly. However, the users (named pipes?) still show the old server name in the path. Do I have to delete and recreate? Or am I missing something else?
    – Holocryptic
    Mar 18, 2011 at 17:35
2

exec sp_dropserver 'Oldname' go exec sp_addserver 'Newname', 'local' go

Then go to the SQL Server Configuration Manager and restart the SQL Server (MSSQLSERVER) service.

Improve this answer
2

All of the logins will keep the same name and should work fine. If you want to you can remove them and re-add them. They keep working because SQL uses SIDs to match those logins and groups to the host OS and these SIDs haven't changed. Only the display information is incorrect. The Named Piped protocal itself should be working fine.

Improve this answer
3
  • Thanks for the info. Now I just have to figure out why I still can't connect to the remote database. It's probably something stupid...
    – Holocryptic
    Mar 18, 2011 at 19:27
  • @Holocryptic See the section in the MSDN article I linked to regarding remote logins.
    – squillman
    Mar 18, 2011 at 22:25
  • @squillman Thanks. I overlooked that part because I didn't see that error when I dropped the server. At this point I burned the server down and I'm going to try fresh. Thanks for the help so far, though!
    – Holocryptic
    Mar 18, 2011 at 22:29

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .