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.

Both computer have Windows 7 but i can't connect from one computer to the other where SQL Server 2012 Express is installed. EDIT: This is a local network.

Ive opened up the program on the firewall and enable sql browser service but i still can't connect.

I used the format "HOSTNAME\NAMEDINSTANCE".

Thanks, any help is greatly appreciated.

share|improve this question
    
1. The SQL Browser service isn't required in order to connect to a SQL instance over the network... and I wish people would stop thinking that it is. 2. Have you enabled any network protocols for the SQL instance? 3. How about giving us some details on what message, if any, that you get when trying to connect. –  joeqwerty Sep 11 '12 at 0:26
    
It say it can't connect. Error 26 Cannot localize the instance. I try to connect from visual studio 2012 using windows auth. –  Rushino Sep 11 '12 at 0:31
    
@joeqwerty The browser service is required if you try to use named instances. If you use the port number its not. –  Brent Pabst Sep 11 '12 at 2:57
    
The SQL browser service is only required for a named instance if you don't specify the port for the named instance or if SQL Server is using dynamic ports. My point is that mucking about with the SQL browser service isn't the path I would take while troubleshooting a connectivity problem –  joeqwerty Sep 11 '12 at 13:58
add comment

1 Answer 1

You can visit following articles for solution of your query :

Connecting MSSQL from Another Computer
Connect to a SQL Server Named Instance

Hope this helps you.

share|improve this answer
add 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.