Re: MSDE, Laptop, Enterprise Manager where to start
From: Anthony Thomas (ALThomas_at_kc.rr.com)
Date: 01/28/05
- Next message: Jan Schustr: "Problem with extended procedure"
- Previous message: Marco Pais: "Database performance"
- In reply to: Siobhan Perricone: "MSDE, Laptop, Enterprise Manager where to start"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 28 Jan 2005 06:32:29 -0600
First of all, if you have per processor licenses or each laptop user uses a
SQL Server CAL, then each is entitled to install SQL Server Personal Edition
and replicate the database from the central SQL Server, Snapshot, Merge,
and/or Transactional. That was what the design of this edition was meant
for.
MSDE is an alternative to MS Access and as a royalty-free, redistributable,
back-end system for desktop, third-party, software providers. It has many
restrictions that are not placed on the Personal Edition. However, Personal
Edition requires you to use license in conjuction with the database(s)
hosted by the Standard or Enterprise Edition installation.
The Personal Edition install is located on the SE and EE distribution media;
however, Product Services can send you PE media in addition.
Sincerely,
Anthony Thomas
-- "Siobhan Perricone" <siobhan.perricone@nostatespam.vt.us> wrote in message news:n3rhv0lc1rth0vbgllpttchqb7hteecjuc@4ax.com... We've currently started using a new database for tracking drinking water test results. This database resides on our SQL server, for which we have two licences (there are two processors), plus several development licenses. The division would like it to be possible to load a snapshot of the database onto their laptops in order to take out into the field. This will be for information only, the field workers won't be updating anything in the database. I really can't see that I need to buy another full SQL server license to load onto these laptops. Did some poking around and it seems like MSDE 2000 is what I should be using here. So I'm trying to figure out how to set this puppy up. Right now I'm just trying to get MSDE loaded on my second computer and set up so I can work with it from the Enterprise Manager that's loaded on my first computer. In the Books Online I keep seeing references like this: "You can only use SQL Server Enterprise Manager with MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition, Standard Edition, or Enterprise Edition), " But I can't seem to find anything that tells me how to go about installing MSDE, and registering it as a server with Enterprise Manager. Originally I downloaded MSDE from the microsoft site and tried installing it using the command prompt on my second computer. I used switches to set the sapassword at that point. I was able to try registering the server (that is, the computer I'd installed MSDE on was seen readily by Enterprise Manager), but when I entered the password I'd set during installation and tried to add the server, I could never get it to connect. It just said "connection failed" with no explanation. So, thinking maybe I didn't "acquire" MSDE properly I uninstalled it and decided to ask the rest of you about this. Do any of you have any more information for how to go about doing this? I can't find anything that I recognize as helpful in Books Online. Thanks in advance for any assistance you can provide. :) -- Siobhan Perricone Systems Developer Vermont Agency of Natural Resources (my comments are my own, not my employer's)
- Next message: Jan Schustr: "Problem with extended procedure"
- Previous message: Marco Pais: "Database performance"
- In reply to: Siobhan Perricone: "MSDE, Laptop, Enterprise Manager where to start"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
