Re: What's My Password?

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"
"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?

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?

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com


.

Relevant Pages

  • Re: Connectivity to SQL Server from Existing COBOL Apps
    ... For access to MS SQL Server, have a look at sourceforge ODBTP. ... migration project, I'm just exploring options, one of which is database ... move a VMS application to Windows so just keep pushing it up that hill. ... equivalent SQL Server database running on Windows. ...
    (comp.os.vms)
  • 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)
  • Re: Connecting using Windows Authentication
    ... You would use the following to authenticate using Windows NT integrated ... > Dirk - the connection string looks like this: ... > the SQL Server provider is expecting something to let it know how to log ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQL open error
    ... I wish to use Windows authentication rather than supplying ... in Enterprise Manager reads as. ... Source=localhost in my connection string I get the error ... "SQL server does not exist or access denied". ...
    (microsoft.public.dotnet.general)
  • Deployment issue - Error 26
    ... The target environment is a dedicated server running SQL Server 2005 Standard ... and client machines running the VS2005-developed code on Windows XP. ... testing looked OK after changing the connection string in the app config file. ... It built a connection string and stored it in the Project settings for the data ...
    (microsoft.public.dotnet.framework.adonet)
Loading