We help IT Professionals succeed at work.

SQL Server Reporting Services problems

Medium Priority
836 Views
Last Modified: 2012-05-06
Hello,

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
Comment
Watch Question

Faiga DiegelSr Database Engineer
CERTIFIED EXPERT

Commented:
Does your windows account used to login to that RS server have access/permission to the DB server instance?

Author

Commented:
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.
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)

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
issue resolved using rsconfig and rskeymgmt
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.