What are the steps you will take, if you are tasked with securing an SQL Server?
This is an open ended question. Here are some things you could talk about: Preferring NT authentication, using server, database and application roles to control access to the data, securing the physical database files using NTFS permissions, using an unguessable SA password, restricting physical access to the SQL Server, renaming the Administrator account on the SQL Server computer, disabling the Guest account, enabling auditing, using multiprotocol encryption, setting up SSL, setting up firewalls, isolating SQL Server from the web server etc.
Read the white paper on SQL Server security from Microsoft website.I will post more about SQL Server security best practices.
Good Luck!!
Girma
http://www.Datagroupusa.com/live
This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test ..... This is test .....
Note for backup ......Note for backup ......Note for backup ......Note for backup ......Note for backup ......Note for backup ......Note for backup ......Note for backup ......Note for backup ......Note for backup ......Note for backup ......Note for backup ......Note for backup ......Note for backup ......Note for backup ......
SQL Server supports different types of Replication. All types of replication technologies are not available in all version of SQL Server. Some of the SQL Server Replications are version specific.
More ..................
SQL Server supports different types of Replication. All types of replication technologies are not available in all version of SQL Server. Some of the SQL Server Replications are version specific.
More ..................
This is for using windows account for sql server database login .........
This is for using windows account for sql server database login .........
This is for using windows account for sql server database login .........