Thursday, March 22, 2012

Can't access SQL Express from SQL Server

I installed SQL Express on an instance of Microsoft Virtual Server. I
haven't been able to connect to it from SQL Server which is running on the
same network, but on our real server. Now I have been able to successfully
able to connect to the real SQL Server from the Express but it doesn't work
the other way around. I am using the same hostname that I see in the
Express managment studio... \\PARENTVM\SQLEXPRESS using the login I created
in Express.
I allowed access through Windows Firewall, and I enabled the allow access
from remote users in the Express configuration.
What am I missing?
Hi there,
Have you enabled remote connections on the SQLExpress instance?
By default the remote connections are disabled. Open "SQL Server
Surface Area Configuration" under Configuration tools. You then need to
select the "Surface Area Configuration for Services and Connections"
option. The Remote connections option will allow you to change the
connection types. Once you've done that restart the service to make
sure the change takes effect.
Hope this help...
sql

No comments:

Post a Comment