Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SQL Server Reporting Services problems

Posted on 2009-02-16
Medium Priority
Last Modified: 2012-05-06

I am running into all sorts of aggravation trying to resolve a problem configuring Reporting Services. Here are the details;

1) I have run the Reporting Services Configuration Manager and all items are checked (Green check mark) on the left pane until I get to "Initialization" which is in Red X.
2) I check Database Setup and notice that Database Name is not correct.
3) Attempting to change the Database Name and then Click APPLY brings up a SQL Server Connection Dialog". Here I have the "Server Name" (which is the Machine Name of my SQL Server) and the "Credentials Type set as "Current User - Integrated Security.
4) When I click OK, I receive the following:

"A connection could not be established with the information provided. Hit OK to change your connection settings.    
Invalid object name 'sysdatabases'

5) No matter what I do, I cannot seem to properly change the Database Name. My questions are as follows:

a) Is there a particular format for specifying database name?  (machinename\dbaname, sqlinstancename\databsename?  )
b) do I need to uninstall Reporting Services? If so, where can you uninstall RS as I don't see a clean method for this?
c) I have made sure that Remote Connections using TCP\IP and Names Pipes is enabled.

SQL Server 2005 running on Windows 2003 Server SP2

Thanks for any Help........500 points
Question by:Charlie_Melega
  • 3
LVL 15

Expert Comment

by:Faiga Diegel
ID: 23652729
Does your windows account used to login to that RS server have access/permission to the DB server instance?

Author Comment

ID: 23652994
Yes, the only caveat is that I am accessing the DB Server Instance via RDP but using the same account.  This account is a Domain Admin account and was used when initially installing SQL Server on this machine.

Accepted Solution

Charlie_Melega earned 0 total points
ID: 23663775
I was able to figure this out. Essentially started over by running rsconfig followed by rskeymgmt (as I also had enctryption issues preveting RS Config tool from properly configurign all aspects)

Here is the syntax I used for those who may have been having a similar experience;

rsconfig -c -m (machinename) -i (instance) -s (server) -d (database) -a (authentication type)

followed by

rskeymgmt -d -i (sqlserverinstance)

Author Comment

ID: 23663790
issue resolved using rsconfig and rskeymgmt

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question