I followed pg 662 to use WroxUnited with XP IIS installed. I created the Virtual Directory and Alias to the WroxUnited directory. Then I browse the "WroxUnited" and receive the below error. I also added to this directory the Write permission and get same error.

Please advise on my error. Thanks!

------------------------------------------------
Server Error in '/WroxUnited' Application.
Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed.

This is an MS problem. I've done some googling for you and it looks like this solution is needed to sort the error:

1) Reboot windows.

2) Log in as Administrator (if you aren't running with Admin privileges)

3) Delete the C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS directory.

You might need to logout and log back in as a "normal" user if you normally run with non-admin privileges.

Chris

Chris Ullman
Programmer/Technical Author
http://www.cuasp.co.uk

Renamed directory. Created new empty directory. Rebooted. New error.
----------------------------------------------
Server Error in '/WroxUnited' Application.
--------------------------------------------------------------------------------

Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed.

Source Error:


Line 112: Public Overridable Property Theme() As String
Line 113: Get
Line 114: Return CType(Me.GetPropertyValue("Theme"),String)
Line 115: End Get
Line 116: Set


Source File: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\wroxunited\4d46c25b\c57181c9\App_Code.zijzit ai.6.vb Line: 114

Stack Trace:


[SqlException (0x80131904): Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed.]
   System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +735075
   System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
   System.Data.SqlClient.SqlInternalConnectionTds.Com pleteLogin(Boolean enlistOK) +33
   System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
   System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
   System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
   System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
   System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject) +424
   System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) +496
   System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   System.Web.DataAccess.SqlConnectionHolder.Open(Htt pContext context, Boolean revertImpersonate) +84
   System.Web.DataAccess.SqlConnectionHelper.GetConne ction(String connectionString, Boolean revertImpersonation) +197
   System.Web.Profile.SqlProfileProvider.GetPropertyV aluesFromDatabase(String userName, SettingsPropertyValueCollection svc) +766
   System.Web.Profile.SqlProfileProvider.GetPropertyV alues(SettingsContext sc, SettingsPropertyCollection properties) +428
   System.Configuration.SettingsBase.GetPropertiesFro mProvider(SettingsProvider provider) +410
   System.Configuration.SettingsBase.GetPropertyValue ByName(String propertyName) +117
   System.Configuration.SettingsBase.get_Item(String propertyName) +89
   System.Web.Profile.ProfileBase.GetInternal(String propertyName) +36
   System.Web.Profile.ProfileBase.get_Item(String propertyName) +68
   System.Web.Profile.ProfileBase.GetPropertyValue(St ring propertyName) +4
   ProfileCommon.get_Theme() in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\wroxunited\4d46c25b\c57181c9\App_Code.zijzit ai.6.vb:114
   Wrox.Web.GlobalEvents.ThemeModule.app_PreRequestHa ndlerExecute(Object Sender, EventArgs E) in C:\WebSites\WroxUnited\App_Code\ThemeModule.vb:30
   System.Web.SyncEventExecutionStep.System.Web.HttpA pplication.IExecutionStep.Execute() +92
   System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean& completedSynchronously) +64

Hi,
   This is fundamentally still the same error, despite the slightly different message. This is a problem with SQL Express setup. More googling reveals another solution - try this:

1) Go to the SQL Configuration Manager
2) Select SQL Express and right click and select properties
3) From the Logon tab, change the account from "Network Service" to "Local System"
4) Try to run it again.

There seems to be a problem with remote logging on as detailed here:
http://blogs.msdn.com/kaelr/archive/...28/486432.aspx

Chris

Chris Ullman
Programmer/Technical Author
http://www.cuasp.co.uk

SQL Express was installed with account set to "Local System".

Will keep searching...

Okay, I reinstalled IIS; created Virtual Directory and now receive error message:

"You are not authorized to view this page" I thought that HTTP Headers didn't have ASP.NET. It does. "X-Powered-By: ASP.NET" is there.

What else can I do to solve this?

Again Thanks!

I think you do not have default.aspx listed in the header.

The IIS WroxUnited Virtual Directory properties has listed Default.aspx listed in #2 position.

I've now found this thread on MSDN which suggests MS will have to fix it in a service pack!!!

http://forums.microsoft.com/MSDN/Sho...36710&SiteID=1

You will need an MSDN persona to see it I think.

Chris

Chris Ullman
Programmer/Technical Author
http://www.cuasp.co.uk