June 3, 2008 at 5:45 am
Hi,
I'm at a dead end - trying to get the SSRS database to initialize. I'm using the configuration utility to do 'Database setup' - and it goes through ok as far as 'Setting Connection Info for Report Server' - and then reports that it could not access internal information about the deployment. I've tried deleting the encryted data - but that fails too. I've tried creating new databases using Windows credentials and sa credentials. Always fails with the same error. I tried using rsconfig to specify the credentials - and whilst rsconfg worked - it didn't make the database 'initialized'.
Any ideas?
Thanks,
P
June 6, 2008 at 4:47 am
Still haven't resolved this issue.
I read somewhere about licensing.....
I'm using SQL Server standard addition with a single server license.
When I installed Reporting Services 2005 - I created a separate instance from MSSQLSERVER ie. REPSER2005INS.
Could this be causing a problem? Is there any way to tell Reporting services to use MSSQLSERVER instead of the one I told it to use initially?
June 9, 2008 at 2:17 pm
I'm guessing you already installed SP2? Did you do the database upgrade after the Service Pack? That threw me a bit the first time I saw it, but I don't remember the exact error message I was seeing.
Can you post the exact message you are getting in your logs?
Thanks.
-Luke.
July 10, 2008 at 2:39 am
I finally resolved it.....
The problem was that somebody (unbeknownest to me!!!) had installed SQL Server Personal Eddition (as they had trouble reading the Standard editoin CD - ).
It's not immediately obvious that it's Personal edition - but you can detect this by looking at the build number. The version build number 8.00.2039 is SQL Server 2000 Personal Edition w/ SP4.
(select @@version)
It was a fairly easy job toi upgrade it to Standard Edition.
P
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply