myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

Do I need to allow Remote Connections? Options · View
Posted: Monday, November 27, 2006 9:22:46 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
One key is you should stress that the Surface Config needs to allow Remote Connections. This is something that may not be obvious since it my SQL Server 2005 allows remote machines to connect but did not have that setting set. Also, I am running with IIS and SQL on the same machine so the reason for remote connections seemed odd anyway.

Remote connections must be allowed when IIS and SQL Server are on 2 different boxes and you need to use TCP/IP protocols.

If you run IIS and SQL Server on the same box, you do not need to allow remote connections. But you need to connect using Shared Memory protocol (click on the Options button in the login page) You can specify Shared Memory as the default value by editing the config.xml file.
Users browsing this topic

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another version (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another All rights reserved.