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 Release A

Dear Experts,
I heard that MSDE Release A removes the limitation of 7 concurrent
queries that affect MSDE when too many users connecting to the system at
the same time. Is this correct?
Thank you very much
No, Release A does not make any changes to the Query Governor. You are
probably confusing this with SQL Server 2005 Express Edition which replaces
MSDE. Express does not have a Query Governor.
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
news:OspP3bHVGHA.5332@.TK2MSFTNGP10.phx.gbl...
> Dear Experts,
> I heard that MSDE Release A removes the limitation of 7 concurrent queries
> that affect MSDE when too many users connecting to the system at the same
> time. Is this correct?
> Thank you very much
sql

MSDE Release A

Dear Experts,
I heard that MSDE Release A removes the limitation of 7 concurrent
queries that affect MSDE when too many users connecting to the system at
the same time. Is this correct?
Thank you very muchNo, Release A does not make any changes to the Query Governor. You are
probably confusing this with SQL Server 2005 Express Edition which replaces
MSDE. Express does not have a Query Governor.
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
news:OspP3bHVGHA.5332@.TK2MSFTNGP10.phx.gbl...
> Dear Experts,
> I heard that MSDE Release A removes the limitation of 7 concurrent queries
> that affect MSDE when too many users connecting to the system at the same
> time. Is this correct?
> Thank you very much|||Thank you very much. This answers my question

MSDE Release A

Dear Experts,
I heard that MSDE Release A removes the limitation of 7 concurrent
queries that affect MSDE when too many users connecting to the system at
the same time. Is this correct?
Thank you very muchNo, Release A does not make any changes to the Query Governor. You are
probably confusing this with SQL Server 2005 Express Edition which replaces
MSDE. Express does not have a Query Governor.
--
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
news:OspP3bHVGHA.5332@.TK2MSFTNGP10.phx.gbl...
> Dear Experts,
> I heard that MSDE Release A removes the limitation of 7 concurrent queries
> that affect MSDE when too many users connecting to the system at the same
> time. Is this correct?
> Thank you very much|||Thank you very much. This answers my question

MSDE OSQL Utility

Dear all,
I have a question about the OSQL utility and the installation of MSDE. I
tried to install MSDE and SQL Server on the same machine. This should work
some people told me. As a result however my application is no longer showing
me the available servers on the machine. (laptop).
I removed everything and reinstalled only MSDE.
When I use the OSQL utility and enter OSQL -L it says there are no servers.
Should it not say which server is available.
Has anyone experienced this before. My system is no longer showing the
available servers. My application still seems to work because when I type in
the name of the server manually it is located.
How can I solve this problem.
regards,
Danny Gaethofs
hi Danny,
"Danny Gaethofs" <dangaet@.home.nl> ha scritto nel messaggio
news:uAGDu0P4EHA.2404@.TK2MSFTNGP14.phx.gbl
> Dear all,
> I have a question about the OSQL utility and the installation of
> MSDE. I tried to install MSDE and SQL Server on the same machine.
> This should work some people told me. As a result however my
> application is no longer showing me the available servers on the
> machine. (laptop).
> I removed everything and reinstalled only MSDE.
> When I use the OSQL utility and enter OSQL -L it says there are no
> servers. Should it not say which server is available.
> Has anyone experienced this before. My system is no longer showing the
> available servers. My application still seems to work because when I
> type in the name of the server manually it is located.
> How can I solve this problem.
> regards,
> Danny Gaethofs
MSDE installs by default disabling network protocols in order to minimize
external (malicious) attacks, preventing the installed instances to be
available for remote connections and disabling it's broadcast enlisting for
available SQL Server/MSDE instances...
to make it available for remote users and to enable server enlistment you
have to use Server Network Utility (svrnetcn.exe) and enable the
desired/preferred network protocol(s)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE NewBie

Dear all I did this.
I installed client version of SQL 2000 to connect to my server
(I can connect to my server and access the database there).
I installed MSDE2000RelA on my Win ME PC. Installation all
went smooth,(no errors). How do I use MSDE now. In the
enterprise manager I dont see any reference to MSDE. Am
I missing something. pls help
Joy -
Here is what you need to do.
First thing first , the network libraries are not enabled in MSDE by default
if it is a NAMED INSTANCE. In order to enable the libraries -
- Go to the Server Network Utilities of SQL Server from the Start Menu.
- Select the MSDE Instance from drop down list
- enable Named Pipes, TCP-IP and Shared Memory
- highlight TCP-IP and go to its Properties.
- if MSDE is a default instance then set the port number to 1433, but if it
is not a default instance then set the Port Number to 0. This will enable
dynamic port allocation.
- apply the above changes.
- close all client tools including Enterprise Manager and Query Analyser
- restart MSDE
- after restarting , Open Enterprise Manager
- right click on the SQL Server Group Icon, and select NEW SQL SERVER
REGISTRATION.
- give the details of the MSDE Instance.
You should be able to see the MSDE Instance in the EM . try connecting to
MSDE from Query Analyser.
This should help.
Regards
Pragya
"Joy H" wrote:

> Dear all I did this.
> I installed client version of SQL 2000 to connect to my server
> (I can connect to my server and access the database there).
> I installed MSDE2000RelA on my Win ME PC. Installation all
> went smooth,(no errors). How do I use MSDE now. In the
> enterprise manager I dont see any reference to MSDE. Am
> I missing something. pls help
|||Just to add to my previous posting, the MSDE by default does not get
registered in the Enterprise Manager. ...
"Joy H" wrote:

> Dear all I did this.
> I installed client version of SQL 2000 to connect to my server
> (I can connect to my server and access the database there).
> I installed MSDE2000RelA on my Win ME PC. Installation all
> went smooth,(no errors). How do I use MSDE now. In the
> enterprise manager I dont see any reference to MSDE. Am
> I missing something. pls help

msde license

dear all,
can develop use msde to connect the testing server to implement without buy
any license or CAL
MSDE doesn't include the client tools so it won't help you connect to a
Standard or Enterprise server. For development and testing purposes you can
purchase Developer Edition for US$50.
David Portas
SQL Server MVP

msde license

dear all,
can develop use msde to connect the testing server to implement without buy
any license or CALMSDE doesn't include the client tools so it won't help you connect to a
Standard or Enterprise server. For development and testing purposes you can
purchase Developer Edition for US$50.
David Portas
SQL Server MVP
--

msde license

dear all,
can develop use msde to connect the testing server to implement without buy
any license or CALMSDE doesn't include the client tools so it won't help you connect to a
Standard or Enterprise server. For development and testing purposes you can
purchase Developer Edition for US$50.
--
David Portas
SQL Server MVP
--

MSDE installation problem in Windows XP

Dear All,
We have been facing problems in installing MSDE 2000 in machines having
Windows XP. The installation starts and then after sometime it retraces back.
The error seems to be because of something related to SQLAgentSecurity.
I am attaching the error log details ( the portion which mentions about the
error) below.
Has anyone faced any similar issues? Can anyone help?
Regards,
Ani
Error log details
Starting custom action DisableNetAccess()
Ending custom action DisableNetAccess()
Action 17:11:59: WriteEnvironmentStrings. Updating environment strings
WriteEnvironmentStrings: Name: PATH, Value: c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\, Action 1610612738
Action 17:11:59: RegisterTypeLibraries. Registering type libraries
RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-00AA004A34D5}
RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-00AA004A34D5}
RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-00AA004A34D5}
Action 17:12:03: InstallServices. Installing new services
Action 17:12:04: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
Action 17:12:05: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action CallSQLAdHlp
c:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe : 0
Action 17:12:06: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B.
Action 17:12:06: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (BSTRAW001A,LocalSystem,87).
Action ended 17:12:07: InstallFinalize. Return value 3.
Action 17:12:07: Rollback. Rolling back action:
Rollback: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B
Rollback: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action UnInstSQLAgentSecurity
Starting custom action UnInstSQLAgentSecurity
Rollback: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B
Rollback: Installing new services
Rollback: Registering type libraries
Rollback: Updating environment strings
Rollback: DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B
Rollback: Writing system registry values
Rollback: Unregistering program identifiers
Rollback: Registering Class servers
Rollback: Creating shortcuts
Rollback: Creating duplicate files
Rollback: InstallSqlRedis.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: NoRebootReplace.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: RollbackNoRebootReplace.2D02443E_7002_4C0B_ABC9_EA B2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action NoRebootReplace
TempFolder Property is C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\
Source Dir Property is C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\SqlSetup\Temp
Rollback: InstallDTC.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Rollback: Copying new files
Rollback: Creating folders
Rollback: Removing ODBC components
Rollback: Deleting services
Rollback: Stopping services
Rollback: Updating component registration
Rollback: RollbackStreamSupportFiles.2D02443E_7002_4C0B_ABC9 _EAB2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\setupex.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqdedev.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlsut.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlunirl.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlresld.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.rll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.rll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
Rollback: RollbackDeferProperties.2D02443E_7002_4C0B_ABC9_EA B2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
Defer Properties returns: 0
Action ended 17:12:14: INSTALL. Return value 3.
Action ended 17:12:14: INSTALL. Return value 3.
=== Logging stopped: 4/28/2005 17:12:14 ===
MSI (c) (94:24): Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
hi,
Aniruddha wrote:
> Dear All,
> We have been facing problems in installing MSDE 2000 in machines
> having Windows XP. The installation starts and then after sometime it
> retraces back. The error seems to be because of something related to
> SQLAgentSecurity.

> InstallSQLAgentSecurity failed (BSTRAW001A,LocalSystem,87).
> Action ended 17:12:07: InstallFinalize. Return value 3.
you probably do not have File & Printer Sharing Services turned on.
please chek the control panel, Admin Tools - Services and (eventually) set
it to on.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE installation problem

Dear all,
I have a installation problem on MSDE and install to window 2000 server,
while installing MSDE, it shows error "1607: Unable to install InstallShield
Scripting Runtime", then rolling back.
Does anyone experienced the same problem?
Thank you very much for any suggestion.
Hi
Are you running the setup whilst logged in as Administrator or a user with
administrator privileges?
Regards
Mike
"kpler" wrote:

> Dear all,
> I have a installation problem on MSDE and install to window 2000 server,
> while installing MSDE, it shows error "1607: Unable to install InstallShield
> Scripting Runtime", then rolling back.
> Does anyone experienced the same problem?
> Thank you very much for any suggestion.
|||Already login by administrator account
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Are you running the setup whilst logged in as Administrator or a user with
> administrator privileges?
> Regards
> Mike
> "kpler" wrote:
|||Hi
http://consumer.installshield.com/kb.asp?id=Q108340
Regards
Mike
"kpler" wrote:
[vbcol=seagreen]
> Already login by administrator account
> "Mike Epprecht (SQL MVP)" wrote:
|||Hi
Also:
Make sure you have the Windows Installer Service enabled and set to manual:
Browse to Control Panel > Administrative Tools > Services.
Verify that the Windows Installer Service is enabled.
If the Windows Installer Service is disabled, set it to Manual.
Refer to InstallShield? Knowledge Base Article - Q107094, ERRDOC: Run-time
Error 1607, for more information.
Regards
Mike
"kpler" wrote:
[vbcol=seagreen]
> Already login by administrator account
> "Mike Epprecht (SQL MVP)" wrote:
|||Checked service enabled, and i can install MDAC, but still can't install MSDE.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Also:
> Make sure you have the Windows Installer Service enabled and set to manual:
> Browse to Control Panel > Administrative Tools > Services.
> Verify that the Windows Installer Service is enabled.
> If the Windows Installer Service is disabled, set it to Manual.
> Refer to InstallShield? Knowledge Base Article - Q107094, ERRDOC: Run-time
> Error 1607, for more information.
> Regards
> Mike
> "kpler" wrote:
|||"kpler" wrote:
> Checked service enabled, and i can install MDAC, but still
> can't install MSDE.
> "Mike Epprecht (SQL MVP)" wrote:
> set to manual:
> Services.
> Manual.
> ERRDOC: Run-time
> &nbsp;> > Already login by administrator account
> &nbsp;> >
> &nbsp;> > "Mike Epprecht (SQL MVP)" wrote:
> &nbsp;> >
> &nbsp;&nbsp;> > > Hi
> &nbsp;&nbsp;> > >
> &nbsp;&nbsp;> > > Are you running the setup whilst logged in
> as Administrator or a user with
> &nbsp;&nbsp;> > > administrator privileges?
> &nbsp;&nbsp;> > >
> &nbsp;&nbsp;> > > Regards
> &nbsp;&nbsp;> > > Mike
> &nbsp;&nbsp;> > >
> &nbsp;&nbsp;> > > "kpler" wrote:
> &nbsp;&nbsp;> > >
> &nbsp;&nbsp;> > > > Dear all,
> &nbsp;&nbsp;> > > >
> &nbsp;&nbsp;> > > > I have a installation problem on MSDE and
> install to window 2000 server,
> &nbsp;&nbsp;> > > > while installing MSDE, it shows error
> "1607: Unable to install InstallShield
> &nbsp;&nbsp;> > > > Scripting Runtime", then rolling back.
> &nbsp;&nbsp;> > > >
> &nbsp;&nbsp;> > > > Does anyone experienced the same problem?
> &nbsp;&nbsp;> > > > Thank you very much for any suggestion.
I am currently experiencing the same problems with installing MSDE.
I have checked everything above.
The server that i am trying to install onto is a domain controller.
I have previously installed on servers which are not domain
controllers without problems.
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/MSDE-install...ict198031.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=706597
|||"jharwood" wrote:
> I am currently experiencing the same problems with installing
> MSDE.
> I have checked everything above.
> The server that i am trying to install onto is a domain
> controller.
> I have previously installed on servers which are not domain
> controllers without problems.
I have cracked this one on the Domain controller.
See this link:
http://www.sepialine.com/kb/read/?1151
Had to change the PDC to the original domain controller, at some point
in the past we added a DC and that new one took over as the Primary.
Good Luck

MSDE Installation failure in Windows XP

Dear all,
during an MSDE installation by a client on windows XP SP1, as well as SP2,
occurs the following error:
"InstallSQLAgentSecurity failed (IP45,LocalSystem,87)"
After this error message in the log file, one could see that the entire
installation is rolled back. The user doesn't get any message.
The server service is on.
On a windows XP SP1 by me the same installation process works fine. The
specified client has normally high security standards and it's the first time
that an MSDE is installed by them.
Any help would be highly appreciated!
Thanks in advance for the help,
Avi Joshua
CRM systems consultant
LOGO consult AG
Head office
Enzianstrasse 4a
82319 Starnberg am See
Germany
mailto:avi@.logo-consult.de
tel +49 (0700) 100 55 100
Hi Avi,
Check that Sharing is enabled on the system.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Avi Joshua" <Avi Joshua@.discussions.microsoft.com> wrote in message
news:CFA84BD4-18A8-4AC4-8AEE-B065ED28E77E@.microsoft.com...
> Dear all,
> during an MSDE installation by a client on windows XP SP1, as well as SP2,
> occurs the following error:
> "InstallSQLAgentSecurity failed (IP45,LocalSystem,87)"
> After this error message in the log file, one could see that the entire
> installation is rolled back. The user doesn't get any message.
> The server service is on.
> On a windows XP SP1 by me the same installation process works fine. The
> specified client has normally high security standards and it's the first
time
> that an MSDE is installed by them.
> Any help would be highly appreciated!
> Thanks in advance for the help,
> Avi Joshua
> CRM systems consultant
> LOGO consult AG
> Head office
> Enzianstrasse 4a
> 82319 Starnberg am See
> Germany
> mailto:avi@.logo-consult.de
> tel +49 (0700) 100 55 100
>
|||Thanks, Greg!
The file and printer sharing component was not installed on the computer.
Have a pleasant weekend,
Avi

MSDE installation - newbie problem

Dear all,

I have this problem with MSDE Installation:

I install MSDE then from prompt c:\sql...\msde\
I type: setup INSTANCENAME=pippo SECURITYMODE=SQL SAPWD=pp
then I restart but I see on the toolbar the icon of the SQL server but Ihaven't any Server or Service, in the Icon there is not the green signal nether the red signal, the little circle is white.

what I need to do?

thanks,
lucaHi Luca,

What version of Windows is this?

Don|||Windows XP Pro.

Now I unistall MSDE and Re-install it and now is ok.

Is the 1st time I use MSDE and I'd like t know wath's the use of SAPWD ?
and I need to indicate in the SETUP SAPWD=... etc. also uid= ?
and uid wath's

thanks,
luca|||I'm having the same problem. I'm using Windows 2000 Professional.

I do have the SQL Server 2000 CLIENT Tools installed on my computer, but as far as I know, those are just for connecting to SQL db's, it's not the actual engine; that's why I want MSDE on my machine. Would those client tools be conflicting with my MSDE installation?|||I've tried uninstalling it and then reinstalling it...

When I double click the little server icon in the tray and I go to hit the green play button, there are no services in the dropdown menu to start.

Anyone know how to solve this?|||Hi Luca,

The SAPWD switch lets you set the sa (system administrator, SQL Server's superuser) password which you shouldALWAYS do because of worms that have taken advantage of it.

uid is user id, the user you can use to log into MSDE.

Don|||Hi Matt,

I'm not sure I understand what you're saying about having the SQL Server client tools installed. You can use those to connect to and manage the engine of any SQL Server or MSDE installation on the local machine or across the network that you have permissions to access.

Do you mean that those don't include the database engine? If so, yes, that's right. So you would indeed want to install MSDE in order to use databases locally. And no, the client tools won't conflict with your MSDE installation at all.

I don't know why you aren't getting any services listed. If you go into Computer Management from the Control Panel do you have MSSQLSERVER listed under Services and Applications | Services? If so, can you start it from there?

This could be because you already had the client tools installed when you installed MSDE. So you probably have to add a registration to the local MSDE. Go into Enterprise Manager, expand Microsoft SQL Servers in the treeview, right-click on SQL SErver Group and select New SQL SErver Registration from the popup menu. In the available servers select either LOCAL (it might say LOCALHOST) or the machine name. If it isn't listed, type it in. Then complete the other steps in the wizard.

Does that solve it?

Don|||Don:

Since my last post I UNinstalled MSDE. You did clear up a lot for me though. I was unsure if the Client Tools were somehow conflicting, but now I know they won't.

I'll REinstall MSDE and register it in Enterprise Manager and see what happens.

Thanks for your help!

MSDE install

Dear Everybody,
When i am installing MSDE 2000 Release A on Windows XP Professional System.
It gives me Error "Invalid Instance Name".
What I done wrong please help me.
Ashok
hi,
Ashok wrote:
> Dear Everybody,
> When i am installing MSDE 2000 Release A on Windows XP Professional
> System. It gives me Error "Invalid Instance Name".
>
can you please provide the command line you passed to the setup.exe boostrap
installer?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 BLANKSAPWD=1
Here the instance name is NetSDK.
Once you are instlled successful with this instance name NetSDK, if you want
to install again with the same instance name, you need to remove instance.
"Ashok" wrote:

> Dear Everybody,
> When i am installing MSDE 2000 Release A on Windows XP Professional System.
> It gives me Error "Invalid Instance Name".
> What I done wrong please help me.
> Ashok
>
>

MSDE Environment

Dear all,
i'm new in MSDE, yet, after i'd installed for MSDE ReleaseA which i
get from SQL web site, i realise that I can't run the MSDE without
fully SQL server install, may i know that whether i can run MSDE
without fully SQL SERVER install? if so, how to use it...
pls give me some guide on that, thanks in advance!! :wink:
MSDE IS Sql Server, and does not need full SQL Server installed (otherwise,
why MSDE?). MSDE Download does not come with good document on how to install
it properly for user who does not have experience on SQL Server. I recommend
search MS Knowledge base with key word "MSDE" to get get more detailed
installation guide.
"themafia907" <themafia907@.yahoo-dot-com.no-spam.invalid> wrote in message
news:JMSdnRvJOr2GFYTfRVn_vA@.giganews.com...
> Dear all,
> i'm new in MSDE, yet, after i'd installed for MSDE ReleaseA which i
> get from SQL web site, i realise that I can't run the MSDE without
> fully SQL server install, may i know that whether i can run MSDE
> without fully SQL SERVER install? if so, how to use it...
> pls give me some guide on that, thanks in advance!! :wink:
>
|||Hi
When you run the MSDE Setup, it installs the SQL Server MSDE Edition Engine.
No tools are supplied with MSDE.
Full editions of SQL Server is not required to run MSDE. MSDE is an stripped
down Edition of SQL Server.
What are you trying to achive?
Regards
Mike
"themafia907" wrote:

> Dear all,
> i'm new in MSDE, yet, after i'd installed for MSDE ReleaseA which i
> get from SQL web site, i realise that I can't run the MSDE without
> fully SQL server install, may i know that whether i can run MSDE
> without fully SQL SERVER install? if so, how to use it...
> pls give me some guide on that, thanks in advance!! :wink:
>