How can I install a 2nd Reporting Services instance ?
after correct installation, in sql server configuration manager, you should see
two reporting services(different names)
one sql server (MSSQLSERVER)If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.
Sevengiants.com
February 18th, 2011 8:54pm
after correct installation, in sql server configuration manager, you should see
two reporting services(different names)
one sql server (MSSQLSERVER)If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.
Sevengiants.com
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2011 8:54pm
Hello,
I already have a Reporting Services instance but I would like to create another. How can I do it ? I ran the SQl Server 2008 setup program, add features to an instance, but i can't choose anything, the checkboxes are disabled.
Can someone help me ? Thank you.
February 18th, 2011 11:26pm
Hi djraphi23,
If you go to add remove programs and repair the installation it will give you option to add another instance of reporting services on that computer. You can add it with a different instance name and it will create seperate directory structure for you.
Regards,
Vikram Kansal
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2011 11:32pm
Thank you for your quick answer. I think I see what you mean, i clicked on "add features" in the add remove programs, i selected the SQL server installation folder, but then i select "add features to an existing instance", all the features
checkboxes all disabled ...
February 19th, 2011 12:13am
is 2005 or 2008? 2008 onwards, you have a shortcut in start menu
MSSQL2008 - Configuration Tools - SQL Server Installation Center
choose new installation
Or you can try install from command line
How to: Install SQL Server 2005 from the Command Prompt
http://msdn.microsoft.com/en-us/library/ms144259%28v=sql.90%29.aspx
How to: Install SQL Server 2008 R2 from the Command Prompt
http://msdn.microsoft.com/en-us/library/ms144259.aspxIf you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.
Sevengiants.com
Free Windows Admin Tool Kit Click here and download it now
February 19th, 2011 12:26am
is 2005 or 2008? 2008 onwards, you have a shortcut in start menu
MSSQL2008 - Configuration Tools - SQL Server Installation Center
choose new installation
Or you can try install from command line
How to: Install SQL Server 2005 from the Command Prompt
http://msdn.microsoft.com/en-us/library/ms144259%28v=sql.90%29.aspx
How to: Install SQL Server 2008 R2 from the Command Prompt
http://msdn.microsoft.com/en-us/library/ms144259.aspxIf you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.
Sevengiants.com
February 19th, 2011 12:26am
Are saying that I need to install a new MSSQLSERVER instance ? can't I install only a new SSRS instance that will use the SQL Server instance already installed ?
Free Windows Admin Tool Kit Click here and download it now
February 19th, 2011 12:34am
Are saying that I need to install a new MSSQLSERVER instance ? can't I install only a new SSRS instance that will use the SQL Server instance already installed ?
February 19th, 2011 12:34am
they are just bound together, once you get to the screen to chose components, make sure you only tick the SSRS then.
for cmd line,
Installing Reporting Services from the Command Prompt
http://msdn.microsoft.com/en-us/library/ms144272%28v=sql.90%29.aspx
make sure change
INSTANCENAME=MSSQLSERVER
default instance name is
MSSQLSERVER
so make sure you change it
If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.
Sevengiants.com
Free Windows Admin Tool Kit Click here and download it now
February 19th, 2011 12:39am
they are just bound together, once you get to the screen to chose components, make sure you only tick the SSRS then.
for cmd line,
Installing Reporting Services from the Command Prompt
http://msdn.microsoft.com/en-us/library/ms144272%28v=sql.90%29.aspx
make sure change
INSTANCENAME=MSSQLSERVER
default instance name is
MSSQLSERVER
so make sure you change it
If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.
Sevengiants.com
February 19th, 2011 12:39am
Ok thank you, last question :
with this new SSRS instance, i can connect to the default instance MSSQLSERVER ?
Free Windows Admin Tool Kit Click here and download it now
February 19th, 2011 12:50am
Ok thank you, last question :
with this new SSRS instance, i can connect to the default instance MSSQLSERVER ?
February 19th, 2011 12:50am
Yes of course. why not?If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.
Sevengiants.com
Free Windows Admin Tool Kit Click here and download it now
February 19th, 2011 12:52am
Yes of course. why not?If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.
Sevengiants.com
February 19th, 2011 12:52am