William \(Bill\) Vaughn
6/20/2007 3:49:00 PM
It won't appear on its own. To use the alias, you need to create a Database Connection in the server explorer and set "Server" to the alias instead of the machine\instance designation.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"wrytat" <wrytat@discussions.microsoft.com> wrote in message news:9A90F3AA-7610-41AE-BF2A-F6D20C699F24@microsoft.com...
> Ok, I have added the alias at Client Network Utility, and registered at the
> Enterprise Manager. However, when I go to Visual Studio 2005, my project, I
> look at the Server Explorer, the database that I registered did not appear,
> no matter how many times I refresh... Were what I did correct?
>
> "William (Bill) Vaughn" wrote:
>
>> Ah, in SQL Server 2000, it's the SS Client Network Utility. I thought you
>> were running 2005.
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no rights.
>> __________________________________
>> Visit www.hitchhikerguides.net to get more information on my latest book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> news:667123B3-BA67-493B-891A-4414F900580C@microsoft.com...
>> > Sorry, I still can't find it. Is it at SQL Server Client Network Utility?
>> > Or
>> > can I find it from Enterprise Manager?
>> >
>> > "William (Bill) Vaughn" wrote:
>> >
>> >> It's installed with SQL Server.
>> >>
>> >> --
>> >> ____________________________________
>> >> William (Bill) Vaughn
>> >> Author, Mentor, Consultant
>> >> Microsoft MVP
>> >> INETA Speaker
>> >> www.betav.com/blog/billva
>> >> www.betav.com
>> >> Please reply only to the newsgroup so that others can benefit.
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >> __________________________________
>> >> Visit www.hitchhikerguides.net to get more information on my latest book:
>> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> >> -----------------------------------------------------------------------------------------------------------------------
>> >>
>> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> >> news:7B2BC418-026B-4C37-B58F-C0F764FAD9D0@microsoft.com...
>> >> > Hi, how do you get SQL Server configuration manager applet?
>> >> >
>> >> > "William (Bill) Vaughn" wrote:
>> >> >
>> >> >> Sure, use the SQL Server configuration manager applet. Click on "SQL
>> >> >> Native
>> >> >> Client Configuration" and choose "Alias". Fill in the dialog with the
>> >> >> Server
>> >> >> as the machine name\instance and an alias name.
>> >> >>
>> >> >> --
>> >> >> ____________________________________
>> >> >> William (Bill) Vaughn
>> >> >> Author, Mentor, Consultant
>> >> >> Microsoft MVP
>> >> >> INETA Speaker
>> >> >> www.betav.com/blog/billva
>> >> >> www.betav.com
>> >> >> Please reply only to the newsgroup so that others can benefit.
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >> __________________________________
>> >> >> Visit www.hitchhikerguides.net to get more information on my latest
>> >> >> book:
>> >> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> >> >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> >> >> -----------------------------------------------------------------------------------------------------------------------
>> >> >>
>> >> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> >> >> news:CE902646-8697-42D4-A28B-81AECC71E827@microsoft.com...
>> >> >> > May I ask how do you create a registered Alias?
>> >> >> >
>> >> >> > "William (Bill) Vaughn" wrote:
>> >> >> >
>> >> >> >> One approach that I discuss in my book is to obfuscate the
>> >> >> >> server/instance
>> >> >> >> with a registered Alias. This way you can change the targeted
>> >> >> >> server
>> >> >> >> at
>> >> >> >> will. Yes, it might be important to hide the credentials, but I
>> >> >> >> often
>> >> >> >> create
>> >> >> >> an account on the server with very limited rights for use by a
>> >> >> >> specific
>> >> >> >> application type.
>> >> >> >>
>> >> >> >> --
>> >> >> >> William (Bill) Vaughn
>> >> >> >> Author, Mentor, Consultant
>> >> >> >> Microsoft MVP
>> >> >> >> INETA Speaker
>> >> >> >> www.betav.com/blog/billva
>> >> >> >> www.betav.com
>> >> >> >> Please reply only to the newsgroup so that others can benefit.
>> >> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> >> rights.
>> >> >> >> __________________________________
>> >> >> >> Visit www.hitchhikerguides.net to get more information on my latest
>> >> >> >> books:
>> >> >> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> >> >> >> and
>> >> >> >> Hitchhiker's Guide to SQL Server 2005 Compact Edition
>> >> >> >>
>> >> >> >> -----------------------------------------------------------------------------------------------------------------------
>> >> >> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> >> >> >> news:C6EE2F70-6786-41B6-8809-148A203B362E@microsoft.com...
>> >> >> >> > I'd like to ask for the correct way, or rather say the more
>> >> >> >> > advisable
>> >> >> >> > way
>> >> >> >> > to
>> >> >> >> > connect to a SQL Server in a Windows application written in .NET
>> >> >> >> > 1.1
>> >> >> >> > or
>> >> >> >> > 2.0.
>> >> >> >> > When I develop my program, the database is located on my machine.
>> >> >> >> > But
>> >> >> >> > when
>> >> >> >> > it
>> >> >> >> > is published, the database that it use will be on our server. My
>> >> >> >> > practice
>> >> >> >> > is
>> >> >> >> > to write a class, storing the credentials and information needed
>> >> >> >> > to
>> >> >> >> > connect
>> >> >> >> > to the database. And create the DataAdapter by coding (instead of
>> >> >> >> > dragging
>> >> >> >> > the DataAdapter to the form from Tools) in the class. Which
>> >> >> >> > should
>> >> >> >> > be
>> >> >> >> > the
>> >> >> >> > common practice to be advised?
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>