Re: Common Practice to Connect SQL
- From: wrytat <wrytat@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 19 Jun 2007 20:39:00 -0700
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:667123B3-BA67-493B-891A-4414F900580C@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7B2BC418-026B-4C37-B58F-C0F764FAD9D0@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CE902646-8697-42D4-A28B-81AECC71E827@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C6EE2F70-6786-41B6-8809-148A203B362E@xxxxxxxxxxxxxxxx
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?
- Follow-Ups:
- Re: Common Practice to Connect SQL
- From: William \(Bill\) Vaughn
- Re: Common Practice to Connect SQL
- References:
- Re: Common Practice to Connect SQL
- From: William \(Bill\) Vaughn
- Re: Common Practice to Connect SQL
- From: William \(Bill\) Vaughn
- Re: Common Practice to Connect SQL
- From: wrytat
- Re: Common Practice to Connect SQL
- From: William \(Bill\) Vaughn
- Re: Common Practice to Connect SQL
- From: wrytat
- Re: Common Practice to Connect SQL
- From: William \(Bill\) Vaughn
- Re: Common Practice to Connect SQL
- Prev by Date: Re: need a reply of this question
- Next by Date: Query is selecting a extra row
- Previous by thread: Re: Common Practice to Connect SQL
- Next by thread: Re: Common Practice to Connect SQL
- Index(es):
Relevant Pages
|
