Category: SQL Server

How to Enable Remote Connections in SQL Server 2005

First time when I tried to make remote connection, I got this error message.

“An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection …?”

By default, SQL Server 2005 doesn’t allow remote connection so you have to enable it manually. If you try to connect to remote SQL Server without enable remote connection first. This is a security precautions that prevents other computers from connection to this instance of SQL Server before it has been properly secured. If you have seccessfully installed SQL Server 2005 and you want to allow other computers to be able to access your instance of database then you have to be enable remote connection in your system.

Here we go step by step, how to do enable remote connection.

  1. Use Surface Area Configuration Tool to enable remote connetion. See in snapshot how?

    What is Surface Area Configuration Tool?

    Microsoft SQL Server 2005 selectively installs and starts key services and features. This helps reduce the attackable surface area of a system. In the default configuration of new installations, many features are not enabled. A system administrator can change these defaults at installation time and also selectively enable or disable features of a running instance of SQL Server 2005.

    image11

  2. Now click on the Surface Area Configuration for Services and Connections.

    pic2

  3. Now click on SQLEXPRESS/Database Engine/RemoteConnections/ or MSSQLSERVER.
  4. Now enable Local and remote connections.
    pic3

Hope it will help.

How to Start and Stop Database Engine in SQL 2005

A service is a type of application (executable) that runs in the system background. Services usually provide core operating system features, such as Web serving, event logging, or file serving. Services can run without showing a user interface on the computer desktop. The SQL Server Database Engine, SQL Server Agent, and several other SQL Server components run as services. These services typically are started when the operating system starts. This depends on what is specified during setup; some services are not started by default.

This article describes the management of the various SQL Server services on your machine. Before you log in to an instance of SQL Server, you need to know how to start, stop, pause, resume, and restart an instance of SQL Server. After you are logged in, you can perform tasks such as administering the server or querying a database.

First of all make sure you have installed SQL Express in your system.  Also, make sure you are the admin on the server. After install SQL Express Server database server will start automatically each time you start your computer by default.

Let’s start now, select start/All Programs/Microsoft SQL Server2005/Configuration Tools/SQL Server Configuration Manager. It should look like Figure 1.

image1

Figure 1.

And you will see the Window in Figure 2. You can see all started and stopped services.

img5

Figure 2.

To start or stop a service, select the service in the right pane and use the buttons in the toolbar to start or stop the service.

If you want change start mode of any service then Click on the property on that service and click on service tab. Then you will see this window.  There are three start mode in a service.

image3

I hope this will help.