MSDE Toolkit issue with windows 98

Hello,
My 1st attempt to install .Net framework, MSDE, my application and the databases during setup (using the MSDE deployment toolkit RC) works fine on windows xp. Now when I try to do the same for windows 98 SE machine, I am able to install .Net framweork an
d MSDE, but after that during the installation I get the following error message:
"An exception occured in the OnAfterInstall event handler of DBInstaller.CustomInstaller --> Unable to access service: Operating system does not support controlling a Windows service. A service can only be controlled on Windows NT, Windows 2000, or lat
er."
It's clear that when the setup tries to start the service to create the database etc it fails. Is this a known issue. I researched on web but couldn't find anything. Any ideas.
Thanks
dev
Any ideas..

MSDE sharepoint databases how to import and export

Dear all,
I have a Intranet running the sharepoint version which
comes with Frontapage 2002 and MS desktop SQL 7.
My server have a problem and I have to upgrade it to MS
desktop SQL 2000A. Now my sharepoint databases don't work
anymore.
I was wondering if theere is a way to import them back
into the new MS DESKTOP SQL 2000A.
Thank you for any help
HI Renato,
ReadmeMSDE2000A.htm comes with your download of MS Desktop SQL 2000A. It
talks about the changes in this release. Your database doesn't work any
more probably due to the security change that requires strong password.
Empty sa passowrd is no longer accepted. If that is the case, you can
change your sa password by running this query: EXEC sp_password NULL,
'yourpassword', 'sa' and then replace in your code with the new password.
Hope this helps.
Amy
| Content-Class: urn:content-classes:message
| From: "Renato" <anonymous@.discussions.microsoft.com>
| Sender: "Renato" <anonymous@.discussions.microsoft.com>
| Subject: MSDE sharepoint databases how to import and export
| Date: Wed, 7 Apr 2004 07:34:13 -0700
| Lines: 13
| Message-ID: <19b6f01c41cad$65a1d0c0$a101280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQcrWWh/rvselubSzuv0Twjq4q0CQ==
| Newsgroups: microsoft.public.sqlserver.msde
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.msde:13479
| NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
| X-Tomcat-NG: microsoft.public.sqlserver.msde
|
| Dear all,
|
| I have a Intranet running the sharepoint version which
| comes with Frontapage 2002 and MS desktop SQL 7.
|
| My server have a problem and I have to upgrade it to MS
| desktop SQL 2000A. Now my sharepoint databases don't work
| anymore.
|
| I was wondering if theere is a way to import them back
| into the new MS DESKTOP SQL 2000A.
|
| Thank you for any help
|

MSDE publisher and subscriber with duplicated Identity column issues

I am new to SQL replication and I have an issue with the identity
column not properly synchronizing between two MSDE databases. I have
turned on the (not for replication) switch and changed the identity
seed and identity increment to be different on the subscriber, but as
soon as I pull the subscription it changes the seed back to the
original so both database are the same again. As both subscriber and
publisher are creating records, the identities are duplicated. I do
have Enterprise Manager installed to help configure the publishing,
but MSDE does not seem to allow the same control over the identity
range in replication as SQL 2000 does. How do I have a MSDE publisher
and a MSDE subscriber create records in different identity seeds
and/or increment?
What I am trying to accomplish:
Publisher -- seed 1, increment 2
Subscriber -- seed 2, increment 2
Or a similar function.
Thanks,
Daniel
Are you using replication's auto identity management feature. In SQL
identitites once a table is created you cannot change the identity increment
or the original seed. The only thing you can do is reseed to a value and SQL
with start inserting from that value onwards.
Thanks.
"Daniel" <dmaynes@.roinc.com> wrote in message
news:5ab2240f.0410061403.3923ef4a@.posting.google.c om...
> I am new to SQL replication and I have an issue with the identity
> column not properly synchronizing between two MSDE databases. I have
> turned on the (not for replication) switch and changed the identity
> seed and identity increment to be different on the subscriber, but as
> soon as I pull the subscription it changes the seed back to the
> original so both database are the same again. As both subscriber and
> publisher are creating records, the identities are duplicated. I do
> have Enterprise Manager installed to help configure the publishing,
> but MSDE does not seem to allow the same control over the identity
> range in replication as SQL 2000 does. How do I have a MSDE publisher
> and a MSDE subscriber create records in different identity seeds
> and/or increment?
> What I am trying to accomplish:
> Publisher -- seed 1, increment 2
> Subscriber -- seed 2, increment 2
> Or a similar function.
> Thanks,
> Daniel
|||I guess this is a newbi question, but how and when do I turn that on?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Daniel,
when you create the publication, on the article properties (the elipsis
button) there is a series of tabs, one called 'identity range'. The checkbox
at the top allows for automatic range management. Some people don't use it
and prefer to roll their own, using formulas like odds on the publisher and
evens on the subscriber.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Right, I found that. I guess the trick is that it has to be checked as
you build the publication, and can be modified, but not added
afterwards. Thank you very much.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

MSDE newbie question: contents of default databases

Having installed MSDE and connected to it, it seems there are several
default databases already:
master
model
msdb
tempdb
Are these intended to be for any specific use?
How do I get a list of the tables that are in these databases?
Simon Elliott http://www.ctsn.co.uk
hi Simon,
"Simon Elliott" <Simon at ctsn.co.uk> ha scritto nel messaggio
news:ureI8NzQEHA.1624@.TK2MSFTNGP09.phx.gbl...
> Having installed MSDE and connected to it, it seems there are several
> default databases already:
> master
> model
> msdb
> tempdb
> Are these intended to be for any specific use?
> How do I get a list of the tables that are in these databases?
in order to limit distribution size, MSDE only ships with system database
you do not have to touch =;-D
these databases are relatated to MSDE itself and are not user database...
if you like some sample database, you can install the Northwind and Pubs
demo databases from
http://www.microsoft.com/downloads/d...DisplayLang=en
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Merge Replication (feasibility and licensing)

I am new to replication and have a couple of questions.
My requirement is to keep several (2 - 10) databases in sync. My current thinking is to use MSDE, along with merge replication. I have determined from the documentation that MSDE has the features and capabilities to fulfil the data storage and retrieval
requirments.
1) Is merge replication possible among a number of MSDE databases across a network (no SQL Server involved)
2) Do any licenses have to be purchased? The documentation is a little inconsistent on this point.
Thanks a lot.
1) yes, but MSDE is optimized for 8 concurrent workloads
2) check out this link for MSDE licensing information
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
"JW" <anonymous@.discussions.microsoft.com> wrote in message
news:F861246B-EBDA-4EEA-8CA0-6077C3F5DBCD@.microsoft.com...
> I am new to replication and have a couple of questions.
> My requirement is to keep several (2 - 10) databases in sync. My current
thinking is to use MSDE, along with merge replication. I have determined
from the documentation that MSDE has the features and capabilities to fulfil
the data storage and retrieval requirments.
> 1) Is merge replication possible among a number of MSDE databases across a
network (no SQL Server involved)
> 2) Do any licenses have to be purchased? The documentation is a little
inconsistent on this point.
> Thanks a lot.
|||I must admit that I've never tested this, but as far as I
recall MSDE is throttled at 5 connections.
Regards,
Paul Ibison
|||Thanks for the replies.
1) I think that it's the number of concurrent batches that chokes MSDE, not the number of connections.
From "The SQL Server 2000 Workload Governor" at http://msdn.microsoft.com/library/?u...asp?frame=true :
"Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition and MSDE 2000 allow 32,767 connections to an instance of the database engine. There is no limit for the number of connections that can be executing operations at the same time. The on
ly effect of the workload governor is that it starts slowing down the database engine when more than eight operations are actively running at the same time."
2) Based on my research, it looks like no extra licensing is required if there is no connection to any of the 'regular' SQL Server editions:
From "HOW TO: Use Replication with SQL Server 2000 Desktop Engine (MSDE 2000)" at http://support.microsoft.com/4
"Licensing Issues
MSDE 2000 does not require any licensing when you use it in a stand-alone mode, but when you use it as part of a replication topology that involves regular SQL Server editions, if the server is in Per Seat mode as opposed to a Per Processor mode, each MSD
E 2000 Subscriber must have a client-access license (CAL).
For more information about SQL Server licensing, visit the following Microsoft Web site:
http://www.microsoft.com/sql/howtobuy/SQL2KLic.doc"
Again, thanks for your time.
Regards,
Joe
|||JW,
interesting. In the MS knowledgebase it mentions throttling after 5
concurrent connections:
MSDE 2000-Specific Limitations and Caveats
a.. MSDE 2000 limits the size of the database to 2 GB...
b.. The number of connections to MSDE 2000 is optimized for five
connections. This may affect the performance of replication if MSDE 2000 is
the Publisher and there are a enough Subscribers to the publication or if it
is a Subscriber to multiple publications.
see: http://support.microsoft.com/default...;en-us;Q324992
I have seen this 'limit' mentioned elsewhere, so the mentioning of 8 is
strange. I'll do some more research and see if we can get a definitive
answer.
Regards,
Paul Ibison

MSDE Memory Leak

My application attaches to, and detaches from many
databases. When I attach, the sqlservr process memory
usage goes up, and when I detach, it sometimes goes back
down, sometimes only partly, and sometimes actually goes
up. When my application exits, the sqlservr process never
releases the memory. Is this a bug? I'm using ADO15 and
I call Close() and Release() on all my connections and
recordsets. Is there something else I should be calling
to clean up the memory in MSDE?awolchinsky,
I don't think it's a bug. If it were, I'm sure it would have been fixed by
now via a service pack or whatever.
The mem usage behaviour you are seeing is not unexpected nor inappropriate
for an application server, which is essentially what MSDE is, being a
cut-down version of SQL Server. Typically, the server would grab as much
memory as is required to manage its workload for optimum performance,
subject to the limitations of the relevant operating system. What it
certainly *won't* do is release its allocated resources (memory) by default!
It wants to keep those resources so it's ready for next time... and no, it
doesn't care if you've got 20 other processes running on your box competing
for those resources - that's for the O/S to manage. This is why application
servers such as SQL Server are (usually) installed on a dedicated box......
You don't need to look at the memory allocation of the sqlserver.exe process
to determine whether your application (and your code) is satisfactory. As a
developer, you should assume that sqlserver.exe is fine and dandy and just
let it get on with doing whatever it's doing. You should concentrate on the
mem usage of your application.exe and any associated components that you've
coded/built etc .. if your app exits "cleanly" (ie your app.exe process
terminates and therefore releases all resources allocated to it) then you
have done your job.
--
--
Kind Regards,
Robert A. Ellis, MCSD
Software Developer
"awolchinsky" <awolchinsky@.bonders.com> wrote in message
news:04f401c35c6f$33c91fd0$a401280a@.phx.gbl...
> My application attaches to, and detaches from many
> databases. When I attach, the sqlservr process memory
> usage goes up, and when I detach, it sometimes goes back
> down, sometimes only partly, and sometimes actually goes
> up. When my application exits, the sqlservr process never
> releases the memory. Is this a bug? I'm using ADO15 and
> I call Close() and Release() on all my connections and
> recordsets. Is there something else I should be calling
> to clean up the memory in MSDE?|||Check the memoryleak FAQ entry and then post back if you think you still have
a leak.
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq|||Robert, thanks for the response. I agree now that it is
not a bug. And normally, I would only be concerned with
the memory usage of my app. But my app runs in the
background while our primary app executes. As sqlserver
eats up memory (200 MG), our main app, with through-put
requirements, slows down.
I did get some decent info from Microsoft. I set the 'max
server memory' to 20 MG, and that seems to hold the memory
usage down our 33 MG.
Thanks again.
Andy
>--Original Message--
>awolchinsky,
>I don't think it's a bug. If it were, I'm sure it would
have been fixed by
>now via a service pack or whatever.
>The mem usage behaviour you are seeing is not unexpected
nor inappropriate
>for an application server, which is essentially what MSDE
is, being a
>cut-down version of SQL Server. Typically, the server
would grab as much
>memory as is required to manage its workload for optimum
performance,
>subject to the limitations of the relevant operating
system. What it
>certainly *won't* do is release its allocated resources
(memory) by default!
>It wants to keep those resources so it's ready for next
time... and no, it
>doesn't care if you've got 20 other processes running on
your box competing
>for those resources - that's for the O/S to manage. This
is why application
>servers such as SQL Server are (usually) installed on a
dedicated box......
>You don't need to look at the memory allocation of the
sqlserver.exe process
>to determine whether your application (and your code) is
satisfactory. As a
>developer, you should assume that sqlserver.exe is fine
and dandy and just
>let it get on with doing whatever it's doing. You should
concentrate on the
>mem usage of your application.exe and any associated
components that you've
>coded/built etc .. if your app exits "cleanly" (ie your
app.exe process
>terminates and therefore releases all resources allocated
to it) then you
>have done your job.
>--
>--
>Kind Regards,
>Robert A. Ellis, MCSD
>Software Developer
>"awolchinsky" <awolchinsky@.bonders.com> wrote in message
>news:04f401c35c6f$33c91fd0$a401280a@.phx.gbl...
>> My application attaches to, and detaches from many
>> databases. When I attach, the sqlservr process memory
>> usage goes up, and when I detach, it sometimes goes back
>> down, sometimes only partly, and sometimes actually goes
>> up. When my application exits, the sqlservr process
never
>> releases the memory. Is this a bug? I'm using ADO15
and
>> I call Close() and Release() on all my connections and
>> recordsets. Is there something else I should be calling
>> to clean up the memory in MSDE?
>
>.
>

MSDE integration with VB. NET

I have VB. NET
I want to build SQL databases on my own PC using VB and
MSDE.
No matter how many ways I install it or passwords I use,
I just cannot get read/write access from witihn VB. I
have upsized the Northwind.mdb.
There seems to be a multidude or service packs for MSDE
and numerous ways of entering passwords.
Could osmeone please just give me a setp by step account
of installing MSDE (with all relevant switches and
passwords), getting a SQL instance on MSDE running and
visible on the manager, upsizing the access database
(with all relevant passwords - what the hell is a trusted
connection?), and then be able to create a view from the
Server Explorer in .NET.
I've been slaving over this for the past two days and
it's driving me nuts. Please help maintain my sanity.
Thanks
Guy
Hi ,
Following are the various parameters available for installing msde along
with examples:
Most installations of MSDE 2000 Release A are made using only these Setup
parameters:
Parameter Description
SAPWD="AStrongPassword" Specifies a strong password to be assigned to the
sa administrator login.
INSTANCENAME="InstanceName" Specifies the name of the instance. If
INSTANCENAME is not specified, Setup installs a default instance.
Other parameters often used to tailor an installation are:
Parameter Description
DISABLENETWORKPROTOCOLS=n Specifies whether the instance will accept
network connections from applications running on other computers. By
default, or if you specify DISABLENTWORKPROTOCOL=1, Setup configures the
instance to not accept network connections. Specify
DISABLENETWORKPROTOCOLS=0 to enable network connections.
SECURITYMODE=SQL Specifies that the instance be installed in Mixed Mode,
where the instance supports both Windows Authentication and SQL
Authentication logins.
DATADIR="data_folder_path" Specifies the folder where Setup installs the
system databases, error logs, and installation scripts. The value specified
for data_folder_path must end with a backslash (\). For a default instance,
Setup appends MSSQL\ to the value specified. For a named instance, Setup
appends MSSQL$InstanceName\, where InstanceName is the value specified with
the INSTANCENAME parameter. Setup builds three folders at the specified
location: a Data folder, a Log folder, and a Script folder.
TARGETDIR="executable_folder_path" Specifies the folder where Setup
installs the MSDE 2000 executable files. The value specified for
executable_folder_path must end with a backslash (\). For a default
instance, Setup appends MSSQL\Binn to the value specified. For a named
instance, Setup appends MSSQL$InstanceName\Binn, where InstanceName is the
value specified with the INSTANCENAME parameter.
When you use DISABLENETWORKPROTOCOLS=0 to enable network support for an
instance of MSDE 2000, applications connecting to the instance over a
network use Microsoft Data Access Components (MDAC). All versions of
Windows supported for use with MSDE 2000 include a version of the MDAC
software that works with MSDE 2000 Release A.
* A trusted connection means the login used to login used to log on to the
machine is the same used by all the applications on the machine for any
authentication mechanism.
Hope this provides you with an answer
Girish sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.

MSDE install problem

I've been using Jet databases for my websites for quite some time. I was
going to try MSDE a year or so ago but there were some limitations to it
back then that prevented me from using it.
After subscribing to the newsgroup yesterday and reading some of the posts I
saw the limitations had been removed in the recent release. So I decised to
download and install it.
I am now trying to install, but I get this error each time...
"The instance name specified is invalid"
I havent specified any instance name, so I don't know what to do.
I'm using WinXP-Pro.
Any ideas what the problem is ?
Thanks,
PW
On Sat, 17 Apr 2004 06:41:11 +0800, "PW" <pwa@.NObigSPAMpond.net.au>
wrote:

>I've been using Jet databases for my websites for quite some time. I was
>going to try MSDE a year or so ago but there were some limitations to it
>back then that prevented me from using it.
>After subscribing to the newsgroup yesterday and reading some of the posts I
>saw the limitations had been removed in the recent release. So I decised to
>download and install it.
>I am now trying to install, but I get this error each time...
>"The instance name specified is invalid"
>I havent specified any instance name, so I don't know what to do.
>I'm using WinXP-Pro.
>Any ideas what the problem is ?
Do you already have SQL server installed? If you don't specify an
instance name, it uses the default which is the same as SQLServer.
Also, check your registry key,'HKLM\Software\Microsoft\Microsoft SQL
Server', value 'InstalledInstances'.

MSDE hosting

Hi all!

One good thing about access databases is the ability to upload the .mdb file to a hosting server and not being charged for database space.

How about MSDE? Does it require SQLServer hosting or can it be done just by uploading the database file?

Thanks,
Ricardo

MSDE is smaller version of SQL server. It is good for development but when you want upload web files and database you will need SQL server. There is a lot of hosting companies offering hosting plan with SQL support for less than $10/m

MSDE Help

I have never done anything with databases, so I am a newbie. My goal is to install an ASP.NET forum, but I need MSDE installed. I downloaded MSDE from the Microsoft website. When I run the setup.exe file, I get an error. It says:

A strong SA password is required for security reasons. Please use SAPWD switch to supply
same. Refer to readme for more details. Setup will now exit.

I looked at the documentation but could not find anything usefull, what do I have to do to install it. Thanks in advance for responses.Did you try the instructions here?Installing MSDE For ASP.NET Web Matrix Also, if you follow links from there you are led toInstalling a New Instance of MSDE 2000 SP3a which may also help.

Terri|||ok, I followed the instructions, but got yet another error.

The Windows Installer Service could not be accessed. This can occur if you are running Windows in safe mode, or if the Windows Installer is not correctly installed. Contact your support personnel for assistance.

well, I am not in safe mode, I guess my Windows Installer is not correctly installed, I don't know why that would be. Does anyone know how I can fix this problem.

MSDE for Testing, SQL Server for Deployment...?

I'm going to be starting a web application this week. I have quite a bit of experience with Access Databases, and I've also used MySQL (back in my PHP days, thank GOD for ASP.NET).
The server we use to host our websites allows us to use SQL Server databases, so I want to move in that direction, but I'm not really sure where to start.
If I download MSDE, and start a database with it on a site I will be developing locally (on my XP box), will it be difficult for me to transfer the database (or layout of the database) to a production server running SQL Server. I know they're basically the same database, but I'm just afraid to start with an MSDE database and then get the site nearly complete, and then not know how to transfer it to a SQL Server DB.

I'm particularly interested to know if the majority of the database creation will be done through queries (similar to MySQL) because I figure if it is, then I can use the same queries to create the database on both the local and production server.

I just want to make sure that downloading MSDE will be a step in the right direction.

Perhaps links or tutorials or some information on things to watch out for as I take on this process would be so greatly appreciated.

Thanks very much.The same code that works on MSDE will work fine on SQL Server. You can use queries to create tables/views/stored procedures, or you can use Enterprise Manager or Visual Studio .NET (presuming you have the correct version - I am not sure what version is required of VS.NET to do DB work).|||Thanks for your reply douglas.reilly
Now if I am creating with queries, what's the best way to go about doing that exactly? Should I create a page that executes the query I type into a textbox? Or is there a better (probably more secure and reliable) way of doing it?

Thanks again for your help!