Discussion:
Cannot open database "OperationsManagerAC" requested by the login. The login failed
(too old to reply)
Seth
2008-02-11 19:54:44 UTC
Permalink
momaction is domain admin, momdatareader, momdw, momsdk, momadmin is
standard user.
all these 5 accounts are member of momglobaladmins account.
momglobaladmins security group is member of local administrators group.
there is only one server and SQL is installed with momadmin user.
Installed scom 2007. no problem.
Installed reporting no problem. But when installing ACS. I have the
following events.
any ideas?


Event Type: Error

Event Source: AdtServer

Event Category: None

Event ID: 4618

Date: 2/11/2008

Time: 5:00:35 PM

User: N/A

Computer: XXXXXXXXXX

Description:

Error occured on database connection:

Status: 0x04080000

ODBC Error: 4060

ODBC State: 42000

Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
database "OperationsManagerAC" requested by the login. The login failed.

Database: Register

Connection: ComplianceTest

Statement: -







Event Type: Failure Audit

Event Source: MSSQLSERVER

Event Category: (4)

Event ID: 18456

Date: 2/11/2008

Time: 5:00:35 PM

User: NT AUTHORITY\NETWORK SERVICE

Computer: XXXXXXXXXX

Description:

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: 172.20.4.75]



For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Data:

0000: 18 48 00 00 0e 00 00 00 .H......

0008: 10 00 00 00 54 00 52 00 ....F.Y.

0010: 4b 00 49 00 53 00 54 00 K.T.G.O

0018: 30 00 31 00 2d 00 4d 00 9.6.-.M.

0020: 4f 00 4d 00 2d 00 30 00 6.-.0.

0028: 31 00 00 00 07 00 00 00 1.......

0030: 6d 00 61 00 73 00 74 00 m.a.s.t.

0038: 65 00 72 00 00 00 e.r...









Event Type: Error

Event Source: AdtServer

Event Category: None

Event ID: 4668

Date: 2/11/2008

Time: 5:05:24 PM

User: NT AUTHORITY\NETWORK SERVICE

Computer: XXXXXXXXXXXXX

Description:

AdtServer encountered the following problem during startup:

Task: Create Machine Register

Failure: An error occured connecting to the database and retrieving
groups and machines

Error: 0x11880008

Error Message:











Event Type: Error

Event Source: AdtServer

Event Category: None

Event ID: 4618

Date: 2/11/2008

Time: 5:05:24 PM

User: N/A

Computer: XXXXXXXXXX

Description:

Error occured on database connection:

Status: 0x00200003

ODBC Error: 0

ODBC State: 08003

Message: [Microsoft][ODBC Driver Manager] Connection not open

Database: Register

Connection: ComplianceTest

Statement: -









Event Type: Failure Audit

Event Source: MSSQLSERVER

Event Category: (4)

Event ID: 18456

Date: 2/11/2008

Time: 5:05:07 PM

User: NT AUTHORITY\NETWORK SERVICE

Computer: XXXXXXXXXX

Description:

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: 172.16.4.34]
Seth
2008-02-12 08:41:26 UTC
Permalink
Solved.
When changing the path to default database location of sql databases, i
could install.
Post by Seth
momaction is domain admin, momdatareader, momdw, momsdk, momadmin is
standard user.
all these 5 accounts are member of momglobaladmins account.
momglobaladmins security group is member of local administrators group.
there is only one server and SQL is installed with momadmin user.
Installed scom 2007. no problem.
Installed reporting no problem. But when installing ACS. I have the
following events.
any ideas?
Event Type: Error
Event Source: AdtServer
Event Category: None
Event ID: 4618
Date: 2/11/2008
Time: 5:00:35 PM
User: N/A
Computer: XXXXXXXXXX
Status: 0x04080000
ODBC Error: 4060
ODBC State: 42000
Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
database "OperationsManagerAC" requested by the login. The login failed.
Database: Register
Connection: ComplianceTest
Statement: -
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 2/11/2008
Time: 5:00:35 PM
User: NT AUTHORITY\NETWORK SERVICE
Computer: XXXXXXXXXX
172.20.4.75]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 10 00 00 00 54 00 52 00 ....F.Y.
0010: 4b 00 49 00 53 00 54 00 K.T.G.O
0018: 30 00 31 00 2d 00 4d 00 9.6.-.M.
0020: 4f 00 4d 00 2d 00 30 00 6.-.0.
0028: 31 00 00 00 07 00 00 00 1.......
0030: 6d 00 61 00 73 00 74 00 m.a.s.t.
0038: 65 00 72 00 00 00 e.r...
Event Type: Error
Event Source: AdtServer
Event Category: None
Event ID: 4668
Date: 2/11/2008
Time: 5:05:24 PM
User: NT AUTHORITY\NETWORK SERVICE
Computer: XXXXXXXXXXXXX
Task: Create Machine Register
Failure: An error occured connecting to the database and retrieving
groups and machines
Error: 0x11880008
Event Type: Error
Event Source: AdtServer
Event Category: None
Event ID: 4618
Date: 2/11/2008
Time: 5:05:24 PM
User: N/A
Computer: XXXXXXXXXX
Status: 0x00200003
ODBC Error: 0
ODBC State: 08003
Message: [Microsoft][ODBC Driver Manager] Connection not open
Database: Register
Connection: ComplianceTest
Statement: -
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 2/11/2008
Time: 5:05:07 PM
User: NT AUTHORITY\NETWORK SERVICE
Computer: XXXXXXXXXX
172.16.4.34]
Loading...