Database Reference
In-Depth Information
Configuring SQL Server Express
You just installed SQL Server Express; you now have a database server running on this ma-
chine. Now, it is time to configure the database so that we can remotely connect to it and
add users.
Enabling TCP remote pipe
TCP remote pipe is another term for the networking capability that is available in SQL
Server. This feature allows remote connection from other machines to the database server
in order to manage and control the database. By default, remote connections are disabled
for Express, so we can't connect to the database unless we enable the remote connections.
In the
Start
menu, point the cursor to
Microsoft SQL Server 2012
,
Configuration Tools
,
and then click on
SQL Server Configuration Manager
, as seen in the following screen-
shot:
Now, we need to configure the TCP remote pipe to enable remote access. To do this, per-
form the following steps:
