Re: cannot log into Reporting Services from SMSS

I can't figure out what you're suggesting, and/or it doesn't work.
When I navigate to https://betav61/reports$ss2k5/Pages/Folder.aspx, it says
"Internet Explorer cannot display this page."
To create a new user, I'm not exactly sure how, but this is what I tried.
In SMSS, under Databases->ReportServer->Security->Users, I right-click New
User. It asks for a User name (I used SQLe) and Login name. It doesn't ask
for a password. I tried all different Login names, but when I add the SQLe
as an Execution Account, it responds "The account name is not valid. Specify
an account in the form domain\alias." I'm not very familiar with
manipulating SQL Server in this way, so please be more detailed in what to
do.

Thanks, Ed

--
Ed


"William Vaughn" wrote:

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
    ... 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
    ... 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