Hi Jim,
Oay, I'm a little confused. When you say "Im have installed the desktop
engine" I am going to guess that by "the desktop engine" you're referring to
MSDE. That much I can guess. "on a local machine" is kind of fuzzy, though.
Local to what? Your home or office? Is your office an ISP office, or just
your office? And when you say "so a user can run SQL locally" I have to
wonder what "a user" is, and what "run SQL locally" means. That is, are you
talking about someone walking into your office, using the "local machine"
and running MSDE on the machine on which it is installed? That would not be
a problem. But if you mean a user somewhere in the cloud, I have to wonder
how you plan on having them "run SQL locally."
So, I'm going to take my best guess, and correct me if I'm wrong as I
rephrase your question:
You've installed MSDE on some machine that is local to you. You want someone
in your office to be able to use it in a web site that they are publishing
from either the same machine or some other machine on the same LAN.
Apparently, that person or yourself is creating some ASP page on that
machine, and when they publish the web (to some unknown destination, whether
server-based or file-based web site, you didn't say). When they do so, they
get an error, either during publishing, or when running the ASP page (you
didn't specify) that says something about ASP not running. It would help if
you posted the exact error, and provided the details I've been trying to
fill in.
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.