Re: What's My Password?

Look for *** below.
Robin S.
----------------------------------
"Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx> wrote in message
news:utzIia2MHHA.1240@xxxxxxxxxxxxxxxxxxxxxxx
Robin,

Where is it asking you for the username and password? Because
if I use integrated security, it doesn't ask me, it collects
that information from Windows.

It isn't. However, the connection string can include a user name and
password, and it appears the connection string is where I'm currently
hung up.

Here's an example of connection string I'm using:

Data Source=xMyMachineName\xMySQLServerName;Initial
Catalog=myFavoriteDB;Integrated Security=True

And, here again, are the ones I tried:

"Data Source=localhost;Initial Catalog=BlackBeltCoder;Integrated
Security=True"

*** I would use this one, but you need \sqlservername after
localhost.

"Data Source=localhost;Initial Catalog=BlackBeltCoder;Integrated
Security=SSPI"
"Data Source=localhost;Initial Catalog=BlackBeltCoder;user
id=sa;password=opensesame"

The password in the last one I read was the default.

If you have SQLServerExpress installed, the default
name is the computer name with \SQLExpress appended to it.
To find your computer name, right-click on My Computer
and choose the tab "Computer Name".

Where is this? Is this the Data Source value in the connection string
or something else?

You can put your computer name in, instead of using "localhost".


To create a SQLServer database using Server Explorer in VS2005:

Click on View/ServerExplorer.

Right-click on the Data Connections node and select
Create New SQL Server Database from the context menu.
This displays the Create New SQL Server Database dialog.

Select the name of the SQL Server you want to use.
You may not see your SQLServer Express edition appear
in the list. If yot, you can type it in as <your machine
name>\SQLExpress or as (local)\SQLExpress or just .\SQLExpress.

Define the appropriate info to log into the selected SQL Server.
By default, SQL Server Express is installed with Windows
Authenticaion in place.

Define the name of the database.

Click <OK>.

I'm happy to try this (I haven't yet). In fact, I'm printing this out.

However, am I screwed given that I already created a database? What
would be *really* nice is if I could see my settings for the database
I created and then change them. But, alas, that's probably too simple,
eh?

No, I'm just trying to get you connected at all. Once you've connected
VS2005 to your SQLServer instance, you should be able to connect to
and/or see all of the databases therein.


Thanks.
Jonathan Wood

Good luck.
Robin S.


.

Relevant Pages

  • asp.net 2.0 login control
    ... A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] ... These problems left me stranded for days, then today, on another machine, I hit a different set of problems I kept getting the following "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance. ... (Basically this is a new option in the connection string that allows you to point out where the ..mdf file resides eliminating the need to create database in some SQL instance.) ... Beware that the windows account of the user that first creates the connection in this databaseless manner, becomes exclusive user for this file and no other windows account will be able to create a connection to this file. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Newbie question on SQL connection
    ... database on my developer machine. ... > to develop databases away from the live SQL server - that way in the ... > domain SQL Server. ... Does your connection string contain a typo? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: .NET and SQL Server on Separate Machines
    ... add this domain account as a valid login to your sql server. ... Everything was running correctly when the database ... > The connection string in our web.config file originally looked like this: ...
    (microsoft.public.sqlserver.connect)
  • Re: .NET and SQL Server on Separate Machines
    ... add this domain account as a valid login to your sql server. ... Everything was running correctly when the database ... > The connection string in our web.config file originally looked like this: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Why do I have to enable File and Printer sharing to connect through the XP firewall?
    ... the connection string. ... IS the client connecting using a Windows account or using a SQL Server account? ... the user is me and I'm a domain/olap admin. ...
    (microsoft.public.sqlserver.clients)