Firstly, thanks for any help that you can provide guys..

I have a problem with NT AUTHORITY\NETWORK SERVICE not being added to the dataase permission on my sql 2005 server..

BACKGROUD:

I have 2 machines, in 2 different domains,

Machine 1: Win 2K, SQL 2005, Domain Controller, Domain A.

Machine 2: Win 2003, reporting services, sharepoint, Domain B

Im getting the following error when i install BSM.. I get past the requirements etc, just fails after its almost installed..

=============================================

Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 16/05/2006
Time: 2:50:04 PM
User: AP\dsadmin
Computer: MAMSGP
Description:
Product: Microsoft Office Business Scorecard Manager 2005 -- Error 26204. Error -2147217900: failed to execute SQL string, error detail: User or role 'NT AUTHORITY\NETWORK SERVICE' does not exist in this database., SQL key: SQLWeb3 SQL string: USE ScorecardServer DECLARE @dbowner sysname SELECT @dbowner = SUSER_SNAME(sid) FROM master.dbo.sysdatabases WHERE name = 'ScorecardServer' IF NOT(@dbowner = 'NT AUTHORITY\NETWORK SERVICE') EXEC sp_addrolemember 'BPMDeveloper', 'NT AUTHORITY\NETWORK SERVICE'

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 44 30 32 46 34 35 32 {D02F452
0008: 43 2d 46 32 33 41 2d 34 C-F23A-4
0010: 41 30 42 2d 39 43 41 33 A0B-9CA3
0018: 2d 46 39 46 34 36 41 45 -F9F46AE
0020: 33 43 34 33 33 7d 3C433}
==========================================================

Now, i can work out the SQL 2005 is trying to add the NETWORK SERVICE account to the database. But as the local machine the SQL is running on, is Win 2000 and haas no NETWORK SERVICE User.. This user is on the Win 2003 server.

Is their anyway of adding the network service user from the other machine in to the sql machine??

or can you think of anythig else that may help me.. Ill try anything!!

Thanks again ,

Scotty

per our support engineer:

I have confirmed that a build-in account can?? be added to another machine. Usually we should use a domain account to access another resources, as SQL Server. And these resource should be in one domain, or some domains with trust relationships.