Re: highly appreciated.

Roy wrote: 
I am trying to connect the named instance from my client computer...
I can easily connect the default instance of my remote machine but
when I tried to connect through named instance it gave me an error
that SQL Server doesn't exist or access denied....

In the client network utility I have defined the IP and alias of that
server but failed to connect.

Can any one give their expert idea.

Thanks

Why are you defining an alias? Was it because you had no luck connecting using the named instance? The named instance runs on a different port than the default 1433. I think it might use 1434, but am not sure. Try using the instance name first before resorting to using an alias. For example, if you remote computer name is MY_COMPUTER and the named instance is SQL2, try the following as the server name:

MY_COMPUTER\SQL2

If you still have trouble, it could be a firewall issue. Try temporarily disabling any firewall software and see if that helps.

--
David Gugick
Quest Software
www.imceda.com
www.quest.com 

.

Relevant Pages

  • highly appreciated.
    ... I am trying to connect the named instance from my client computer... ... easily connect the default instance of my remote machine but when I tried to ... connect through named instance it gave me an error that SQL Server doesn't ...
    (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)
  • change a named instance to default instance
    ... Produced By Microsoft MimeOLE V6.00.2800.1441 ... even though there is only one SQL Server ... | Is there anyway I can make my named instance behave like the default? ... Configure an Alias by Using TCP/IP Sockets ...
    (microsoft.public.sqlserver.connect)
  • Re: SSAS with an Instance name
    ... We are able to connect to the named instance from Excel without passing ... connect to that server). ... Please do not send email directly to this alias. ... but it brings an error: Datasource Local Analysis Server not ...
    (microsoft.public.data.xmlanalysis)
  • Re: connect to named instances
    ... Your client system likely has an older version of MDAC. ... higher to connect to a named instance without requiring an alias. ...
    (microsoft.public.sqlserver.server)