myLittleTools Community Forum

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

Cannot connect to specified instance Options · View
dbaxronin
Posted: Saturday, February 09, 2008 2:21:13 AM
Rank: Newbie
Groups: Member

Joined: 2/9/2008
Posts: 4
Points: 0
Location: USA
I have this installed and am able to log in to my local isntance of SQL 2005. However, it is not connecting to the correct instance I have setup in my config.xml.

I have one instance named thor. The other is thor\thor.

Regardless of what I specify in the config, it is always connecting to the thor instance. Both instances are SQL2005. Any clue? Does this not support multiple instances? Is it perhaps because the secondary instance name of \thor is the same as the initial? I don't have any issues connecting in Management Studio. Any help is appreciated. Thanks.
elian
Posted: Saturday, February 09, 2008 9:29:40 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Yes multiple instances are supported.
When you declare your instances in the config.xml file, you should have something like

Code:
<sqlserver
    address="thor"
    name="Default Instance"
/>
<sqlserver
    address="thor\thor"
    name="Second Instance"
/>
dbaxronin
Posted: Saturday, February 09, 2008 6:49:53 PM
Rank: Newbie
Groups: Member

Joined: 2/9/2008
Posts: 4
Points: 0
Location: USA
Excellent. That worked perfectly. Thank you.
Users browsing this topic
Guest


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 Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.