Connecting to SQL server

(local) should be the Server Name, not the database name. You need a username and password to connect to SQL server. Start with those and then will see.

Regards

yes, (local) is the Server name.

however, i use Windows Authentication and I have NO username or password on
the local database.

Do I need to set one at the SQL Server level or Coldfusion level? And where do
I set the password? I thought I read in the CF documentation, that username and
password should be left blank.

In the Connecting to SQL SERVER section of Cold Fusion, it has the following:
To set up the database in the ColdFusion MX Administrator:
Open the ColdFusion MX Administrator.
Click Data & Services > Data Sources.
Type northwind in the Data Source Name field, and select Microsoft SQL Server
in the Driver drop-down list box.
Click Add.
Type Northwind in the Database Name field, 127.0.0.1 (or the database server
IP address) in the Server field, and 1433 in the Port field.
Note: Do not specify a user name or password when defining the data source.
Save the data source.

Thanks. I figured it out.

I had to an a User in the SQL Server User Table; and setup a Username / Password for each user.

The CF documentation says otherwise..oh, well...thanks!