Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making sure a database requires a username
Message
 
To
07/03/2008 11:09:20
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
01299694
Message ID:
01299735
Views:
8
>>Just setup the SQL Server to use SQL Server Authentication.
>>That way Windows Authentication will be ignored and you have to use UserName and Password to connect.
>
>Ok, so that would be at the server level and not at the database level, right? And, then, I would have to disabled the guest account, is that correct?

You could have a user that can operate only on one database. Just right click on Database and select properties. Then select permissions.
There you could set which user can use that Database.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform