Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remote Connection SQL Express Issue

Status
Not open for further replies.

pcollins1

Technical User
Jun 19, 2002
72
US
I have a named instance that is installed on a local machine
with SQL Express. When I try to connect to it remotely , I get "under default settings SQL Server does not allow remote connections." I go to the configuration manager, but I can not see the named instance to set "allow remote connections." I only see the default instance MSSMLBIZ. I downloaded the SMSS manager express on the local machine and can see the instance database, but i can not see it through a remote machines SMSS manager.
In services I do see a SQLAGENT$NamedInstance, but the SQL Server service is set to MSSMLBIZ
How can I set this named instance to allow remote connections, if I can not configure it through the configuration manager, it does not appear?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top