none
failed to generate a user instance of sql server ...

    Question

  • I am getting a "failed to generate a user instance of sql server due to a failure in start the process for the user instance" error in visual studio. I get the error when I try to connect to an .mdf file in the app_data folder of an asp.net mvc project.  Within this same project ( same login ) I can connect to a database in the sqlexpress sql server. Also, when I login as administrator I can connect to the same .MDF file I am having the problem with in my user login. In sql mgmt studio, I went to server roles and created a login for the windows user that has this problem with the .MDF file.

    What could the problem be with this .MDF file and my user account? 

    thanks,

     

     

    Thursday, July 08, 2010 9:14 PM

Answers

  • Hi,

    When a user sets User Instance=true in the connection string, a user instance is generated at the first time. Then, the master and msdb system databases are copied from the Template Data folder to a path under the user's local application data repository directory for exclusive use by the user instance. This path is typically C:\Documents and Settings\<UserName>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS. When a user instance starts up, the tempdb, log, and trace files are also written to this directory. A name is generated for the instance, which is guaranteed to be unique for each user.

    In this case, please check the C:\Documents and Settings\<UserName>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS directory. If the folder exists, try to copy it to another folder and then delete it.

    If you have any more questions, please let me know.
    Thanks


    ***Xiao Min Tan***Microsoft Online Community***
    Monday, July 12, 2010 5:59 AM

All replies

  • Hi,

    User instance is different with a normal SQL Server instance. It doesn’t requires   a login or any database/server roles.  The user who opened the user instance connection need to have write permissions on the .mdf and .ldf files that are specified in the AttachDbFilename option of the connection string.  Therefore, please make sure the user who connects to the user instance has the write permissions on both the .mdf and .ldf files.

    Please also refer to the common issues from the following document:
    http://technet.microsoft.com/en-us/library/bb264564(SQL.90).aspx

    If you have any more questions, please let me know.
    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Friday, July 09, 2010 6:39 AM
  • still not working.  I understand the concept a lot better, but still no go.

    running VS2010 in my user account, I cannot create a new .MDF database in the APP_DATA folder of a web project. Same error: "Failed to generate a user instance of SQL server due to a failure in starting the process for the user instance."

    Works when I log in as the administrator. Does not work with my user account.

    I downloaded and installed sql server express r2 yesterday.

    Is there a log file I can view that contains more detailed info about the error?

    Friday, July 09, 2010 1:02 PM
  • Here is process monitor output. Filtering on PID = visual studio and result != SUCCESS.

    I start capturing events in process monitor, click the add button in visual studio to add a sql server database to the project, get the "failed to generate a user instance" error, stop capturing events in process monitor.

    "Time of Day","PID","Operation","Path","Result","Detail"
    "11:03:47.1902857 AM","6920","QueryOpen","C:\srmvc\CashForYourBooks\CashForYourBooks\CashForYourBooks.csproj","FAST IO DISALLOWED",""
    "11:03:47.1906067 AM","6920","QueryOpen","C:\BookStore\BookLib\BookLib\BookLib.csproj","FAST IO DISALLOWED",""
    "11:03:48.1047945 AM","6920","RegOpenKey","HKLM\SOFTWARE\Microsoft\CTF\KnownClasses","NAME NOT FOUND","Desired Access: Read"
    "11:03:48.2031052 AM","6920","QueryOpen","C:\srmvc\CashForYourBooks\CashForYourBooks\CashForYourBooks.csproj","FAST IO DISALLOWED",""
    "11:03:48.2038240 AM","6920","QueryOpen","C:\BookStore\BookLib\BookLib\BookLib.csproj","FAST IO DISALLOWED",""
    "11:03:48.2973555 AM","6920","RegOpenKey","HKLM\SOFTWARE\Microsoft\CTF\KnownClasses","NAME NOT FOUND","Desired Access: Read"
    "11:03:48.3263215 AM","6920","RegOpenKey","HKLM\SOFTWARE\Microsoft\CTF\KnownClasses","NAME NOT FOUND","Desired Access: Read"
    "11:03:48.3270787 AM","6920","RegQueryValue","HKU\S-1-5-21-3945770714-1964116772-3840333764-1104\Software\Microsoft\VisualStudio\10.0_Config\CLSID\{C28C4281-6E29-41AB-A120-9B6336BAC906}\Assembly","BUFFER OVERFLOW","Length: 144"
    "11:03:48.3271010 AM","6920","RegQueryValue","HKU\S-1-5-21-3945770714-1964116772-3840333764-1104\Software\Microsoft\VisualStudio\10.0_Config\CLSID\{C28C4281-6E29-41AB-A120-9B6336BAC906}\CodeBase","BUFFER OVERFLOW","Length: 144"
    "11:03:48.3292902 AM","6920","ReadFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\ItemTemplatesCache\CSharp\Data\1033\SqlDatabase.zip\SqlDatabase.vstemplate","END OF FILE","Offset: 1,783, Length: 1,783"
    "11:03:48.3297345 AM","6920","QueryOpen","C:\srmvc\CashForYourBooks\CashForYourBooks","FAST IO DISALLOWED",""
    "11:03:48.3470627 AM","6920","RegOpenKey","HKLM\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo","NAME NOT FOUND","Desired Access: Read"
    "11:03:48.3472453 AM","6920","RegOpenKey","HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\Cluster","NAME NOT FOUND","Desired Access: Read"
    "11:03:48.3472772 AM","6920","RegOpenKey","HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\Cluster","NAME NOT FOUND","Desired Access: Read"
    "11:03:48.3472955 AM","6920","RegOpenKey","HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\Cluster","NAME NOT FOUND","Desired Access: Read"
    "11:03:48.3497979 AM","6920","RegOpenKey","HKLM\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo","NAME NOT FOUND","Desired Access: Read"
    "11:03:48.3499667 AM","6920","RegOpenKey","HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\Cluster","NAME NOT FOUND","Desired Access: Read"
    "11:03:48.3499963 AM","6920","RegOpenKey","HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\Cluster","NAME NOT FOUND","Desired Access: Read"
    "11:03:48.3500146 AM","6920","RegOpenKey","HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\Cluster","NAME NOT FOUND","Desired Access: Read"
    "11:03:49.2430652 AM","6920","QueryOpen","C:\srmvc\CashForYourBooks\CashForYourBooks\CashForYourBooks.csproj","FAST IO DISALLOWED",""
    "11:03:49.2437887 AM","6920","QueryOpen","C:\BookStore\BookLib\BookLib\BookLib.csproj","FAST IO DISALLOWED",""
    "11:03:49.8115356 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VisualBasic\Web\MVC 2","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8115810 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VisualBasic\SharePoint\SharePoint14","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8116169 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VisualBasic\Silverlight","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8116524 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VisualBasic\Windows Forms","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8116904 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CSharp\Web\MVC 2","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8117259 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CSharp\SharePoint\SharePoint14","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8715672 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\%VSDIR%VC#\%VSZ_SUB_DIR%CSharpProjectItems","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8716920 AM","6920","CreateFile","\\\","NAME INVALID","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8722029 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\%VB7DIR%%VSZ_SUB_DIR%VBProjectItems","NAME NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8725480 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Web\WebProjectItems.old","NAME NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8726376 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\Web\Visual C#","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8730922 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CSharp","NAME NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8731826 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CSharp\Code","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8732627 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CSharp\General","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8733407 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CSharp\Web","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8734179 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CSharp\WPF","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8734944 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CSharp\Data","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8735727 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\Web\Visual Basic","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8736506 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\FSharp\General","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8741026 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VisualBasic","NAME NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8741952 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VisualBasic\Code","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8742761 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VisualBasic\General","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8743559 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CSharp\Reporting","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8744338 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VisualBasic\Web","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8745129 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VisualBasic\WPF","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8745904 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CSharp\Office","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8746677 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CSharp\Workflow","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8747460 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VisualBasic\Data","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8748236 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CSharp\Silverlight","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8749008 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\CSharp\Windows Forms","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8749780 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\FSharp\FSharpCode","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8750570 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VisualBasic\Reporting","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8751361 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VisualBasic\Office","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:49.8752140 AM","6920","CreateFile","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\VisualBasic\Workflow","PATH NOT FOUND","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a"
    "11:03:50.1580622 AM","6920","RegOpenKey","HKLM\SOFTWARE\Microsoft\CTF\KnownClasses","NAME NOT FOUND","Desired Access: Read"
    "11:03:50.1597585 AM","6920","RegOpenKey","HKLM\SOFTWARE\Microsoft\CTF\KnownClasses","NAME NOT FOUND","Desired Access: Read"
    "11:03:50.1641494 AM","6920","RegOpenKey","HKLM\SOFTWARE\Microsoft\CTF\KnownClasses","NAME NOT FOUND","Desired Access: Read"
    "11:03:50.2254955 AM","6920","RegQueryValue","HKU\S-1-5-21-3945770714-1964116772-3840333764-1104\Software\Microsoft\VisualStudio\10.0\NewItemDialog\CreateDirectoryForSolution","NAME NOT FOUND","Length: 144"
    "11:03:50.2258662 AM","6920","QueryOpen","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe","FAST IO DISALLOWED",""
    "11:03:50.2262915 AM","6920","QueryOpen","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe","FAST IO DISALLOWED",""
    "11:03:50.2266501 AM","6920","RegQueryValue","HKU\S-1-5-21-3945770714-1964116772-3840333764-1104\Software\Microsoft\VisualStudio\10.0_Config\Projects\{F85E285E-A4E0-4152-9332-AB1D724D3325}\TemplateIDs(VsTemplate)","NAME NOT FOUND","Length: 144"
    "11:03:50.2266871 AM","6920","RegOpenKey","HKU\S-1-5-21-3945770714-1964116772-3840333764-1104\Software\Microsoft\VisualStudio\10.0_Config\Setup\VSLS","NAME NOT FOUND","Desired Access: Read"
    "11:03:50.2268814 AM","6920","RegOpenKey","HKU\S-1-5-21-3945770714-1964116772-3840333764-1104\Software\Microsoft\VisualStudio\10.0_Config\NewProjectDialog","NAME NOT FOUND","Desired Access: Read"
    "11:03:50.2269026 AM","6920","RegQueryValue","HKU\S-1-5-21-3945770714-1964116772-3840333764-1104\Software\Microsoft\VisualStudio\10.0_Config\Projects\{F85E285E-A4E0-4152-9332-AB1D724D3325}\DisableOnlineTemplates","NAME NOT FOUND","Length: 144"
    "11:03:50.2272378 AM","6920","RegQueryValue","HKU\S-1-5-21-3945770714-1964116772-3840333764-1104\Software\Microsoft\VisualStudio\10.0\DisableUserTemplates","NAME NOT FOUND","Length: 144"
    "11:03:50.2349162 AM","6920","QueryOpen","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe","FAST IO DISALLOWED",""
    "11:03:50.2353265 AM","6920","QueryOpen","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe","FAST IO DISALLOWED",""
    "11:03:50.2357528 AM","6920","QueryOpen","C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe","FAST IO DISALLOWED",""
    "11:03:50.2367790 AM","6920","RegOpenKey","HKU\S-1-5-21-3945770714-1964116772-3840333764-1104\Software\Microsoft\Avalon.Graphics","NAME NOT FOUND","Desired Access: Query Value"
    "11:03:50.2368035 AM","6920","RegQueryValue","HKLM\SOFTWARE\Microsoft\Direct3D\ShowFrameRate","NAME NOT FOUND","Length: 144"
    "11:03:50.2368083 AM","6920","RegQueryValue","HKLM\SOFTWARE\Microsoft\Direct3D\FlipNoVsync","NAME NOT FOUND","Length: 144"
    "11:03:50.2368251 AM","6920","RegQueryValue","HKLM\SOFTWARE\Microsoft\DirectDraw\ForceRefreshRate","NAME NOT FOUND","Length: 144"
    "11:03:50.2372394 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{F3377B14-D7FE-4FCC-AB68-31F0779ACD12}\0000","REPARSE","Desired Access: Read"
    "11:03:50.2372602 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Class\{4D36E968-E325-11CE-BFC1-08002BE10318}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.2374301 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{F3377B14-D7FE-4FCC-AB68-31F0779ACD12}\0001","REPARSE","Desired Access: Read"
    "11:03:50.2374462 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Class\{4D36E968-E325-11CE-BFC1-08002BE10318}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.2375592 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{DEB039CC-B704-4F53-B43E-9DD4432FA2E9}\0000","REPARSE","Desired Access: Read"
    "11:03:50.2375750 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Video\{DEB039CC-B704-4F53-B43E-9DD4432FA2E9}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.2376262 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{42CF9257-1D96-4C9D-87F3-0D8E74595F78}\0000","REPARSE","Desired Access: Read"
    "11:03:50.2376412 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Video\{42cf9257-1d96-4c9d-87f3-0d8e74595f78}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.2376943 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{B043B95C-5670-4F10-B934-8ED0C8EB59A8}\0000","REPARSE","Desired Access: Read"
    "11:03:50.2377100 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Video\{b043b95c-5670-4f10-b934-8ed0c8eb59a8}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.2378081 AM","6920","RegOpenKey","HKU\S-1-5-21-3945770714-1964116772-3840333764-1104\Software\Microsoft\Avalon.Graphics","NAME NOT FOUND","Desired Access: Query Value"
    "11:03:50.2378271 AM","6920","RegQueryValue","HKLM\SOFTWARE\Microsoft\Direct3D\ShowFrameRate","NAME NOT FOUND","Length: 144"
    "11:03:50.2378315 AM","6920","RegQueryValue","HKLM\SOFTWARE\Microsoft\Direct3D\FlipNoVsync","NAME NOT FOUND","Length: 144"
    "11:03:50.2378458 AM","6920","RegQueryValue","HKLM\SOFTWARE\Microsoft\DirectDraw\ForceRefreshRate","NAME NOT FOUND","Length: 144"
    "11:03:50.2380716 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{F3377B14-D7FE-4FCC-AB68-31F0779ACD12}\0000","REPARSE","Desired Access: Read"
    "11:03:50.2380899 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Class\{4D36E968-E325-11CE-BFC1-08002BE10318}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.2382132 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{F3377B14-D7FE-4FCC-AB68-31F0779ACD12}\0001","REPARSE","Desired Access: Read"
    "11:03:50.2382286 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Class\{4D36E968-E325-11CE-BFC1-08002BE10318}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.2383406 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{DEB039CC-B704-4F53-B43E-9DD4432FA2E9}\0000","REPARSE","Desired Access: Read"
    "11:03:50.2383552 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Video\{DEB039CC-B704-4F53-B43E-9DD4432FA2E9}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.2384046 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{42CF9257-1D96-4C9D-87F3-0D8E74595F78}\0000","REPARSE","Desired Access: Read"
    "11:03:50.2384193 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Video\{42cf9257-1d96-4c9d-87f3-0d8e74595f78}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.2384683 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{B043B95C-5670-4F10-B934-8ED0C8EB59A8}\0000","REPARSE","Desired Access: Read"
    "11:03:50.2384829 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Video\{b043b95c-5670-4f10-b934-8ed0c8eb59a8}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.3028175 AM","6920","RegQueryValue","HKLM\SOFTWARE\Microsoft\Direct3D\ShowFrameRate","NAME NOT FOUND","Length: 144"
    "11:03:50.3028256 AM","6920","RegQueryValue","HKLM\SOFTWARE\Microsoft\Direct3D\FlipNoVsync","NAME NOT FOUND","Length: 144"
    "11:03:50.3028519 AM","6920","RegQueryValue","HKLM\SOFTWARE\Microsoft\DirectDraw\ForceRefreshRate","NAME NOT FOUND","Length: 144"
    "11:03:50.3035853 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{F3377B14-D7FE-4FCC-AB68-31F0779ACD12}\0000","REPARSE","Desired Access: Read"
    "11:03:50.3036132 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Class\{4D36E968-E325-11CE-BFC1-08002BE10318}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.3037811 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{F3377B14-D7FE-4FCC-AB68-31F0779ACD12}\0001","REPARSE","Desired Access: Read"
    "11:03:50.3037972 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Class\{4D36E968-E325-11CE-BFC1-08002BE10318}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.3039147 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{DEB039CC-B704-4F53-B43E-9DD4432FA2E9}\0000","REPARSE","Desired Access: Read"
    "11:03:50.3039301 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Video\{DEB039CC-B704-4F53-B43E-9DD4432FA2E9}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.3039842 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{42CF9257-1D96-4C9D-87F3-0D8E74595F78}\0000","REPARSE","Desired Access: Read"
    "11:03:50.3039996 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Video\{42cf9257-1d96-4c9d-87f3-0d8e74595f78}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.3040523 AM","6920","RegOpenKey","HKLM\System\CurrentControlSet\CONTROL\VIDEO\{B043B95C-5670-4F10-B934-8ED0C8EB59A8}\0000","REPARSE","Desired Access: Read"
    "11:03:50.3040677 AM","6920","RegQueryValue","HKLM\System\CurrentControlSet\Control\Video\{b043b95c-5670-4f10-b934-8ed0c8eb59a8}\0000\PruningMode","NAME NOT FOUND","Length: 52"
    "11:03:50.3093021 AM","6920","RegOpenKey","HKLM\SOFTWARE\Microsoft\CTF\KnownClasses","NAME NOT FOUND","Desired Access: Read"
    "11:03:50.3689344 AM","6920","QueryOpen","C:\srmvc\CashForYourBooks\CashForYourBooks\CashForYourBooks.csproj","FAST IO DISALLOWED",""
    "11:03:50.3692568 AM","6920","QueryOpen","C:\BookStore\BookLib\BookLib\BookLib.csproj","FAST IO DISALLOWED",""
    "11:03:51.3785594 AM","6920","QueryOpen","C:\srmvc\CashForYourBooks\CashForYourBooks\CashForYourBooks.csproj","FAST IO DISALLOWED",""
    "11:03:51.3792759 AM","6920","QueryOpen","C:\BookStore\BookLib\BookLib\BookLib.csproj","FAST IO DISALLOWED",""

    Friday, July 09, 2010 3:17 PM
  • Hi,

    When a user sets User Instance=true in the connection string, a user instance is generated at the first time. Then, the master and msdb system databases are copied from the Template Data folder to a path under the user's local application data repository directory for exclusive use by the user instance. This path is typically C:\Documents and Settings\<UserName>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS. When a user instance starts up, the tempdb, log, and trace files are also written to this directory. A name is generated for the instance, which is guaranteed to be unique for each user.

    In this case, please check the C:\Documents and Settings\<UserName>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS directory. If the folder exists, try to copy it to another folder and then delete it.

    If you have any more questions, please let me know.
    Thanks


    ***Xiao Min Tan***Microsoft Online Community***
    Monday, July 12, 2010 5:59 AM
  • That solved my problem, thanks.

    JJ

    Thursday, January 20, 2011 3:17 PM