Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am using sql server 2008 inside my home lan. I've configured it to accept remote connections and I can now connect to the server from other pcs inside the lan.

The problems rises when I try connecting to the server from a computer outside of my home lan. I've disabled my router's firewall and I've configured a virtual server on port 1433 forwarding to the correct lan ip. What's wrong? why is it not working?

Thank you very much for your help~!

share|improve this question
    
This is really more appropriate for serverfault - it a networking issue rather than a programming issue. –  Joel Coel Jul 7 '09 at 19:39
    
Also, if you want to see this answered you should at least post the error message shown when you try to connect, and share what tools you're using to test this. –  Joel Coel Jul 7 '09 at 19:40
1  
This is the error I keep getting: a network related or instance specific error occured while establishing connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that the SQL SERVER is configued to allow remote connections. (provider : Sql network interfaces, error: 25- Connection string is not valid) –  vondip Jul 7 '09 at 20:04
    
I think you asked this same question yesterday here? Anyway, please post the connection string as that is what the error you are getting is complaining about. –  marshall Jul 9 '09 at 5:38
add comment

1 Answer

You need to enable the SQL Server Browser service on your server

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.