all groups > sql server msde > april 2006 >
You're in the

sql server msde

group:

How do I make use of SQL Express on a website?



How do I make use of SQL Express on a website? Mike
4/7/2006 10:36:01 AM
sql server msde: Hi All,

How do I make use of SQL Express on a website?

I am trying to make some first steps with SQL express and need some
hand-holding. I have supported a plain-vanilla html website for some
time and I am trying encourage the owners of the website to move to at
least some database-related functionality that will relieve me of a lot
of the day-to-day updates.

The website is currently on Apache but can and must be moved to IIS if
we want to use asp (or any db/scripting) (they do not support php and
won't allow me to use their Oracle db). They suggested that if we move
to the IIS server I would have to use an Access db as that can be
deployed in isolation with the app.

Is there any reason I cannot use SQL Express instead?

I apologize for my ignorance as I typically just deal with application
development and don't manage much on the database side other than
connecting.

Mike
Re: How do I make use of SQL Express on a website? Andrea Montanari
4/8/2006 12:00:00 AM
hi Mike,
[quoted text, click to view]

actually there's no reason you can not move to SQLExpress... obviously do
protect the database server.. do not directly expose it to the Internet as
IIS should be the only connection point...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

AddThis Social Bookmark Button