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.
Hi,I'm trying to install MSDE Desktop SP3a SQL server on my Windows 2000 Professional Laptop.Every time I try it nearly finishes the installation and then just rollsback.Can anyone help? Is this a known issue?Thanks in advance,Jocky
I have installed Sql 7.0 desktop edition on Win 98 with IE5 and am having a problem starting the Sql server. It auto registered the server under my machine name. It was returning a network connection error so I deleted it and tried to add one with the name (local). Enterprise Manager then returned an error saying one was already registered under that name.
This week I was told to setup MSDE Desktop Engine on my pc bcz my Access back end db is getting bigger in size. And as a little advance step, I decided to put my Access back end on SQL server.
To be frank, I have no experience with SQL server but after reading the instructions, I have installed MSDE (latest version) on my pc successfully. A small icon of SQL server appeared nearby clock icon of my pc showing the SQL server is running on ASHFAQUEPC.
I shifted a Trial db onto this server in following way.
Considering the opened Trial db would be my BE, from the Tools---Database Utility---Upsize wizard, I followed below steps according to Upsize wizard.
1.I selected ‘Local’ server and check marked to ’Use Trusted Connection’. 2.And then I selected some tables to export 3.Kept all default attributes of db as it is 4.Selected ‘Let the wizard decide’ under data option to include. 5.At the next step ‘What application change do you want to make? a.Create a new Access client/Server application. b.Link SQL Server tables to existing application. c.No application changes. (I selected this option)
Then it showed me the report of my db description of changes that were made after deploying it. The report I did not print bcz it was a trial db with one table (2 fields) and a simple query.
My idea was to connect my Trial BE with another one of another Access mdb file so FE would be Access and BE would be from MSDE.
1.Now I don’t know how to link my BE to my FE? 2.From where I can directly see my BE? Because SQL Server Service Manager does not have any menu? 3.Where I was wrong in following steps?
I have a new computer p4 2.8 i just install in it the Microsoft Visual Studio .NET, when i try to install the sql server desktop from: "C:Program FilesMicrosoft Visual Studio .NETSetupMSDE" in the middle it stops installing, I tryed to uninstall Visual Studio and install it again , but i get the same problem what can i do?
Can someone advise me if this is basically SQL server 2000 and will work effectively to simulate sql server on a stand alone development machine ? Is this what its meant for?
My question is, is it possible to connect to an SQL database using the MSDE 2000 SP3a edition over the internet? And if so, how do I set it up? Thank you in advance.
i'm chanaka my problem is i had a wsus 2.0 version server, last week my server disk was full, finaly i was move the Wsus data to new disk.with all the contens. when i try to move the datbase it's give the error.
when i open the wsus admin console it's give the error message. and it's add the event log error also. this thing is giving to me big problems.
Connection to database failed. Reason=Unknown error.. Connection string: Data Source=EMAIL-FILTERWSUS;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
if u can give me help. . please if u can give me help.
Does anyone know if it's at all possible to install SQL Server Express 2005 over a Remote Desktop on a Windows XP machine.
I know there are problems running SQL over Remote Desktop, in that it won't start up a User Instance, but I wasn't sure if we can install over Remote Desktop.
If it's not possible, can anyone point me to an official document stating this fact?
What can I do about this? There doesn't seem to be any workaround, I've upgraded everything, including the Msiexec to 3.2 (v2), but the same error always pops up.
I've done other installs of the same product without any problem whatsoever.
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??
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.
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
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.
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.
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.
Am very new to MS SQL adminstration Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice.
The activity which am going to workout on MSDE is below.
How to install SQL(on XP) How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other) How to create/delete tables if so, how can we do it either by GUI or CUI
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.
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.
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: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:
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.
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.
