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!

SQL Server express 05 and server management studio remote connection 1

Status
Not open for further replies.

NewDays

Programmer
Aug 14, 2008
4
Can these connect from another computer on the network. We have been having problems. It would see the server but wouldn't allow access. All services are running and were trying to connect through SQL server management from another computer on the network. Help. New to this stuff.
 
By default SQL Express doesn't allow access from a remote computer. You will need to turn on this ability within the Surface Area Configuration tool.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog
 
You guys must have a crystal ball...!
This tip solved the problem I have in this moment...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top