How to configure SCE 2007 with remote instance of SQL 2005 Std
I'm trying to install System Center Eseentials so that it'll connect to a separate SQL Server 2005 database instnace. I understand that SQL Reporting Services SP1 is required on the SCE box, so I installed that first, and then manually created a database on the SQL box called SCE2007.
For some reason, during the SCE install, and on the Databse type page, the area to 'iUse an existing remote SQL server instance' is still greyed out.
Thoughts?
Answers
Hi circulent,
Besides collecting the log files, please also check the following:
A. The edition of SQL Server 2005 should be compatible with SRS.
For your scenario, please confirm that Service Pack 1 has been installed on the remote SQL Server.
B. Please ensure that SQL instance for SCE has been installed on SQL Server, but not only database(named SCE2007).
C. SQL Reporting server need to be configured after it installed.
The following steps can help you to configure SRS via “Reporting Services Configuration” tool:
1. Open ”Reporting Services Configuration” tool.
a. Click ”Start” ,find ”All Programs” then “Microsoft SQL Server 2005”.
b. Click ”Configuration Tools”, find “Reporting Services Configuration” and then open it.
2. Please click “Connect” in the pop-up message.
(Note: Machine Name is SCE Server name, Instance Name is “MSSQLSERVER” if you install with default SRS instance .)
3. Follow the wizard to finish all the configurations one by one listed on the left pane.
a. “Report Server Virtual Directory”: click new and use the default settings and then click ”Apply”
(Note: Do not select “Require Secure Socket Layer (SSL) connections”)
b. “Report Manager Virtual Directory”: click new and use the default settings and then click ”Apply”.
c. “Windows Service Identity”: select the account which you use to install SRS.
(Note: account must has administrative privilege.)
d. “Web Service Identity”: choose reportserver in report server and report manager.
(Note: Asp.NET Service Account should be “NT Authority\NetworkService”)
e. “Database Setup”: click “New”, type the SQL Server name and Database name, and then click ”OK”.
(Note: if it cannot connect to the remote SQL Server, please check the connection between these two computers and confirm that the remote connection configuration for SQL Server has be done.)
4. Check that list in left pane have all be configured except “Email Settings”, ”Execution Account”, ”Encryption Keys” and ”Sharepoint Integration”.
5. Click exit and finish the SRS configuration.
If it is not the issue, please send SCESetupx.log from %TEMP% to SCEDATA@microsoft.com or post it here.
More Information regarding SRS:
TechNet Webcast: Overview of SQL Server 2005 Reporting Services (Level 200)
Reporting Services Configuration F1 Help
http://technet.microsoft.com/en-us/library/ms187055.aspx
Reporting Services Configuration Tool
http://technet.microsoft.com/en-us/library/ms156305.aspx
Note:
Please include the following three lines in the email body:
Post: How to configure SCE 2007 with remote instance of SQL 2005 Std?
http://forums.microsoft.com/TechNet/ShowPost.aspx?postid=2091689&siteid=17
Xiu Zhang - MSFT
Regarding more information about how to send email to SCEDATA@microsoft.com, please refer to:
How to send files to the Microsoft SCE team for review
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1680389&SiteID=17
Post a quick note in the current thread after sending the email.
Thanks!
Best regards,
Xiu Zhang - MSFT
Microsoft Online Community Support
All Replies
Can you post the contents of %TEMP%\SCESetupx.log? This should detail why the SRS instance on your machine is not being recognized as valid and causing options to be grayed out.Hi circulent,
Besides collecting the log files, please also check the following:
A. The edition of SQL Server 2005 should be compatible with SRS.
For your scenario, please confirm that Service Pack 1 has been installed on the remote SQL Server.
B. Please ensure that SQL instance for SCE has been installed on SQL Server, but not only database(named SCE2007).
C. SQL Reporting server need to be configured after it installed.
The following steps can help you to configure SRS via “Reporting Services Configuration” tool:
1. Open ”Reporting Services Configuration” tool.
a. Click ”Start” ,find ”All Programs” then “Microsoft SQL Server 2005”.
b. Click ”Configuration Tools”, find “Reporting Services Configuration” and then open it.
2. Please click “Connect” in the pop-up message.
(Note: Machine Name is SCE Server name, Instance Name is “MSSQLSERVER” if you install with default SRS instance .)
3. Follow the wizard to finish all the configurations one by one listed on the left pane.
a. “Report Server Virtual Directory”: click new and use the default settings and then click ”Apply”
(Note: Do not select “Require Secure Socket Layer (SSL) connections”)
b. “Report Manager Virtual Directory”: click new and use the default settings and then click ”Apply”.
c. “Windows Service Identity”: select the account which you use to install SRS.
(Note: account must has administrative privilege.)
d. “Web Service Identity”: choose reportserver in report server and report manager.
(Note: Asp.NET Service Account should be “NT Authority\NetworkService”)
e. “Database Setup”: click “New”, type the SQL Server name and Database name, and then click ”OK”.
(Note: if it cannot connect to the remote SQL Server, please check the connection between these two computers and confirm that the remote connection configuration for SQL Server has be done.)
4. Check that list in left pane have all be configured except “Email Settings”, ”Execution Account”, ”Encryption Keys” and ”Sharepoint Integration”.
5. Click exit and finish the SRS configuration.
If it is not the issue, please send SCESetupx.log from %TEMP% to SCEDATA@microsoft.com or post it here.
More Information regarding SRS:
TechNet Webcast: Overview of SQL Server 2005 Reporting Services (Level 200)
Reporting Services Configuration F1 Help
http://technet.microsoft.com/en-us/library/ms187055.aspx
Reporting Services Configuration Tool
http://technet.microsoft.com/en-us/library/ms156305.aspx
Note:
Please include the following three lines in the email body:
Post: How to configure SCE 2007 with remote instance of SQL 2005 Std?
http://forums.microsoft.com/TechNet/ShowPost.aspx?postid=2091689&siteid=17
Xiu Zhang - MSFT
Regarding more information about how to send email to SCEDATA@microsoft.com, please refer to:
How to send files to the Microsoft SCE team for review
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1680389&SiteID=17
Post a quick note in the current thread after sending the email.
Thanks!
Best regards,
Xiu Zhang - MSFT
Microsoft Online Community Support
As this thread has been quiet for a while, we assume that the issue has been resolved. At this time, we will mark it as ‘Answered’ as the previous steps should be helpful for many similar scenarios.
If the issue still persists and you want to return to this question, please reply this post directly so we will be notified to follow it up. You can also choose to unmark the answer as you wish.
In addition, we’d love to hear your feedback about the solution. By sharing your experience you can help other community members facing similar problems.
Thanks!
Hi Xiu,
For some reason I did not get an e-mail that you replied. So sorry for the delay.
It seems I'm having issues interpreting the installation guide. Prior to following your steps above, should I ONLY install the SQL Server 2005 Reporting Services on the SCE box? And after that should I install a new database instance on my SQL box? And then should I run through your steps.
I guess I'm confused about the order of things.
Thanks
Hi,
In this issue, the option of “Use an existing remote SQL server instance” was grayed out. I think some requirements for remote SQL database are not met so the SCE installation makes it not available.
Actually, in my last reply, I suggested we check the following:
1. A valid SQL Report Service instance has been installed already on the computer which will be installed as the SCE server.
2. The local SRS instance has been previously configured so it is ready for the new SCE installation.
In my last email (especially Step #C), I provided steps on how to configure SRS instance. Please follow the steps and check if the issue can be resolved.
If it still exists, please send SCESetupx.log from the %TEMP% folder to SCEDATA@microsoft.com.
Note:
Please include the following three lines in the email body:
Post: How to configure SCE 2007 with remote instance of SQL 2005 Std?
http://forums.microsoft.com/TechNet/ShowPost.aspx?postid=2091689&siteid=17
Xiu Zhang - MSFT
Regarding more information about how to send email to SCEDATA@microsoft.com, please refer to:
How to send files to the Microsoft SCE team for review
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1680389&SiteID=17
Post a quick note in the current thread after sending the email.
Thanks!
Best regards,
Xiu Zhang - MSFT
Microsoft Online Community Support
I have the same issue with SCE 2007 installation with local instance of SQL database and reporting service. Installation fails to detect SQL reporting services (SRS) instance, even though it is installed , configured ,initialized and running.
My system details are : Windows server 2003 R2 SP2 standard x64 , SQL standard x64 with sp2, SCE 2007 sp1.
After selecting an existing local SQL server instance (MYSERVER\SCE), in the next page , SCE setup warning appears with " The selected SQL Reporting Server instance is not configured . To continue with setup , you must first configure the SQL Reporting server instance using SQL server's Reporting services Configuration Manager."
I have tried several reinstallations of SQL and reporting services , and gone through all suggestions in this forum but with no luck.
Kindly advice what is going wrong here.
- Hello,
I am having the exact same issue above with Windows Server 2008 SP2, which has IIS7. I do not have a Web Service Identity to pick from. No Application pool was created.
Any help wouod be appreciated.
Randy
