MSDE: Can I Install Onto My D: Drive?
Oct 7, 2004
When I ran the install for MSDE, it installed the DB server and the databases onto my C: drive and under program files...
The instructions I followed were listed here:
http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1
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?
Thanks,
LD.....
View 2 Replies
ADVERTISEMENT
Aug 7, 2007
We are currently having a "lively" discussion between our DBAs and Server Builders and I am interested in what others are doing. Our DBAs want to take the default SQL install into the C: drive, making sure that NO logs are written to C:. That way there is no chance for the C: drive to become full, crashing the box. Server guys are insisting that we install to a drive other than C:.
I would appreciate any discussion re: what others consider best practice , industry standard, if such a things esist.
Thanks.
View 2 Replies
View Related
Mar 19, 2007
Is there a way to install SQL 2005 Express on a different drive? The server that I want to use has 700MB availible on the C drive and 80 GB availible on the D drive. can I install SQL and all tools on the D drive?
View 3 Replies
View Related
Dec 23, 1999
We have purchased a new Server at my company. We previously had two servers. One was the NT file server and then we had another SQL Server. Well, we've bought one box to replace both old boxes. I have 3 18.2 GB SCSI drives running on a RAID-5 configuration. I've partitioned the C: drive as 2GB and it will only be used for NT files and NT Utility apps.
On the old system I had all my data files on one physical drive and all of my logs on a seperate physical drive. Now, with RAID, the three drives act like one big 36GB drive. Finally, my question...
How should I partition this drive? Should I put the SQL Server App, my data files and my logs all on one partition? Should they each have their own partition? Should it be a mix (App & Log, Data & Log, etc.). Also, how much space do I need just for the application if I put it in its own partition?
I've never installed SQL Server before, so if anyone has any other suggestions, tips, tricks, etc., I'd love to hear it. Either post here or e-mail me responses.
Thank you all very much
Merry Christmas!
View 1 Replies
View Related
Jun 11, 2008
Hello Everyone,
I wasn't able to find the answer to my question by searching the forum. I would very much appreciate if anyone would help me.
I need to install the SQL Server Workgroup trial. I wasn't able to find the workgroup trial so I was trying to install the enterprise instead. (If anyone knows how to get ahold of the workgroup trial that would be a help too)
I keep getting the following error when running the SQLEval.exe:
There is not enough space on drive C: to extract this package
I did an internet search on this error and it seems there is a bug that requires the amount of free space not be a multiple of 4. I currently have 13.2 GB free space and I have tried adding and removing files, to no avail. I have tried downloading the file in a few different versions in case the file was corrupted, and rebooting etc, but still I keep getting the same message. I only have one drive!!!
Can anyone help me with this?
View 8 Replies
View Related
Oct 22, 2007
I created two partitions for my hard drive. The C drive which holds all of the Windows 2003 server operating system files and E drive which will be just for data and applications. The C drive is only 30GB while the E drive is 119GB. I need to be able to install in the application on the E drive. I already tried creating a folder on the E partition named program files with the sql2005 folder in it when I go through the installer package. SQL server still wants to be installed on the C drive. Is there anyway I can change this so it gets installed on the E partition. Thank You
View 1 Replies
View Related
Oct 29, 2007
I am trying to install the SQL Sever 2005 Workgroup Edition software that came with our Small Business Server 2003 R2 system. I would like to install to the d: drive because space on the c: drive is limited. Can I do that? If so, how?
View 1 Replies
View Related
Oct 22, 2007
I created two partitions for my hard drive. The C drive which holds all of the Windows 2003 server operating system files and E drive which will be just for data and applications. The C drive is only 30GB while the E drive is 119GB. I need to be able to install in the application on the E drive. I already tried creating a folder on the E partition named program files with the sql2005 folder in it when I go through the installer package. SQL server still wants to be installed on the C drive. Is there anyway I can change this so it gets installed on the E partition. Thank You
View 3 Replies
View Related
Jan 12, 2005
On the drive that SQL server is install on which is the C drive the amount of space is 495mb, can the amount of space be a potential problem, I am so used to looking at the drives that contains the data and log files and the backup.
So My question is should I also concern myself with the drive the sql server itself is installed on?
Thanks
Lystra
View 5 Replies
View Related
Aug 20, 2007
I am trying to install SQL Server 2005 Express Edition onto my PC on the D: drive. I do not have write privelleges to the C Drive. All I want to do is point the executable to install to another drive like D: or E: etc. Is this possible with SQL Server 2005 Express Edition setup executable file.
Just to let you know I have changed the template.ini file in the source folder to reflect the following (I tried both with and without quotes)
INSTALLSQLDIR="D:Program FilesMicrosoft SQL Server"
And then using command prompt I did the following:
"start /wait setup.exe /qn myini.ini"
and it still doesn't work.
View 1 Replies
View Related
Mar 22, 2004
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.
Can anyone help???
Thanks,
Jeff
View 3 Replies
View Related
May 24, 2004
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.
Thanks
View 7 Replies
View Related
Feb 21, 2001
The installation of MSDE always pop up
the error "setup.iss not found" on a
win98 se.
View 1 Replies
View Related
May 1, 2006
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.
Any Ideas?
Thanks
View 1 Replies
View Related
Jul 23, 2005
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
View 4 Replies
View Related
Dec 18, 2003
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.
thanks
JSearcy
View 1 Replies
View Related
Dec 18, 2003
I am trying to install MSDE according to:
http://www.siue.edu/~dbock/cmis460/msde.htm
But it says I need to go to control panel to install components, but it is not listed on the VS.NET 2003 install.
In VS.NET 2002 it worked fine as per instructions, but now i can't seem to get it to work in VS.nET 2003
View 2 Replies
View Related
Dec 28, 2003
Hi All,
I hope you can help.
I am reading SAMS Teach Yourself ASP.NET and have loaded the WEB Matrix and have been going through the exercises.
I have now tried to load MSDE and my first attempt seemed to load it correctly
C:sql2ksp3MSDE> setup SAPWD=****** SecurityMode=SQL
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.
Can any one help
Best wishes.
James.
View 5 Replies
View Related
Apr 28, 2004
Hello,
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.
PLEASE HELP!!!
View 1 Replies
View Related
May 27, 2004
Hi, folks.
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?
TIA,
Bob
View 4 Replies
View Related
Jan 12, 2005
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:
setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"
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.
Hey! Hope this helps others.
Paul Townsend
View 1 Replies
View Related
May 23, 2000
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?
BTW Backups weren't completed....
If anyone can help please let me know.
View 1 Replies
View Related
Nov 10, 2002
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
Thank you
View 1 Replies
View Related
Oct 14, 2004
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!
View 1 Replies
View Related
Nov 13, 2004
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.
Mike
View 1 Replies
View Related
Mar 22, 2004
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?
Thanks,
clothilde
View 1 Replies
View Related
Apr 7, 2004
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.
View 4 Replies
View Related
Jul 20, 2005
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!
View 1 Replies
View Related
Jul 20, 2005
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
View 2 Replies
View Related
May 17, 2007
Dear all
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
regards
View 1 Replies
View Related
Jul 19, 2006
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.
Any help is greatly appreciated.
View 1 Replies
View Related
Nov 1, 2006
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)
View 3 Replies
View Related
