Audit Fails for DOMAIN\Administrator account on SQL server 2005 instance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zaur Bahramov - 01 Jul 2008 15:43 GMT

Hi!

I have a WSS 3.0 running on SQL Server 2005 Standard. It was upgraded from
SQL Server 2005 Express edition. Everytime I restart server I have 4 events
in the event log as follows:

1)
SQL Database 'SharePoint_Config ' on SQL Server instance 'WEBSRV1\SQLEXPRESS
' not found. Additional error information from SQL Server is included below.
Cannot open database "SharePoint_Config" requested by the login. The login
failed.
Login failed for user 'DOMAIN\Administrator'.

Type: Error
Source: Windows SharePoint Services 3

2)
Login failed for user 'DOMAIN\Administrator '. [CLIENT: 10.10.7.7]
Source: MSSQL$SQLEXPRESS
Type: Failure Audit
Event ID: 18456

This one repeats two times...

3) Report Server Windows Service (SQLEXPRESS) cannot connect to the report
server database.
Type: Error
Source: Report Server Windows Service (SQLEXPRESS)
Event ID: 107

How can I find and eliminate the problem. Database permission for
DOMAIN/\Administrator look OK, but still something is wrong...

Reply to this Message

Erland Sommarskog - 01 Jul 2008 23:21 GMT

> I have a WSS 3.0 running on SQL Server 2005 Standard. It was upgraded
> from SQL Server 2005 Express edition. Everytime I restart server I have
[quoted text clipped - 7 lines]
> The login failed.
> Login failed for user 'DOMAIN\Administrator'.

Is there a database with that name on that server instance? In such
case is DOMAIN\Administrator a valid user in that database?

You say that you upgraded from SQL 2005 Express to Standard Edition?
Did you simply upgrade the existing instance, or did you move to a new
instance. (It would be a little confusing to have an instance called
SQLEXPRESS which runs a different edition.)

> 2)
> Login failed for user 'DOMAIN\Administrator '. [CLIENT: 10.10.7.7]
>...
>
> 3) Report Server Windows Service (SQLEXPRESS) cannot connect to the >
> report server database.

This could be errors that are due to the first error, so concentrate
on resolving that at first.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message

Zaur Bahramov - 02 Jul 2008 08:13 GMT

I can access the database both with odbc and SQLSMS. What could be wrong?
How else can I troubleshoot it?

>> I have a WSS 3.0 running on SQL Server 2005 Standard. It was upgraded
>> from SQL Server 2005 Express edition. Everytime I restart server I have
[quoted text clipped - 25 lines]
> This could be errors that are due to the first error, so concentrate
> on resolving that at first.

Reply to this Message

Zaur Bahramov - 02 Jul 2008 10:09 GMT

I figured out that the Reporting Services actually generates me this error:

TITLE: Surface Area Configuration
------------------------------

Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'.
The request failed with the error message:
--
<HTML dir="ltr">
<HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta
name="progid" content="SharePoint.WebPartPage.Document" /><meta
HTTP-EQUIV="Content-Type" content="text/html; charset=utf-8" /><meta
HTTP-EQUIV="Expires" content="0" /><meta name="ROBOTS" content="NOHTMLINDEX"
/><title>

Error

</title><link rel="stylesheet" type="text/css"
href="/_layouts/1033/styles/core.css?rev=5msmprmeONfN6lJ3wtbAlA%3D%3D"/>
<script type="text/javascript" language="javascript"
src="/_layouts/1033/init.js?rev=ck%2BHdHQ8ABQHif7kr%2Bj7iQ%3D%3D"></script>
<script type="text/javascript" language="javascript"
src="/_layouts/1033/core.js?rev=S5dt4K8TJGVTYU9HrW6enw%3D%3D"></script>

<meta name="Robots" content="NOINDEX " />
<meta name="SharePointError" content=""/>
</HEAD>
<BODY scroll="yes" onload="javascript:if (typeof(_spBodyOnLoadWrapper) !=
'undefined') _spBodyOnLoadWrapper();">
<form name="aspnetForm" method="post" action="../_layouts/error.aspx"
id="aspnetForm" onsubmit="return _spFormOnSubmitWrapper();">
<div>
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE"
value="/wEPDwUKLTU2NjkxODU3M2RkZjlbj5AL4TXtkhS3ANKvv2B07O0=" />
</div>

<TABLE class="ms-main" CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%"
HEIGHT="100%">
<tr><td>
<table CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%">
<tr>
<td colspan=4 class="ms-globalbreadcrumb" align="right">
<a href="javascript:TopHelpButtonClick('NavBarHelpHome')"
id="ctl00_PlaceHolderGlobalNavigation_TopHelpLink" AccessKey="6" title="Help
(new window)"><img src="/_layouts/images/helpicon.gif" align="absmiddle"
border="0" alt="Help (new window)" /></a>
</td>
</tr>
</table>
</td></tr>
<tr>
<td class="ms-globalTitleArea">
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr>
<td id="GlobalTitleAreaImage" class="ms-titleimagearea"><img
id="onetidHeadbnnr0" src="/_layouts/images/titlegraphic.gif" alt="" /></td>
<td class="ms-sitetitle" width=100%>

</td>
<td style="padding-top:8px;" valign=top>

</td>
</tr>
</table>
</td>
</tr>
<TR>
<TD id="onetIdTopNavBarContainer" WIDTH=100% class="ms-bannerContainer">

</TD>
</TR>

<TR height="100%"><TD><TABLE width="100%" height="100%" cellspacing="0"
cellpadding="0">
<tr>
<td class="ms-titlearealeft" id="TitleAreaImageCell" valign="middle"
nowrap><div style="height:100%" class="ms-titleareaframe"></div></td>
<td class="ms-titleareaframe" id="TitleAreaFrameClass">

<table cellpadding=0 height=100% width=100% cellspacing=0>
<tr><td class="ms-areaseparatorleft"><IMG
SRC="/_layouts/images/blank.gif" width=1 height=1 alt=""></td></tr>
</table>

</td>
<td valign=top id="onetidPageTitleAreaFrame" class='ms-areaseparator'
nowrap width="100%">
<table id="onetidPageTitleAreaTable" cellpadding=0 cellspacing=0
width=100% border="0">
<tr>
<td valign="top" class="ms-titlearea">

<a href="http://websrv1"
id="ctl00_PlaceHolderTitleBreadcrumb_idSimpleGoBackToHome">Go back to
site</a>

</td>
</tr>
<tr>
<td height=100% valign=top ID=onetidPageTitle class="ms-pagetitle">
<h2 class="ms-pagetitle">

Error

</h2>
</td>
</tr>
</table>
</td>
<td class="ms-titlearearight">

<div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif"
width=8 height=100% alt=""></div>
</td>
</tr>

<TR>
<TD class="ms-leftareacell" valign=top height=100%
id="LeftNavigationAreaCell">
<table class=ms-nav width=100% height=100% cellpadding=0 cellspacing=0>
<tr>
<td>
<TABLE height="100%" class=ms-navframe CELLPADDING=0 CELLSPACING=0
border="0">
<tr valign="top">
<td width="4px"><IMG SRC="/_layouts/images/blank.gif" width=4 height=1
alt=""></td>
<td valign="top" width="100%">

</td>
</tr>
<tr><td colspan=2><IMG SRC="/_layouts/images/blank.gif" width=138
height=1 alt=""></td></tr>
</TABLE>
</td>
<td></td>
</tr>
</table>
</TD>
<td>
<div class='ms-areaseparatorleft'><IMG SRC="/_layouts/images/blank.gif"
width=8 height=100% alt=""></div>
</td>
<td class='ms-formareaframe' valign="top">
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0"
class="ms-propertysheet">
<TR valign="top" >
<TD class="ms-descriptiontext" width="100%">

</TD>
<TD ID=onetidYPadding width="10px"><IMG
SRC="/_layouts/images/blank.gif" width=10 height=1 alt=""></TD>
</TR>
<TR >
<TD ID=onetidMainBodyPadding height="8px"><IMG
SRC="/_layouts/images/blank.gif" width=1 height=8 alt=""></TD>
</TR>
<tr>
<td valign="top" height="100%">
<A name="mainContent"></A>

<table width=100% border=0 class="ms-titleareaframe" cellpadding=0>
<TR>
<TD valign=top width="100%" style="padding-top: 10px"
class="ms-descriptiontext">
<span id="ctl00_PlaceHolderMain_LabelMessage">The file you are
attempting to save or retrieve has been blocked from this Web site by the
server administrators.</span>
<P><span class="ms-descriptiontext">
<span id="ctl00_PlaceHolderMain_helptopic_troubleshooting"><A
Title="Troubleshoot issues with Windows SharePoint Services. - Opens in new
window" HREF="javascript:HelpWindowKey('troubleshooting')">Troubleshoot
issues with Windows SharePoint Services.</A></span>

</span>
</TD>
</TR>
</table>
<script type="text/javascript" language="JavaScript">
var gearPage = document.getElementById('GearPage');
if(null != gearPage)
{
gearPage.parentNode.removeChild(gearPage);
document.title = "Error";
}
</script>

</td>
</tr>
</table>
</td>
<td class="ms-rightareacell">
<div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif"
width=8 height=100% alt=""></div>
</td>
</TR>
<tr>
<td class="ms-pagebottommarginleft"><IMG SRC="/_layouts/images/blank.gif"
width=1 height=10 alt=""></td>
<td class="ms-pagebottommargin"><IMG SRC="/_layouts/images/blank.gif"
width=1 height=10 alt=""></td>
<td class="ms-bodyareapagemargin"><IMG SRC="/_layouts/images/blank.gif"
width=1 height=10 alt=""></td>
<td class="ms-pagebottommarginright"><IMG SRC="/_layouts/images/blank.gif"
width=1 height=10 alt=""></td>
</tr>
</TABLE></TD></TR>
</TABLE>

<input type="text" name="__spDummyText1" style="display:none;" size=1/>
<input type="text" name="__spDummyText2" style="display:none;" size=1/>
</form>

</BODY>
</HTML>

--. (SQLSAC)

------------------------------
BUTTONS:

OK
------------------------------

>I can access the database both with odbc and SQLSMS. What could be wrong?
> How else can I troubleshoot it?
[quoted text clipped - 28 lines]
>> This could be errors that are due to the first error, so concentrate
>> on resolving that at first.

Reply to this Message

Erland Sommarskog - 02 Jul 2008 23:09 GMT

> I can access the database both with odbc and SQLSMS. What could be wrong?
> How else can I troubleshoot it?

And you access it as DOMAIN\Administrator?

And is the name of the instance still WEBSRV1\SQLEXPRESS, despite that
it's now Standard Edition?

Signature

Reply to this Message

Zaur Bahramov - 03 Jul 2008 07:30 GMT

Hi!

Yes, after moving to SQL Server 2005 standard edition the instance name
remains SQLEXPRESS. I didn't try to do something with it because I was
afraid to mess something up and the procedure I used for that didn't mention
renaming an instance.

As for connecting to SQL Server, I can connect with both, SQL user account
and doman user account.

>> I can access the database both with odbc and SQLSMS. What could be wrong?
>> How else can I troubleshoot it?
[quoted text clipped - 3 lines]
> And is the name of the instance still WEBSRV1\SQLEXPRESS, despite that
> it's now Standard Edition?

Reply to this Message

Zaur Bahramov - 03 Jul 2008 07:31 GMT

And, I've resolved the first 2 issues as you've advised. Then I was trying
to resolve the report server error. For now I left it to start up manually
since I don't use it at this time.

Reply to this Message