Connecting to MSDE

[RenWeb Bob]

I have just upgrade to CF MX 7 on my development laptop where I have MSDE
installed. When I am in Cold Fusion Administrator it cannot verify the
connections for any of my datasources to my MSDE databases. I found in the
documentation that Trusted connections are no longer used but when I change the
server from (local) to 127.0.0.1 it did not connect I have also tried localhost
to no avail. I checked the port number of 1433 and that is correct.

Any help would be appreciated.

[PaulH *TMM*]

RenWeb Bob wrote:

> I have just upgrade to CF MX 7 on my development laptop where I have MSDE
> installed. When I am in Cold Fusion Administrator it cannot verify the
> connections for any of my datasources to my MSDE databases. I found in the
> documentation that Trusted connections are no longer used but when I change the
> server from (local) to 127.0.0.1 it did not connect I have also tried localhost
> to no avail. I checked the port number of 1433 and that is correct.

if i recall correctly, msde default installs using windows
authentication. you need to reset it to use both (windows & sql)as
that's what cf's JDBC driver uses. sorry i don't know the details
concerning hwo to make this switch.