Express version access from other machine

[iccsi]

I installed a SQL Express version on machine A.
I am able to access Express version from SSMS on machine A, but I can
not access the Express SQL server on the machine B using SSMS.

I would like to know any configuration need to be done to let my
machine B to access Express SQL server.

Your information and help is great great appreciated,


iccsi

[Erland Sommarskog]

Post by iccsi
I installed a SQL Express version on machine A.
I am able to access Express version from SSMS on machine A, but I can
not access the Express SQL server on the machine B using SSMS.
I would like to know any configuration need to be done to let my
machine B to access Express SQL server.
Your information and help is great great appreciated,

Note that by deault, SQL Server Express does not accept connections from
remote servers, but only connections over shared memory.

You can change this in SQL Server Configuration Manager. The first step
is to enable TCP/IP.

Next is to make sure that the Browser service is running.

And, finally, don't forget that you may have a firewall blocking access!