January 31, 2013 at 2:39 pm
Hello,
I am doing my first installation of SQL Server. I need to move a couple databases from a 2005 named instance to a new 2008 instance. I am currently installing the SQL Server 2008 and I wasn't sure if I should give the instance the same name as the 2005 instance. Will this create conflict or will it create conflict if I give it a different name?
I have several client machines, MS Access and reports that will need to be upgraded and connected. I wasn't sure what kind of conflict the instance name could create.
Thanks in advance for your help!
January 31, 2013 at 3:00 pm
The instance name does not matter when moving a DB over to a newer version. I would not name the 08 Instance the same name. I would install with a new name and restore the DB from 05.
MCSE SQL Server 2012\2014\2016
January 31, 2013 at 3:33 pm
Thank you! I did figure out that on the 2005 installation, the default name was used. I have a feeling that using the default is better than giving a name. Is this right? Will I have problems if I re-use the default?
Thanks!
February 1, 2013 at 6:25 am
If you're talking about installing a SQL 2008 instance on the machine where your SQL 2005 instance resides then you will need to give the SQL 2008 instance a different name than the 2005 instance. If SQL 2005 is a default instance then you'll have to install SQL 2008 as a named instance (implies running it on a port other than the default 1433).
Once you disable or uninstall the SQL 2005 instance you can always change your SQL 2008 instance to run on port 1433 which will have it effectively appear as a default instance on the network, i.e. clients will be able to connect to it by only providing the server name, i.e. omitting the instance name.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 1, 2013 at 7:40 am
opc.three is correct, is this on the same server? I thought I had read that it was on a different server. Here are the two scenarios;
a.
if on a new server the instance name does not matter, name it what you want.
b.
on the same server, it HAS to be a different name, it cannot be default, you can easily give it a new instance name during the install. You cannot, no matter what, have the same instance name for sql server on the same machine.
MCSE SQL Server 2012\2014\2016
February 1, 2013 at 11:54 am
You are correct, it is a different (new) server. I gave it the same name.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply