|
I installed HELM 4 upgrade to my server and lost ability to attach .mdf file located in the App_Data folder.
I moved to a new server and am having the same issue.
Exception Details: System.Data.SqlClient.SqlException: User does not have permission to perform this action.
I need RameyJane.com DNN install to pass the Database check when using an .mdf file in the App_Data folder.
TerriCavoli.com/Albums.aspx is having the same issue, throwing the exception listed above.
I can attach an .mdf file and create a user. Using an attached db works fine.
The install is sqlExpress.
Some of the things I've looked at:
NT Authority/Network Services can log onto SQL server, read/write in the website folder.
Using the Surface Configuration utility, I've checked for allowing remote and local connections. (It was already set as I understand this to be the default for the Express version)
When I try to run http://terricavoli.com/albums.aspx I find the following in the Application Event Log
Source: ASP.NET 2.0.50727.0
Category: Web Event
Type: Warning
EventID: 1309
User: N/A
Computer: CA207
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 7/3/2009 1:21:33 PM
Event time (UTC): 7/3/2009 6:21:33 PM
Event ID: 326052e98d844710953f9c0393162cc8
Event sequence: 49
Event occurrence: 24
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/96687/Root-4-128910717577472774
Trust level: Full
Application Virtual Path: /
Application Path: E:InetpubTerriCavoli.comwww
Machine name: CA207
Process information:
Process ID: 3676
Process name: w3wp.exe
Account name: NT AUTHORITYNETWORK SERVICE
Exception information:
Exception type: TargetInvocationException
Exception message: Exception has been thrown by the target of an invocation.
Request information:
Request URL: http://TerriCavoli.com/Albums.aspx
Request path: /Albums.aspx
User host address: 78.46.96.245
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITYNETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITYNETWORK SERVICE
Is impersonating: False
Stack trace: at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance)
at System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
at System.Web.UI.WebControls.BaseDataList.GetData()
at System.Web.UI.WebControls.DataList.CreateControlHierarchy(Boolean useDataSource)
at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e)
at System.Web.UI.WebControls.BaseDataList.DataBind()
at System.Web.UI.WebControls.BaseDataList.EnsureDataBound()
at System.Web.UI.WebControls.BaseDataList.CreateChildControls()
at System.Web.UI.Control.EnsureChildControls()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
|