Re: What's My Password?
- From: "RobinS" <RobinS@xxxxxxxxxxxxxxx>
- Date: Mon, 8 Jan 2007 16:46:07 -0800
Bill,
Does it install SQLServer Express if you already have
SQLServer installed?
Robin S.
-----------------------------------------
"William (Bill) Vaughn" <billvaRemoveThis@xxxxxxxxxx> wrote in message
news:e94J$91MHHA.3424@xxxxxxxxxxxxxxxxxxxxxxx
Ok, I understand.
When you install any version of Visual Studio (even the Express SKU),
it installs SQL Server Express Edition (quietly). There's no reason
you should have known that. To determine if you have SQL Server
Express installed, use the Server Explorer in Visual Studio and click
on Servers | YourSystem | Services and scroll down to see if "SQL
Server (SQLEXPRESS)" is listed. If it's there, you have an instance of
SQL Server (named "SQLEXPRESS") installed and (possibly) running on
your system. This assumes you aren't running the Express SKU of Visual
Studio as this exposes a "database" explorer instead with far more
limited functionality.
When connecting to any instance of SQL Server, you have to establish
who you are and which database on the server (it can support virtually
any number of databases) you want to use. You identify yourself with
username and password credentials. These can either be supplied by
Windows authentication (as when you logged on to your system or on to
a domain) or by SQL Server authentication. By default, only Windows
authentication is enabled (on all SKUs of SQL Server). This means that
SQL Server must have a Login account setup to permit access to the
server. By default, SQL Server permits members of the Administrators
group to be granted access to the server. If you don't have a Username
and Password in your ConnectionString, you must have "Trusted
Connection=Yes" or "Integrated Security=SSPI" to indicate that SQL
Server is to use the current user's Windows authentication
credentials. However, when creating an application, you can't assume
that the end-user will have those rights.
I discuss how to configure the server and all of this in far more
detail in my latest book--See Chapter 9.
--
____________________________________
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)
-----------------------------------------------------------------------------------------------------------------------
"Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx> wrote in message
news:e9GFAb1MHHA.3424@xxxxxxxxxxxxxxxxxxxxxxx
William,
I hope it was not my book that lead you astray. Getting connected to
SQL Express can be a bit tricky...
Yeah, particularly when you're not using SQL Expres (I think).
it's born deaf and blind. See my blog for a whitepaper on connecting
issues and perhaps my book (which has a long chapter on connecting)
will help...
I must admit, I'm getting a bit pessimistic about that. Especially,
when I have several books and I'm not any closer to connecting to my
database even after getting several replies from this group.
Thanks.
--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com
.
- Follow-Ups:
- Re: What's My Password?
- From: William \(Bill\) Vaughn
- Re: What's My Password?
- References:
- What's My Password?
- From: Jonathan Wood
- Re: What's My Password?
- From: William \(Bill\) Vaughn
- Re: What's My Password?
- From: Jonathan Wood
- Re: What's My Password?
- From: William \(Bill\) Vaughn
- What's My Password?
- Prev by Date: Re: What's My Password?
- Next by Date: Re: What's My Password?
- Previous by thread: Re: What's My Password?
- Next by thread: Re: What's My Password?
- Index(es):
Relevant Pages
|
