Configure Report Server Error

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
JaimeJegoniaAsked:
Who is Participating?
 
JaimeJegoniaConnect With a Mentor Author Commented:
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
 
Jai STech ArchCommented:
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
 
JaimeJegoniaAuthor Commented:
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
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Jai STech ArchCommented:
you have to choose the SAME instance of database for your report server...like try with a proper instance name...
0
 
SQL_SERVER_DBACommented:
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
 
JaimeJegoniaAuthor Commented:
Which one do you mean should be assigned to the schema of RSExecRole?
0
 
Jai STech ArchCommented:
can you check in your sql server whther the database ReportServer already exists ? or is not created at all !!!
0
 
Jai STech ArchCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.