On other note, make sure that you are using a SQL Server login and not a NT
login for validation. NTs validation tokens do not route effectively to
remote networks.
-----Original Message-----
From: Tac/Smokescreen Action Network [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 19, 2000 6:15 PM
To: inFusion Support List
Subject: Re: [iMS] using an offsite SQL-Server database via ODBC, over
TCP/IP
No, I've been spending a lot of time on the listserver administration stuff,
so I've held off on the back-end processing. I'm doing a demonstration to a
group of potential users next week, and they are much more interested in
ease of administration.
I'm using SQL Auth., but still not connecting. Question: in the ODBC
setup, when it asks for server, do you just need the IP address? I'm
assuming you need something more -- backslashes, alias name, something,
because that's not working.
Right now I have
data source name: TEST
description: <blank>
Server: 209.8.58.3
Cold Fusion Login: (username and password)
This identical configuration works if I give it the NAME of a SQL server,
rather than the IP address. I've also tried
209.8.58.3:1433
since 1433 is the port SQL-Server runs on. To no avail.
Thanks, I'm really stuck on this! I'll move this over to cf-talk if I can't
get this soon (so I won't be OT on this list)
Tac
----- Original Message -----
From: Guillermo Dewey <[EMAIL PROTECTED]>
To: inFusion Support List <[EMAIL PROTECTED]>
Sent: Friday, May 19, 2000 6:43 PM
Subject: Re: [iMS] using an offsite SQL-Server database via ODBC, over
TCP/IP
> we use iMS on a non local machine using tcp ip and had the same problem at
> the begining.. we solved using the sql auth not nt auth, just make sure
the
> user access from machine 1 is ok for machine 2. by other way did you make
> ims work storing files on the sql server instead of making files?
>
> At 06:38 p.m. 19/05/00 -0400, you wrote:
> >This is not iMS-specific, but more CF/SQL-Server (but would apply to
iMS).
> >
> >How does one connect to a SQL-Server database that's not on the local
> >network? I tried setting up my datasource to point the the IP address
where
> >the SQL-Server lives, but the connection fails.
> >
> >Is there a port it needs to specify? Is there something in SQL-Server
that
> >I need to say "Connections via TCP/IP okay"?
> >
> >Thanks!
> >
> >Tac
> >
> >
> >
> >==============================================
> > This list server is Power by iMS
> > --------------------------------
> >To leave this list please complete the form at
> >http://www.CoolFusion.com/iMS.htm
> >==============================================
> >
> >
> >========================================================================
> > This list server is Powered by iMS
> > 'The Swiss Army Knife of Mail Servers'
> > --------------------------------------
> >To leave this list please complete the form at
> >http://www.CoolFusion.com/iMS.htm
> >
> >List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
> >========================================================================
>
> ********************************************
> * Ing. Guillermo Dewey Guerra
> * Metro Cybercomercio Mexico
> * [EMAIL PROTECTED]
> * ICQ: 25876549 (GDewey)
> *
> * http://www.metro.com.mx
> * http://www.coldfusion.com.mx
> * http://www.ablecommerce.com.mx
> *
> * Tel. (011) (52) (8) 3-90-7000
> * Fax (011) (52) (8) 3-90-7001
> * Cel. (011) (52) (044) (8) 3-09-24-16
> * Monterrey N.L. Mexico
> ********************************************
>
>
> ========================================================================
> This list server is Powered by iMS
> 'The Swiss Army Knife of Mail Servers'
> --------------------------------------
> To leave this list please complete the form at
> http://www.CoolFusion.com/iMS.htm
>
> List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
> ========================================================================
>
==============================================
This list server is Power by iMS
--------------------------------
To leave this list please complete the form at
http://www.CoolFusion.com/iMS.htm
==============================================
========================================================================
This list server is Powered by iMS
'The Swiss Army Knife of Mail Servers'
--------------------------------------
To leave this list please complete the form at
http://www.CoolFusion.com/iMS.htm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
========================================================================
========================================================================
This list server is Powered by iMS
'The Swiss Army Knife of Mail Servers'
--------------------------------------
To leave this list please complete the form at
http://www.CoolFusion.com/iMS.htm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
========================================================================
