Re: App_data - ASPNETDB.MDF

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I would review this:
http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx


If your hosting provider doesn't support Sql Express version, then you'll
need to create a non express database somewhere.

The MembershipProvider is an ABSTRACT implementation, thus there are several
backend database choices.
Express aspnetdb.mdf is the DEFAULT "auto get created" version.

If you already have membership data in place, you can consider this blog
entry for transferring data.
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!160.entry






"Mr. X." <no_spam_please@xxxxxxxxxxxxxxxxx> wrote in message
news:O2sO2VkMJHA.1160@xxxxxxxxxxxxxxxxxxxxxxx
I have visual studio 2008.
My site has a plesk on it.

I want to deploy my project, and save it on the host machine.

Looking for solution for folowings, please :

1st solution
=======
Should ASPNETDB.MDF is necessary,
and can I ignore it (How can I do that) ?

Since the host side trying to make this file automatically.

2nd solution
========

I tried to make the ASPNET.MDF on my machine,
but I got a message :
Cannot make SSPI context.

I persume this is via security, and I should run SSMS.exe
(I have SQL-Server 2005 on my machine).
But where is it ?

3rd solution
========
Can't just finding somewhere a good ASPNETDB.MDF, and is it the only file.
After downloading from
http://www.4shared.com/file/59591680/a5b7abdf/ASPNETDB_TMP.html
(Which is 10M !!! - A problem too).
I got the message :

Failed to generate a user instance of SQL Server due tofailure in
retrieving the user's local application data path. Pleasemake sure the
user has a local user profile on the computer. Theconnection will be
closed.
Description: Anunhandled exception occurred during the execution of the
current webrequest. Please review the stack trace for more information
about theerror and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException:Failed to generate a
user instance of SQL Server due to failure inretrieving the user's local
application data path. Please make sure theuser has a local user profile
on the computer. The connection will beclosed.

Source Error:

An unhandled exception was generated during the execution of
thecurrent web request. Information regarding the origin and location
ofthe exception can be identified using the exception stack trace below.




Thanks :)




.

Relevant Pages

  • RE: Express refuses to install
    ... Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup ... Action "LaunchPatchedBootstrapAction" will be skipped due to the following ... Action "InvokeSqlSetupDllAction" threw an exception during execution. ... Aborting queue processing as nested installer has completed ...
    (microsoft.public.sqlserver.setup)
  • Re: Reliably reproducing Native Exception 0xc0000005 on SQL CE 2.0
    ... SQL CE QP is not going to be able to optimize that stmt. ... >I am reliably reproducing the ExceptionCode 0xc0000005 native exception ... > SQL CE 2.0 database file ...
    (microsoft.public.sqlserver.ce)
  • Re: SQLCommandparameters - viewing prepared statement
    ... corresponding value (we actually often use different levels of logging so at ... throw back Print Statements as well as Sql Error msgs with a Severity level ... If the query threw an exception the evaluated ... the exception that says "incorrect ...
    (microsoft.public.dotnet.framework.adonet)
  • Sql Reporting Serviced - > ASP.NET ACCESS DENIED!
    ... Hi, I have installed Sql Reporting Services on 2 machines, one is WIN 2000 ... Exception Details: System.UnauthorizedAccessException: Access to the path ... granting access rights to the resource to the ASP.NET request identity. ... System.IO.Directory.InternalGetFileDirectoryNames(String fullPath, String ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: DISP_E_TYPEMISMATCH with OWC11
    ... you think its related to what data type OWC is expecting from the SQL ... I have a SQL ... Dim objChartspace, objChart, c, objConn, objRS, axis, sql ... An unhandled exception occurred during the execution of the ...
    (microsoft.public.office.developer.web.components)