Re: What's My Password?

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




.

Relevant Pages

  • Re: My C:Windows folder takes 9.21GB, is it too large?
    ... Visual Studio 2005 ... SQL Server 2005 Developer Edition ... -- Install an imaging program for your backups; ... -- Get a 500 Gig internal drive to replace the one you have. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: .Net Framework, SQL Server & Visual Studio
    ... when you install Visual Studio, just unselect the SQL Server Express ... After the setup finishes, install SQL Server 2005. ... functionality VS and VS 2005 comes with the SQL Server Express Edition, ...
    (microsoft.public.dotnet.framework)
  • Re: SQL Server 2008 Standard and Visual Studio 2008 Professonal
    ... If you have the SR1 beta and Sulverlight beta installed in Visual Studio Pro. ... Futhermore you have to install Visual Studio 2008 before you install SQL ... I messed around with SQL Server 2008 and Visual Studio 2008 so much that I ... instead of creating it as a new database on SQL-Server 2008. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL2008 Fails VSShellInstalledRule
    ... Does anyone know the possible RTM date for Visual Studio 2008 SP1? ... Before you install or upgrade to SQL Server 2008, ...
    (microsoft.public.sqlserver.setup)
  • Re: .Net Framework, SQL Server & Visual Studio
    ... Best regards, ... So you should install Visual Studio 2005, then SQL Server 2005, then the ...
    (microsoft.public.dotnet.framework)
Loading