May 17, 2009 at 11:37 pm
Hi All!
We are having about 250 computers on LAN running with application.
I want to shift my application database on sql server 2005.
What are best requirements for sql server lan settings and hardware settings for fast access of sql server 2005 ?
May 18, 2009 at 2:19 am
Security best practices for a SQL Server installation
Each of the items that follow will make your system more secure and they are part of the standard security "best practices" for any SQL Server installation :-
•Secure your sa login account with a non-NULL password. There are worms that only work if you have no security for your sa login account. Therefore, to make sure that the built-in sa account has a strong password, you must follow the recommendation provided in the "System Administrator (SA) Login" topic in SQL Server Books Online, even if you never directly use the sa account.
•Block port 1433 at your Internet gateways, and then assign SQL Server to listen on an alternate port.
•If port 1433 must be available on your Internet gateways, enable egress and ingress filtering to prevent misuse of the port.
•Run the SQLServer service and SQL Server Agent under a Microsoft Windows NT account, not a Local System account.
•Enable Microsoft Windows NT Authentication, and then enable auditing for successful and failed logins. Then, stop and restart the MSSQLServer service. Configure your clients to use Windows NT Authentication.
Check out:
http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx
Tanx 😀
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply