Fail to install reporting service

I need to install the Reporting Service in a production site on the web server.
Both web server and database server are mamber server in the same domain.
When i install the Reporting Service in the web server in keep having below
error
SQL Setup failed to connect to the database service for server
configuration. The error was: Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection.
Refer to the Server error logs and setup logs for more detailed information.
The eviroment configuration as below
DC : NT 4.0 with sp 6a
Web Server : - Windows 2003 standard server with sp 1, SSL Apply, Sharepoint
Services with sp 1 installed, .Net Framework 1.1 with sp 1
Database Server : Windows 2003 standard server with sp 1, MS SQL 2000 with
sp 3a in mix mode, .Net Framework 1.1 with sp 1
User :
SetupAdmin
- Domain User
- Is added to local administrator group on both web server and database
server
- With database server right on 'Security Administrator', 'Process
Administrator' and 'Database Creator'
ReportUser
- Domain User
- Is a database user
ReportSQLUser
- SQL Login Account
I login web server using SetupAdmin, when run setup. I set 'Network\Service
account' to reporting service, when ask for the database connection user I
can use either SetupAdmin, ReportUser or ReportSQLUser it will pass. But the
setup give me an error when going to setup database on the database server,
non off the 3 user account i can use to make the setup success.
Can anyone let me know why? and how to solve it?James,
Go to the SQL Server that you're trying to set up the database on, open it
up in Enterprise Manager, navigate to the Security folder and verify that the
Admin account you are using is mapped to a SQL Server login AND that that
login has the rights to create a new database. You'll need DBOwner database
role and DBCreator server role.
I believe the reason you're unable to complete your setup is a simple
permissions issue.
Hope that helps!
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"James Hong" wrote:
> I need to install the Reporting Service in a production site on the web server.
> Both web server and database server are mamber server in the same domain.
> When i install the Reporting Service in the web server in keep having below
> error
> SQL Setup failed to connect to the database service for server
> configuration. The error was: Login failed for user '(null)'.
> Reason: Not associated with a trusted SQL Server connection.
> Refer to the Server error logs and setup logs for more detailed information.
> The eviroment configuration as below
> DC : NT 4.0 with sp 6a
> Web Server : - Windows 2003 standard server with sp 1, SSL Apply, Sharepoint
> Services with sp 1 installed, .Net Framework 1.1 with sp 1
> Database Server : Windows 2003 standard server with sp 1, MS SQL 2000 with
> sp 3a in mix mode, .Net Framework 1.1 with sp 1
> User :
> SetupAdmin
> - Domain User
> - Is added to local administrator group on both web server and database
> server
> - With database server right on 'Security Administrator', 'Process
> Administrator' and 'Database Creator'
> ReportUser
> - Domain User
> - Is a database user
> ReportSQLUser
> - SQL Login Account
> I login web server using SetupAdmin, when run setup. I set 'Network\Service
> account' to reporting service, when ask for the database connection user I
> can use either SetupAdmin, ReportUser or ReportSQLUser it will pass. But the
> setup give me an error when going to setup database on the database server,
> non off the 3 user account i can use to make the setup success.
> Can anyone let me know why? and how to solve it?|||Thanks for the advice Catadmin.
Need comfirmation on the setting you have advice.
1. The Reporting Services Database name "ReportServer" and
"ReportServerTempDB" have not yet being created so the DBOwner Database Role
should grant to which database? Is the 'master', 'model' or 'msdb'.
2. I have granted the 'Database Creator' server role to SetupAdmin. So, is
it meet the DBCreator server role which you have advice?
--
Best Regard,
James Hong
"Catadmin" wrote:
> James,
> Go to the SQL Server that you're trying to set up the database on, open it
> up in Enterprise Manager, navigate to the Security folder and verify that the
> Admin account you are using is mapped to a SQL Server login AND that that
> login has the rights to create a new database. You'll need DBOwner database
> role and DBCreator server role.
> I believe the reason you're unable to complete your setup is a simple
> permissions issue.
> Hope that helps!
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
>
> "James Hong" wrote:
> > I need to install the Reporting Service in a production site on the web server.
> > Both web server and database server are mamber server in the same domain.
> > When i install the Reporting Service in the web server in keep having below
> > error
> >
> > SQL Setup failed to connect to the database service for server
> > configuration. The error was: Login failed for user '(null)'.
> > Reason: Not associated with a trusted SQL Server connection.
> > Refer to the Server error logs and setup logs for more detailed information.
> >
> > The eviroment configuration as below
> > DC : NT 4.0 with sp 6a
> > Web Server : - Windows 2003 standard server with sp 1, SSL Apply, Sharepoint
> > Services with sp 1 installed, .Net Framework 1.1 with sp 1
> > Database Server : Windows 2003 standard server with sp 1, MS SQL 2000 with
> > sp 3a in mix mode, .Net Framework 1.1 with sp 1
> > User :
> > SetupAdmin
> > - Domain User
> > - Is added to local administrator group on both web server and database
> > server
> > - With database server right on 'Security Administrator', 'Process
> > Administrator' and 'Database Creator'
> > ReportUser
> > - Domain User
> > - Is a database user
> > ReportSQLUser
> > - SQL Login Account
> >
> > I login web server using SetupAdmin, when run setup. I set 'Network\Service
> > account' to reporting service, when ask for the database connection user I
> > can use either SetupAdmin, ReportUser or ReportSQLUser it will pass. But the
> > setup give me an error when going to setup database on the database server,
> > non off the 3 user account i can use to make the setup success.
> >
> > Can anyone let me know why? and how to solve it?