I have set up SQL Server 2005 Reporting Services on a W2K3 64-bit server.
During the installation I installed Reporting Service using a files-only
installation. I used the Reporting Services Configuration tool to do the
final configuration. I created the databases through the database setup page
and with Service Credentials.
I looked at both the ReportServer and ReportServerTempDB databases and see
that DBO account is the SQL Sysadmin/Server Admin account I use to
administer SQL Server. Is this desirable? Should the DBO be a seperate
account? What is the best practices on this?This is standard, and typical... no need to change the owner...
"Loren Z" wrote:
> I have set up SQL Server 2005 Reporting Services on a W2K3 64-bit server.
> During the installation I installed Reporting Service using a files-only
> installation. I used the Reporting Services Configuration tool to do the
> final configuration. I created the databases through the database setup page
> and with Service Credentials.
> I looked at both the ReportServer and ReportServerTempDB databases and see
> that DBO account is the SQL Sysadmin/Server Admin account I use to
> administer SQL Server. Is this desirable? Should the DBO be a seperate
> account? What is the best practices on this?
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment