[horde] MSDE SQL Create Script

[Jeff Graves]

Also just submitted README instructions (#1870). For those not running HEAD:

MSDE 2000 (& possibly MS SQL Server)
~~~~~~~~~~~~~~~~~~~~~~~

This applies to Windows users only!

To create user and database, use the osql command:

C:\>osql -U sa -P admin_password -S localhost -i create.msde.sql

Be sure to change the password for the horde user in the script file. To
specify a 
particular instance of the SQL server use the <servername>/<instance> for
the -S flag.
If you aren't using mixed SQL authentication, then you'll need to modify the
script 
to associate the horde user with a windows user account and run the script
in the 
following manner as the Administrator:

C:\>osql -E -S localhost -i create.msde.sql

If you're having problems running this script on a SQL server on the
network, be sure
the server is set up to allow network access.

The script and directions may work with MS SQL Server but I don't have a
license or install so I can't test it.

Jeff Graves, MCSA
Customer Support Engineer
Image Source, Inc.
10 Mill Street
Bellingham, MA 02019

508.966.5200 - Phone
508.966.5170 - Fax
jeff at image-src.com - Email
www.image-src.com

-----Original Message-----
From: horde-bounces at lists.horde.org [mailto:horde-bounces at lists.horde.org]
On Behalf Of Jeff Graves
Sent: Monday, April 25, 2005 6:31 PM
To: horde at lists.horde.org
Subject: Re: [horde] MSDE SQL Create Script


Ticket# 1862

It's the free version of MS SQL Server:

http://www.microsoft.com/sql/msde/

Jeff Graves, MCSA
Customer Support Engineer
Image Source, Inc.
10 Mill Street
Bellingham, MA 02019

508.966.5200 - Phone
508.966.5170 - Fax
jeff at image-src.com - Email
www.image-src.com

-----Original Message-----
From: horde-bounces at lists.horde.org [mailto:horde-bounces at lists.horde.org]
On Behalf Of Chuck Hagenbuch
Sent: Monday, April 25, 2005 6:20 PM
To: horde at lists.horde.org
Subject: Re: [horde] MSDE SQL Create Script


Quoting Jeff Graves <jeff at image-src.com>:

> I'd like to submit the following SQL script for MSDE. I'm putting together
a
> Win32 tutorial (like Mike Cochrane had) for IIS, MSDE, PHP, and Horde. I'm
> hoping to put together an entire installer package but that's down the
> road...

Please create an enhancement ticket on bugs.horde.org for this. Also, 
what's MSDE? Related to MSSQL?

-chuck

-- 
"But she goes not abroad in search of monsters to destroy." - John 
Quincy Adams
-- 
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe at lists.horde.org


-- 
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe at lists.horde.org