user don't have permission to do operation in ASP.NET

Control Panel Forum Hosting Help ASP.NET 4 & SQL 2008 Hosting Resources Notice

Total members: 149203
Average new registrations per day (in last 7 days): 122

New Registration: Open

Register Now

Learn Windows 7: How to make your own Server to host your websites Here you can learn about to create your own web server and host your website to that web server using NetServer Package.

Want to become a DBA ? SQL Server 2008 training courses - by AspSpider team

Home » Questions & Answers » user don't have permission to do operation

user don't have permission to do operation

3/8/2010

Author: gagan deep sharma
IGNOU
http://aspspider.info/gagsha

Gagan is Student

I m uploading my website on asp.net 3.5
i put my Db in the App_Data directory now
as i m tring to login it is giving error

that user don't have permission to perform
this operation.

please help to solve this problem.

thanks in advance

Answers .............

Author: Ahmed Talu

Posted Date: 3/8/2010

*************************************************

gagan deep sharma

At ASPSPIDER you have to upload SQL databases to the DATABASE folder, not App_Data used at local computer during development and testing.

If the name of your database is xxxx.mdf then your connection string at ASPSPIDER will be:
"Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=gagsha_xxxx"

DETACH database before uploading.
ATTACH database after uploading.
Do not upload *.LDF file for the database. If there is a *.LDF file from an earlier version of a SQL database at the server then remove it (a new *.LDF file will automatically be made).
You are not allowed to use USER INSTANCE of SQL Server.
Do not include file extension (.mdf) in connection string for SQL databases. MS ACCESS databases needs file extension (.mdb) in the connection string though.

Do not disable impersonation in web.config when using a SQL database. Otherwise *.aspx files etc. will not be able to connect to the database in response to request through the Internet.

*************************************************

Some info from ASPSPIDER:
http://www.aspspider.com/tips/Tip18.aspx Connection strings
http://www.aspspider.com/tips/Tip16.aspx How to use SQL
http://www.aspspider.com/tips/Tip15.aspx How to use MS ACCESS

*************************************************

You must login to post answer for this question.