Installing Developers Edition

I want to install MS SQL server to my machine but first I would like some advise of you pro's who have done it already.

The following is my setup.

1.- My development machine WindowsXP Pro 1Gig ram and 250gigs HD Loaded with my dev.Software from Dreamweaver, graphic apps and so on.

2.- The machine I want to install on is a WindowsXP Pro sp2 with 1 Gig Ram and plenty of HD space. and runing Apache and PHP and MySQL

3.- Win Server 2003 Sp2, 1GIG of ram where I test my ASP websites.

The last time attempted install MS SQL something went totally wrong and corrupted my machine somehow and I had to re-install everything I had. So, this time I want some advice:

Do I have to have IIS on the same machine as MS SQL or can I have IIS on one, let say my 3rd machine and install SQL on my second machine

Any ideas please let me know

Posted On: Sunday 11th of November 2012 09:11:47 PM Total Views:  407
View Complete with Replies

Related Messages:

Accessing Sql compact edition through Native C++   (160 Views)
Has anyone tried accessing SQL Compact edition file through native c++ code. I am trying to use the .sdf file through native c++ in linux system. I would appreciate a sample code.
Sql Server FAQ for developers   (154 Views)
Iam preparing for a interview. i have developed applications with and sql server. i would like to know some frequently asked questions in sql server.
need help installing MSDE 2000   (271 Views)
I have to do this project for school to make a website something like We have to use VS.NET and MSDE2000 I m running winXP pro., have i do have a router, my computer is an AMD 2500+ I installed its working fine. As i m trying to install MSDE2000 using the instruction my professor gave us which is the following: Using MSDE (SQL Server Desktop Engine) You will need to download and install the MSDE from Microsoft. If you did not do so with the initial install of VS.NET you can get a copy at IMPORTANT Use the following instructions to install MSDE. DO NOT use an instance as the backup and restore of your database will not be compatible with the school lab. The MSDE should have the following path: C:\Program Files\Microsoft SQL Server\Mssql Within the MSSQL folder there should be a Binn and Data folder. If your setup is different you will not be able to use the backup and restore database features and will instead have to use attach/detach. Click the Download link to start the download. Do one of the following: To start extracting files required to install MSDE immediately, click Open or Run this program from its current location. To copy the download to your computer for installation at a later time, click Save or Save this program to disk. If you choose Save this program to disk, locate the file where you saved it, and double-click the .exe file to extract all files required to install MSDE on your computer. After extracting the MSDE installation files, open an MS-DOS command prompt and change to the directory where you extracted the files. MSDE extracts to C:\sql2ksp3\MSDE by default. Run the following command to set up MSDE for Visual Studio .NET.: Setup.exe /qb+ DISABLENETWORKPROTOCOLS=1 SAPWD=itm605Everytime i try to install it says MSDE could not be isntalled and to look in error log.i looked there it gives me the following:004-06-21 12:00:41.46 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)2004-06-21 12:00:41.46 server Copyright (C) 1988-2002 Microsoft Corporation. 2004-06-21 12:00:41.46 server rights reserved. 2004-06-21 12:00:41.46 server Server Process ID is 3508. 2004-06-21 12:00:41.46 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'. 2004-06-21 12:00:41.49 server SQL Server is starting at priority class 'normal'(1 CPU detected). 2004-06-21 12:00:41.51 server SQL Server configured for thread mode processing. 2004-06-21 12:00:41.51 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks. 2004-06-21 12:00:41.54 spid3 Warning ****************** 2004-06-21 12:00:41.54 spid3 SQL Server started in single user mode. Updates allowed to system catalogs. 2004-06-21 12:00:41.54 spid3 Starting up database 'master'. 2004-06-21 12:00:42.17 server Using 'SSNETLIB.DLL' version '8.0.766'. 2004-06-21 12:00:42.18 server SQL server listening on Shared Memory. 2004-06-21 12:00:42.18 server SQL Server is ready for client connections 2004-06-21 12:00:42.18 spid5 Starting up database 'model'. 2004-06-21 12:00:42.23 spid3 Server name is 'STABREZ'. 2004-06-21 12:00:42.23 spid3 Skipping startup of clean database id 5 2004-06-21 12:00:42.23 spid3 Skipping startup of clean database id 6 2004-06-21 12:00:42.23 spid3 Starting up database 'msdb'. 2004-06-21 12:00:42.82 spid5 Clearing tempdb database. 2004-06-21 12:00:44.14 spid5 Starting up database 'tempdb'. 2004-06-21 12:00:44.34 spid3 Recovery complete. 2004-06-21 12:00:44.34 spid3 SQL global counter collection task is created. 2004-06-21 12:00:44.42 spid3 Warning: override, autoexec procedures skipped. 2004-06-21 12:02:28.04 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.I do not know what to do please someone help me very important. Thank you in advance Shams