Re: SQL Server and ASPNET user

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.