Articles   Members Online:
-Article/Tip Search
-News Group Search over 21 Million news group articles.
-Delphi/Pascal
-CBuilder/C++
-C#Builder/C#
-JBuilder/Java
-Kylix
Member Area
-Home
-Account Center
-Top 10 NEW!!
-Submit Article/Tip
-Forums Upgraded!!
-My Articles
-Edit Information
-Login/Logout
-Become a Member
-Why sign up!
-Newsletter
-Chat Online!
-Indexes NEW!!
Employment
-Build your resume
-Find a job
-Post a job
-Resume Search
Contacts
-Contacts
-Feedbacks
-Link to us
-Privacy/Disclaimer
Embarcadero
Visit Embarcadero
Embarcadero Community
JEDI
Links
How to set SQL Server Security Setting Turn on/off line numbers in source code. Switch to Orginial background IDE or DSP color Comment or reply to this aritlce/tip for discussion. Bookmark this article to my favorite article(s). Print this article
SQL Server Security Setting 12-Jun-03
Category
Security
Language
Delphi 4.x
Views
92
User Rating
No Votes
# Votes
0
Replies
0
Publisher:
DSP, Administrator
Reference URL:
DKB
			Author: Majid Vafaei Jahan 

How I can Set SQL Server Security in SQL Server Authentication without windows 
Authentication.

Answer:

You must install new sql server and set authentication in mix mode or SQL Server 
and Windows authentication. 

In Sql Manager, Add New Group and add New SQL Server and set connection type to SQL 
Server Authentication with checking check box (Always Prompt). 

In Security/Login Section you should set BUILTIN/Adminstrator to Access Deny. 

Every Users with windows authentication should had appropriate access with Deny 
Access. 

Every Users with Funcional access such as creating, droping,... tables should had 
SQL Server Authentication with appropriate Password. 

Sa should SQL Authentication wih appropriate password.

			
Vote: How useful do you find this Article/Tip?
Bad Excellent
1 2 3 4 5 6 7 8 9 10

 

Advertisement
Share this page
Advertisement
Download from Google

Copyright © Mendozi Enterprises LLC