[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Configure Report Server Error

Posted on 2007-10-15
8
Medium Priority
?
2,657 Views
Last Modified: 2013-11-15
Hi,

I'm configuring my report server but I keep getting this error:

"The current connection string is not valid and can't be used to connect to SQL server"

I get a warning in Verifying Database Version...

What am I missing? Has anyone encountered the same problem and has solved it?

Thanks in advance
0
Comment
Question by:JaimeJegonia
  • 4
  • 3
8 Comments
 
LVL 14

Expert Comment

by:Jai S
ID: 20083206
its common...you need to have a valid server connection
in the reporting services configuration --> database setup --> select the servername and click the connect button next to it...enter the credentials type properly and give ok...(use either user - integrated security / sql server account - just try both options) and in the database name...click new and enhter the details...say ok...
select SERVICE CREDENTIALS in the crdentials type(below to the database name) click apply...let me know the result...
0
 

Author Comment

by:JaimeJegonia
ID: 20083585
jaiganeshsrinivasan, I tried your suggestion but still no luck.

This is the error I get when I create a report and run:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.8.54'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

0
 
LVL 14

Expert Comment

by:Jai S
ID: 20083590
you have to choose the SAME instance of database for your report server...like try with a proper instance name...
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 16

Expert Comment

by:SQL_SERVER_DBA
ID: 20085214
Make sure under Security/Roles - that the RSExecRole exist, if not then make one. It should also be assigned to the schema of RSExecRole. On your report service login User make sure that this user is assigned under the RSExecRole.
0
 

Author Comment

by:JaimeJegonia
ID: 20090814
Which one do you mean should be assigned to the schema of RSExecRole?
0
 
LVL 14

Expert Comment

by:Jai S
ID: 20090817
can you check in your sql server whther the database ReportServer already exists ? or is not created at all !!!
0
 

Accepted Solution

by:
JaimeJegonia earned 0 total points
ID: 20091038
Thanks for your time guys.

I finally got Reporting Services working successfully in my machine but didn't have to go thru checking if RSExecRole exist etc. What I did is uninstalled the SQL Server including all components that come with it, restart, install again then run Reporting Services Configuration -- no special steps, just went thru the buttons marked in red x with the defaults
0
 
LVL 14

Expert Comment

by:Jai S
ID: 20091053
as mentioned earlier...the INSTANCES have to be the same for SQL and reporting...so tht might have fixed it...
you dont need to uninstall...but you would have acreated a new instance of the sql server adn it should have worked...
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

834 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