Need help in SQL Server Remote Access

Question

how to connect two laptops to share a database using windows form application? i mean i've installed mssql server 2008 in my laptop, i need to make windows form application so my friend can modify the database from his laptop, it's not in LAN , we have to use Internet as medium to connect, it'd be helpful if anyone can show me some directions like how connection strings should be. thanks :)

Answer 1

You should consider looking into this. If you search for Error 40 or Error 26 SQL Server. You will get lot of links for connecting SQL Server remotely both on LAN and WAN.

Take a look at this link as well. Screenshots are added here

There are multiple steps involved

1. Enable default login (sa) - not a good practice

2. Enable remote connection on sql server

3. Enable SqlBrowser service - either through Sql Server configuration manager or type services.msc on Run(Ctrl + R)

4. Add SqlBrowser.exe to firewall exception

5. Open TCP port 1433 and add it to firewall

6. Enable TCP, NamedPipe in Sql Server Configuration manager.

7. Check your public IP using any site like Seemyip.com

8. Give this IP to your friend along with sql server instance name

9. On remote machine - enter IP\ServerName with credentials for sa.