>downloading filemon from sysinternals

ta, did that,  also got
http://www.sysinternals.com/Files/ProcessExplorerNt.zip
gives a good handle on jrun, right click jrun process and loads of info
there re security and granting permissions directly
to jrun from within processexplorer,but can't see anything there, nor the CF
MX 7 server logs

-Colm


-----Original Message-----
From: database-bounces@list...
[mailto:database-bounces@list...]On Behalf Of Snake
Sent: Friday, March 03, 2006 3:49 PM
To: 'Allan Cliff - CFUG Spain'; 'database programming'
Subject: [work] RE: [CF-Database] Sql Server 2000 connectivity issues



I would suggest downloading filemon from sysinternals, as I expect something
is being denied somewhere, and this will tell you what.

Russ

-----Original Message-----
From: database-bounces@list...
[mailto:database-bounces@list...] On Behalf Of Allan Cliff -
CFUG Spain
Sent: 03 March 2006 15:26
To: database programming
Subject: Re: [CF-Database] Sql Server 2000 connectivity issues


The same problem that I had.
It was impossible to fix and had to use the ODBC connection instead of the
SQL connection in CF Admin.

Sorry can't be of more help. I tried SP4 updates for SQL and all CFMX 7
updates and followed all the intsructions by MM but to no avail.

Allan
----- Original Message -----
From: "Colm Brazel" <c.brazel@ntlw...>
To: "database programming" <database@list...>
Sent: Friday, March 03, 2006 1:52 PM
Subject: RE: [CF-Database] Sql Server 2000 connectivity issues


>
> thanks for that,
>
> Still getting this message."The root cause was that:
> java.sql.SQLException:
> [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database
> requested
> in login '/mylogical/northwnd.mdf'. Login fails."
>
> Looked at
> http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19518 and
> tried to give the service cfmx in windows firewall, as it suggests, port
> external and internal 8500. I'm using the CF MX 7 with internal
> webserver,however it gives an error, 'port already in use by another
> programme'. However, I've deleted all firewall references to CF and this
> port! Later I'll check if jrun or something else used by CF is locking
> this
> port. In the windows services panel have stopped restarted CF
> and windows firewall and 'remote procedure call' apparently windows
> firewall
> uses this as well. Also checked logon characteristecs of RPC and Windows
> Firewall to windows authentication to see if this made a difference, no
> luck
> yet with this.
>
> Colm
>
> -----Original Message-----
> From: database-bounces@list...
> [mailto:database-bounces@list...]On Behalf Of Snake
> Sent: Friday, March 03, 2006 11:03 AM
> To: 'database programming'
> Subject: [work] RE: [CF-Database] Sql Server 2000 connectivity issues
>
>
>
> If you are running XP SP2 then this affected database connectivity when u
> have everything on the local machine.
> You should search the MM site for solutions to the XP sP2 and SQL server
> problem.
>
> Russ
>
> -----Original Message-----
> From: database-bounces@list...
> [mailto:database-bounces@list...] On Behalf Of Colm Brazel
> Sent: 03 March 2006 10:17
> To: database programming
> Subject: [CF-Database] Sql Server 2000 connectivity issues
>
>
>
> Hi,
>
> XP pro, CF MX 7 developer edition, Sql Server 2000 developer edition and
> for
> some PITA reason I can't connect to northwind.mdf database. I've set up a
> password/username with security policy in SQL 2000 and set MSSQLServer
> services to log on from local system account(windows), checked file
> permissions, enabled the port/firewall in windows. In ODBC datasource
> administrator I can configure/setup and connect to northwind but though
> this
> is set up, CF MX 7 still won't connect giving log on message errors. I've
> looked at hotfixes particularly interested in hotfix for sequelink ODBC
> drivers as 'ODBC access in Macromedia ColdFusion MX is provided through
> the
> use of the DataDirect SequeLink Server software', but the hotfix won't
> install due to a file it can't find! Likewise a hotfix, service pack 3 for
> SQL Server 2000 complains because it can't find an instance of the server.
> The server is running with a default instance and I can see/connect
> through
> it to northwind.
>
>
> Regards
>
>
> Colm
>
>
> ---
> avast! Antivirus: Outbound message clean.
> Virus Database (VPS): 0609-2, 03/02/2006 Tested on: 3/3/2006 10:17:17 AM
> avast! - copyright (c) 1988-2004 ALWIL Software.
> http://www.avast.com
>
>
>
> --
> For details on ALL mailing lists and for joining or leaving lists, go to
> http://list.cfdeveloper.co.uk/mailman/listinfo
>
> --
> CFDeveloper Sponsors and Supporters:-
>>- Hosting provided by www.cfmxhosting.co.uk -<
>>- Lists hosted by www.Gradwell.com -<
>>- supporters:- www.apycom.com :  www.proworkflow.com -<
>>- CFdeveloper is run and managed by Russ Michaels, feel free to
>>volunteer your help -<
>
>
> --
> For details on ALL mailing lists and for joining or leaving lists, go to
> http://list.cfdeveloper.co.uk/mailman/listinfo
>
> --
> CFDeveloper Sponsors and Supporters:-
>>- Hosting provided by www.cfmxhosting.co.uk -<
>>- Lists hosted by www.Gradwell.com -<
>>- supporters:- www.apycom.com :  www.proworkflow.com -<
>>- CFdeveloper is run and managed by Russ Michaels, feel free to volunteer
> your help -<
>
> ---
> avast! Antivirus: Outbound message clean.
> Virus Database (VPS): 0609-2, 03/02/2006
> Tested on: 3/3/2006 12:52:21 PM
> avast! - copyright (c) 1988-2004 ALWIL Software.
> http://www.avast.com
>
>
>
> --
> For details on ALL mailing lists and for joining or leaving lists, go to
> http://list.cfdeveloper.co.uk/mailman/listinfo
>
> --
> CFDeveloper Sponsors and Supporters:-
>>- Hosting provided by www.cfmxhosting.co.uk -<
>>- Lists hosted by www.Gradwell.com -<
>>- supporters:- www.apycom.com :  www.proworkflow.com -<
>>- CFdeveloper is run and managed by Russ Michaels, feel free to volunteer
>>your help -<
>



--
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors and Supporters:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- supporters:- www.apycom.com :  www.proworkflow.com -<
>- CFdeveloper is run and managed by Russ Michaels, feel free to volunteer
your help -<



--
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors and Supporters:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- supporters:- www.apycom.com :  www.proworkflow.com -<
>- CFdeveloper is run and managed by Russ Michaels, feel free to volunteer
your help -<


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 0609-2, 03/02/2006
Tested on: 3/3/2006 5:35:24 PM
avast! - copyright (c) 1988-2004 ALWIL Software.
http://www.avast.com



--
For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors and Supporters:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- supporters:- www.apycom.com :  www.proworkflow.com -<
>- CFdeveloper is run and managed by Russ Michaels, feel free to volunteer your help -<