Dear Friends,

Following is the steps for to Use SQL Server Express edition in your internal network.

1). Make sure express is running correctly (assumes a default install).

Drop to a “Command” prompt , Type Following Command , “sqlcmd -S.\sqlexpress

You should get a prompt like this 1> , Now Type “Exit”.

2). Now you have to Enable Protocols for the connectivity.

a. Launch SQL Computer Manager

b. Expand “Server Network Configuration”

c. Expand Protocols for “SQLEXPRESS”

d. Enable Np (for local and remote access)

e. Enable TCP (for local and remote access)

3). Now You have to Restart SQLExpress.

You can be done the same from the command prompt , Go to “Command” , and type

net start mssql$sqlexpress

4).Now Start “SQL Server Browser Services From Service Pannel.

You can be done the same from the command prompt , Go to “Command” , and type

net start sqlbrowser

5). At this point the client should be able to connect, if the machine is rebooted then the last step (4)

needs to be repeated as this service must always be running. You can also set this service to

autostart via Computer Manager, Services Management Applet.

6). Now in the last if you are not able to connect then you have to check your Windows Firewall Status.

If firewall is on then perform the following steps,

1. Click Start, click Control Panel, and then click Network Connections.

2. From the navigation bar on the left, click Change Windows Firewall settings.

3. On the Exceptions tab, in the Programs and Services box, you will probably see that SQL Server is listed, but not selected as an exception. If you select the checkbox, Windows will open the 1433 port to let in TCP requests. Alternatively, if you do not see SQL Server listed, do the following:

a. Click Add Program.

b. Click Browse.

c. Navigate to drive:/Program Files/Microsoft SQL Server/MSSQL.1\MSSQL\BINN

d. Add the file sqlservr.exe to the list of exceptions.

Enjoe !!!! 🙂

Regards,

Kuntal(SR. System Administrator)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: