Re: .NET Data Adapter not taking Alias added in ClientNetwork Utility

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 05/29/04 

Date: Sat, 29 May 2004 15:30:37 -0400

I wasn't aware that .NET would even look at the client network utility. Are
you sure that's in its list of things to check (especially considering that
SQL Server / client network utility is not always going to be installed
where .NET is installed)? I thought for most applications it was HOSTS,
then WINS, then DNS... and SQL Server uses the client network utility on its
own? 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Ganesan Subramanian" <gansub@hotmail.com> wrote in message 
news:eODEacVREHA.4048@TK2MSFTNGP10.phx.gbl...
>I added an alias in Client Network Utility. (cliconfg.exe).
> I am in Administrators and hence was able to add the ALias.
>
> Alias Name : MyDatabase
> Protocols Enabled : Named Pipes, TCP/IP.
> Protocol for Alias : tried both Tcp/ip and Named Pipes
> Server : MyServer
>
> From query analyser if I try to open "MyDatabase" it opens the server
>
> From .NET Windows Server, I give it in connection string - it doesnt take
> it.
>
> Note : this is not working only on this server. Another similarly 
> configured
> server, takes this.
>
> Any Help is much appreciated.
>
> Gan
>
> -- 
> Ganesan Subramanian
> Microsoft Technologies and Solutions
>
>
>

Relevant Pages

  • Re: How can I tell what protocols are enabled for the client?
    ... The client and server use only the protocols enabled ... using the alias, only the protocls enabled for the alias are used. ... My question is on the Client Network Utility not on the Server Network Utility. ...
    (microsoft.public.sqlserver.connect)
  • Re: Connect to SQL Server from Workgroup Computer
    ... I opened Client Network Utility and in the Alias> ... Edit tab changed the name of the 'Server Alias' to something different from ... > I suspect SQL Server is not hearing the connection request. ...
    (microsoft.public.sqlserver.connect)
  • Help Please with a step by step keystroke by keystroke(or Mouse) illustration on how to setup a stan
    ... the most typical for the average developer wanting to push .Net SQL driven ... did it would involve a domain server, ... client network utility force protocol encryption is NOT checked) ... Please give a complete account of the standalone CA installation as this ...
    (microsoft.public.sqlserver.security)
  • Re: Server Alias - SQL Server Configuration Manager
    ... The alias is working on our test machine. ... do the changes exactly the same way as SQL Server Configuration Manager ... Tibor Karaszi, SQL Server MVP ... Is there a way to install SQL Server Configuration Manager without also ...
    (microsoft.public.sqlserver.tools)
  • Re: Clustered SQL servers in DR Hotsite
    ... Make sure that the TTL for the alias is 0. ... SQL Server MVP ... Does ODBC/OLEDB just use the server name to ... I have to bring up a second set of clustered SQL servers at a DR Hotsite. ...
    (microsoft.public.sqlserver.clustering)