Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: SQL server 2005 and Windows 7

11 May 2009   #1

Vista x64
SQL server 2005 and Windows 7

Hi, I would like to know if it's possible to run SQL server 2005 Developer edition under Windows 7 x64.

My Vista installation is messed up so I want to try clean install of Windows 7 but I need SQL server 2005 working.

My System SpecsSystem Spec
11 May 2009   #2


i have sql 2005 express running fine, so the full server should install correctly.
My System SpecsSystem Spec
23 Oct 2009   #3

windows 7

Quote   Quote: Originally Posted by ccatlett1984 View Post
i have sql 2005 express running fine, so the full server should install correctly.
Did you run the installer in a compatibility mode?
My System SpecsSystem Spec

23 Nov 2010   #4

Windows 7 Business x64

Yes it is, for a full walkthrough see here...

Installing SQL Server 2005 on Windows 7 (x32 & x64) | GeakeIT
My System SpecsSystem Spec
13 Jan 2011   #5

windows 7 home premium 64
Trouble with Sql Server 2005 Surface Area Conf.

I have, finally, installed SSRVER 2005 on my Win 7 machine.

I can not give my user account SysAdmin Privileges

I keep addding them - they do not take

I have SQL Server Running

I have noticed in some of the docs that told me to go here, That i should be in "SQL Server 2005 User Provisioning Tool for Vista/Windows 7".

Mine only reads "SQL Server 2005......Vista". No windows 7.

not sure if this is the issue. but until i can get SysAdmin I can't see my instance
My System SpecsSystem Spec
25 Jul 2011   #6

Windows 7 Professional 64-bit

joshgeake, that link no longer works. I'm also having trouble figuring out how to get SQL 2005 on my machine. I recently got a Windows 7 machine and need SQL Server for accessing a few databases locally. I'd really appreciate any help you may be able to provide.
My System SpecsSystem Spec
27 Jul 2011   #7

Windows 7 Business x64

The link seems to work ok now?
My System SpecsSystem Spec
27 Jul 2011   #8

Windows 7 Professional 64-bit

Thanks, Joshgeake. The link does work now.

I ended up resolving the issue in the meantime. I didn't really care if it was 2005 or 2008 -- but wasn't having luck with either. What ended up helping me was what Nicholas Piasecki says at the very bottom here: SQL Server Express 2008 - Missing Client Tools / Management Studio / Profiler

Basically, I needed to upgrade the Edition before the Client Tools were even available for install. Not very obvious. Once I did that (and I also made sure I had installed any available service packs for SQL Server), management studio was available and I was able to install it.

Hope this helps someone!
My System SpecsSystem Spec
11 Nov 2011   #9

windows 7 home premium


I am also facing the same problem.After installing sql server i am not able to see my instance name...please help me out.
My System SpecsSystem Spec

 SQL server 2005 and Windows 7

Thread Tools

Similar help and support threads
Thread Forum
How can I use Windows Photo Gallery now SQL Server 2005 is obsolete?
Having finally sourced a brand new laptop with Windows 7 Pro installed, my computing life was back to normal! I found a couple of small differences to my previous Home Premium Edition, but nothing drastic that I could not handle ... with the exception, that is, of Windows Photo Gallery and the...
Music, Pictures & Video
MS SQL server 2005 3.0.000
Both of our Win 7 desktop computers (stats for mine are shown, but the other is very similar) came with Microsoft SQL Server 2005 Compact Edition version 3.1.000 installed. The program has never updated via Windows Update, and I don't believe we've ever had any use for it. This morning, however,...
sql server 2005 installation fails on windows 7
Hi, sql server installation fails on windows 7. Any ideas to resolve this problem.
SQL Server 2005
Hi all, Is there any person who has installed SQL Server 2005 on Win7. I'm having much trouble with this OS. A lot of compatibilities issues... :cry: Thanks for help
SQL server 2005 standard install fails on windows 7
Hello I am trying to install SQL server 2005 standard edition on windows 7 professional. I select to install everything, but the installation of database services fail, and I can't find the log file I am requested to inspect. Please note that it is the installation that fails, so I have...

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 21:27.
Twitter Facebook Google+