billygolden
asked on
DPM Reporting not functioning. Access Denied Errors in Event Log.
When trying to access the reporting functions of DPM 2007 it hangs and does not display any reports and logs the following errors in the event log. Any help with this would be greatly appreciated. Just FYI this is running on Windows Storage Server 2003 x64. These errors repeat about every minute.
Event Type: Error
Event Source: MSSQL$MS$DPM2007$
Event Category: (2)
Event ID: 17053
Date: 10/23/2008
Time: 3:14:09 PM
User: N/A
Computer: BACKUP
Description:
UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 9d 42 00 00 10 00 00 00 B......
0008: 13 00 00 00 42 00 41 00 ....B.A.
0010: 43 00 4b 00 55 00 50 00 C.K.U.P.
0018: 5c 00 4d 00 53 00 24 00 \.M.S.$.
0020: 44 00 50 00 4d 00 32 00 D.P.M.2.
0028: 30 00 30 00 37 00 24 00 0.0.7.$.
0030: 00 00 07 00 00 00 6d 00 ......m.
0038: 61 00 73 00 74 00 65 00 a.s.t.e.
0040: 72 00 00 00 r...
Event Type: Error
Event Source: MSSQL$MS$DPM2007$
Event Category: (2)
Event ID: 17053
Date: 10/23/2008
Time: 3:14:09 PM
User: N/A
Computer: BACKUP
Description:
UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 9d 42 00 00 10 00 00 00 B......
0008: 13 00 00 00 42 00 41 00 ....B.A.
0010: 43 00 4b 00 55 00 50 00 C.K.U.P.
0018: 5c 00 4d 00 53 00 24 00 \.M.S.$.
0020: 44 00 50 00 4d 00 32 00 D.P.M.2.
0028: 30 00 30 00 37 00 24 00 0.0.7.$.
0030: 00 00 07 00 00 00 6d 00 ......m.
0038: 61 00 73 00 74 00 65 00 a.s.t.e.
0040: 72 00 00 00 r...
When trying to access the reporting functions of DPM 2007 it hangs and does not display ....
Is this the first time you attemp to access this report?
What login account did you try? Does it account set in SQL database server? Is it an owner of the database?
Your error shows that you simply have a permission error. When you try to access directly to the database, you need to be either the owner of the database or a member of the owner account. Talk to the SQL admin and make sure you have sufficient privileges to the database.
K
Is this the first time you attemp to access this report?
What login account did you try? Does it account set in SQL database server? Is it an owner of the database?
Your error shows that you simply have a permission error. When you try to access directly to the database, you need to be either the owner of the database or a member of the owner account. Talk to the SQL admin and make sure you have sufficient privileges to the database.
K
ASKER
This is supposed to be all setup during the install. It installs a local copy of SQL during the installation of DMP. It is using the default account for the database that DMP creates during the installation. I agree that I think it is a permissions problem, and may be something that is being caused by our group policy settings. During DPM installation it creates a local computer user account this is also the account that it sets up and uses for SQL. If you could tell me exactly what to get you to help figure this out I can try to pull some more info off of the system.
ASKER
Oh, just FYI I gave up and started all over again. Clean install of OS and DPM and reporting is still not working, everything else is fine, but now I have new errors in the event logs.
Event Type: Warning
Event Source: Report Server Windows Service (MS$DPM2007$)
Event Category: Logging
Event ID: 118
Date: 11/4/2008
Time: 4:01:11 PM
User: N/A
Computer: BACKUP
Description:
The trace log cannot be found at the default directory location. Trace logs will be created at the following location: C:\DOCUME~1\NETWOR~1\LOCAL S~1\Temp\L ogFiles
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type: Warning
Event Source: Report Server (MS$DPM2007$)
Event Category: Logging
Event ID: 118
Date: 11/3/2008
Time: 9:42:58 AM
User: N/A
Computer: BACKUP
Description:
The trace log cannot be found at the default directory location. Trace logs will be created at the following location: C:\WINDOWS\TEMP\LogFiles
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type: Warning
Event Source: Report Server Windows Service (MS$DPM2007$)
Event Category: Logging
Event ID: 118
Date: 11/4/2008
Time: 4:01:11 PM
User: N/A
Computer: BACKUP
Description:
The trace log cannot be found at the default directory location. Trace logs will be created at the following location: C:\DOCUME~1\NETWOR~1\LOCAL
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type: Warning
Event Source: Report Server (MS$DPM2007$)
Event Category: Logging
Event ID: 118
Date: 11/3/2008
Time: 9:42:58 AM
User: N/A
Computer: BACKUP
Description:
The trace log cannot be found at the default directory location. Trace logs will be created at the following location: C:\WINDOWS\TEMP\LogFiles
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
It's a normal message. When you uninstall your SQL all trace logs are removed and no recreated. You still need to create a user in your database. Here is what you should do.
Access to your database via SQL studio --> Login with DB admin or server admin (if using server admin, you need to login as NT login, otherwise, choose database login) --> expand Databases --> yourDB name --> Security --> right click the users folder and create new user. If you already see your user under here, don't need to create user. You then double click on the user and look in the bottom at role membership -> select database owner and other roles if applicable.
K
Access to your database via SQL studio --> Login with DB admin or server admin (if using server admin, you need to login as NT login, otherwise, choose database login) --> expand Databases --> yourDB name --> Security --> right click the users folder and create new user. If you already see your user under here, don't need to create user. You then double click on the user and look in the bottom at role membership -> select database owner and other roles if applicable.
K
ASKER
Ok, in sql DPM created 3 databases....DPMDB which has dbo as the Owner, and DPMDBReaders$BACKUP as reader. It has ReportServer$MS$DPM2007$ and the owner is NT Authority\Network Service. Finally, ReportServer$MS$DPM2007$Te mpDB with NT Authority\Network Service as the owner. As far as local accounts on the computer DPM created, DPMR$BACKUP This account is used by SQL Server Reporting Services to generate DPM reports, and MICROSOFT$DPM$Acct SQL Server and SQL Server Agent services of instance MS$DPM2007$ will run under this low privilege account. These are the descriptions that DPM put in when it created the accounts. I do not see these listed in SQL manager...should they be?
You are not looking in the right place. I told you to look in Servername\databases\yourd atabase\se curity\use rs\dbo .... not Servername\Security\users\ dbo....
Make sure the dbo I mention has the login name as sa or admin.... if not create one.
K
Make sure the dbo I mention has the login name as sa or admin.... if not create one.
K
ASKER
ASKER
DBO account in SQL.
dbo.bmp
dbo.bmp
Pretty clear. Thank you.
Let me know what account that your report is using. Does it use sys?
There are several way to solve your problem. Here they are:
- If you know what account you are using, login and go to user as db3 picture --> go to user property -> on the left panel, select server roles --> grant all access to this user
- You can choose not granting all access to this user, but you have to get in database as db1 picture -> then add/create the user and grand owner access to it.
Let me know how it works out.
K
Let me know what account that your report is using. Does it use sys?
There are several way to solve your problem. Here they are:
- If you know what account you are using, login and go to user as db3 picture --> go to user property -> on the left panel, select server roles --> grant all access to this user
- You can choose not granting all access to this user, but you have to get in database as db1 picture -> then add/create the user and grand owner access to it.
Let me know how it works out.
K
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The problem was acutally permissions setting on the windows temp folder.
ASKER