SQL Server Reporting Services problems

Posted on 2009-02-16
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
    LVL 15

    Expert Comment

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

    Author Comment

    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

    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

    issue resolved using rsconfig and rskeymgmt

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    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…

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now