?
Solved

unable to generate scripts for SSRS database (SQL 2005 SP4)

Posted on 2012-08-29
1
Medium Priority
?
552 Views
Last Modified: 2012-09-07
In Report Config tool, I don't see option for SP4. When I manually put in SP4's version number, it fails.

The DB engine is SP4. Reporting also.

What else could it be? (pl see attached picture)
ssrs.png
0
Comment
Question by:25112
1 Comment
 
LVL 25

Accepted Solution

by:
TempDBA earned 2000 total points
ID: 38358383
DB Engine being SP4 doesn't comply that reporting service should also be the same. While upgrading to SP4, may be SSRS wasn't upgraded. You can't create script for something that doesn't exists.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
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…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

864 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