Re: cannot log into Reporting Services from SMSS

Okay, try this: https://betav61/reports$ss2k5/Pages/Folder.aspx
This URL includes the named instance "ss2k5".
Next, get into your Users and create a user "SQLe". Don't worry about rights. Set the password as needed but make sure it does not expire (for now).
Next, open the config manager and choose the Execution Account and choose SQLe as the execution account. When you do so the appropriate rights are automatically set (or should be).


--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
"Ed White" <ewhite@xxxxxxxxxxxxxxxxx> wrote in message news:61EDB8BC-D87F-4369-9011-6EE899AA7ED6@xxxxxxxxxxxxxxxx
In Reporting Services Configuration Manager, on the left, all items are
checked green except for SharePoint Integration and Encryption Keys which are
blue, and Email Settings and Execution Account are yellow. I can Connect
just fine. Under Server Stats, it says it is Initialized and Running. Under
Database Setup, the Database Name is ReportServer, Server Mode is Native,
Credentials Type is Service Credentials. When I change Credentials Type to
something else, it doesn't work (it gives some kind of error), but when I
change it back to Service Credentials, at the bottom is says Number of
Errors: 0 and all of the tasks below get a green check mark. However, I
still cannot log into Reporting Services through SMSS.

I can log into SMSS Database Engine, Analysis Services, etc. using Windows
Authentication with no problem.
--
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
    ... 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)
  • RE: cannot log into Reporting Services from SMSS
    ... In Reporting Services Configuration Manager, on the left, all items are ... 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 ...
    (microsoft.public.sqlserver.connect)
  • Re: VB.NET/Crystal - How do I change a reports connection "integrated security" to FALSE?
    ... open the name of the server and properties until you see the ... bit buggy, so after you save, reopen the report to verify that the change ... FieldExplorer/DatabaseFields and select 'Verify Database' from the menu. ... Since it can't find the database, it prompts for the connection info. ...
    (microsoft.public.dotnet.languages.vb)
Loading