Dear all,I have XP pro as Operating system.I installed Webmatrix, downloaded SQL 2000 desktop (sql2ksp3), run the command prompt in the directory where dir MSDE of sql2ksp3 was as so: setup.exe SAPWD=hello INSTANCENAME=RMSI lat the installation ran and I got msg that installation ran successfully. So far, so good. From WebMatrix, I tried to add a database connection within a project. When I select SQL-database and click on OK, I get the error message that SQL server administration requires SQL client installed on my machine. In Control Panel - AddRemove Programs, I see indeed that there is no MSSQLserver or client mentionned.I check also the services. The only one I have is SQLADHelper that starts manually. I must have to do with XP security, right... Can someone please please help me. I am a newbie and only want to learn ASP and VB programming via Matrix and Visual Studio IDE.Thanks in advance!Christiane
I have a copy of MS Visual Studio 2002 Professional ACADEMIC which Iunderstand is the same as the regular Professional version with theaddition of a student CDROM. The installation program on the firstCDROM only copies the MSDE to the harddrive and the copied setup filehas to then be manually executed to complete the installation.Are the SQL tools such the SQL Enterprise Manager and MS Queryincluded in the professional version? If so, how can I install thesetools? The course that I am taking uses these tools to study SQL. Ifnot, how is the MSDE to be used?
I try to install MSDE as a new instance (SQL2) on my computer with Windows 2000 Professional, but a problem occurs and instalaltion does not complete successfully. I am an administrator of the computer. The application log contains the following errors descriptions: "The SYSTEMCurrentControlSetServicesMSSQL$SQL2Perfo rmance key could not be opened or accessed in order to install counter strings.The Win32 status returned by the call is in the Record Data as DWORD 0. " and "Installing the performance counter strings for MSSQL$SQL2 failed. The Error code is DWORD 0 of the Record Data. "
I think most of the visitors here are experts of SQL 7.0. But I am a absolutely new one. So I may ask some very foolish questions.
I plan to learn how to use MS SQL 7.0 recently, but I don't know how to begin, can anybody here give me some good experience or material(websites) on learning SQL 7.0?
Also, I want to install SQL 7.0 in my home PC. should I install it with Win 2000 professional or Server version?
Hi, I am looking at installing SQL Server 7 on my PC which runs Windows 2000 Professional. Can anyone give me some advice before I do the installation of SQL Server 7. Any tips or any problems I might encounter.
This is my first time posting, so be gentle as I'm not exactly sure what the protocol here is regarding posting errors.
I'm encountering an issue with an installation of SQL 2005 Express (SQLEXPR_ADV.EXE) on a Windows 2000 Professional SP4 machine (Intel P4 1.8 Ghz). The following error is what I receive:
Setup.exe - Entry point not found:
The procedure entry point _create_local could not be located in the dynamic link library mscvr80.dll
< OK >
The following is what I see in the error log (C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles):
SQLSetup0007_SQL2005TEST_Core.log
Microsoft SQL Server 2005 Setup beginning at Wed Dec 06 11:28:08 2006 Process ID : 452 c:98b179fcf692887ac3setup.exe Version: 2005.90.2047.0 Running: LoadResourcesAction at: 2006/11/6 11:28:7 Complete: LoadResourcesAction at: 2006/11/6 11:28:7, returned true Running: ParseBootstrapOptionsAction at: 2006/11/6 11:28:7 Loaded DLL:c:98b179fcf692887ac3xmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2006/11/6 11:28:8, returned true Running: ValidateWinNTAction at: 2006/11/6 11:28:8 Complete: ValidateWinNTAction at: 2006/11/6 11:28:8, returned true Running: ValidateMinOSAction at: 2006/11/6 11:28:8 Complete: ValidateMinOSAction at: 2006/11/6 11:28:8, returned true Running: PerformSCCAction at: 2006/11/6 11:28:8 Complete: PerformSCCAction at: 2006/11/6 11:28:8, returned true Running: ActivateLoggingAction at: 2006/11/6 11:28:8 Complete: ActivateLoggingAction at: 2006/11/6 11:28:8, returned true Running: DetectPatchedBootstrapAction at: 2006/11/6 11:28:8 Complete: DetectPatchedBootstrapAction at: 2006/11/6 11:28:8, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__452" returned false. Running: PerformSCCAction2 at: 2006/11/6 11:28:8 Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435 Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435 Complete: PerformSCCAction2 at: 2006/11/6 11:28:8, returned true Running: PerformDotNetCheck at: 2006/11/6 11:28:8 Complete: PerformDotNetCheck at: 2006/11/6 11:28:8, returned true Running: ComponentUpdateAction at: 2006/11/6 11:28:8 Complete: ComponentUpdateAction at: 2006/11/6 11:45:55, returned true Running: DetectLocalBootstrapAction at: 2006/11/6 11:45:55 Complete: DetectLocalBootstrapAction at: 2006/11/6 11:45:55, returned true Running: LaunchLocalBootstrapAction at: 2006/11/6 11:45:55 Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 128 Aborting queue processing as nested installer has completed Message pump returning: 128
Notice the time jump; I did this to make sure I was looking at the right log file.
Any help is greatly appreciated as I'll be monitoring this thread closely. Searches of my error show that other people have received it as well, although no resolution has ever been forthcoming. Thanks in advance.
I installed MSDE and it would not let me login. I figured that I must have made a mistake when I initially installed the program so I uninstalled it and then tried to reinstall it but now an error comes up and tells me to check the "server error logs" and "setup error logs". I can find these error logs but I have no idea as to what to do with them. I have tried "system restore" but nothing seems to help. I have scowered this forum and have noted that others have had this problem but have yet to find a solution.
Hi I have installed .net framework 1.1 and .net web matrix from 'sams teach yourself asp.net' CD. I installed MSDE from the same CD, its not giving any error, but at the end it does not promt to restart the computer, even after restarting I can not see the MSDE icon in the system tray, also I dont see MSDE in the add/remove programs in control panel.I installed sql2kdesksp3.exe from www.asp.net/msde/, but the same thing repeats.
1. Shld I install the sql2kasp3.exe(Analysis services companents) and sql2ksp3.exe(Databasre components) also?
I am new to asp,It will be helpful if somebody can tell me how to install MSDE.
After upgrading MSDE 7 to MSDE 2000, when you log on to the server, it keeps trying to install. I have looked for the InProgress registry key, but it is not there.
I have tried to install MSDE 2000, first the normal version, then theone for developers using Visual Studio .NET. Each time the installationappears to complete, but there is no shortcut to start the program andit's not in the Start/Programs menu. However, if I look for it in "Addand Remove Programs" it's there.The directoryC:Program FilesMicrosoft SQL ServerMSSQLBinnincludes some exe files and I have tried to start them, but nothingappears to happen. If I start sqlsrvr.exe I get a command prompt windowin which I see things like "Server Process ID is 182", "Logging SQLserver messages in file..." etc, but I have no idea how to go on fromthere.I tried installing the new 2005 Beta version but exactly the sameproblem.Why is this happening? How can I make it work?Thanks in advance.Bruno Panetta
I have installed MSDE from the command prompt as instructed and get no error message - nor do I get the expected request to reboot. Since I know I must reboot to see MSDE launch, I did so, but it does not launch. It doesn't matter how many times I do this... Any ideas? I am attempting to do this on an XP machine with more than the requirements for doing so. Any help would be MOST APPRECIATED.
The Icon appeared in my task bar and I carried on with the Exercises.
My problem started when I tried to create my first data base.
Open Web Matrix Clicked on Data Tab in the Workspace pane Clicked on the new Connection Icon Server = LocaHost Clicked SQL Server authentication User Name = sa Password = ***** (As above)
However when I click on the "Create a new data base" link I get an Error
login failed for user 'sa'. Reason: Not associated with a trusted sql server connection.
I tried to look in the forum to see if I could find a reason however could not.
Decided in the end to uninstall using Start - Control panel - add & remove programs.
However now when I try and reinstall the installation fails.
I've been trying to install MSDE and I keep getting errors. The first time I ran set up command, I got an error saying the insntace name was invalid. I was using "SETUP SAPWD=[pass] SECURITYMODE=SQL" and it didn't work.
Then I uninstalled the whole thing and added the line "INSTANCE NAME=[something]" to the SETUP command, and MSDE installed "properly". But then when I clicked on the icon on the task bar to make the service active, I got an error message saying that no service could be associated to the MSDE.
Then I, again, I uninstalled the whole thing and tried to install it again. Now I'm getting the following error "Setup failed to configure the server. Refer to the server error logs and set up error logs for more information." Now, the funny thing is that when I go to "remove programs" I cannot even see the damn MSDE to uninstall it. I don't know what to do at this point: set up does't run and can't get rid of it.
I have been trying to install sql2kdesksp3 and am running into some problems. The initial install seems to go okay, even up to the point of issuing the Setup sapwd=password command-line command. However, when I try to install sql2kasp3 or sql2ksp3, a message appears saying that SQL 2000 is not installed.
I am on a XPPro SP1 desktop, with IIS 5.1 and .NET 1.1 Framework installed. Can anybody point me in the right direction to get MSDE installed?
I'd like to be able to install it to my D: drive. I've looked through all of the docs but I can't find any information on how to change the install path. Would anyone know how to do this?
First off, let me say it took me nearly all day to get this working. When you download the sql2decksp3.exe you might think it install like any other program. No. This exe simply unpacks the setup files. The actual setup program, setup.exe must be run from a DOS command prompt.... so you've got to look up the correct command line parameters in the sp3reademe.htm file. Something like:
No problem so far, but then when I go to run the setup.exe with the correct parameters the install goes fine until the last 5 seconds. Then hangs. Again and again. The install program keep getting hung up just before the finish. Each time I had to uninstall and reinstall-- 6 times. When if it hangs you've got to break out with the Task Manager, then do an uninstall from the Control Panel... if... an entry there was created. It usually is.
I tried everything I could think of and then did a search here. There were a few messages. The only one who actually got past this problem said he deleted all references for "Microsoft SQL" in the registry. I tried that too. It didn't work for me. That setup hung in the very same place. Then instead of breaking out and starting again, I tried shutting the machine down, while the setup was hung, thinking that maybe after a restart the installation might continue AND and that point the install completed.
Hope these notes help the next person who runs into the same problem. I also tried putting the modem on standby and disabling Norton anti-virus. Alone that did help, but when I tried all this stuff together... finally at 4:34 PM, I was able to establish a connection, from both VB.NET and with a great FREE MS SQL Manager at http://sqlmanager.net/products/mssql/manager/download
Now I can start. For some reason, the way I think... I can't do any coding until the entire database spec is first set up. Then you write all the add, edit, display and sort form, windows. When designing web applications, you design the database first, then each web form preforms some unique operation or reference on the remote database. I think that's the way it works.
I have a friend who has installed MSDE over SQL Server 6.5 - by doing so he broke some other apps that required a SQL 6.5 DB, he realises now it was a mistake on his part and would like to revert to SQL 6.5 again and recover his data, is this possible or has he lost all his old data?
I was trying to install the MSDE 2000 from the Office XP CD in Windows XP Pro. In the middle of the installation, it rolls back, does not give any message and the installation fails. :confused: What could be the problem? Please help me with this
I am trying to build a VB6.0 application with the msde as back end
I have just installed Windows 2000 Pro, Visual Studio 2003 Academic and , MSDE 2000. I get the little icon in the Service Tray(?) showing an empty circle partially overlaying a server symbol. It says Not Connected-VSDOTNET. If I click it and get SQL Server Service Manager and put in Server name of VSDOTNET, The drop down listbox for SERVICES is empty (no SQL Server choice) I enabled TCP/IP for this server thru SVRNETCN.DLL. I'm a newbie to pc development. Help!
I have to yet successfully install MSDE on my machine. I suspect there is installation lint from previous attempts, however for the life of me I can't seem to get it running.
Attached is my log file from the latest attempt. I am really stumped. Any help will be greatly appreciated.
I recently had to install 40 german NT 4 laptops with MSDE sp3.
I prepared a setup.ini file: [Options] DATADIR="C:ProgrammeMicrosoft SQL Server" TARGETDIR="C:ProgrammeMicrosoft SQL Server" SAPWD="AStrongPwd" SECURITYMODE=SQL
and installed most of them sucessfully. Some of them I installed via network, some of them were installed from CD. I tested each installation by copying a prepared database into the data directory and tried to connect to this database using the specified sapwd and found out When i installed from CD, I could connect to the databases. Some of the network installs produce a logon failure. it looks like the sapwd was ignored during install - I could not figure out, which password was used, I uninstalled it and reinstalled from CD.
Does anyone know what's the reason for this behaviour?
I installed MSDE SP3A with sapwd=abc123 instancename=msde_1. I went to services and started mssql$msde_1 and sqlagent$msde_1. In the system tray, I clicked the sql service manager. I put msde_1 in the server name and hit refresh services, but I get an error stating "The Network Path was not found".
Can someone give me a clue as to what I am doing wrong?
I'm new to MSDE and would like to use it with MSACCESS Projects.
The installation of MSDE fails and I dont find any solution to get itwork. If I start the setup than a windows with the time bar appears andsays it will take 1 minute. After nearly 1 minute it closes the windowand gives no additional information. But I see that it generates firstall the directories and files in c:Programme but after the setup is endeverything is deleted. Nearly everything , I see a service"MSSQLServerADHelper" is still installed.Must everytime delete it via regedit.I am using WindowsXP SP1 with MDAC 2.8I get this at the end of the generated protokollafter I start setup with"setup SAPWD="mypasswort" SECURITYMODE=SQL /L*v D:/MSDELog.log"Property(C): StartupFolder = C:Dokumente und EinstellungenAllUsersStartmenüProgrammeAutostartProperty(C): ProgramMenuFolder = C:Dokumente und EinstellungenAllUsersStartmenüProgrammeProperty(C): StartMenuFolder = C:Dokumente und EinstellungenAllUsersStartmenüProperty(C): DesktopFolder = C:Dokumente und EinstellungenAllUsersDesktopProperty(C): FontsFolder = C:WINDOWSFontsProperty(C): GPTSupport = 1Property(C): OLEAdvtSupport = 1Property(C): ShellAdvtSupport = 1Property(C): Intel = 6Property(C): PhysicalMemory = 448Property(C): VirtualMemory = 805Property(C): AdminUser = 1Property(C): LogonUser = BILOAGAProperty(C): UserSID = S-1-5-21-1606980848-1563985344-1202660629-1003Property(C): UserLanguageID = 1031Property(C): ComputerName = JUSTLERProperty(C): SystemLanguageID = 1031Property(C): ScreenX = 1024Property(C): ScreenY = 768Property(C): CaptionHeight = 19Property(C): BorderTop = 1Property(C): BorderSide = 1Property(C): TextHeight = 16Property(C): ColorBits = 16Property(C): TTCSupport = 1Property(C): MsiNetAssemblySupport = 1.1.4322.573Property(C): MsiWin32AssemblySupport = 5.1.2600.1106Property(C): RedirectedDllSupport = 2Property(C): Time = 19:43:01Property(C): Date = 18.12.2003Property(C): Privileged = 1Property(C): USERNAME = BILOAGAProperty(C): COMPANYNAME = xxxProperty(C): DATABASE = C:DOKUME~1BILOAGALOKALE~1Temp5b2b57.msiProperty(C): OriginalDatabase = C:SQL2ksp3installSetupSqlRun01.msiProperty(C): UILevel = 3Property(C): ACTION = INSTALL=== Protokollierung beendet: 18.12.2003 19:43:01 ===MSI (c) (B0:20): Note: 1: 1708MSI (c) (B0:20): Produkt: Microsoft SQL Server Desktop Engine --Installationsvorgang fehlgeschlagen.MSI (c) (B0:20): Grabbed execution mutex.MSI (c) (B0:20): Cleaning up uninstalled install packages, if any existMSI (c) (B0:20): MainEngineThread is returning 1603=== Verbose logging stopped: 18.12.2003 19:43:01 ===It would be super if anyone can help me. Havent find any informationsabout this.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
Hello,I have just purchased a new CPU and when I attempt to install MSDE theprocess nears the end and stops, and removes the installed files. If anyonrhas an idea on a correction let me know.Thanks
I want to install the MSDE 2000 sp3 or sp4, and using this command "c:sql2ksp3MSDE> setup aspwd ="astrongpwd" "....but it failed during the installation ." Setup failed to configure the server. Refer to the server error logs and setup error logs for more information" this message is shown on final............And then, i go the event log to see what message, it show "17112 Invalid command option q.".............anyone know what happen....can tell me where can find the solution....thank you very much
I am trying to upgrade an MSDE 1.0 db with the Service Pack 4 patch but I need to do either a Silent or Unattended install. Does anyone know how to do this? Does anyone know the command-line command to do this?
I tried using...
sql70sp4.exe -a -f1 "unattend.iss"
....but that didn't work. It popped up a window asking where I should extract the contents of the .exe (that shouldn't be appearing either) and then after it extracted it didn't do anything else.
Hi,My computer crashed and I have had to reinstall all the software. However, when I try to reinstall MSDE (server), it keeps telling me a strong SA password is required and to use the SAPWD to switch it. I cannot find SAPWD files or anyway to change this. After I get this message, the installation process stops. I didn't have this issue the first time I installed everything back in the beginning of September when the class started and before the computer crashed, I had no problem accessing a database using Web Matrix and the same server setup that I'm trying to install right now.If anyone can help me, I would be more than grateful.Thank youCarolyn (Crowbare)
But it gets through the install, then the progress bar goes backwards and it uninstalled, I tried to enable logging and do /q+ but none of this gives usable information, i have redownloaded the MSDE SP3 install files and this has changed nothing, I know this is a common problem as I have seen a few sites mention it, but i can't seem to find the fix.
I installed MSDE. Then I changed the name of my machine. Then I uninstalled MSDE, so I could create a new, properly-named instance.
Now, when I try to install, the installer gets about 75% of the way through the "gathering information" stage, and hangs, every time. I have to kill it with Task Manager.
Help! What can I do?
Extra info: I thought maybe the problem was related to Norton AV, so I uninstalled that. While that was uninstalling, the installer announced that there was a "suspended" install of MSDE that needed to be cleared. So I said, yes, clear it. How do I find out if there are other suspended installs in progress?
The process proceeds then a pop-up says the installation failed. The log reports:
--------------- 2004-11-04 15:07:21.30 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.0 (Build 2195: Service Pack 4)
2004-11-04 15:07:21.35 server Copyright (C) 1988-2002 Microsoft Corporation. 2004-11-04 15:07:21.35 server All rights reserved. 2004-11-04 15:07:21.35 server Server Process ID is 1904. 2004-11-04 15:07:21.35 server Logging SQL Server messages in file 'C:librarydataMSSQLLOGERRORLOG'. 2004-11-04 15:07:21.41 server SQL Server is starting at priority class 'normal'(1 CPU detected). 2004-11-04 15:07:21.64 server SQL Server configured for thread mode processing. 2004-11-04 15:07:21.65 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks. 2004-11-04 15:07:21.94 spid3 Warning ****************** 2004-11-04 15:07:21.94 spid3 SQL Server started in single user mode. Updates allowed to system catalogs. 2004-11-04 15:07:22.03 spid3 Starting up database 'master'. 2004-11-04 15:07:22.83 server Using 'SSNETLIB.DLL' version '8.0.766'. 2004-11-04 15:07:22.83 spid5 Starting up database 'model'. 2004-11-04 15:07:22.96 spid3 Server name is 'MJWLAP2'. 2004-11-04 15:07:22.96 spid3 Skipping startup of clean database id 5 2004-11-04 15:07:23.00 spid3 Skipping startup of clean database id 6 2004-11-04 15:07:23.00 spid3 Starting up database 'msdb'. 2004-11-04 15:07:23.51 spid5 Clearing tempdb database. 2004-11-04 15:07:24.34 spid5 Starting up database 'tempdb'. 2004-11-04 15:07:24.53 spid3 Recovery complete. 2004-11-04 15:07:24.53 spid3 SQL global counter collection task is created. 2004-11-04 15:07:24.60 spid3 Warning: override, autoexec procedures skipped. 2004-11-04 15:07:25.56 server SQL server listening on . 2004-11-04 15:07:25.58 server Error: 17826, Severity: 18, State: 1 2004-11-04 15:07:25.58 server Could not set up Net-Library 'SSNETLIB'.. 2004-11-04 15:07:25.58 server Unable to load any netlibs. 2004-11-04 15:07:25.59 server SQL Server could not spawn FRunCM thread. -------------------------
