sql server access

[lamynes03]

can I run sql server from xp pro and have access to the data from my website
running on the same system?

I can get my site fine, but can't seem to access my data when I use my web
address. I can access it perfectly when I view it from my server.

Paul

[The ScareCrow]

Have you installed sp2 for xp ?

If so, you have to install sp3 for sql server after installing sp2 for xp

You can then have problems with the xp firewall, you will need to have a look
at this link.

[url]http://www.docs.com/HelpFiles/WindowsXPServicePack2Fix.htm[/url]

But yes you can do what you want.

Ken

[lamynes03]

I am running sql server 7, does that apply? I have norton firewall and my
router firewall, xp's firewall is disabled since I am running norton.

I am configuring the ports for sql server to run on both the router and
through norton. It's somewhat confusing, but I think I have those two
configured to allow my sql server to have access.

It seems that if I can see my site from the localhost and connect to my data,
then I should also be able to if I connect to it through the actual web address?

I am learning anyway....

Paul

[The ScareCrow]

What port have you given access to in your firewalls ?

What tool are you using to develop in ? Can you access the sql server through
this ?

Have you created a dsn in the cf administrator ?

Just because you can view the pages from the web server, does not mean cf can
access the db server.

Ken

[lamynes03]

right now I am using the 1433 tcp and 1434 udp, also with coldfusion I do have
the dsn running and it's verified/working fine.

I am on the edge with the development tools, coldfusion cfc for scripting,
flash front end with webservices to connect to my cfc. All the is working
great, coldfusion is running with iis and all is well.

I just can't get my data to come through when I access through the www
address.

Paul

[lamynes03]

would I need to have the update for sql still?