Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Connection string fails - permission denied

Thread Tools

Connection string fails - permission denied

Posts: n/a
The following error appears when I try to "view in browser" (in Visual Web
Developer) a data-driven Web page:

SELECT permission denied on object 'Stocks', database 'EzMarket', schema

I use Windows authentication and the Web.config file has the following
connection string:

<add name="EzMarketConnectionString" connectionString="Data
Source=3Z4L0YQHJ3LWW5M\SQLEXPRESS;Initial Catalog=EzMarket;Integrated
providerName="System.Data.SqlClient" />

I also tried to create a new user with full permissions on database
(EzMarket) and table (Stocks), with no result.

I'm very confused of that. I'd be very grateful for any help.

Many thanks
Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fixed: The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID {555F3418-D99E-4E51-800A-6E89CFD8B1D7} to the user NT AUTHORITY\LOCAL SERVICE SID (S-1-5-19). Skybuck Flying Windows 64bit 1 06-29-2009 06:17 PM
boost::asio (Permission denied, Connection refused) C++ 1 04-20-2008 02:52 AM
copy stdout fails with permission denied when stdout is redirected Perl Misc 2 12-07-2005 10:49 PM
Re: command string good in subprocess.Popen(string) fails inprocess.Process(string) Trent Mick Python 0 05-16-2005 04:51 PM
command string good in subprocess.Popen(string) fails inprocess.Process(string) Earl Eiland Python 3 05-16-2005 04:48 PM