Prev: Error in adding web parts (MOSS 2007)
Next: Access Dennied Problem with the Event Planning Application Template
From: Nick-Mars on 12 Apr 2008 16:36
After following a procedure to move the location of the SQL databases from
drive C to drive D, we are getting errors in the event log. Sharepoint
itself is working fine, however we get the following errors about twice per
day. Note that the database it mentions I am able to connect to fine. Have
any ideas? I can't seem to find much information about these problems
elswhere.

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database
Event ID: 3760
Date: 4/12/2008
Time: 1:24:42 AM
User: N/A
Computer: TRESBS-1
Description:
SQL Database 'WSS_Content' on SQL Server instance
'np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query' not found. Additional error
information from SQL Server is included below.

Cannot open database "WSS_Content" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

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

Event Type: Failure Audit
Event Source: MSSQL$MICROSOFT##SSEE
Event Category: (4)
Event ID: 18456
Date: 4/12/2008
Time: 1:24:37 AM
User: NT AUTHORITY\NETWORK SERVICE
Computer: TRESBS-1
Description:
The description for Event ID ( 18456 ) in Source ( MSSQL$MICROSOFT##SSEE )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote computer.
You may be able to use the /AUXSOURCE= flag to retrieve this description; see
Help and Support for details. The following information is part of the event:
NT AUTHORITY\NETWORK SERVICE, [CLIENT: <named pipe>].
Data:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 19 00 00 00 54 00 52 00 ....T.R.
0010: 45 00 53 00 42 00 53 00 E.S.B.S.
0018: 2d 00 31 00 5c 00 4d 00 -.1.\.M.
0020: 49 00 43 00 52 00 4f 00 I.C.R.O.
0028: 53 00 4f 00 46 00 54 00 S.O.F.T.
0030: 23 00 23 00 53 00 53 00 #.#.S.S.
0038: 45 00 45 00 00 00 07 00 E.E.....
0040: 00 00 6d 00 61 00 73 00 ..m.a.s.
0048: 74 00 65 00 72 00 00 00 t.e.r...

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database
Event ID: 3760
Date: 4/10/2008
Time: 11:20:43 PM
User: N/A
Computer: TRESBS-1
Description:
SQL Database 'WSS_Content' on SQL Server instance 'TRESBS-1\Microsoft##SSEE'
not found. Additional error information from SQL Server is included below.

Cannot open database "WSS_Content" requested by the login. The login failed.

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

Event Type: Failure Audit
Event Source: MSSQL$MICROSOFT##SSEE
Event Category: (4)
Event ID: 18456
Date: 4/10/2008
Time: 11:20:43 PM
User: NT AUTHORITY\NETWORK SERVICE
Computer: TRESBS-1
Description:
The description for Event ID ( 18456 ) in Source ( MSSQL$MICROSOFT##SSEE )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote computer.
You may be able to use the /AUXSOURCE= flag to retrieve this description; see
Help and Support for details. The following information is part of the event:
NT AUTHORITY\NETWORK SERVICE, [CLIENT: <named pipe>].
Data:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 19 00 00 00 54 00 52 00 ....T.R.
0010: 45 00 53 00 42 00 53 00 E.S.B.S.
0018: 2d 00 31 00 5c 00 4d 00 -.1.\.M.
0020: 49 00 43 00 52 00 4f 00 I.C.R.O.
0028: 53 00 4f 00 46 00 54 00 S.O.F.T.
0030: 23 00 23 00 53 00 53 00 #.#.S.S.
0038: 45 00 45 00 00 00 07 00 E.E.....
0040: 00 00 6d 00 61 00 73 00 ..m.a.s.
0048: 74 00 65 00 72 00 00 00 t.e.r...

-------------------------
We are also getting the following "information" messages at a rate of about
10-20 a day.

Event Type: Information
Event Source: MSSQL$MICROSOFT##SSEE
Event Category: (2)
Event ID: 2803
Date: 4/12/2008
Time: 4:15:45 PM
User: N/A
Computer: TRESBS-1
Description:
The description for Event ID ( 2803 ) in Source ( MSSQL$MICROSOFT##SSEE )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote computer.
You may be able to use the /AUXSOURCE= flag to retrieve this description; see
Help and Support for details. The following information is part of the event:
1, Object Plans.
Data:
0000: f3 0a 00 00 0a 00 00 00 ó.......
0008: 19 00 00 00 54 00 52 00 ....T.R.
0010: 45 00 53 00 42 00 53 00 E.S.B.S.
0018: 2d 00 31 00 5c 00 4d 00 -.1.\.M.
0020: 49 00 43 00 52 00 4f 00 I.C.R.O.
0028: 53 00 4f 00 46 00 54 00 S.O.F.T.
0030: 23 00 23 00 53 00 53 00 #.#.S.S.
0038: 45 00 45 00 00 00 07 00 E.E.....
0040: 00 00 6d 00 61 00 73 00 ..m.a.s.
0048: 74 00 65 00 72 00 00 00 t.e.r...


Event Type: Information
Event Source: MSSQL$MICROSOFT##SSEE
Event Category: (2)
Event ID: 3455
Date: 4/12/2008
Time: 4:04:41 PM
User: NT AUTHORITY\NETWORK SERVICE
Computer: TRESBS-1
Description:
The description for Event ID ( 3455 ) in Source ( MSSQL$MICROSOFT##SSEE )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote computer.
You may be able to use the /AUXSOURCE= flag to retrieve this description; see
Help and Support for details. The following information is part of the event:
WSS_Content, 9, 100, 0.
Data:
0000: 7f 0d 00 00 0a 00 00 00 .......
0008: 19 00 00 00 54 00 52 00 ....T.R.
0010: 45 00 53 00 42 00 53 00 E.S.B.S.
0018: 2d 00 31 00 5c 00 4d 00 -.1.\.M.
0020: 49 00 43 00 52 00 4f 00 I.C.R.O.
0028: 53 00 4f 00 46 00 54 00 S.O.F.T.
0030: 23 00 23 00 53 00 53 00 #.#.S.S.
0038: 45 00 45 00 00 00 07 00 E.E.....
0040: 00 00 6d 00 61 00 73 00 ..m.a.s.
0048: 74 00 65 00 72 00 00 00 t.e.r...


Event Type: Information
Event Source: MSSQL$MICROSOFT##SSEE
Event Category: (2)
Event ID: 17137
Date: 4/12/2008
Time: 4:04:36 PM
User: NT AUTHORITY\NETWORK SERVICE
Computer: TRESBS-1
Description:
The description for Event ID ( 17137 ) in Source ( MSSQL$MICROSOFT##SSEE )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote computer.
You may be able to use the /AUXSOURCE= flag to retrieve this description; see
Help and Support for details. The following information is part of the event:
WSS_Content.
Data:
0000: f1 42 00 00 0a 00 00 00 ñB......
0008: 19 00 00 00 54 00 52 00 ....T.R.
0010: 45 00 53 00 42 00 53 00 E.S.B.S.
0018: 2d 00 31 00 5c 00 4d 00 -.1.\.M.
0020: 49 00 43 00 52 00 4f 00 I.C.R.O.
0028: 53 00 4f 00 46 00 54 00 S.O.F.T.
0030: 23 00 23 00 53 00 53 00 #.#.S.S.
0038: 45 00 45 00 00 00 07 00 E.E.....
0040: 00 00 6d 00 61 00 73 00 ..m.a.s.
0048: 74 00 65 00 72 00 00 00 t.e.r...

From: Ada Pan [MSFT] on 13 Apr 2008 22:24
Hello Nick,

It seems there are multiple errors posted in this thread. Generally, we
request one question/problem per post in the newsgroups. In order to
concentrate fully on each of these issues and provide clarity for others
that may be following here, we ask that you post them as separate threads.


In this thread, we will focus on the error 3760. If we finally resolve the
error 3760 but other errors still persist, please feel free to open
different posts for these errors. We will be very glad to work with you.

Based on my knowledge, the error "3760" may occur if the auto-close option
is turned on for the database.

To narrow down the problem, run the following command to turn Auto-close
options off:

sqlcmd -E -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

REFERENCE:
-----------------------------
Setting Database Options
<http://msdn2.microsoft.com/en-us/library/ms190249.aspx>
SQLCMD tool
<http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f
269484/SQLServer2005_SQLCMD.msi>

If you have any questions, please let me know. I am glad to be of
assistance.

Regards,

Ada Pan

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
From: Ada Pan [MSFT] on 16 Apr 2008 01:00
Hello Nick,

How are you?

I am currently standing by for an update from you and would like to know
how things are going there. Please let me know if there is anything else I
can do further assistance.

Regards,

Ada Pan

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
From: Nick-Mars on 24 Apr 2008 17:10
Ada,

Thanks for the help! I wasn't able to get your command to work, but
unchecking the auto-close option for the database from management studio
fixed the issue. Thanks!

"Ada Pan [MSFT]" wrote:

> Hello Nick,
>
> How are you?
>
> I am currently standing by for an update from you and would like to know
> how things are going there. Please let me know if there is anything else I
> can do further assistance.
>
> Regards,
>
> Ada Pan
>
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights
From: "Ada Pan [MSFT]" on 24 Apr 2008 23:32
Hello Nick,

Thank you for your reply and the detailed additional feedback on how you
were successful in resolving this issue. Your solution will benefit many
other users, and we really value having you as a Microsoft user.

If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.

Have a nice day!

Regards,

Ada Pan

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 | 
Pages: 1
Prev: Error in adding web parts (MOSS 2007)
Next: Access Dennied Problem with the Event Planning Application Template