Tip & How-To about Computers & Internet

Tricks for Keeping SQL Server Safely

Some simple ways to protect your SQL Server database

1. Using the Microsoft Baseline Security Analyzer (MBSA) to assess the server's security
MBSA is one of a variety of Microsoft products, which can scan unsafe configuration tools. It can be run locally; you can also run through the network.

2. Isolate your server and regularly back up
Physical and logical isolation would form the basis of SQL Server security. Database should be installed within the enterprise network security area, but not directly connected to the Internet. Back up all data regularly and store copies in a safe location outside the site.

3. Assign a strong SA password for a SA account
SA account should always have a strong password, even if Windows is configured to require authentication of the server. This will ensure that the server has been reconfigured in the future as Mixed Mode authentication; it will not appear blank or weak SA.

4. Restrict the permissions SQL Server service
SQL Server 2000 and SQL Server Agent is running as a Windows service. Each service must be associated with a Windows account, and derive from this account security context. SA log in SQL Server allows the user (sometimes including other users) to access the operating system features.

About reset SA password in SQL 2008/2005/2000

To secure our database we would like to choose create an intricate password. But even our selves would forget the SA password in SQL Server 2005/2008 sometimes. So here is a way for you to reset SQL Server 2005 password -- MS SQL Server Password Unlocker, which is a highly A Highly Technical and Safe SQL password 2005 Recovery tool. And following is a few features of the tool.

Features:

* Support SQL Server password recovery for MS SQL Server and MS SQL Server Express 2008/2005/2000

* No need to install MS SQL Server on your PC or lose data, the file master.mdf format is necessary

* Stop and resume MS SQL service automatically if the MS SQL Server on your PC is running

* Reset SQL password with ease no matter how long and complicated the SQL password is

* Easy to use

Feedback:

The most of people who encountered with SQL 2005 password losing problems are getting back to their SQL account now. We can also feel that ease and the hilarious mood when a hard nut has been cracked. Hope this MS SQL Server Password Unlocker would help more people and get their trouble erased.

Posted by on

Computers & Internet Logo

Related Topics:

Related Questions:

2 Answers

SQL 2008 R2 - MASTER.LDF corrupted without backup


Try this one solution...

1. First Shutdown SQL Server
2. Then move the current database file/rename (do not touch the .ldf)
3. After rename/move db, restart SQL Server
4. Create a new database with same name and log file and location also same
5. Stop SQL Server

Make use of some interesting links which might help you....
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1465-table-in-sql-server-2008-is-corrupted - a lot of guides and tips for corrupted sql server databases
https://repairsql.recoverytoolbox.com/ Recovery Toolbox for SQL Server - free demo version of this tool, if any variant doesn't seem effective

Apr 26, 2015 | Microsoft SQL Server 2008 Enterprise Full...

1 Answer

SQL server won't work on my laptop


Two ways to access your server. First, make sure the SQL Server Service is running. Start | Run | Services.msc | Enter. Look for Microsoft SQL Server Service and that it's running. Or Look for the SQL Service Broker icon by the clock and see that it's running. The default instance of SQL Server uses the Hostname. Start | Run | Cmd | Enter. The type hostname. This will be the name to access to server. Then type IPCONFIG, this is then the IP address that you could also use to access it.

SQL Server runs on port 1433, so any firewall has to have it open.

Open Query Analyzer, type in the hostname or ip of the local box, type in "sa" and the password for sa (if setup in mixed mode) or Windows Authentication.

Once you login in, you should now see the databases in the Tree on the left side under the Server | Databases node.

Your description though states "SQL Server won't work on my laptop". TO answer this, the only two SQL Editions that work on anything other than "SERVER" software is SQL Professional and SQL Developer. All others have to be on a "SERVER" platform.

Aug 30, 2007 | Microsoft SQL Server 2000 Standard Edition...

Not finding what you are looking for?

179 people viewed this tip

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Loading...