SQL Express Connecting via Local Network

Question

Is it possible to connect to an instance of sql express via another computer on my home network. I have tried but the connection always fails. What settings should I be looking out for? What are good words to search on? I have enabled TCP/IP Always get a message saying 'SQL servers does not exist or access is denied'

thanks

Answer 1

Have you also checked your firewall? Either allow SqlServr.exe and/or port 1433 access through it.

Answer 2

I had the same issue. Check to see if SQL Browser is running

http://stackoverflow.com/questions/452850/all-the-reasons-i-cant-access-an-instance-of-sql-2005

Answer 3

Here is a good article how to make it works via local network. Hope it helps.