Installing SQL 2005 in Windows 7 Professional 64-bit

Hi

i have Windwos 7 Professional Installed in my computer. also i have installed Visual Studio 2008 as well.

last week i wanted to install SQL Server 2005 Enterprise Edition in my computer so i came to know that u need the SQL Server 2005 Service Pack 3 for this as well.

after obtaining both the Enterprise Edition Setup and the SP3 Setup of SQL Server 2005, i began the installation. first i installed the server. and selected The Server and Workstation components. but when the installation was progressing, it gave a message that the workstation componenets could not be installed and hence only the MSSQLSERVER Service got installed. i take think this so seriously hoping that client tools (workstation componenets) can be installed after the SP3 is being installed. so after the setup completed, i installed SP3 as well. even there, the client tools were disabled.

after SP3 installation and System Restart, i couldnt find Managament Studio; so i again went to the SQL server 2005 setup and selected the client tools to be installed. but just before the installation started, an error message prompted saying that "one or more componenets could not be installed" and then exiting the setup..

please advise what i am missing. i tried the same thing using SQL Server 2005 Standard but the same thing happens.

p

Hi all,

I have a web app that runs on local and use merge replcation using sql server 2005 standard on the server and sql express 2005 on clients on XP. As you know, XP Pro laptops are getting hard to find. We are trying to change to Windows 7 Pro x64. I installed SQL Express 2005 and I don't see a subscription on "Sync Center" after I created local subscription using SSMS. I normally see the subscription in Synchronize in XP Pro right away. 

I googled about this issue and not really have a good solution. There is one link saying Windows 7 not supporting Express 2005 anymore. http://blogs.msdn.com/b/repltalk/archive/2010/03/24/using-windows-synchronization-manager-on-x64-to-synchronize-replication-revised.aspx 

If so, I would like to know what would be a solution such as can I use Sql Express 2008 R2 instead of Sql Express 2005 for client even if the server is still SQL Server 2005 Standard edition. We are planning to upgrade, but we need to hire 5 to 10 people now. My boss does not want us to keep using XP Pro. 

Any suggestion would be appreciated.

Thanks,

Sompop

Hi

I want to install MS SQL 2005 Exp. edition in windows server. For that I had already downloaded the SP2 MS SQL 2005 exp. edition from Microsoft web site. I am geeting error while trying to install SQL: "The SQL service failed to strat . For more information see the SQL server books online topics, "How to view SQL server 2005 setup log files and starting SQL server manually." Our Server configuration is windows 2008 R2 with 32 bit prcessor.

Before that i had install the same but SQL Server Management Studio icon is not showing, so I unstalled SQL and then trying to fresh installation.

Please help me to resolve this issues.

Thanks in advance.

Last year I had Vista on machine with Visual Studio 2008 and SQL Server 2005 running fine. Last week I decided to wipe the hard disk, install Windows 7 and make the move to Visual Studio 2010. I still need SQL Server 2005 to be able to test code for clients using this.

Anyway, Visual Studio 2010 Professional went on OK. This installed SQL Server 2008 Epxress.

I then try to install SQL Server 2005. I know that there is a compatibility problem, so following advice from other sources, I want to install it without running the server, then install SQL Server 2005 SP3. Then I should be up and running.

The problem is that even though I make sure the 'Start SQL Server' check box is UNchecked, part way through the installation it throws up an error saying it can't start the server and this part of the installation is unrolled.

I've tried running 'setup.exe SKUUPGRAGE=1' which gets rid of the only warning I was getting up to this point, but the setup seems to insist on running the server even though I tell it not to. So I don't get a chance to run SP3 on it.

I wonder if the problem is that SQL Server 2008 Epxress is already installed but can't see an easy way of uninstalling it. It doesn't appear as an uninstall option using the Visual Studio 2010 disk and if I look at uninstall programs I get the f