SQL Server 2008 Upgrade

[kermitforney]

We are currently in the process of upgrading to SQL Server 2008 Enterprise edtition. We need to go the side by side route due to the move from 32bit - 64bit as well as some other issues.

The question that I have is in keeping the pre existing SQL Server's name. I plan on shutting down the existing server after backing it up and renaming our test SQL2008 database server to our production server's name. This way all of the ODBC connections should function in the same way.

Am I correct in my assumption as long as all login info and passwords are transferred over.

 

[mrdenny]

If you have Copied the usernames and passwords to the new server, then when you rename the server yes the usernames and passwords will stay.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog