I recently had this problem. Once I created a new user login in SQL Server
and NT for the web server and used that login in cf admin, I was fine. Make
sure you have port 1433 open on the database machine for TCP/IP and double
check the database name. Good luck.
Sincerely,
Shane Witbeck
Webmaster
mailto:[EMAIL PROTECTED]
www.digitalsanctum.com
-----Original Message-----
From: Frank Priest [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 10:18 PM
To: [EMAIL PROTECTED]
Subject: Re: Remote SQL server as datasource
Have you tried using an IP Address instead of a server name in the CF
administrator?
One more thing to check is the login permissions...
Try connecting as "sa"
>That was also already done, still no go (although from ODBC control panel
>the source tests out fine--its just ColdFusion that can't seem to get to
>this SQL Server datasource...weird.)
>
>Thanks for your help...
>
>Eron
>
>----- Original Message -----
>From: "Frank Priest" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, August 11, 2000 8:01 PM
>Subject: Re: Remote SQL server as datasource
>
>
> > Go into the Windows NT "Control Panel", "ODBC"
> >
> > Select your data source, click configure, click "Nex", "Client
>Configuration"
> > Make sure that you have TCPIP selected under Client Libraries.
> >
> > Hopefully that will do the job.... :-)
> >
> >
> > At 06:05 PM 8/11/2000 -0400, you wrote:
> > >Thanks for your help, unfortuantely, I have done that, but still
>no-go...It
> > >still comes back with a "FAILED" status for the connection in the
>ColdFusion
> > >Admin ODBC settings.
> >
>
> --------------------------------------------------------------------------
>----
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
> >
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
