How can I Set TCP/IP as default network protocol? - Installing myLittleAdmin for SQL Server

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Installing myLittleAdmin for SQL Server » How can I Set TCP/IP as default network protocol?

How can I Set TCP/IP as default network protocol?

Options · View

Previous Topic · Next Topic

elian

Posted: Thursday, February 22, 2007 9:59:50 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

Edit the config.xml file and change the line (section connection/protocols)
from
<protocol value="dbmslpcn" name="lDefault" localization="true" />
into
<protocol value="dbmssocn" name="lDefault" localization="true" />

dbaxronin

Posted: Saturday, February 09, 2008 2:01:30 AM

Rank: Newbie
Groups: Member

Joined: 2/9/2008
Posts: 4
Points: 0
Location: USA

elian wrote:

I found in my experience, that all I had to do was move the <protocol value="dbmssocn" name="lTCPIP" localization="true" /> node to the top of the protocols node and it was then default. The value attribute is the defining charachteristic in this heierarchy, "1Default" is just a name, it has no propensity on the list or selected value order.

I only intend on using TCP/IP anyway, so I actually deleted the rest. Thats uber default.

elian

Posted: Saturday, February 09, 2008 9:35:09 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

The best solution is to change this line to
<protocol value="" name="lDefault" localization="true" />

OoOlOo

Posted: Sunday, February 15, 2009 10:12:36 PM

Rank: Newbie
Groups: Member

Joined: 2/15/2009
Posts: 1
Points: 3
Location: dhg

wheres config.xml?

elian

Posted: Monday, February 16, 2009 5:01:11 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

In your install folder. Near the Installation guide PDF version.

Users browsing this topic

Guest

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Installing myLittleAdmin for SQL Server » How can I Set TCP/IP as default network protocol?

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.