I have written an Intranet page to front end my companies applications
security. This, via triggers, adds users into SQL Server using sp_addlogin
and sp_adduser commands.
Unfortunately (?) we are using NT Integrated Security and the user who has
been granted access cannot connect to SQL Server (Unauthorised access error)
until they are placed into an NT Group which has in turn been added into SQL
Security Manager.
Can anyone tell me what SQL Security Manager does or how it works?
--
Remove NOSPAM from Email address before Replying