Connecting to SQL server

[oscar]

Are settings configured wrong? Of course both possible reasons given
are both true, that is the web services is up and running and the ODBC
DSN does exist on the server. Remember DW does connect to the SQL
server to build the Connection String but fails later at the "OLE DB
Connection" window. Why does my FTP server come up when the SQL server
timeout occurs? My SQL server server is my ISP's and so is my FTP. I
read johndoe01's thread about the permissions problem. Doea that come
into play here?


oscar wrote:

> Greetings,
>
> I am trying to connect my asp.net page to my sql server. I have
> attempted to create a connection through the OLE DB Connection dialogue.
> I insert a connection name and "Build" the Connection String through
> the "Data Link Properties" dialogue. My connection succeeds through
> this "Data Link Properties" window and I hit OK. I am then back on the
> "OLE DB Connection" window; I hit test and another little window comes
> up that is labeled with my ftp server and I get the following message:
> "A server timeout occurred. Here are the possible reasons. 1. Please
> make sure the web service is up and running. 2. Please verify that the
> ODBC DSN exists on the testing server. What is happening?
>
> oscar

[CFGoneWild]

I'm just starting with Coldfusion. I used it several years ago before
MacroMedia purchased it.

I'm testing the Northwind Database connection.
-- (local) as the database name
-- the default port is 1433
-- no username or password
-- sql server database is up and running

when it goes to verify the connection, it TIMEOUT.

what could be wrong?

[Sojovi]

(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

[CFGoneWild]

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.

[CFGoneWild]

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!