Showing posts with label box. Show all posts

Monday, March 26, 2012

Reporting Services Roles not seeing presenting AD dialog box

Hi,
We have installed RS 2K5 & SQL 2K5 on Windows XP with SP2. SQL and RS have
all patches applied. When we try and set the permissions on a report that
has been uploaded or created we are not able to specify domain users. This
causes the report not to be viewable by the end user we are testing with.
What does happen when you right mouse click on:
Report Server
Home
ReportName
Is you get the window for "Resouce Properties - Home/Reportname. If we then
click on the Add Group or User... button we are prompted with a dialog box
that has a free form text field with the prompt of "type the name of a
security group or user to which you want to give permissions". In all the
examples that we see on line as well as the Microsoft Events (webinars) it
show the AD dialog box prompt so that you can choose someone or something
from AD. In this case we can't. This then leaves us stuck.
We would prefer to run this in Integrated Security mode with Kerberos. We
have the SPN set although we don't need it because IIS and SQL are running on
the same box. We do have the SPN set because future reports will not use the
local database but rather another SQL database as their source for data.
Again the real problem is because we can't set domain or local users
correctly. It is as if somewhere it thinks we have sql authorization set.
Any pointers would be appreciated.You know something, I have never gotten AD to work "quite right" when using
a Windows XP machine - something to do with the behavior of IIS 5.0...
Have you tried this on a Windows Server 2003 machine? (I know that works for
sure). :)
=-Chris
"Fred Lobmeyer" <Lobmeyer@.myalias.postalias> wrote in message
news:FB36D3F8-979B-4864-A064-CE301DB875B2@.microsoft.com...
> Hi,
> We have installed RS 2K5 & SQL 2K5 on Windows XP with SP2. SQL and RS
> have
> all patches applied. When we try and set the permissions on a report that
> has been uploaded or created we are not able to specify domain users.
> This
> causes the report not to be viewable by the end user we are testing with.
> What does happen when you right mouse click on:
> Report Server
> Home
> ReportName
> Is you get the window for "Resouce Properties - Home/Reportname. If we
> then
> click on the Add Group or User... button we are prompted with a dialog box
> that has a free form text field with the prompt of "type the name of a
> security group or user to which you want to give permissions". In all the
> examples that we see on line as well as the Microsoft Events (webinars) it
> show the AD dialog box prompt so that you can choose someone or something
> from AD. In this case we can't. This then leaves us stuck.
> We would prefer to run this in Integrated Security mode with Kerberos. We
> have the SPN set although we don't need it because IIS and SQL are running
> on
> the same box. We do have the SPN set because future reports will not use
> the
> local database but rather another SQL database as their source for data.
> Again the real problem is because we can't set domain or local users
> correctly. It is as if somewhere it thinks we have sql authorization set.
> Any pointers would be appreciated.
>

Wednesday, March 21, 2012

Reporting Services on a development box?

Hi,
Our live and test servers are enterprise edition, but development servers are developer edition, due to not needing to match the live spec exactly. What can we do about reporting services, since this product will not install on the developer edition of SQL Server'
Many thanksPlease refer to
http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp for system
requirements. You can install RS 2000 on Standard, Enterprise, or Developer
Edition of SQL Server. However, installing it on Desktop Edition of SQL
Server is unsupported.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy" <Andy@.discussions.microsoft.com> wrote in message
news:8C6B7F39-D421-46E1-B8FF-6D0A1BD84E2C@.microsoft.com...
> Hi,
> Our live and test servers are enterprise edition, but development servers
are developer edition, due to not needing to match the live spec exactly.
What can we do about reporting services, since this product will not install
on the developer edition of SQL Server'
> Many thanks

Reporting Services Login Problem

Hi All,
I am getting Reporting Services Login box , when trying to deploy the
reporting services reports on the test server.
After entering username/password it does not do anything, I mean not
allowing to deploy.
I am unable to deploy straight from VS2005 (on development box) to the
test server which is on another domain.
(I tried even adding myself to administrator groups on another
domain).
I have developed the project on my development box,It works fine if I
copy accross the rdl files and upload them.
I am able to run/view the reportmanager and reportserver on the
another domain.
Any help much appreciated.
CheersI think, give the credentials in the datasource and save it, so that it wont
ask for username / password. Moreover just check the report project
parameters
ie target server URL (it should be http://<server>/reportserver) and
overwrite Datasource (keep it true)
just check this things and let me know still you have some probs.
Amarnath
"Veera" wrote:
> Hi All,
> I am getting Reporting Services Login box , when trying to deploy the
> reporting services reports on the test server.
> After entering username/password it does not do anything, I mean not
> allowing to deploy.
> I am unable to deploy straight from VS2005 (on development box) to the
> test server which is on another domain.
> (I tried even adding myself to administrator groups on another
> domain).
> I have developed the project on my development box,It works fine if I
> copy accross the rdl files and upload them.
> I am able to run/view the reportmanager and reportserver on the
> another domain.
> Any help much appreciated.
> Cheers
>

Tuesday, March 20, 2012

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.

I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I have solve this problem, myself. The problem is that i have written the target server url only to http://localhost/ but when i change it to "http://localhost/reportserver" it work fines. so in this way all of you check your target server url to remove this problem|||I have been hoping for resolution of this problem. Having recently installed SS05, I have not yet got this sorted. I have followed generic instructions, incl. IIS set ups, deployment options (incl using http:\\localhost\ReportServer), but still get the credentials request. I have local admin rights to server\ using windows domain account. Could you be more explicit (sorry!) Paul about how to give necessary access to (which) folders, given I am using default settings?

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

|||I found this thread because I was experiencing the same issue described here. I just found a resolution, for my specific case anyway. It turns out that the report server path property was wrong in the reports project properties. I had to create the reports web site http://localhost:81/reports and I neglected to put in the port number in the properties so it was attempting to access a site that didn't exist.

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

I have the opposite problem. I am trying to deploy the solution and it is using some other login to try to deploy. This other login does not have the correct rights to deploy. How do I get Visual Studio to prompt for the login name and password when I am trying to deploy the solution. I have checked that the target is correct. I have deleted all cookies and internet files from my PC, removed all other (file share) connections to the server and rebooted. Still no luck - it still wants to use the old login id.

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

1. Open your project in SQL Server Business Intelligence Development Studio
2. Select the project menu followed by the properties of the project.
3. Change the TargetServerURL: To the appropriate path to your reportserver.

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

sry for the second post. This solution works for me.
|||

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Monday, March 12, 2012

Reporting services initilization problem

Hello,
I installed RS on a Windows 2003 box with SQL Server 2000 sp3. Unfortunately
setup reported that it could not initialize RS and it has to be initialized
manually
I have tried:
rsconfig & rsactivate with tons of different combinations of users ranging
from local system account to domain admin No luck, neither windows nor sql
authentications work, I tried some solutions suggested here and there like
re registering .net 1.1, installing a hotfix, adding permission to some
registry keys... etc. no luck.
The server is not a DC,
It's not going to be a part of a RS webfarm
A clean RS database is being used
There are no other web sites on the server
I tried re installing many many times, I even reinstalled SQL server and
applied sp3, still no luck...
It reports of a database connection failure, but I tried to config/activate
it as sa or windows admin it still fails...
I am out of options at this point. Anyone has a suggestion?
Thanks
PS: Below are the error messages from the log and rsactivate
w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
System.Web.Services.Protocols.SoapException: The report server installation
is not initialized. Check the documentation for more information. -->
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information. --> System.Runtime.InteropServices.COMException
(0x80004005): -2147159551 --> System.Exception: 0x8007007f
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
item, StringCollection& Operations)
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
--Details--
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: The report server installation
is not initialized. Check the documentation for more information. -->
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information. --> System.Runtime.InteropServices.COMException
(0x80004005): -2147159551 --> System.Exception: 0x8007007f
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
--RSACTIVATE--
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer>rsac
tivate -c rsreportserver.config
Failure starting the web service:
Unable to connect to the database (-2147159551) 0x8007007fThe only thing I can think to try is reinstalling MDAC. You can find the
download here.
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Skeptical" <skep@.yahoo.com> wrote in message
news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> Unfortunately setup reported that it could not initialize RS and it has to
> be initialized manually
> I have tried:
> rsconfig & rsactivate with tons of different combinations of users
> ranging from local system account to domain admin No luck, neither
> windows nor sql authentications work, I tried some solutions suggested
> here and there like re registering .net 1.1, installing a hotfix, adding
> permission to some registry keys... etc. no luck.
> The server is not a DC,
> It's not going to be a part of a RS webfarm
> A clean RS database is being used
> There are no other web sites on the server
> I tried re installing many many times, I even reinstalled SQL server and
> applied sp3, still no luck...
> It reports of a database connection failure, but I tried to
> config/activate it as sa or windows admin it still fails...
> I am out of options at this point. Anyone has a suggestion?
> Thanks
> PS: Below are the error messages from the log and rsactivate
>
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32 clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> pathTranslator, String userSuppliedPath, String parameterName)
> at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> item, StringCollection& Operations)
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> --RSACTIVATE--
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsac
> tivate -c rsreportserver.config
> Failure starting the web service:
> Unable to connect to the database (-2147159551) 0x8007007f
>|||Well, I forgot to mention. I have already tried that :(
I am thinking of reinstalling 2003 or even downgrading to 2000
Any other suggestions ?
"Skeptical" <skep@.yahoo.com> wrote in message
news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> Unfortunately setup reported that it could not initialize RS and it has to
> be initialized manually
> I have tried:
> rsconfig & rsactivate with tons of different combinations of users
> ranging from local system account to domain admin No luck, neither
> windows nor sql authentications work, I tried some solutions suggested
> here and there like re registering .net 1.1, installing a hotfix, adding
> permission to some registry keys... etc. no luck.
> The server is not a DC,
> It's not going to be a part of a RS webfarm
> A clean RS database is being used
> There are no other web sites on the server
> I tried re installing many many times, I even reinstalled SQL server and
> applied sp3, still no luck...
> It reports of a database connection failure, but I tried to
> config/activate it as sa or windows admin it still fails...
> I am out of options at this point. Anyone has a suggestion?
> Thanks
> PS: Below are the error messages from the log and rsactivate
>
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32 clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> pathTranslator, String userSuppliedPath, String parameterName)
> at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> item, StringCollection& Operations)
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> --RSACTIVATE--
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsac
> tivate -c rsreportserver.config
> Failure starting the web service:
> Unable to connect to the database (-2147159551) 0x8007007f
>|||I think you said this but I will ask to make sure. When you are in the
install wizard step that allows you to specify the SQL Server Instance, are
you choosing a 'SQL Credentials Type:' of 'SQL Login Account' and then
providing a SQL username/password that you have previously accessed the DB
(using QA for example)?
If so, take a look on the install wizard step that illustrates which account
the Report Server Web Service is run. This is normally ASPNET (I think
becuase none of the sites I use use the default) but if it is not, I have
found I have to add this user to the Administrators account of local machine
in order for it to run correctly.
"Skeptical" wrote:
> Well, I forgot to mention. I have already tried that :(
> I am thinking of reinstalling 2003 or even downgrading to 2000
> Any other suggestions ?
> "Skeptical" <skep@.yahoo.com> wrote in message
> news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> > Hello,
> >
> > I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> > Unfortunately setup reported that it could not initialize RS and it has to
> > be initialized manually
> >
> > I have tried:
> >
> > rsconfig & rsactivate with tons of different combinations of users
> > ranging from local system account to domain admin No luck, neither
> > windows nor sql authentications work, I tried some solutions suggested
> > here and there like re registering .net 1.1, installing a hotfix, adding
> > permission to some registry keys... etc. no luck.
> >
> > The server is not a DC,
> > It's not going to be a part of a RS webfarm
> > A clean RS database is being used
> > There are no other web sites on the server
> >
> > I tried re installing many many times, I even reinstalled SQL server and
> > applied sp3, still no luck...
> >
> > It reports of a database connection failure, but I tried to
> > config/activate it as sa or windows admin it still fails...
> >
> > I am out of options at this point. Anyone has a suggestion?
> >
> > Thanks
> >
> > PS: Below are the error messages from the log and rsactivate
> >
> >
> > w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> > System.Web.Services.Protocols.SoapException: The report server
> > installation is not initialized. Check the documentation for more
> > information. -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> > The report server installation is not initialized. Check the documentation
> > for more information. --> System.Runtime.InteropServices.COMException
> > (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> > Int32 extendedError)
> > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> > Int32 clientType)
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > at Microsoft.ReportingServices.Library.Storage.get_Connection()
> > at
> > Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> > storedProcedureName)
> > at
> > Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> > key)
> > at
> > Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> > name)
> > at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> > name)
> > at
> > Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> > name)
> > at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> > at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> > source)
> > at
> > Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > path, Boolean validate, Boolean convert, Boolean translate)
> > at
> > Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > path)
> > at
> > Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> > pathTranslator, String userSuppliedPath, String parameterName)
> > at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> > item, StringCollection& Operations)
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> > Item, String[]& Permissions)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> > Item, String[]& Permissions)
> > w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> > --Details--
> > System.Web.Services.Protocols.SoapException:
> > System.Web.Services.Protocols.SoapException: The report server
> > installation is not initialized. Check the documentation for more
> > information. -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> > The report server installation is not initialized. Check the documentation
> > for more information. --> System.Runtime.InteropServices.COMException
> > (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> > Int32 extendedError)
> >
> > --RSACTIVATE--
> > C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportServer>rsac
> > tivate -c rsreportserver.config
> > Failure starting the web service:
> > Unable to connect to the database (-2147159551) 0x8007007f
> >
> >
>
>|||I tried that too. I am thinking that the problem might be with .net 1.1
Unfortunately it's not possible to uninstall and reinstall that part.
"Skeptical" <skep@.yahoo.com> wrote in message
news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> Unfortunately setup reported that it could not initialize RS and it has to
> be initialized manually
> I have tried:
> rsconfig & rsactivate with tons of different combinations of users
> ranging from local system account to domain admin No luck, neither
> windows nor sql authentications work, I tried some solutions suggested
> here and there like re registering .net 1.1, installing a hotfix, adding
> permission to some registry keys... etc. no luck.
> The server is not a DC,
> It's not going to be a part of a RS webfarm
> A clean RS database is being used
> There are no other web sites on the server
> I tried re installing many many times, I even reinstalled SQL server and
> applied sp3, still no luck...
> It reports of a database connection failure, but I tried to
> config/activate it as sa or windows admin it still fails...
> I am out of options at this point. Anyone has a suggestion?
> Thanks
> PS: Below are the error messages from the log and rsactivate
>
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32 clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> pathTranslator, String userSuppliedPath, String parameterName)
> at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> item, StringCollection& Operations)
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> --RSACTIVATE--
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsac
> tivate -c rsreportserver.config
> Failure starting the web service:
> Unable to connect to the database (-2147159551) 0x8007007f
>|||Formatted, new 2003...
It works... Thanks...
"Skeptical" <skep@.yahoo.com> wrote in message
news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> Unfortunately setup reported that it could not initialize RS and it has to
> be initialized manually
> I have tried:
> rsconfig & rsactivate with tons of different combinations of users
> ranging from local system account to domain admin No luck, neither
> windows nor sql authentications work, I tried some solutions suggested
> here and there like re registering .net 1.1, installing a hotfix, adding
> permission to some registry keys... etc. no luck.
> The server is not a DC,
> It's not going to be a part of a RS webfarm
> A clean RS database is being used
> There are no other web sites on the server
> I tried re installing many many times, I even reinstalled SQL server and
> applied sp3, still no luck...
> It reports of a database connection failure, but I tried to
> config/activate it as sa or windows admin it still fails...
> I am out of options at this point. Anyone has a suggestion?
> Thanks
> PS: Below are the error messages from the log and rsactivate
>
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32 clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> pathTranslator, String userSuppliedPath, String parameterName)
> at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> item, StringCollection& Operations)
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> --RSACTIVATE--
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsac
> tivate -c rsreportserver.config
> Failure starting the web service:
> Unable to connect to the database (-2147159551) 0x8007007f
>

Friday, March 9, 2012

Reporting Services how do I disable a drop down box

Hi,

SQL Server Reporting Services 2005.

I have a tick box that is required to enable or disable two associated drop down boxes.

Example: Tick box has 2 associated drop down boxes. The drop down boxes list details of Area from a database. The Area is linked to Properties. This allows the selection of Properties to be filtering by Area. Ticking the tick box allows the user to select from the drop down boxes.

I have tried setting the Report Parameters in different ways, but without any success.

Please can someone suggest how I can set the two drop down boxes to be disabled when the tick box is unticked and enabled when the check box is ticked?

Thanking you,

dwemh

Hi,

I think enabling or disabling of parameter controls is not possible, since we have limited access to report parameter controls.

You could have cascaded parameters instead. On selection of tick box populate the Area dropdown (by filling the Area dataset with the result of the tick box as input parameter), which in turn populates Properties based on the default Area value.

By tick box do you mean check box, because when I choose a Boolean report parameter type I am getting radio buttons!

Thanks,

JDee

Tuesday, February 21, 2012

Reporting Services CPU utilization

I have a box that is running SPS03 and SQL Reporting Svcs.
it was all running fine on friday when I left. When I got
in this morning the box was close to a meltdown from
running at 100% CPU Utilization for who knows how long. I
took a look at the task manager and found it was Reporting
Services running at 50% utilization hitting SQL which was
running at 50% utilization. Nobody was hittting Reporting
services at the time. It was doing this on it's own. If I
shut down the reporting services service the utilization
drops to about 0%. if I turn it back on, it goes back up
to 100%. Has anyone ever seen this type of behavior from
Reporting Services?Please contact me offline so we can troubleshoot this further :
tudortr@.microsoft.com
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Starr" <MStarr13@.hotmail.com> wrote in message
news:225e001c45d18$66eb6e40$a501280a@.phx.gbl...
> I have a box that is running SPS03 and SQL Reporting Svcs.
> it was all running fine on friday when I left. When I got
> in this morning the box was close to a meltdown from
> running at 100% CPU Utilization for who knows how long. I
> took a look at the task manager and found it was Reporting
> Services running at 50% utilization hitting SQL which was
> running at 50% utilization. Nobody was hittting Reporting
> services at the time. It was doing this on it's own. If I
> shut down the reporting services service the utilization
> drops to about 0%. if I turn it back on, it goes back up
> to 100%. Has anyone ever seen this type of behavior from
> Reporting Services?|||Yup, just had that problem myself today, and I found that not only was it hogging cpu time, it also created some 6 Gb of log files under the LogFiles folder before I became aware of the problem... 8-( You might want to check that out.
The log files all said something about expiring old execution log entries, but no matter how much I tried to turn of this execution log or the expiring of its entries, it kept making more log files with identical content, save for the timestamp on each line, which told me this happened many times per second!
I tried many things, until it struck me: I very seldomly turn off my workstation. Test: Reboot, and voila, no problems anymore.
I don't feel confident that this will be the last time it does this, because it feels too much like a bug in RS, like using GetTickCount inappropriately or something...
Hope this helps! 8-)
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

Monday, March 26, 2012

Reporting Services Roles not seeing presenting AD dialog box

Wednesday, March 21, 2012

Reporting Services on a development box?

Reporting Services Login Problem

Tuesday, March 20, 2012

Reporting Services Login box appears when trying to deploy in SSRS 2005

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

Reporting Services Login box appears when trying to deploy in SSRS 2005

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

Reporting Services Login box appears when trying to deploy in SSRS 2005

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

Reporting Services Login box appears when trying to deploy in SSRS 2005

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

Reporting Services Login box appears when trying to deploy in SSRS 2005

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

Reporting Services Login box appears when trying to deploy in SSRS 2005

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

Reporting Services Login box appears when trying to deploy in SSRS 2005

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

Reporting Services Login box appears when trying to deploy in SSRS 2005

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

Monday, March 12, 2012

Reporting services initilization problem

Friday, March 9, 2012

Reporting Services how do I disable a drop down box

Tuesday, February 21, 2012

Reporting Services CPU utilization

Reporting Services Count

Blog Archive

About Me