Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Problem After Attaching/Detaching Database.mdfProblem After Attaching/Detaching Database.mdf
Previous
 
Next
New Post
12/21/2006 6:42 AM
 
Thomas Lanier

Joined: 4/26/2004
Posts: 4
I'm a new user of DotNetNuke trying to learn the basics.

I successfully installed the product on my local machine.

In exploring the features of the product, I decided to take a look at the database tables to understand everything a little better.

When I tried to attach to the Database.mdf file with SQL Server Management Studio Express, I got an open error because ASP.Net had the file opened.

I resolved the problem by doing the following:

"You can close any connections held by an ASP.NET application by ending the application. This can be done by by placing a file named App_offline.htm in the root directory of the ASP.NET application."

http://msdn2.microsoft.com/en-us/library/ms228037.aspx

I then used SQL Server Management Studio Express to attach to the Database.mdf file and explore the table structures. Nothing was modified.

I then detached the Database.mdf file and closed the management program.

I then tried to reopen my site, http://localhost/DotNetNuke, but an error message was generated.

DotNetNuke Upgrade Error --> ERROR: Could not connect to database

I've tried rebooting the computer and clearing the browser cache with no luck.

The application event log says that

Event code: 3005

Event message: An unhandled exception has occurred.

Event time: 12/21/2006 5:38:57 AM

Event time (UTC): 12/21/2006 10:38:57 AM

Event ID: 30e3ae3c3d8246c48d47008349ba7ea8

Event sequence: 4

Event occurrence: 2

Event detail code: 0

 Application information:

Application domain: /LM/W3SVC/1/Root/DotNetNuke-1-128111705392187500

Trust level: Full

Application Virtual Path: /DotNetNuke

Application Path: C:\DotNetNuke\Website\

Machine name: THL-HOME

 Process information:

Process ID: 2808

Process name: aspnet_wp.exe

Account name: THL-HOME\ASPNET

 Exception information:

Exception type: SqlException

Exception message: Cannot open user default database. Login failed.

Login failed for user 'THL-HOME\ASPNET'.

 Request information:

Request URL: http://localhost/DotNetNuke/Default.aspx?TabId=53&EntryID=1

Request path: /DotNetNuke/Default.aspx

User host address: 127.0.0.1

User:

Is authenticated: False

Authentication Type:

Thread account name: THL-HOME\ASPNET

 Thread information:

Thread ID: 1

Thread account name: THL-HOME\ASPNET

Is impersonating: False

Stack trace: 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.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues)

at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter)

at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter)

at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName)

at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)

at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.GetLogTypeConfigInfo()

at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfo()

at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfoByKey(String LogTypeKey, String LogTypePortalID)

at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.AddLog(LogInfo objLogInfo)

at DotNetNuke.Services.Log.EventLog.LogController.AddLog(LogInfo objLogInfo)

 Custom event details:

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

In trying to research the problem I came across this Microsoft bug report. It doesn't exactly match my circumstances; however, the basic problem is the same.

After you detach a Microsoft SQL Server 2005 database that resides on network-attached storage, you cannot reattach the SQL Server database

http://support.microsoft.com/kb/922804

This problem occurs because SQL Server 2005 resets the file permissions when the database is detached. When you try to reattach the database, it cannot be attached because of limited share permissions.

The article doesn't say how to correct the problem.

Anyone have any ideas what I did wrong and how I can fix it without reinstalling and starting over?

Thanks
 
New Post
12/21/2006 12:52 PM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212
please have a look at this post.
Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Problem After Attaching/Detaching Database.mdfProblem After Attaching/Detaching Database.mdf


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out