Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making sure integrated security cannot be used
Message
 
To
11/04/2008 12:05:46
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
01309940
Message ID:
01310092
Views:
19
You can limit the BUILTIN\Users login credentials just to those objects you want users logging in with Windows Authentication have access to. You can even disable all access but then it wouldn't make sense using mixed mode authentication.

Enmanuel

>>You should use Windows authentication and configure access to SQL Server through Active Directory, at least that's the recommended way.
>
>So, basically, I shouldn't have to create a user in SQL Server and rely on Windows authentication only. So, basically, the reason it works right now is probably related to the Web site configuration where the user being used would have access to SQL Server. My main concern now would be to associate a server user to the database so only that user can access the database.
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform