Re: Sharepoint Installation MSDE Location Question

Yes,

Sorry to be so confusing, I want to host the SQL Server and WSS on the
same box, and I want to store the SQL database on a storage array
connected to our file server.

I will be using SQL Server 2005 or any other latestest version as the
company I work for is a Microsoft Partner.



On Dec 3, 5:36 pm, "Daniel Bugday" <itkons...@xxxxxxxxx> wrote:
Trip..

If I understand you correctly.. you wan't to store the Database files (.mdf
and .ldf) on a remote shared folder?

You cannot store the database in this way.. you need a SAN or some other
kind of shared storage for this to work..

Are you going to use a free version of SQL or do you have a full version?

/Daniel Bugdayhttp://www.sharepointforum.com/http://www.sharepointforum.com/en-US/Blog/default.aspx

"trip" <crystal...@xxxxxxxxx> wrote in message

news:6e5127ff-c712-46cc-86e6-0729d4c1db1b@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



On Dec 3, 11:03 am, Mike Walsh <englantilai...@xxxxxxxxxxx> wrote:
Yes. There's no problem with that.

It's easier to start with SQL Server 2005 so you don't need to do it,
but there are instructions around as to how to do it.

For instance here

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1144

Mike Walsh

trip wrote:
On Dec 3, 3:01 am, Mike Walsh <englantilai...@xxxxxxxxxxx> wrote:
You can't have your database accessed as a share.

You can locate it on another server in the domain as Daniel has said,
but that server must then be running full SQL Server 200x.

The "MSDE" (wrong name - right name is "Windows Internal Database" or
WID) database can only be installed a part of the Basic WSS 3.0
installation on the server on which you have WSS 3.0

Mike Walsh
WSS FAQhttp://www.wssfaq.com
No private e-mail questions please

trip wrote:
On Dec 1, 7:22 pm, "Daniel Bugday" <itkons...@xxxxxxxxx> wrote:
The SharePoint Content and Configuration is stored in a database
which could
be SQL 2000 SP4 or higher. You could also use Express Edition of SQL
2005 or
let SharePoint install a Windows Internal Datbase (WID). You choose
where
the database is going to be located in the installation.
Follow this guide for the
installation:http://www.sharepointforum.com/en-US/Wiki/Forms/DispForm.aspx?ID=11
/Daniel
Bugdayhttp://www.sharepointforum.com/http://www.sharepointforum.com/en-US/B...
"trip" <crystal...@xxxxxxxxx> wrote in message
news:c866b65e-3f86-4eb8-b78d-e7c1b26ec8f4@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,
I have a very basic HP ML110 I woudl like to install sharepoint on
to
host my company's Intranet.
Our data is stored on another file server, along with some other
items.
Can I map a network drive to that server and create a folder called
MSDE database, share the folder and give everyone read writes to it
and during the Sharepoint 3.0 setup I will create the MSDE database
on
that PC?
Basically, I do not want to store the database on the ML110 as it's
not reliablit (e.g no raid) I want to store the database on another
network storage location so it can get backed up as well.
My concerns is permissions.
Let me know,
thanks.- Hide quoted text -
- Show quoted text -
This would be if I was using something like SQL. I basically want to
have the MSDE database stored on my file server in a share, and I
want sharepoint to access it from there.
Or they any special share permission considerations?- Hide quoted
text -
- Show quoted text -

Thanks,

One more question can I right now have the internal database on the PC
and then later migrate to SQL?

Thanks,- Hide quoted text -

- Show quoted text -

Thanks,

I think what I am going to do is, I am going to install WSS 3.0 & SQL
Server on the same PC. I will store the SQL database on our storage
array, so it'll will be on a shared folder, will that work:?

I am getting from what your saying is, I should have one server for
Intranet and one for SQL.- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • Re: Problems with querying date field
    ... >> If you want to put a database somewhere for safekeeping, ... database - SQL isn't about persistence, ... says nothing about the physical storage media to be used. ... store data on a tape, or a disk, or a CD, or a file, or any physical ...
    (microsoft.public.sqlserver.programming)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
Quantcast