Answered by:
I keep these two errors MSSQL$QUEST2 & folder redirection

Question
-
Log Name: Application
Source: MSSQL$QUEST2
Date: 8/5/2009 11:28:04 AM
Event ID: 17207
Task Category: (2)
Level: Error
Keywords: Classic
User: N/A
Computer: Cliffs-Laptop.cei.local
Description:
FCB::RemoveAlternateStreams: Operating system error (null) occurred while creating or opening file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\tempdb.mdf'. Diagnose and correct the operating system error, and retry the operation.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQL$QUEST2" />
<EventID Qualifiers="49152">17207</EventID>
<Level>2</Level>
<Task>2</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2009-08-05T15:28:04.000000000Z" />
<EventRecordID>11286</EventRecordID>
<Channel>Application</Channel>
<Computer>Cliffs-Laptop.cei.local</Computer>
<Security />
</System>
<EventData>
<Data>FCB::RemoveAlternateStreams</Data>
<Data>(null)</Data>
<Data>c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\tempdb.mdf</Data>
<Binary>37430000100000001500000043006C0069006600660073002D004C006100700074006F0070005C00510055004500530054003200000000000000</Binary>
</EventData>
</Event>
Log Name: Application
Source: Microsoft-Windows-Folder Redirection
Date: 8/5/2009 11:31:13 AM
Event ID: 502
Task Category: None
Level: Error
Keywords:
User: CEI\cyoun001
Computer: Cliffs-Laptop.cei.local
Description:
Failed to apply policy and redirect folder "Documents" to "\\cei01\users\cyoun001".
Redirection options=0x9211.
The following error occurred: "Can not create folder "\\cei01\users\cyoun001"".
Error details: "This security ID may not be assigned as the owner of this object.
".
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-Windows-Folder Redirection" Guid="{7D7B0C39-93F6-4100-BD96-4DDA859652C5}" />
<EventID>502</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x8000000000000000</Keywords>
<TimeCreated SystemTime="2009-08-05T15:31:13.199156500Z" />
<EventRecordID>11341</EventRecordID>
<Correlation ActivityID="{68132BFB-0053-4EDC-8745-CFCD00A4F271}" />
<Execution ProcessID="1052" ThreadID="2292" />
<Channel>Application</Channel>
<Computer>Cliffs-Laptop.cei.local</Computer>
<Security UserID="S-1-5-21-2716589573-1642372169-821230542-1137" />
</System>
<EventData Name="EVENT_FDEPLOY_FailedToApplyPolicy">
<Data Name="FromFolder">Documents</Data>
<Data Name="ToFolder">\\cei01\users\cyoun001</Data>
<Data Name="Options">0x9211</Data>
<Data Name="Error">Can not create folder "\\cei01\users\cyoun001"</Data>
<Data Name="ErrorDetails">This security ID may not be assigned as the owner of this object.
</Data>
</EventData>
</Event>Wednesday, August 5, 2009 8:49 PM
Answers
-
Hi Tcyoung,
Your Thread is based on MSSQL$QUEST2 and Folder redirectio problem.
This forum is explicitly meant for resolving Windows 7 issues.
However, I would try my level best to help you in resolving of issue.
For resolving MSSQL$QUEST2 issue:
You have a permissions issue, the Workgroup isn't set up correctly and the SQL Server has conflicts! Some of the Errors overlap in that fixing one SQL error may also fix another. This is not my forte but I did a lot of searching:For further details , please visit: http://www.techspot.com/vb/topic127485.html
If I understand correctly, QUEST2 is an add-on module for the SQL Server and interestingly enough, the searches has to be for MSSQUL or SQL, not for MSSQL$QUEST2. If this id correct, I would first suggest disabling the QUEST2 add-on. Check the system. See if it makes any difference. If not:
Resolve these:
17204:
SQL Server was unable to open the specified file due to the specified error.
This problem occurs because the user account that you use to log on to Microsoft Dynamics CRM 3.0 does not have the Microsoft Dynamics CRM System Administrator role.
See FIX here: http://support.microsoft.com/default...b;en-us;946542
User Action
Diagnose and correct the operating system, then retry the operation.
17049:
A process outside of SQL Server may be preventing SQL Server from reading the files. As a result, errorlog entries may be lost and it may not be possible to view some SQL Server errorlogs. Make sure no other processes have locked the file with write-only access."
NOTE: possible print server conflict
7024.
The SQL error log may contain additional information about this problem
The 3417 message is an error recovering the master database so the instance can not start.
3409:
TO FIX: (should also handle Error 8313.)
1. Reinstall sqlctr.ini for this instance and ensure that the instance login account has correct registry permissions.
7034 Date: 6/11/2009 Time: 9:20:21 AM
Description: The MSSQL$QUEST service terminated unexpectedly.
FIX: A stack overflow exception may occur, and SQL Server 2000 may unexpectedly close when you submit a query that uses the UNION ALL operator more than 255 times
Hotfix download is available> http://support.microsoft.com/default...b;en-us;892141
7031
The Print Spooler service terminated unexpectedly
TO FIX:
Method 1: Remove the registry entry for the Xerox language monitor in Registry Editor
OR
Method 2: Disable the language monitor entry in the Printer.inf file of the printer
HERE: http://support.microsoft.com/default...b;en-us;888206
1003
Description:Error code 00000093
0x00000093 is "Invalid Kernel Handle" This is a relatively rare error condition. Most documentation points to a driver problem - so check all hardware drivers starting with the most obvious, the video driver.
Start> Run type "sigverif.exe" without quotes and hit OK. What
drivers are listed as unsigned? Disregard those which are not checked.
http://aumha.org/a/stop.htm
For Resolving Folder redirection issue, please visit: http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/Windows_Vista/Q_23090538.html
Hope this helps
Thanks
Abhay
NOTE - Disclaimer
The links in this message may lead to third-party Web sites. Microsoft provides third-party resources to help you find customer service and/or technical support resources. Information at these sites may change without notice. Microsoft is not responsible for the content at any third-party Web sites and does not guarantee the accuracy of third-party information.
- Edited by Abhay-MSFT Friday, August 7, 2009 6:35 PM Update
- Marked as answer by Nicholas Li Monday, August 10, 2009 10:06 AM
Friday, August 7, 2009 6:30 PM