Re: Setup of SQL Server 2005 - problems
- From: Denny Cherry <mrdenny.nospam@xxxxxxxxxxx>
- Date: Fri, 25 Jul 2008 16:30:26 -0700
It appears that you have setup Reporting Services to log into the
database server, but you have removed the BUILTIN\Administrators group
from the sysadmin fixed server role so the NT AUTHORITY\SYSTEM account
doesn't have rights to log into the database.
Open the Reporting Services configuration tool and change the account
which the reporting services service logs in with into the database.
Denny
On Fri, 25 Jul 2008 11:48:31 -0500, "Mike in Nebraska"
<Mike_Webb@xxxxxxxxxxxxxxxxx> wrote:
I installed SQL Server 2005 on a Windows Server 2003 R2 SP2 application.
server this morning - no prior SQL server, just an MSDE. I did a full
install to the default instance, using mixed mode authentication, then
applied SP2. I rebooted after the initial install and then again after SP2
completed.
I am getting the following errors in the Application Log - I'm too new to
know what to do once I looked at the links provided and then entering the
info into eventid.net - so I thought I'd ask here for advice/help.
1st error:
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 7/25/2008
Time: 11:17:20 AM
User: NT AUTHORITY\SYSTEM
Computer: WCT-SHAREPOINT
Description:
Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <named pipe>]
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: 0f 00 00 00 57 00 43 00 ....W.C.
0010: 54 00 2d 00 53 00 48 00 T.-.S.H.
0018: 41 00 52 00 45 00 50 00 A.R.E.P.
0020: 4f 00 49 00 4e 00 54 00 O.I.N.T.
0028: 00 00 07 00 00 00 6d 00 ......m.
0030: 61 00 73 00 74 00 65 00 a.s.t.e.
0038: 72 00 00 00 r...
============
2nd error:
Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: Management
Event ID: 107
Date: 7/25/2008
Time: 11:17:20 AM
User: N/A
Computer: WCT-SHAREPOINT
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report
server database.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
====================
3rd error:
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 7/25/2008
Time: 11:17:26 AM
User: NT AUTHORITY\SYSTEM
Computer: WCT-SHAREPOINT
Description:
Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
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: 0f 00 00 00 57 00 43 00 ....W.C.
0010: 54 00 2d 00 53 00 48 00 T.-.S.H.
0018: 41 00 52 00 45 00 50 00 A.R.E.P.
0020: 4f 00 49 00 4e 00 54 00 O.I.N.T.
0028: 00 00 07 00 00 00 6d 00 ......m.
0030: 61 00 73 00 74 00 65 00 a.s.t.e.
0038: 72 00 00 00 r...
=================
4th through 7th errors:
Event Type: Error
Event Source: .NET Runtime Optimization Service
Event Category: None
Event ID: 1101
Date: 7/25/2008
Time: 11:18:36 AM
User: N/A
Computer: WCT-SHAREPOINT
Description:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
===========================
What did I do wrong??
- Follow-Ups:
- Re: Setup of SQL Server 2005 - problems
- From: Mike_in_Nebraska
- Re: Setup of SQL Server 2005 - problems
- References:
- Setup of SQL Server 2005 - problems
- From: Mike in Nebraska
- Setup of SQL Server 2005 - problems
- Prev by Date: Re: Seems like only 1GB RAM being used even when higher MAX RAM is
- Next by Date: Re: FCB::RemoveAlternateStreams: Operating system error (null)
- Previous by thread: Setup of SQL Server 2005 - problems
- Next by thread: Re: Setup of SQL Server 2005 - problems
- Index(es):
Relevant Pages
|
