SORTED SORRY - I had to got to my APP_DATA directory and reassign permissions to the ASPNET user. very strange.

This is driving me insane tonight. I have setup a site AGAIN using the starter kit, VWD and SQL 2005 Express. All goes well and the site runs. Then I use SQL Management Studio to ATTACH to the database created and visible in VWD and thats where it all starts going wrong. I run the site again and get:

Error Installing DotNetNuke

Current Assembly Version: 04.00.02

ERROR: Could not connect to database specified in connectionString for SqlDataProviderSystem.Data.SqlClient.SqlException: Cannot open user default database. Login failed. Login failed for user 'XPC\ASPNET'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript

etc...

Please can someone tell me how I get my database back without having to reinstall and why this should happen just while trying to view / backup the database with SQL Management Studio.

Thanks

Mark