>I believe that I have that configured as I am able to connect to the database from a different PC on the local network.
>
>I understand that I need to know the IP address of the database server, how would I determine that? This is what I would need to use in my connection string from the PC outside the LAN.
Assuming your SQL Server is on a LAN that is using NAT behind a firewall, you'll probably need to establish port forwarding for the TCP port of the SQL server (default is 1433 - you may have changed it) to send that port to the internal address of the SQL server.
>
>>In SQL Server Management Studio, did you check "Allow remote connections" in the server properties?
>>
>>
>>>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?
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________