Correct, you need to grant execute permissions to the users. Use this from within Query Analyzer:
grant execute on <stored proc name> to public go Seang -----Original Message----- From: Karen Healey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 1:55 PM To: [EMAIL PROTECTED] Subject: Re: [DOTNET] SQL Server and ASPNET user That almost did it. Now I cannot run any of my stored procedures unless I go into the user permissions and turn on execute for every one of them. Is this really necessary? Is there a quicker way to get them turned on? Thanks, Karen Healey [EMAIL PROTECTED] (508) 473-1218 ----- Original Message ----- From: "Sean Greer (SBI-Chico)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 18, 2002 16:30 Subject: Re: [DOTNET] SQL Server and ASPNET user > Have you enabled mixed mode authentication on for SQL Server? Right-click > on the server node in the tree, choose properties, then the security tab. > Change from Windows Authentication to Mixed Mode Authentication (sorry if > the verbage is off, don't have SQL Server on this machine). > > Seang > > -----Original Message----- > From: Karen Healey [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 18, 2002 1:25 PM > To: [EMAIL PROTECTED] > Subject: [DOTNET] SQL Server and ASPNET user > > > Hi, > > I'm having some problems with users/connection strings for a SQL Server > database though. Right now, I use SQL Enterprise Manager and add the > ASPNET user with dbo permission and use a trusted connection and I'm able > to access the database. The connection string looks like the following: > > <add key="ConnectionString" > value="server=localhost;Trusted_Connection=true;database=TASCBenef" /> > > But the ASPNET user should not have dbo permission (I understand this is a > bad thing). But if I get rid of the ASPNET user on my database and create > another user and give it dbo permission on my database and use a uid and > pwd in my connection string, it doesn't work. Here is the connection > string: > > <add key="ConnectionString" > value="server=localhost;uid=healkar;pwd=password;database=TASCBenef" /> > The error I'm getting is > > [SqlException: Login failed for user 'healkar'. Reason: Not associated > with a trusted SQL Server connection.] > > > I tried adding Trusted_Connection=true back to the string but then it > tries to use the ASPNET user again?! > > [SqlException: Cannot open database requested in login 'PortalGS'. Login > fails. > Login failed for user 'HEALEY2002\ASPNET'.] > > > If you can help, please reply. My hosting site requires that I NOT use > the ASPNET user for my database access. > > Karen Healey > [EMAIL PROTECTED] > (508) 473-1218 > > You can read messages from the DOTNET archive, unsubscribe from DOTNET, or > subscribe to other DevelopMentor lists at http://discuss.develop.com. > > You can read messages from the DOTNET archive, unsubscribe from DOTNET, or > subscribe to other DevelopMentor lists at http://discuss.develop.com. > You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
