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.

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)'

thx

share|improve this question
add comment

2 Answers

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
add comment

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
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.