Hi I am planning to implement website administration through user management. I followed this tutorial...
http://livedemos.peterkellner.net/Default.aspx Great everything works fine...on local machine
But when i moved my application to production server, i get real trouble...
ASPNET user permission error: I am getting this kind of error Here is my question can anybody clarify
Q1). in this tutorial http://livedemos.peterkellner.net/Default.aspx ASPNET.MDF has been placed in App_Data folder. I just ported the folder as it is to the server. Do I really need create a sql Database instead of MDF which is inside App_Data on the SQL
server??
Q2). How do I and where do place connection string? what is the relation between machin.config and web.config?
Even though my application runs with MSACCESS for user management I did not see any interface which works with MSaccess? Do I get any interface for user membership management which works with MSACCESS not SqlServer
hi, right click your App_Data folder, choose "Properties" and add "ASPNET" user to permission under "Security" tab. That should able to solve your permission exception.If it doesn't, then repeat the same steps for your mdf file inside App_Data folder.
Q1 - you need to install SQL Server 2005 Express edition in order to connect this kind of file. You don't need to attach it to the sql server, sql server express will handle the request in between asp.net application and sql server.
Q2 - you need to place connection string in web.config. Web.config only apply to your website/web application while machine.config apply its setting to your whole machine (pc).
Likewise, the common issue that I encounter whenever people upload the database to the server is they fail to correct the attribute "User Instance" in the connection string from "true" to "false" (ergo, it should be User Instance=false)
Even though my application runs with MSACCESS for user management I did not see any interface which works with MSaccess? Do I get any interface for user membership management which works with MSACCESS not SqlServer
Q1). in this tutorial http://livedemos.peterkellner.net/Default.aspx ASPNET.MDF has been placed in App_Data folder. I just ported the folder as it is to the server. Do I really need create a sql Database instead of MDF which is inside App_Data on the SQL server??
Both of the 2 ways are allowed.
venkatad
Q2). How do I and where do place connection string? what is the relation between machin.config and web.config?
Settings in machine.config file will affect all web sites in IIS, while settings in web.config will take responsibility of certain one web site (or sub web site or even some folders).
Regards
Andrew Zhu
Microsoft online ASP.NET support
Please remember to click “Mark as Answer” on the post that helps you. This can be beneficial to other community members reading the thread.
venkatad
Member
4 Points
80 Posts
asp.net membership provider
Apr 22, 2009 07:41 PM|LINK
Hi I am planning to implement website administration through user management. I followed this tutorial...
http://livedemos.peterkellner.net/Default.aspx Great everything works fine...on local machine
But when i moved my application to production server, i get real trouble...
ASPNET user permission error: I am getting this kind of error Here is my question can anybody clarify
Q1). in this tutorial http://livedemos.peterkellner.net/Default.aspx ASPNET.MDF has been placed in App_Data folder. I just ported the folder as it is to the server. Do I really need create a sql Database instead of MDF which is inside App_Data on the SQL server??
Q2). How do I and where do place connection string? what is the relation between machin.config and web.config?
Even though my application runs with MSACCESS for user management I did not see any interface which works with MSaccess? Do I get any interface for user membership management which works with MSACCESS not SqlServer
fatewong
Member
718 Points
121 Posts
Re: asp.net membership provider
Apr 23, 2009 03:29 AM|LINK
hi, right click your App_Data folder, choose "Properties" and add "ASPNET" user to permission under "Security" tab. That should able to solve your permission exception.If it doesn't, then repeat the same steps for your mdf file inside App_Data folder.
Q1 - you need to install SQL Server 2005 Express edition in order to connect this kind of file. You don't need to attach it to the sql server, sql server express will handle the request in between asp.net application and sql server.
Q2 - you need to place connection string in web.config. Web.config only apply to your website/web application while machine.config apply its setting to your whole machine (pc).
jpcoliveros
Contributor
2916 Points
419 Posts
MVP
Re: asp.net membership provider
Apr 23, 2009 11:34 PM|LINK
Likewise, the common issue that I encounter whenever people upload the database to the server is they fail to correct the attribute "User Instance" in the connection string from "true" to "false" (ergo, it should be User Instance=false)
superpatrick.wordpress.com
hans_v
All-Star
35998 Points
6551 Posts
Re: asp.net membership provider
Apr 24, 2009 01:46 AM|LINK
Take a look at:
Using the Microsoft Access Providers to Replace the Built-In SQL Server Providers
venkatad
Member
4 Points
80 Posts
Re: asp.net membership provider
Apr 27, 2009 04:36 AM|LINK
guys Thanks for the suggestions....! I made it work this way.
Installed sql exprss on windows server 2000.
Changed machine.config to (local) in place of .\sqlexpress
gave the aspnet account full rights on app_data directory of the application.
restarted IIS....Volaa.....worked
Andrew Zhu -...
Contributor
7443 Points
713 Posts
Re: asp.net membership provider
Apr 27, 2009 06:00 AM|LINK
Hi,venkatad
Check this link:
Core Differences Between IIS and the ASP.NET Development Server
Both of the 2 ways are allowed.
Settings in machine.config file will affect all web sites in IIS, while settings in web.config will take responsibility of certain one web site (or sub web site or even some folders).
Regards
Microsoft online ASP.NET support
Please remember to click “Mark as Answer” on the post that helps you. This can be beneficial to other community members reading the thread.