>>This is actually SQL Server Express 2012 .
>>
>>I have two PCs in a workgroup at a client. Both running Win 7 Home Premium. I have installed SQL Server Express 2012 on one and my system running on that PC is able to access it.
>>
>>I have:
>>
>>1. enabled TCP/IP and named pipes
>>2. set dynamic ports to blank and set a TCP port number
>>3. Added an exception for this port number in Windows firewall
>>
>>Is there anything I am missing? I can't access the data from the other PC.
>>
>>
Update>>
>>I found that I had changed the dynamic ports on IP2 (or was it IP4?) instead of IPALL. Once I did that I was able to connect.
>>
>>Now my next challenge is to allow a remote computer access to the database over the internet. Any suggestions of where to find instructions on how to do this?
>
>Instructions..
>
>Step 1 - Don't do it!!
>
>Step 2 - See Step 1!
>
>Set up a webservice(s), use a VPN, etc.
>
>Putting your SQL server on the public internet is just inviting DOS and hack attacks. Been there. Done that.
Thanks, that's the eventual goal, I just need to test this immediately and this is the quickest way.