Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My remote server running 08 R2 can connect to it's SQLExpress instance via SSMS. db Properties has 'Permit remote connections ticked'. Firewall off doesn't help. Another thread here shows 'sqlcmd -e -s ip\instance' as a suggestion - i'm not familiar with that way in - only use SSMS - but if that's _supposed to work locally, it's not in my case.

What's the next step to implementing remote access? Is the 64 bit coming into play? 64 bit version is installed but the configuration manager has a couple nodes with reference to '(32-bit)'


share|improve this question
up vote 1 down vote accepted

If this is a default install of SQL Express (ie- SQL is installed as a named instance) then make sure the SQL Browser service is running.

share|improve this answer

Have you run the SQl Server Configuration Manager to make sure that you've enabled the appropriate network protocols for the SQL instance (TCP/IP and/or Named Pipes)? If not, that's what you need to do.

share|improve this answer

Your Answer


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.