RE: cannot log into Reporting Services from SMSS

Also, I'm not sure how to grant "sysadmin" server role to the credential I
use, since I am using Windows Authentication. How do I do this?
--
Ed


""Peter Yang[MSFT]"" wrote:

Hello Ed,


It's normal that "Evaluation copy: 0 days left" appears since 0 days means
unlimited days. The following is copied from my test machine and it's a
Enterprise edition.

ReportingServicesService!resourceutilities!9!11/01/07-05:36:25:: i INFO:
Reporting Services starting SKU: Enterprise
ReportingServicesService!resourceutilities!9!11/01/07-05:36:25:: i INFO:
Evaluation copy: 0 days left


I think the issue is caused by that RS cannot connect to report server
database server as shown in the following exception:


ReportingServicesService!library!d!1/27/2008-20:08:29:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavai
lableException: The report server cannot open a connection to the report
server database. A connection to the database is required for all requests
and processing., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavai
lableException: The report server cannot open a connection to the report
server database. A connection to the database is required for all requests
and processing. ---> System.Data.SqlClient.SqlException: A transport-level
error has occurred when sending the request to the server. (provider:
Shared Memory Provider, error: 0 - No process is on the other end of the
pipe.)
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjec
t stateObj)
at System.Data.SqlClient.TdsParserStateObject.WriteSni()
at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode)
at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray,
Int32 timeout, Boolean inSchema, SqlNotificationRequest
notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
--- End of inner exception stack trace ---


In Reporting services configuration utitlity, please check credential you
use in "database setup" entry. Please make sure the report server
database/server name is configured properly. Also, please make sure the
credential you use has the proper permission on the SQL instance/database.
Please click Connect to verify that the instance of SQL Server 2005 is
available.

If you encounter problem, you may want to temporarily grant "sysadmin"
server role to the credential you use. If you connect to the server by
using the credential by using SQL Server management studio, can you log on
properly? Can you see Reportserver database and can you access the database
properly?

Please let's know if you have any update. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support



======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • Re: How long should statspack.snap take to run?
    ... While the default report has limited ... database seemed to be performing slower than expected. ... 2.2GHz Oracle server with a dual 3.66GHz Oracle server. ... a client computer problem and the finger is pointed at the computer ...
    (comp.databases.oracle.server)
  • Re: MSSQL$SBSMonitoring Database size (SBS2003)
    ... You can use the SQL Client Utilities to try and shrink the database. ... to delete over 90 day old information from the monitoring ... The server will start to collect new counter value ... Check 'View the usage report in Server Management' option. ...
    (microsoft.public.windows.server.sbs)
  • Re: cannot log into Reporting Services from SMSS
    ... Under Server Stats, it says it is Initialized and Running. ... Database Setup, the Database Name is ReportServer, Server Mode is Native, ... I think the issue is caused by that RS cannot connect to report server ... exception, Boolean breakConnection) ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot log into Reporting Services from SMSS
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... Database Setup, the Database Name is ReportServer, Server Mode is Native, ... I think the issue is caused by that RS cannot connect to report server ... exception, Boolean breakConnection) ...
    (microsoft.public.sqlserver.connect)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
Loading