Re: Connecting to wrong SQL Server

Tech-Archive recommends: Speed Up your PC by fixing your registry

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@xxxxxxxxxxxxxx> wrote in message
news:o50292l98e45ugu0j7cej427gm5qeaj5ju@xxxxxxxxxx
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



.

Relevant Pages

  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
    (microsoft.public.sqlserver.connect)
  • Re: Cannot connect a remote sql server
    ... I too have written quite a bit about connecting. ... Hitchhiker's Guide to Visual Studio and SQL Server ... such as the server's firewall, SQL Server's remote connection setting, ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.adonet)
  • Use Single Sign on to connect to sql server
    ... connection in an excel file that connects using an odc file connecting using ... The logon account information that you configure here must match the logon ... Name: SQL Server ... If I'm connecting using a sql username, do i need to use the domain piece ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Problem connectin SQL Server 2005
    ... > Have you configured the SQL Server 2005 to allow remote connections? ... > Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... > Configuring a Fixed Port ...
    (microsoft.public.sqlserver.connect)
  • Re: Problem connectin SQL Server 2005
    ... Have you configured the SQL Server 2005 to allow remote connections? ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Configuring a Fixed Port ...
    (microsoft.public.sqlserver.connect)