cannot log into Reporting Services from SMSS

Hi Peter,

When I try to log into the Report Server from IE per your #1, it returns
essentially "Internet Explorer cannot open this page."

I'm emailing you the last few logs. I noticed at one point in the logs it
says "Evaluation copy: 0 days left". I've installed the Developer version of
SQL Server 2005 with the latest service pack (SP1 I believe). In SMSS, when
I try to log into Analyis Services or any of the others (Integration
Services, etc.), it works--it's just Reporting Services I cannot log into.
I've installed SQL Server 2005 on my laptop, and it responds exactly the same
way (i.e. cannot log into Reporting Services but can log into other services).

I have pulled up the Reporting Services configuration, and everything
appears to be fine (I haven't selected encryption keys, but I don't see how
that should matter).

There is no web.config file in c:\inetpub\wwwroot.

I Googled the error message and found a number of other people have had this
issue, but found no-one that had a suggested fix to it. My guess is that it
has something to do with the "Evaluation Copy" in the log.

Ed



--
Ed


""Peter Yang[MSFT]"" wrote:

> Hello Ed,
>
> To understand the issue better, I'd like to know the following informaiton:
>
> 1. What's the result if you connect to http://servername/reportserver and
> http://servername/report? If you encounter errors, please let me know the
> exact error message.
>
> 2. Please collect the report services log under
>
> C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles
>
> You could send them to me and remove "online" from my displayed email
> address.
>
>
> 3. Did you try to Reporting services configuration from startup menu->All
> Programs->SQL Server 2005->Configuration tools?
>
>
> Please check if the IIS is properly configured in the machine. Is there a
> web.config in c:\inetpub\wwwroot? There shouldn't be one. If there is one,
> please temporarily move the file to another folder and run RS configuration
> tool to see if it helps.
>
> If you have other related information, please feel free to let's know.
> Thank you.
>
> Best Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
 >> Stay informed about: cannot log into Reporting Services from SMSS 

Incidentally, just to clarify, Reporting Services works fine from VS 2005. I
can design and preview reports just fine. The problem is that I cannot log
into Reporting Services from SMSS. I can log into other services (e.g.
Analysis Services, Integration Services, etc.) from SMSS, just not Reporting
Services.
--
Ed


""Peter Yang[MSFT]"" wrote:

> Hello Ed,
>
> To understand the issue better, I'd like to know the following informaiton:
>
> 1. What's the result if you connect to http://servername/reportserver and
> http://servername/report? If you encounter errors, please let me know the
> exact error message.
>
> 2. Please collect the report services log under
>
> C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles
>
> You could send them to me and remove "online" from my displayed email
> address.
>
>
> 3. Did you try to Reporting services configuration from startup menu->All
> Programs->SQL Server 2005->Configuration tools?
>
>
> Please check if the IIS is properly configured in the machine. Is there a
> web.config in c:\inetpub\wwwroot? There shouldn't be one. If there is one,
> please temporarily move the file to another folder and run RS configuration
> tool to see if it helps.
>
> If you have other related information, please feel free to let's know.
> Thank you.
>
> Best Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
 >> Stay informed about: cannot log into Reporting Services from SMSS 

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.
 >> Stay informed about: cannot log into Reporting Services from SMSS 

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.
>
>
 >> Stay informed about: 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.
>
>
 >> Stay informed about: 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" wrote in message

> 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.
>>
>>
 >> Stay informed about: 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" wrote in message
>
> > 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.
> >>
> >>
>
 >> Stay informed about: cannot log into Reporting Services from SMSS 

Hello Ed,

You could try the following steps to grant a login in SQL Server with
sysadmin role:

In SQL Management studio, select Server name->Security->Logins, and right
click the login->Properties->Server roles

Check "sysadmin" role.

Please add a domain user as a new login and grant it sysadmin role.

I'd like to know in database setup if you change the type to Windows
credential, and use the domain user you configure in above step, what's the
exact error message you encounter?

Also, you may want to temporiarily grant "Nt authority/network service"
account with sysadmin role, can you see any difference if you access
http://servername/reportserver?

Please confirm you installed default instance of RS, if it's a named
instance, you need to connect to

http://servername/reportserver$instancename as mentioned by william.

Please let's know if you have any update, please feel free to let's know.
Thank you.

Best Regards,

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


=====================================================

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: cannot log into Reporting Services from SMSS 

When you say in SMSS select Server name...Server roles, there are seven
logins listed. One of them is sa, which is what I assume you were talking
about. "sysadmin" role was already checked for that login.

I don't know how to "add a domain user". I've tried to add a new login, but
was unsuccessful mostly because I'm not familiar with the process.

In Reporting Services Configuration Manager, when I change Credentials Type
to Windows Credentials, I leave the Account Name and Password blank. It
responds:

Number of errors: 0
* There was a failure applying your change.
You need to specify the database name and the server name to run the
selected task(s).

I've left the server name as before (ASUS2), and the database name is
ReportServer.

I installed the ReportServer as part of a full installation of SQL Server
2005--I'm sure I did not ask for a named instance --I generally used the
defaults during installation.
--
Ed


""Peter Yang[MSFT]"" wrote:

> Hello Ed,
>
> You could try the following steps to grant a login in SQL Server with
> sysadmin role:
>
> In SQL Management studio, select Server name->Security->Logins, and right
> click the login->Properties->Server roles
>
> Check "sysadmin" role.
>
> Please add a domain user as a new login and grant it sysadmin role.
>
> I'd like to know in database setup if you change the type to Windows
> credential, and use the domain user you configure in above step, what's the
> exact error message you encounter?
>
> Also, you may want to temporiarily grant "Nt authority/network service"
> account with sysadmin role, can you see any difference if you access
> http://servername/reportserver?
>
> Please confirm you installed default instance of RS, if it's a named
> instance, you need to connect to
>
> http://servername/reportserver$instancename as mentioned by william.
>
> Please let's know if you have any update, please feel free to let's know.
> Thank you.
>
> Best Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
>
> =====================================================
>
> When responding to posts, please "Reply to Group" via your
> newsreader so that others may learn and benefit from this issue.
> ======================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
 >> Stay informed about: cannot log into Reporting Services from SMSS 

Hello Ed,

You could try the following steps to add a domain user to sql logins.

1. In SQL Management studio, select Server name->Security->Logins

2. Right click the logins->New login

3. Type "domainname\username"(without quotes) in Login name box. For
example, you domain name is test and the user name is user1, you should
type "test\user1"(without quotes)

4. Click "server roles" on left panel, and check "sysadmin" role

5. Click OK to add.

After that, please use the login in Report Manager configuration utility:

1. On Database setup panel, select "Windows credential"

2. In Account name, type "domainname\username" (without quotes), and in
password box type the password you use for this account.

3. Check Servername and database to make sure they are correct. You could
click "connect" to test.

4. Click Apply to see the result. Please let me know the error message if
you encounter any.

Please add the domain user as local admin temporarily by following steps:

1. Right click "My Computer"->Manage->Local users and groups

2. Select Groups, and double click "Administrators" group.

3. Click "Add", and type "domainname\username" (without quotes), and click
OK.


Please try to connect http://servername/reportserver to see the result. If
you still see the same error message, please check the report server log to
see if it has the same exception we noticed in previous repot server log.
Thank you for your time.

Best Regards,

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


=====================================================
Please note that the newsgroups are staffed weekdays with a goal to provide
ONE BUSINESS DAY RESPONSE to all posts.
If this response time does not meet your needs, please contact CSS for more
immediate assistance:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone#faq607
<http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone>.
Feedback on your service and satisfaction can be posted to:
from the web interface: Partner Feedback
from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: cannot log into Reporting Services from SMSS 

Hello Ed,

I'm just curious how things are going there. Should you have any questions
or concerns regarding this issue, please don't hesitate to let us know.

Best Regards,

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


=====================================================
Please note that the newsgroups are staffed weekdays with a goal to provide
ONE BUSINESS DAY RESPONSE to all posts.
If this response time does not meet your needs, please contact CSS for more
immediate assistance:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone#faq607
<http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone>.
Feedback on your service and satisfaction can be posted to:
from the web interface: Partner Feedback
from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: cannot log into Reporting Services from SMSS