aspnet membership with live Id login sdk

by the3factory 5/6/2008 8:27:00 AM

Question:

i am creating my college website for goalivechallenge a Microsoft website compition.

i hav used live id sdk in my site and aslo want to use asp.net membership.

so for that i use code given at

http://www.eggheadcafe.com/tutorials/aspnet/48857836-0c72-4efb-9d29-fbcb8e17ef3a/integrate-windows-live-id.aspx

now when i click on sign in on my homepage it redirects to live login and after login it redirects it to my site webauth-handler.aspx

now following error occurs

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. 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.

SQLExpress database file auto-creation error:

The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:"

as i am using sql server express edition on my localhost but using sqlserver 2005 on my hosting server.

i changed my connection string properly and my other database driven modules are connecting to database and working correctly.

i think profiles in membership is doing problem or ???

how to check it on server as it is working fine on my localhost.

plz check at sirifort.info

plz help i hav to complete it v.fast as 15 may 2008 is the last date of competition.

Thanks

Vinamra Bhatnagar

Sirifort.info

Answer1:

For the SQL Server Express database with user instances, please make sure that the App_Data folder is readable and writeable by the web server, then change the impersonate setting in your web.config. Hope it helps

Answer2:

my server does not support SQL Server Express edition . it supports SQL Server 2005 (not express edition)

now what to do.

Thanks

Vinamra Bhatnagar

Tags: asp.net security