Wednesday, March 7, 2012

Report server not inizialized after installation

Platform : SQL Server Express SP2 with advanced services

I have an install script that installs all of the services and features with the exception of management studio express. My install script is very basic, the only addition was to have RSSQLOCAL=1, and I set RSCONFIGURATION=Default.

After the installation, when I navigate to localhost\Reports$SQLEXPRESS or localhost\ReportServer$SQLEXPRESS, I get an authentication error. When I go into the reporting services configuration manager, everything looks OK, but the 'Initialized' status is 'NO' under status. If I go to 'Database Setup', choose Connect, and then 'Apply', the reporting services now becomes initialized, and everything seems to be OK.

What is the reason for this manual step in the reporting configuration manager? Any ideas?
I don't know why that happens either. A bit of a mystery...but trust me, if that is the only problem you had installing....... You're Lucky.|||Hmmm,

Thanks for the reply.

Sounds like installation can be a huge headache for SSRS. Has anyone compiled a page with install issues and resolutions for SSRS?
|||According to this post:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=838483&SiteID=1

You simply have to restart the PC for it to be initialized.
|||

ajhuddy wrote:

Hmmm,
Has anyone compiled a page with install issues and resolutions for SSRS?

Yes, a good portion of these forums.

No comments:

Post a Comment