Connecting to wrong SQL Server

I have a machine where I have installed Visual Studio 2005 including SQLExpr
ess. I have also installed MSDE2000. They are both named instances:
MyMachine\SQLExpress and MyMachine\S3MSDE.
Locally everything works fine. But when I connect to MyMachine from an other
machine with the connectstring containing '...Data
Source=MyMachine\S3MSDE,1234;...' I always end up beeing connected to the SQ
LExpress instance of SQL Server.
WHY?
ToschIt looks like you are always connecting to the default port. Try starting
the SQL Server Browser Service on MyMachine. It is the browser service that
resolves the name to the correct port.
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Tosch" <tosch_nospam@.swissonline.ch> wrote in message
news:o50292l98e45ugu0j7cej427gm5qeaj5ju@.
4ax.com...
>I have a machine where I have installed Visual Studio 2005 including
>SQLExpress. I have also installed MSDE2000. They are both named instances:
> MyMachine\SQLExpress and MyMachine\S3MSDE.
> Locally everything works fine. But when I connect to MyMachine from an
> other machine with the connectstring containing '...Data
> Source=MyMachine\S3MSDE,1234;...' I always end up beeing connected to the
> SQLExpress instance of SQL Server.
> WHY?
> Tosch
>|||It looks like you are always connecting to the default port. Try starting
the SQL Server Browser Service on MyMachine. It is the browser service that
resolves the name to the correct port.
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Tosch" <tosch_nospam@.swissonline.ch> wrote in message
news:o50292l98e45ugu0j7cej427gm5qeaj5ju@.
4ax.com...
>I have a machine where I have installed Visual Studio 2005 including
>SQLExpress. I have also installed MSDE2000. They are both named instances:
> MyMachine\SQLExpress and MyMachine\S3MSDE.
> Locally everything works fine. But when I connect to MyMachine from an
> other machine with the connectstring containing '...Data
> Source=MyMachine\S3MSDE,1234;...' I always end up beeing connected to the
> SQLExpress instance of SQL Server.
> WHY?
> Tosch
>|||ok, since I changed the port number to the port number msde2000 uses everyth
ing works fine. Apparently if you add the port number the name of the
sqlserver/instance doesn't seem to matter.
Tosch
On Thu, 15 Jun 2006 08:05:26 -0700, "Rick Byham [MS]" <rickbyh@.online.mi
crosoft.com> wrote:

>It looks like you are always connecting to the default port. Try starting
>the SQL Server Browser Service on MyMachine. It is the browser service that
>resolves the name to the correct port.|||ok, since I changed the port number to the port number msde2000 uses everyth
ing works fine. Apparently if you add the port number the name of the
sqlserver/instance doesn't seem to matter.
Tosch
On Thu, 15 Jun 2006 08:05:26 -0700, "Rick Byham [MS]" <rickbyh@.online.mi
crosoft.com> wrote:

>It looks like you are always connecting to the default port. Try starting
>the SQL Server Browser Service on MyMachine. It is the browser service that
>resolves the name to the correct port.