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'm trying to access a SQL Server 2012 database from a SQL Server Management Studio 2008 from a remote machine(on the same LAN). I can connect to the database using "sa" user under "SERVER_NAME\INSTANCE" on the local SQL Server Management Studio 2012, but I can't connect remotelly with "sa" even using "SERVER_NAME\INSTANCE", only "SERVER_NAME" or with the server IP address using the SQL Server Management Studio 2008. Already disabled firewall and made proper settings to connect with sa, am I missing some point?

share|improve this question
add comment

2 Answers

Make sure that you have enabled TCP/IP for the SQL Server. Check also the port setting.

The full step by step guide for enabling is here

SQL Browser Service is only needed if you have more instances on one server. See here and here for some more information.

share|improve this answer
add comment

Enable the SQL Browser Service on the server

You also need to make sure the firewall is open on the server.

You can reference this identical question: SQL 2008 R2 Named Instance Client Connectivity Issues?

share|improve this answer
    
Could you help me how to do that??? (I'm a litle beginner on SQL Server).. –  Diogo Jul 13 '12 at 20:07
    
Hmmm, I got it, services.msc.... testing now.. –  Diogo Jul 13 '12 at 20:08
    
Still didn't happend, should I restart the server? –  Diogo Jul 13 '12 at 20:10
    
Did you make sure the firewall is open on ports 1433 and 1434? –  Brent Pabst Jul 13 '12 at 20:10
    
I just disabled the firewall –  Diogo Jul 13 '12 at 20:17
show 1 more comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.