Reporting Services affected by a server name change?

We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
operating system. We had Reporting Services installed and configured but we
did not use it. A couple of weeks ago the server name was changed. I ran
sp_dropserver and then sp_addserver.
Since then our client want to utilize Reporting Services. Although
configured it is not working. I cannot even access Reporting Services
through SQL Server Management Studio. Could this be the result of the server
name change? What should be done with Reporting Services in the event of a
server name change?Go to RS Config Manager (Start Menu\Programs\Microsoft SQL Server
2005\Configuration Tools)
-Database Setup:
-Change the name in the "Server Name" field to your server's new name
-Click on "Connect"
-Click on "Apply"
-Encryption keys
-Click on "Delete" and Ok (deleting this can give you problems on an
active production server)
-Open the file C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\rsreportserver.config
and change the line
<UrlRoot>http://OldServerName/reportserver</UrlRoot>
to
<UrlRoot>http://NewServerName/reportserver</UrlRoot>
-In MSIE, check the following addresses:
http://localhost/reports
http://localhost/reportserver
-Try to connect to Reporting Services through Management Studio
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Loren Z" <anonymous@.discussions.microsoft.com> wrote in message
news:e$M4P4ThIHA.2268@.TK2MSFTNGP02.phx.gbl...
> We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
> operating system. We had Reporting Services installed and configured but
> we did not use it. A couple of weeks ago the server name was changed. I
> ran sp_dropserver and then sp_addserver.
> Since then our client want to utilize Reporting Services. Although
> configured it is not working. I cannot even access Reporting Services
> through SQL Server Management Studio. Could this be the result of the
> server name change? What should be done with Reporting Services in the
> event of a server name change?
>

Reporting Services affected by a server name change?

We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
operating system. We had Reporting Services installed and configured but we
did not use it. A couple of weeks ago the server name was changed. I ran
sp_dropserver and then sp_addserver.
Since then our client want to utilize Reporting Services. Although
configured it is not working. I cannot even access Reporting Services
through SQL Server Management Studio. Could this be the result of the server
name change? What should be done with Reporting Services in the event of a
server name change?Go to RS Config Manager (Start Menu\Programs\Microsoft SQL Server
2005\Configuration Tools)
-Database Setup:
-Change the name in the "Server Name" field to your server's new name
-Click on "Connect"
-Click on "Apply"
-Encryption keys
-Click on "Delete" and Ok (deleting this can give you problems on an
active production server)
-Open the file C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\rsreportserver.config
and change the line
<UrlRoot>http://OldServerName/reportserver</UrlRoot>
to
<UrlRoot>http://NewServerName/reportserver</UrlRoot>
-In MSIE, check the following addresses:
http://localhost/reports
http://localhost/reportserver
-Try to connect to Reporting Services through Management Studio
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Loren Z" <anonymous@.discussions.microsoft.com> wrote in message
news:e$M4P4ThIHA.2268@.TK2MSFTNGP02.phx.gbl...
> We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
> operating system. We had Reporting Services installed and configured but
> we did not use it. A couple of weeks ago the server name was changed. I
> ran sp_dropserver and then sp_addserver.
> Since then our client want to utilize Reporting Services. Although
> configured it is not working. I cannot even access Reporting Services
> through SQL Server Management Studio. Could this be the result of the
> server name change? What should be done with Reporting Services in the
> event of a server name change?
>sql

Reporting Services affected by a server name change?

We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
operating system. We had Reporting Services installed and configured but we
did not use it. A couple of weeks ago the server name was changed. I ran
sp_dropserver and then sp_addserver.
Since then our client want to utilize Reporting Services. Although
configured it is not working. I cannot even access Reporting Services
through SQL Server Management Studio. Could this be the result of the server
name change? What should be done with Reporting Services in the event of a
server name change?
Go to RS Config Manager (Start Menu\Programs\Microsoft SQL Server
2005\Configuration Tools)
-Database Setup:
-Change the name in the "Server Name" field to your server's new name
-Click on "Connect"
-Click on "Apply"
-Encryption keys
-Click on "Delete" and Ok (deleting this can give you problems on an
active production server)
-Open the file C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\rsreportserver.config
and change the line
<UrlRoot>http://OldServerName/reportserver</UrlRoot>
to
<UrlRoot>http://NewServerName/reportserver</UrlRoot>
-In MSIE, check the following addresses:
http://localhost/reports
http://localhost/reportserver
-Try to connect to Reporting Services through Management Studio
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Loren Z" <anonymous@.discussions.microsoft.com> wrote in message
news:e$M4P4ThIHA.2268@.TK2MSFTNGP02.phx.gbl...
> We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
> operating system. We had Reporting Services installed and configured but
> we did not use it. A couple of weeks ago the server name was changed. I
> ran sp_dropserver and then sp_addserver.
> Since then our client want to utilize Reporting Services. Although
> configured it is not working. I cannot even access Reporting Services
> through SQL Server Management Studio. Could this be the result of the
> server name change? What should be done with Reporting Services in the
> event of a server name change?
>

Reporting Services Addin - Set Server Defaults Error

Hey All,

I installed Reporting Services Add-in with no problems on a Virtual server that already hosts MOSS 2007 and configured everything that was stated in documentation. The Report server Url works fine..like http://myserver1:802/ReportServer and I can see the contents when I type this url.

However, when I go to Central Administration and click on "Set Server Defaults"...I am getting a "401.1 Unauthorized..." error.I setup the Manage Integration to TrustedAccount and the Grant DatabaseAccess to the account that is the Server.Farm and local administrator.

In the Reporting Services Configuration, I used SSRSWebAccount for WebService and SSRSWindowsAccount for WindowsService and the RSAppPool which is the ApplicationPool for ReportingServices Web Site uses the SSRSWindowsAccount only.

Anybody..please help.

Thanks,

Vedala

I resolved my problem by installing SQL Server 2005 SP2. All along I assumed my virtual machine had SQL Server 2005 SP2, but after looking closely, I found that my version was 9.0.3033 and not 9.0.3042 which is official SP2 release version. I grabbed that and reinstalled it on my image and everything started working.

I however did couple of other steps too...which I did not go back and undo and test..so at this point I am not really sure if only the above was the problem or something else.,,, I will update this post with the blog entry about my issue later.

Thanks,

Vedala

Reporting Services Addin - Set Server Defaults Error

Hey All,

I installed Reporting Services Add-in with no problems on a Virtual server that already hosts MOSS 2007 and configured everything that was stated in documentation. The Report server Url works fine..like http://myserver1:802/ReportServer and I can see the contents when I type this url.

However, when I go to Central Administration and click on "Set Server Defaults"...I am getting a "401.1 Unauthorized..." error.I setup the Manage Integration to TrustedAccount and the Grant DatabaseAccess to the account that is the Server.Farm and local administrator.

In the Reporting Services Configuration, I used SSRSWebAccount for WebService and SSRSWindowsAccount for WindowsService and the RSAppPool which is the ApplicationPool for ReportingServices Web Site uses the SSRSWindowsAccount only.

Anybody..please help.

Thanks,

Vedala

I resolved my problem by installing SQL Server 2005 SP2. All along I assumed my virtual machine had SQL Server 2005 SP2, but after looking closely, I found that my version was 9.0.3033 and not 9.0.3042 which is official SP2 release version. I grabbed that and reinstalled it on my image and everything started working.

I however did couple of other steps too...which I did not go back and undo and test..so at this point I am not really sure if only the above was the problem or something else.,,, I will update this post with the blog entry about my issue later.

Thanks,

Vedala

sql

Reporting Services 2005 in SharePoint Integrated mode with formsauthentication problem

Well, I have reporting services 2005 installed and configured in
sharepoint integrated mode, so I am deploying reports in sharepoint
libraries. After that I configured sharepoint to use forms
authentication with builtin AspNetSqlMembership provider, but this
action caused reports to not execute. I searched and found hotfix 3186
for this issue and applied it, but nothing has changed!
Error I have been experiencing is following:
An unexpected error occurred while connecting to the report server.
Verify that the report server is available and configured for
SharePoint integrated mode. --> The request failed with the error
message:
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="http://links.10026.com/?link=/_layouts/login.aspx?ReturnUrl=
%2f_vti_bin
%2fReportServer%2fReportService2006.asmx">here</a>.</h2>
</body></html>
anyone can help? maybe i have not configured something correctly...
Irakli
It would be better of you post that question in .reportrtingsvcs or
sharepoint user group.
"Irakli" <Irakli.Rostiashvili@.gmail.com> wrote in message
news:5e330a25-f9bb-4657-9e26-e00a0ab96f6f@.m34g2000hsf.googlegroups.com...
> Well, I have reporting services 2005 installed and configured in
> sharepoint integrated mode, so I am deploying reports in sharepoint
> libraries. After that I configured sharepoint to use forms
> authentication with builtin AspNetSqlMembership provider, but this
> action caused reports to not execute. I searched and found hotfix 3186
> for this issue and applied it, but nothing has changed!
> Error I have been experiencing is following:
> An unexpected error occurred while connecting to the report server.
> Verify that the report server is available and configured for
> SharePoint integrated mode. --> The request failed with the error
> message:
> --
> <html><head><title>Object moved</title></head><body>
> <h2>Object moved to <a href="http://links.10026.com/?link=/_layouts/login.aspx?ReturnUrl=
> %2f_vti_bin
> %2fReportServer%2fReportService2006.asmx">here</a>.</h2>
> </body></html>
> anyone can help? maybe i have not configured something correctly...

Reporting Services 2005 in SharePoint Integrated mode with forms

Well, I have reporting services 2005 installed and configured in
sharepoint integrated mode, so I am deploying reports in sharepoint
libraries. After that I configured sharepoint to use forms
authentication with builtin AspNetSqlMembership provider, but this
action caused reports to not execute. I searched and found hotfix 3186
for this issue and applied it, but nothing has changed!
Error I have been experiencing is following:
An unexpected error occurred while connecting to the report server.
Verify that the report server is available and configured for
SharePoint integrated mode. --> The request failed with the error
message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="http://links.10026.com/?link=/_layouts/login.aspx?ReturnUrl= %2f_vti_bin
%2fReportServer%2fReportService2006.asmx">here</a>.</h2>
</body></html>
anyone can help? maybe i have not configured something correctly...Irakli
It would be better of you post that question in .reportrtingsvcs or
sharepoint user group.
"Irakli" <Irakli.Rostiashvili@.gmail.com> wrote in message
news:5e330a25-f9bb-4657-9e26-e00a0ab96f6f@.m34g2000hsf.googlegroups.com...
> Well, I have reporting services 2005 installed and configured in
> sharepoint integrated mode, so I am deploying reports in sharepoint
> libraries. After that I configured sharepoint to use forms
> authentication with builtin AspNetSqlMembership provider, but this
> action caused reports to not execute. I searched and found hotfix 3186
> for this issue and applied it, but nothing has changed!
> Error I have been experiencing is following:
> An unexpected error occurred while connecting to the report server.
> Verify that the report server is available and configured for
> SharePoint integrated mode. --> The request failed with the error
> message:
> --
> <html><head><title>Object moved</title></head><body>
> <h2>Object moved to <a href="http://links.10026.com/?link=/_layouts/login.aspx?ReturnUrl=> %2f_vti_bin
> %2fReportServer%2fReportService2006.asmx">here</a>.</h2>
> </body></html>
> anyone can help? maybe i have not configured something correctly...