Wednesday, March 7, 2012

New Install Error

Hi,
I'm installing Reporting Services on our productions
server which is a domain controller, Windows 2003.
The database is on a different server, so it would be a
remote install of the databases. I keep getting error
messages that say 'can not create database'. I'm using sa
as a sql login, which has administrative rights.
Please let me know if you need anymore information.
Thanks in Advance,
MarciaBy default, setup uses the credentials of the user running setup to create
the report server database. The screen where you configure the report
server database only allows you to specify credentials the report server
uses to access the database (after setup is over).
To use a SQL login to create the report server database, you need to specify
RSSETUPACCOUNT and RSSETUPPASSWORD on the command line when running setup.
More info here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_6h6h.asp
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcia" <anonymous@.discussions.microsoft.com> wrote in message
news:461701c47332$7e57f870$a501280a@.phx.gbl...
> Hi,
> I'm installing Reporting Services on our productions
> server which is a domain controller, Windows 2003.
> The database is on a different server, so it would be a
> remote install of the databases. I keep getting error
> messages that say 'can not create database'. I'm using sa
> as a sql login, which has administrative rights.
> Please let me know if you need anymore information.
> Thanks in Advance,
> Marcia

No comments:

Post a Comment