Re: connect to named instances

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 04/28/04 

Date: Tue, 27 Apr 2004 20:04:29 -0400

Your client system likely has an older version of MDAC. Install MDAC 2.6 or
higher to connect to a named instance without requiring an alias. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Hassan" <fatima_ja@hotmail.com> wrote in message
news:ud6L39KLEHA.2100@TK2MSFTNGP10.phx.gbl...
> How can I connect to a named instance from a client. I believe the problem
> is bcos of the port number.. When i connect to computername\instancename
it
> says SQL Server does not exist or access denied. However when i register
an
> alias in client network utility with the instance name and the actual port
> number it works fine, but i have to use the alias.
>
> Can i not register with the instance name directly without setting it up
> thru the client network utility ? Please advice..
>
>

Relevant Pages

  • Re: Using SSL with named instance
    ... I tried using alias for the named instance as MyServer_second and then tried ... Is there any issue with using named instance with SSL. ... >> client connections) ... server. ...
    (microsoft.public.sqlserver.security)
  • Re: Named instance question
    ... Only from the clients connecting to it. ... You can install MDAC 2.6 or later ... and use the alias. ... > over from using a named instance, to a default instance, but don't want to ...
    (microsoft.public.sqlserver.server)
  • Re: highly appreciated.
    ... First of all David, thanks for your reply.... ... I am at client computer and how client computer diagnose MY_COMPUTER\SQL2 ... I did findout the port No of named instance through SQL Server ...
    (microsoft.public.sqlserver.clients)
  • Re: SSAS with an Instance name
    ... I would also highly recommend moving the server to SP1 -- there were several ... Try out the MSDN Forums for Analysis Services at: ... Please do not send email directly to this alias. ... We are able to connect to the named instance from Excel without passing ...
    (microsoft.public.data.xmlanalysis)
  • Re: DL membership - can we hide it? EXCH2003 SP2
    ... Please do not send email directly to this alias. ... Have a client who sends 'Bid Requests' to five vendors. ... would like to set up a Distribution Group that has these five ... recipients UNDER NO CIRCUMSTANCES determine to whom the e-mail was sent. ...
    (microsoft.public.exchange.admin)