Connecting to SQL server

Posted: 02-16-2005, 05:01 AM
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
Reply With Quote

Responses to "Connecting to SQL server"

CFGoneWild
Guest
Posts: n/a
 
Connecting to SQL SERVER
Posted: 03-17-2006, 07:32 PM
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?

Reply With Quote
Sojovi
Guest
Posts: n/a
 
Re: Connecting to SQL SERVER
Posted: 03-17-2006, 09:02 PM
(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
Reply With Quote
CFGoneWild
Guest
Posts: n/a
 
Re: Connecting to SQL SERVER
Posted: 03-17-2006, 10:30 PM
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.


Reply With Quote
CFGoneWild
Guest
Posts: n/a
 
Re: Connecting to SQL SERVER
Posted: 03-18-2006, 12:08 AM
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!
Reply With Quote
 
LinkBack Thread Tools Search this Thread Display Modes
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC Server hangs mkarl Coldfusion Database Access 12 04-19-2005 02:10 PM
Connecting SQL Server to DW Mike1500 Dreamweaver AppDev 1 02-17-2005 05:49 PM
cant get Restrict Access to Page server behaviour towork e_clare Dreamweaver AppDev 0 02-17-2005 11:27 AM
File Server issues while using CS Cabbage@adobeforums.com Adobe Photoshop Mac CS, CS2 & CS3 0 02-11-2004 10:59 PM