I tried to install the MSDE 2000A to have a copy of the SQL Server northwind datbase on my machine. When I was installing it I got an error that said the following......
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Set up will now exit"
Does any one know what I need to do to fix this?
-Thanks
Hello,
I am trying to install MSDE 2000A (by typing 'setup sapwd="ABC123"' in the command prompt), but receive the following error:
"Setup failed to configure the server. Refer to the server error logs and setup error logs for more information".
Has anybody ever encountered this before?
I dowloaded the MSDE 2000A and got an error when I was trying to install it. The error was as follows.......
" A strong SA password is required for security reasons. Please use a SAPWD switch to supply the same. Refer to readme for more details. Set up will now exit."
The read me wasn't much help.
Does anyone know what I need to do?......Thanks
What is going on with this program???
When I try to install it I get the error message:
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit."
Runing Win2k server, logged in as Administration.
Readme file says nothing about this
As usual, you can't find anything on M$ KB site.
I also tried the MSDE SP3 version - got the same results.
Hi, i tried to install MSDE 2000A sp3, but the installation wasn't seccessful.Can somebody help me and write me what I have to do to install MSDE 2000A sp3 with SQL authentification (and how can I add some user, database and table)?I'm using Win XP sp2, .NET Framework 1.1 and VS .NET 2003 (but I haven't got SQL Enterprise manager)Thank's
View 6 Replies View RelatedIs it possible to install MSDE 2000A as a local admin and then run it as a poweruser or do I have to have local admin rights when I run it as well?
Regards,
Carolina
Hi all
I am trying to install SQL server 2000a I install per the instructions but when I go to plesk to create a SQL database I get the following error message:
Unable to create database: Unable to create database-dependent object:Database Microsoft SQL server is not running.
I am running a Windows 2003 duel processor server.
I would also like to know if I can upgrade to service pack 3a from 2000a or do I need to install service pack 2 first.
Also should I install service pack 4?
Thanks
Cruiser859
Hello,
I have the following scenario. An application using SQL Server 2000 SP3 on the server side and clients using MSDE 2000A (SP3a) on the client machine. Since the client is offline quite often merge replication is used to keep the clients in sync.
Now we try to upgrade to SQL Server 2005 SP1. The publisher and distributor upgrade (on the same box) worked fine and all clients could still synchronize. Fine :-)
Now we try to upgrade the clients to SQL Express SP1. Now the problems start :-(
1) After the upgrade the entry within the Synchronization Manager is gone (we can overcome this by using sp_MSregistersubscription or by manually disable and enable Synchronization manager on the subscription properties)
2) Initial Synchronization (takes a long time but) works fine, if I apply changes to the subscriber or force a reinitialize all following synchronization will fail. With the following messages:
Error messages:
The merge process could not clean up the subscription to 'tstvmw23':'TestBase:'TestBase'. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200965)
Get help: http://help/MSSQL_REPL-2147200965
New request is not allowed to start because it should come with valid transaction descriptor. (Source: MSSQLServer, Error number: 3989)
Get help: http://help/3989
Remark the test system I use is a nearly empty db (only with full schema and a few lookup tables) with 15MB. The same error occures if I create a new database an subscribe to the same publication.
Please help otherwise I'm forced to step back to MSDE.
Thanks in advance,
Thomas Hotz
Someone please tell me how to install MSDE. I am somewhat unfamiliar with the command prompt - I'm using XP Professional. I need to set "SAPWD."
I have tried "setup SAPWD="" security=SQL" but I don't believe I'm doing it right.
Hi:
I'm just getting started with ASP.net and am trying to install MSDE. I am getting the error message : Instance specified name is invalid.
I have followed the directions in the downloadpage. Any help??
Thanks
Crystal.
I am running Windows XP Pro. When trying to install MSDE, sql2ksp3, i go to the command line and enter:
setup SAPWD=somegreatpassword SECURITYMODE=SQL and off it goes, gathering information and starting to install.
After a short period of time where the status bar shows about 9 seconds left the status bar runs backwards down to zero and installation stops.
No error message, no crashes, just packs up its tent and goes away.
I have tried running setup from a batch file with the same results.
I have turned off my antivirus program as well as all other programs.
Need Input! - Thanks - T.C.
Ok I installed the MSDE and after following the steps the last message box says to go to the control panel and install and configure the components.
I'm not sure what to do once I'm in the control panel.
Thank you.
I followed all instructions, then I got an example from microsoft on creating a database, it isjust a visual basic example, it has a button create database and it says sql server not found but i can see it on the tray that it is running and using the web interface i can see the databases so i dont know why doesnt the microsoft created example doesnt work.
Thank you
Hi All,
I need help installing MSDE. I am using Windows XP. When I download it and try to set the password with the Command Prompt, it doesn't work. When I setup XP my username became the Admin. When I open the Command Prompt, it defaults into my documents and setting - I can't get a C: prompt. My login is the Admin and the old Administrator account isn't listed anywhere on my computer. Am I screwed? Do I have to reinstall XP and have the seperate Admin account? Please help.
Thanks,
Tony
Hello All:
I am having a problem with installing MSDE. I do not have SQL Server 2000 installed on my computer, but I am getting the error, "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same..." If I am not running SQL Server, how can I get an SA password so I can complete the install. Thanks for the help in advance.
- Jesse Williams
I've downloaded sql2ksp3. After I have extracted the file, I found MSDE folder and I ran the setup.exe. Halfway through the installation, it says the instance name specified is invalid.
Does anyone know how to fix this? Thanks.
Hi, are days that i'm trying to install MSDE on my computer (windows XP service pack 1).
The problem is that when I run the setup program from console using SAPWD="(Some password)" SecurityMode=SQL, it fails with that error log:
-------- LOG START
2003-08-15 17:56:13.12 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
2003-08-15 17:56:13.12 server Copyright (C) 1988-2002 Microsoft Corporation.
2003-08-15 17:56:13.12 server All rights reserved.
2003-08-15 17:56:13.12 server Server Process ID is 3076.
2003-08-15 17:56:13.12 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQLLOGERRORLOG'.
2003-08-15 17:56:13.14 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2003-08-15 17:56:13.18 server SQL Server configured for thread mode processing.
2003-08-15 17:56:13.21 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2003-08-15 17:56:13.29 spid3 Warning ******************
2003-08-15 17:56:13.29 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2003-08-15 17:56:13.87 spid3 Starting up database 'master'.
2003-08-15 17:56:15.76 server Using 'SSNETLIB.DLL' version '8.0.766'.
2003-08-15 17:56:15.76 spid5 Starting up database 'model'.
2003-08-15 17:56:15.87 spid3 Server name is 'ALEX'.
2003-08-15 17:56:15.87 spid3 Skipping startup of clean database id 5
2003-08-15 17:56:15.87 spid3 Skipping startup of clean database id 6
2003-08-15 17:56:15.87 spid3 Starting up database 'msdb'.
2003-08-15 17:56:17.18 spid5 Clearing tempdb database.
2003-08-15 17:56:18.70 server SQL server listening on Shared Memory.
2003-08-15 17:56:18.70 server SQL Server is ready for client connections
2003-08-15 17:56:21.43 spid5 Starting up database 'tempdb'.
2003-08-15 17:56:22.56 spid3 Recovery complete.
2003-08-15 17:56:22.56 spid3 SQL global counter collection task is created.
2003-08-15 17:56:22.93 spid3 Warning: override, autoexec procedures skipped.
2003-08-15 17:56:36.48 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
-------- LOG END
if anybody can help, I would really appreciate!
Alex.
I must be doing something wrong here, i have downloaded msde and when i run the set up i get this error
The instance name specified is invalid.
Any ideas
Hi, I am trying to teach myself ASP.NET from the SAMS 24 Hrs book and I am trying to install MSDE for use with the web matrix project.
I think I succesfully installed it the first time I tried but entered a four digit SAPWD password not knowing it needed to be strong. I clicked on the data tab in the web matrix project as instructed to open the database and entered my user and password but it gave me some error message.
Now when I click the data tab it say I need to install MSDE on my computer and links me to www.asp.net.
Then when I try to install MSDE after it has downloaded, it gives me this error message. ----- 'Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.'---
I have tried uninstalling and reinstalling everything as well as everything else I can think of.
I would be forever grateful if someone could help me out with this.
Many Thanks
Mark
E-Mail: poolstar_uk@hotmail.com
after uninstalling my msde now i am not able to reinstall it. In logfile message in "failed due to stop my service of control manager".
i couldnot understand it means.
plz help.
I've running MSDE on a win xp box with SP2. The SQL server service manager indicates that the SQL server is running. I'm using Visual Studio 2003. According to the install page for 101 VB and C# Code Samples I should install the .NET frameword samples db.. See http://www.microsoft.com/downloads/details.aspx?FamilyId=08E3D5F8-033D-420B-A3B1-3074505C03F3&displaylang=en
I cd to the appropriate dir and run osql -E -S (local)NetSDK -i InstNwnd.sql (the cmd given on the page noted above). I get the following error:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:Documents and SettingsPhilip Toews>cd C:Program FilesMicrosoft Visual Stud
io .NET 2003SDKv1.1SamplesSetup
C:Program FilesMicrosoft Visual Studio .NET 2003SDKv1.1SamplesSetup>osql -
E -S (local)NetSDK -i InstNwnd.sql
[DBMSLPCN]SQL Server does not exist or access denied.
[DBMSLPCN]ConnectionOpen (Connect()).
C:Program FilesMicrosoft Visual Studio .NET 2003SDKv1.1SamplesSetup>
I'm a newbie to .NET and SQL server so this makes no sense to me. If the SQL server service manager indicates that the SQL server is running why do I get that error and what is the work around?
Thanks .NET great ones for helping a newbie get off the ground...
:-)
Sorry if this seems to be very basic question. But after 5 hours I am thinking may be I am missing something.
I had always setup the dbs in server environment and I had never any issues but on my new Vaio Laptop with XP. Last time it was rather easy and I can not remember such issues. I downloaded (MSDE 2000) Release A from Microsoft and setting it up.
I set it up with the with the same parameters using an .ini file, I used Notepad to create a file named MyParameters.ini with these contents:
[Options]
INSTANCENAME="MSSQL"
TARGETDIR="D:MSDE"
SECURITYMODE=SQL
Then run Setup using the /settings switch to point to the .ini file:
setup /settings "MyParameters.ini" SAPWD="MyStrongPassword"
I find that my Visual studio is showing the instance at "Vaio/MSSQL" where Vaio is my Laptop. The setup created a folder in D:MSDEMSSQL$MSSQL and not in the target directory MSDE!!
Also my enterprise manager can not find it at all.
Also In visual studio I dont seem to be able to connect using my sa_password.
Any help is very much appreciated.
Salar
Hi,
(After having extracted SQL2kdesksp3.exe, and opened a command promt, navigate to the MSDE subdirectory.)
When I enter the "Type Setup SAPWD=(Some password) SecurityMode=SQL" command line, I have an error message : "The instance name specified is invalid".
Can someone explain why this happen?
Thanks a lot for the answers.
Bye.
I get the following message and I am not in safe mode
any ideas
The windows installer service could not be accessed. This can occur if you are running Windows on safe mode or if the Windows installer is not correctly installed. Contact your support personnel for assistance.
When a double click setup.exe, I get the following message:
“SQL Server 2000 Desktop Engine Setup
SQL Server 2000 Desktop Engine cannot be installed on this
computer. This product requires Microsoft Windows NT Version 4.0 Service Pack 5
or higher. Please download the service pack from www.microsoft.com prior to installing.�
My machine is running Windows 2000 5.00.2195 Service Pack 4.
Anyone knows how to solve this problem?
Hi All,
I'm trying (and have been for ages) to install a MSDE server with a
different instance name than the default. Im setting the
instancename when using the setup.exe file and all seems to install
fine, but when I then restart my system the SQL icon appears in the
system tray but the white circle is completely empty. It says
that it is not connected.
If i install with the default instance name then all seems to work fine.
Does anyone know what I am doing wrong and what I can do to fix this problem?
Thanks in advance for any help!
Does anyone have any experience or knowledge what would be best way of installing msde with vb application
I created vb app with msde database , right now app uses sql server, iam planning to move sql database to msde and distribute that with vb app. What would be best approach for distributing and installing those files? Does vb package deployment will do the trick or I should acuire some professional setup program ??
Thanks
Robert
I am new to MSDE and want to deploy it in my company (because it is free).However, when I install it in a W2K professional machine, there is a messagebox saying that a "strong SA password is required". How can I solve theproblem?Arthur Cheung(The MSDE engine was downloaded from the microsoft sql server web page)
View 1 Replies View RelatedI am in the process of preforming backwards compatibility testing inside our software with our sql statements. In the past we have run into problems where we write our SQL code in 2005 and SQL 2k cannot handle that code. (ie: nested sub selects within the select statement) I want to maximize effiency and install MSDE 2k on my Vista test machine but i have heard rumors that this could be potentially bad. Also if anyone has done this can you explain how to set the instance name if you already have sql 2005 installed? I would assume this would be done in the setup.ini in the MSDE folder before launch. If this cannot be done i can certainly put a XP test machine online for me to dial into and install MSDE 2k as well but it would have an existing 2005 session on it and i would need to find out how to name the instance before msde installed.
Thanks in advance
-Loryn
I'm having problems installing MSDE on a windows XP maching. Running setup with the verbose script gives me this:
Property(C): OriginalDatabase = C:MSDERelASetupSqlRun01.msi
Property(C): UILevel = 3
Property(C): ACTION = INSTALL
=== Logging stopped: 04/09/2007 14:17:38 ===
MSI (c) (A4:AC) [14:17:38:817]: Note: 1: 1708
MSI (c) (A4:AC) [14:17:38:817]: Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.
MSI (c) (A4:AC) [14:17:38:828]: Grabbed execution mutex.
MSI (c) (A4:AC) [14:17:38:828]: Cleaning up uninstalled install packages, if any exist
MSI (c) (A4:AC) [14:17:38:828]: MainEngineThread is returning 1603
This is just the last little bit I can post the whole thing if necessary. The installation stops and rolls back anyone have any idea what's causing this to fail? The server service is started and running normally.....
HELP! this is driving me mad!!
I installed MSDE desktop with no problems... months later when creating a database, I stupidily forgot the "sa" password that I set during setup... So I decided to unistall MSDE and reinstall it, this time documenting the username and password... BUT now it is giving me errors which I am unable to solve... is there anyone out there that might be able to help me??
I go to a command-line, locate the directory where the install program lives and type in "setup SAPWD=(a password) SecurityMode=SQL" and it returns the follow error message:
"Setup Failed to configure the server. Refer to the server error logs and setup error logs"
My problem is I don't know where to locate these error logs. Please if anyone can help me with this problem I would greatly appreciate it.
thanks, Donald - email = pizzazzz@cox.net
Hi. I am taking a certification class for which I recieved MSDE 2000 SQL server to use. I had a version that came with my textbook installed, and uninstalled it to use this one. Now I can no longer install either version, when I try it gives me a "instance name specified is not valid" error message when I start the installation, then kills it. Anyone have any ideas?
View 1 Replies View RelatedHi Guys,
I am Access user of both BE and FE. I would like to set my BE with SQL
Therefore, as trial I just downloaded MSDE2000A.Exe a Desktop SQL Engine from Microsoft. I need to install it. But due to some technical aspect (which I might not understand) I could not install it. Bcz whenever I am trying to install its setup file, it ask me a strong password. How to set it ? or how to supply it I dont know...
Any help.
Regards,
Ashfaque