.NET Data Adapter not taking Alias added in ClientNetwork Utility

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 SolutionsI 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
>
>|||It was .NET SQL Data adapter for SQL Server.
This was working on another similar box.
I gave "MyDatabase" for datasource in connection string and it was working.
Any idea what setting should be set on to get this working?
Gan
--
Ganesan Subramanian
Microsoft Technologies and Solutions
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:OF#DNObREHA.4020@.TK2MSFTNGP11.phx.gbl...
> 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
> >
> >
> >
>|||This is nothing more than name resolution issue. When you use cliconfg.exe
and entry is added to:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo]
which should be enumerated by ADO/.Net. Check to see if the running user has
access to read the registry.
-oj
http://www.rac4sql.net
"Ganesan Subramanian" <gansub@.hotmail.com> wrote in message
news:%23GnrrNgREHA.2876@.TK2MSFTNGP09.phx.gbl...
> It was .NET SQL Data adapter for SQL Server.
> This was working on another similar box.
> I gave "MyDatabase" for datasource in connection string and it was
working.
> Any idea what setting should be set on to get this working?
> Gan
> --
> Ganesan Subramanian
> Microsoft Technologies and Solutions
>
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:OF#DNObREHA.4020@.TK2MSFTNGP11.phx.gbl...
> > 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
> > >
> > >
> > >
> >
> >
>|||Hi Group
Anyone had this issue before. I am eager to get an answer for this.
--
Ganesan Subramanian
Microsoft Technologies and Solutions
"Ganesan Subramanian" <gansub@.hotmail.com> wrote in message
news:#GnrrNgREHA.2876@.TK2MSFTNGP09.phx.gbl...
> It was .NET SQL Data adapter for SQL Server.
> This was working on another similar box.
> I gave "MyDatabase" for datasource in connection string and it was
working.
> Any idea what setting should be set on to get this working?
> Gan
> --
> Ganesan Subramanian
> Microsoft Technologies and Solutions
>
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:OF#DNObREHA.4020@.TK2MSFTNGP11.phx.gbl...
> > 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
> > >
> > >
> > >
> >
> >
>