Database Knowledge Base
Search:     Advanced search
Browse by category:
Glossary | Contact Us
Database Knowledge Base / MS SQL Server / What are the various security modes for SQL Server and how do they work?

What are the various security modes for SQL Server and how do they work?
Print
Email to friend
Add comment
Views: 741
Votes: 1
Comments: 45

Since SQL Server 7 - Microsoft has only supported two modes:

  • Windows Only - Only Windows accounts can access the server via an integreated login process.
  • Windows and SQL Server - Both Windows accounts and accounts created within SQL Server can connect to the server.

Windows Only is recommended but not always practical depending on your infrastructure.  In addition, SQL Server 2005 has taken great strides to increase the security of standard SQL Server logins by adding password complexity, timeouts, and other features previously absent.

Logging-in is only the first step. Once a user logs in, he or she must access the individual databases. For this, an entry must exist in the sysusers table for each database for that user. Keep a close eye on that “guest” account in your databases and make sure you don’t inadvertently give someone access to a database .

Showing: 1-20 of 45    »»
Comments

31 Dec, 1969   |   Guest
sql server 2008 r2
31 Dec, 1969   |   Guest
database
31 Dec, 1969   |   Guest
dbms advantages
31 Dec, 1969   |   Guest
sql stored procedure
31 Dec, 1969   |   Guest
database designer
31 Dec, 1969   |   Guest
sql tutorial
31 Dec, 1969   |   Guest
sql server insert into
31 Dec, 1969   |   Guest
sql contains
31 Dec, 1969   |   Guest
sql server 2008 r2 editions
31 Dec, 1969   |   Guest
sql server support
31 Dec, 1969   |   Guest
web hosting sql server
31 Dec, 1969   |   Guest
database designer
31 Dec, 1969   |   Guest
sql server magazine
31 Dec, 1969   |   Guest
microsoft sql server 2008 r2
31 Dec, 1969   |   Guest
photo database software
31 Dec, 1969   |   Guest
dc database
31 Dec, 1969   |   Guest
what is dbms
31 Dec, 1969   |   Guest
sql server replication
31 Dec, 1969   |   Guest
download microsoft sql server
31 Dec, 1969   |   Guest
sql basics
Showing: 1-20 of 45    »»


Add comment

Others in this Category
document How to change the owner of all tables in a database?
document how to build connection string for MS SQL Server?
document How we can back up all databases in SQL Server
document If the TempDB Database is deleted from MS-SQL Server what will happen..?
document How to insert a not null column in an existing table with records..?
document If a table is deleted, what will happen for the Stored procedures and Views, which that table reffered..?
document Is there an easy way to loop through every stored procedure in a database and create a file containing all of the SP code?
document What is denormalization and when would you go for it?
document How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
document What's the difference between a primary key and a unique key?
document What are user defined datatypes and when you should go for them?
document What is bit datatype and what's the information that can be stored inside a bit column?
document How we can determine which version of SQL Server 2005 is running?
document How to determine which version of SQL Server 2000 is running
document What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
document Can you have a nested transaction?
document What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
document You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
document Is length of sql query limited in MS_SQL Server ?
document Where we can find Free MS SQL Server System Table chart or map ?
document I'm using SQL Server 2005. Do I need to get Enterprise Manager to administer the app through a hosted server? What do I need if not EM?
document How do I restict clients by IP Address?
document How do I perform encryption with SQL Server?
document What is SQLPing and how does it work?
document How can I hide my SQL Server 2000 installations from SQLPing?
document How can I keep the 'sa' account from reading my confidential data?
document Why is SQL Server security important?
document What different network protocol libraries should I use?
document What different network protocol libraries should I use?
document What are some things I can do to secure my SQL Server?
document What could happen if the 'sa' account is compromised?
document Does MySQL 5.0 provide any new features/capabilities for MySQL Cluster?
document Can you use MySQL GUI Tools to build Stored Procedures and Views?
document How does PostgreSQL compare to other DBMSs?
document How we can perform MINUS (Oracle) Or EXCEPT (Maxdb) in MS Access?
document What is normalization?
document What is a Stored Procedure?
document Can you give an example of Stored Procedure?
document What is a trigger?
document What is a view?
document What is an Index?
document What are the types of indexes available with SQL Server?
document What is the basic difference between clustered and a non-clustered index?
document What are cursors?
document When do we use the UPDATE_STATISTICS command?
document Which TCP/IP port does SQL Server run on?
document From where can you change the default port?
document Can you tell me the difference between DELETE & TRUNCATE commands?
document Can we use Truncate command on a table which is referenced by FOREIGN KEY?
document What is the use of DBCC commands?
document Can you give me some DBCC command options?
document What command do we use to rename a db?
document Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
document What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
document What do you mean by COLLATION?
document What is a Join in SQL Server?
document Can you explain the types of Joins that we can have with Sql Server?
document When do you use SQL Profiler?
document What is a Linked Server?
document Can you link only other SQL Servers or any database servers such as Oracle?
document Which stored procedure will you be running to add a linked server?
document What are the OS services that the SQL Server installation adds?
document Can you explain the role of each service?
document How do you troubleshoot SQL Server if its running very slow?
document Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
document What are the authentication modes in SQL Server? -
document Where do you think the users names and passwords will be stored in sql server?
document What is log shipping? Can we do logshipping with SQL Server 7.0
document Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?
document Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
document What is BCP? When do we use it?
document What should we do to copy the tables, schema and views from one SQL Server to another?
document What are the different types of joins and what does each do?
document What is a sub-query? When would you use one?
document Hacking SQL Server!!!
document When do you use SQL Profiler?
document What is a Linked Server?
document Can you link only other SQL Servers or any database servers such as Oracle?
document Which stored procedure will you be running to add a linked server?
document What are the OS services that the SQL Server installation adds?
document Can you explain the role of each service?
document How do you troubleshoot SQL Server if its running very slow?
document What are the authentication modes in SQL Server?
document Where do you think the users names and passwords will be stored in sql server?
document What is log shipping?
document What is BCP?
document What is Data Mapping
document What is an Ad Hoc Query?
document How to identify your SQL Server version and edition?
document what is the method to change location of tempdb?
document How to know which index a table is using?
document What is Data page?
document Define Disaster recovery planning.
document define term Minimally logged operations (bulk load operations)
document What is Filegroup?
document What is Log sequence number (LSN)?
document what is an Extent?
document how we can change ownership in SQL Server?
document Oracle Database 11g Administrator
document Which transport protocol cannot be used for database mirroring?
document which function displas the state of information of the transaction in the session?
document which pages in the SQL Server Management Studio allow you to configure different properties of backup?
document Which function displays the state of information of the transaction in the session?
document Which argument should be specified in the bcp command to perform an export?
document Which server role allows you to execute requests on an endpoint in the database?
document Which clause specifies the assembly name and class name while creating a user-defined type by using the CREATE TYPE statement.
document on which two editions of Windows 2003 can you install the SQL Server 2005 Enterprise edition?
document Which stored procedure is used to change the password for the distributor?
document A partititon scheme can be based on how many partition functions?
document Which statement can be used to import data from a data file into a temporary table?
document What should be the value in the STATUS clause in the CREATE QUEUE statement if you want that the queue should receive messages?
document You are assigned the role of a Certification authority (CA) in your company. As a CA, you are required to create certificates as and when requested by users in your company. On Adam's request, you issue the following Transact-SQL Statement to create a certificate (line numbers are for referene only.):
document Where we can find Maximum Capacity Specifications for SQL Server 2008?
document what is ONLINE INDEX?
document Which is the best free tool to read large sql files
document Australian Post Code Database with Coordinates
document Introduction to SQL - SQL LESSON 1
document SQL Server Backup Compression and Security


RSS
Powered by KBPublisher (Knowledge base software)