May 13, 2010 at 4:43 pm
I have a computer running Windows Server 2003 SP2.
SQL2005 was installed some time ago. See attached file sql2005.bmp for stats. It was installed as a named instance and is the only instance.
About a year ago, Reporting Services was added. It appears that in doing so, Reporting Services created two more instances for itself, MSSQL.2 and MSSQL.3.
The software that uses this server needs to have SQL2008. The software is also having problems with the named instance, so I want SQL2008 to use the default instance.
I setup a test box, installed SQL2005 as a named instance and then installed SQL2008 as the default instance. My plan was to bring up SQL2008, move the databases, users, and jobs as needed. When everything was working fine, I would uninstall SQL2005 and IIS. Everything seemed to work fine including Reporting Services on the test box.
However, when I went to install SQL2008 on the production box I get this error:
===
[Error Message]
The SQL Server instance 'MSSQLSERVER' already has an Instance ID '2' that is different than the specified Instance ID 'MSSQLSERVER'. Specifying more than one instance ID for the same SQL Server instance is not supported.
[Details]
Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException: The SQL Server instance 'MSSQLSERVER' already has an Instance ID '2' that is different than the specified Instance ID 'MSSQLSERVER'. Specifying more than one instance ID for the same SQL Server instance is not supported.
===
See attachment sql2008setup.bmp
I am wondering if this is because Reporting Services was added later -- in my test I installed it at the same time I installed SQL2005.
It does not matter whether I choose the default instance or a named instance during the SQL2008 install, the error message is the same. I saw other forum threads that had problems, but they do not seem to match my particular circumstances.
Does anyone know how to convince SQL2008 setup to install?
May 14, 2010 at 6:51 am
Hi,
From the error, it looks like there is already an instance with name "MSSQLSERVER". Can you please let us know the name of the reporting services that you have installed? or Please check if the following path already exists in the server
C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER,
I doubt if the reporting services where installed with MSSQLSERVER has the name...
May 14, 2010 at 9:40 am
Here is the directory list:
Directory of C:\Program Files\Microsoft SQL Server
05/13/2010 11:18 AM <DIR> .
05/13/2010 11:18 AM <DIR> ..
05/12/2010 09:43 AM <DIR> 100
04/03/2007 05:11 PM <DIR> 80
04/03/2007 05:21 PM <DIR> 90
04/09/2009 06:12 AM <DIR> InetPub
04/03/2007 05:12 PM <DIR> MSSQL.1
04/09/2009 06:12 AM <DIR> MSSQL.2
04/09/2009 06:20 AM <DIR> MSSQL.3
I don't know what you mean by the name of the reporting services. When we connect to it using SSMS we use CHARLIE\ADMIN.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply