Sounds like user healkar is not a dbo either. Dbo is the only user that has permission to execute all sp's by default, there is no built in db_executor like there is for db_datareader,db_datawriter. To accomplish that we usually make a db_executor role and assign it to the user(s). Then we have a script the will find all sp's in the db and grant execute to the db_executor role.
Justin Harrell Vice President Development Aciss Systems Inc. -----Original Message----- From: Karen Healey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 4: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.
