Hello,

For some reason the search function is not working for me, and google returns too many hits about not what I am looking for...

short answer question:

Vista seems to have a version of sql server running on it by default... is this version sufficiently capable of running db apps? (like sql server express)

...or do I need to install sql server express to make this happen? (with the thought that the version included on vista is too stripped down to serve databases)

Thanks!

What's the built in App called? I don't see it on my installation of Vista.

Yeah, I didn't have any prior to installing the Accounting 2007 basic. I wonder if you have a program that is using SQL Express for its backend.

Hi there,

I read up on this last night, do you have Outlook 2007 installed? Because I know that Outlook now uses the sql server express engine rather than Jet (about time too imo).

In any case I doubt you will be able to use it to serve other databases, but certainly worth trying it out, get some sql server manangement tools on your machine and see if you can register the installation.

Yes, this is a Vista system with the new Office 2007 installed. Perhaps that is what I was looking at. It had the sql server configuration area installed, but little else, which was weird.

I couldn't add any new db's after loading the management console so I (uninstalled the mgt console) and pulled down the express version (then reinstalled the mgt console) and this seemed to do the trick.

Thanks for your help guys!

...as a side note, when attempting to install the sql server enterprise edition from our MSDN library (pre-SP2 version, which apparently vista needs) it was a nightmare - standard roles/principals not installed/errors galore...

So I pulled all that off, and went with the online sql server express version and it all came to life.

Thanks again folks.