question about login at database level

Hi,

i created at general database level a login 'Network service' (windows
server 2003).
At level of 'mydb' database, i created an user 'aspnet' and i associated it
to the login 'Network service'. That user 'aspnet' receives the necessary
schemas (db_read /db_write) rrquired by the application.

Now, i removed the login 'Network Service' at general database level (not
the user 'aspnet') but the application still runs properly.

My question is: is it allowed to remove a defined login at general database
level (in my case the login 'Network Service')?

Thanks
Jean

You delete the login without affecting the database user.
But at the end you will have a login mapped to a database user

So, yes it is allowed to remove the login.

Good luck.

|||

Thanks

|||

Sorry, i was too fast in my answer.

I did the same on a XP prof. box (removing the login at server level, after defining an user associated to that login at database level).

But now, i get the error :" login failed for user servename\aspnet"

If i recreate that login, it works again.

So it seems that the login cannot be removed at server level?

|||

tartuffe2:

Sorry, i was too fast in my answer.

I did the same on a XP prof. box (removing the login at server level, after defining an user associated to that login at database level).

But now, i get the error :" login failed for user servename\aspnet"

If i recreate that login, it works again.

So it seems that the login cannot be removed at server level?

I guess this is because theservername\aspnet account is not "trusted" by your SQL Server. TSo, the NT account must be granted permission to use your SQL Server database.

You can implement impersonation, and grant that account the needed access.

Check out this link:http://support.microsoft.com/?id=316989

|||

ok, thanks

sql