This is my last attemp at trying to install sql server installed, which its been quite reluctant too, as I've spent the last 2 hours with no progress.
I've downloaded MSDE2000A.exe from http://www.microsoft.com/downloads/details.aspx FamilyId=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en
Installed it in the default directory. "C:\MSDERelA"
And ran setup which returned this error "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"
So, I started reading the readme more carefully.
I dont have Device signing in my advanced network connection settings.
I dont have a Local Security Policy in my Administrative Tools
I have a more current version of windows installer
Running win xp (home) and all in english
I open the folder in cmd and run the line "
setup SAPWD="AStrongPassword" TARGETDIR="C:\Sql" changeing AStrongPassword to my own password
It installed a bunch of files in that folder and now any other comman given by the readme returns a error
I dont see how sql server is running. Not in program files, not in task list.
Where do i go from here
sql server 2000
ooKmonkey
Hi,
is there a service present in the SCM (Service Control Manager), if yes try to start it. If the start is not successfull, paste the event log messages in here to see what happened.
HTH, jens Suessmeyer.
---
http://www.sqlserver2005.de
---
DesX
Paul Nast
I installed the instance as 'ED' and i did change the password, and i dont know what SCM means sorry.
Ricardo_AG
John371393
builder_ed
Ok,
so you got two instances running on your machine, on is the default instance, the other one is the named instance. Did you run the setup with the instance name "Edward" If so, here are another links which might help you further.
http://support.microsoft.com/kb/810826/en-us
As you posted no error log within your threads, read this article and try lto get a log which will tell us more information about the problem you are facing:
http://www.aspfaq.com/show.asp id=2440
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
Mike95
I need this installed with the pubs tutorial database for a class. Please help me figure this out.
KlausHolster
Hi,
http://www.aspnet101.com/aspnet101/tutorials.aspx id=44
http://support.microsoft.com/default.aspx scid=KB;EN-US;Q324998
http://support.gfi.com/manuals/en/lanselm4/installingmicrosoftdataengine.msde..htm
HTH; Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
Lacia
Setup.exe /upgradesp SQLRUN INSTANCENAME=instance_name
results in.
"Please go to controll panel to install components"
And i get none of the errors on the second page,
CloudNine
maybe im not doing this right its like sql server doesnt exist on my pc. it not in add or remove programs its not in my services or applications. if it wasnt for the icon in the task bar i would think it was never installed.
please help me I need like a idiot proof guide to installing a database i can read off vb because nothing i find on the internet is any help at all
ReidDesign
"MSSQL$EDWARD"
"MSSQLSERVER"
"MSSQLServerADHelper"
"SQLAgent$EDWARD"
"SQLSERVERAGENT"
Dave Berkowitz
perhaps we should take that offline. But anyway, you did the install of the MSDE in the default instance, but the /upgradesp swith is done with an instancename which is as far as I can remember form the sp the named instance, which you don’t how as I suppose. Try to get a list of the services assiciated with SQL Server (should be MSSQLSERVER or MSSQL$SomeInstanceName) in your SCM and pst this back. There we can see wheter you installed a default / names or no instance at all.
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
edvo
"setup /upgradesp sqlrun INSTANCENAME= InstanceName SECURITYMODE=SQL UPGRADEUSER=SA UPGRADEPWD=YourSAPWD DISABLENETWORKPROTOCOLS=1"
"Sql server 2000 is not installed on this machine"
MeercatMilker
SCM means Service Control Manager, which can be found under Start --> COntrol Panel --> Adminstrative Tool --> Services
-Jens.