But....

Question

Ok, I usually love Microsoft technologies but this time I have to admit I am a bit frustrated. I just bought a new laptop and have installed Visual studio 2005 Team edition and the full version of SQL Server 2005, over and over again. I proebably restored the system 5 times because its easier than trying to figure out why it does not work. Interestingly I get different errors all the time :)

1) Dont see Management Studio (have to rename tools folder and re-install SQL_tools)

2) Can not create user instances (forgot the solution)

3) Dont see MSSQLSERVER instance (gave up trying to find a solution)

I now have it fianlly working (god knows what I did right this time), BUT.... installed the samples and they dont show up anywhere.

I wonder if microsoft puts out software as a training exercise rather than providing reliable software. I run a small web application business and this sort of stuff takes too much time to sort out.

btw, running a quad core 8gb windows 7 machine which should be enough I thought

 sigh....

 

btw found out that "AdventureWorksDB_x64" does not work on a 64 bit intel, because its AMD, but not mentioned in the title.....

Answer 1

Hi Ronald,

I'm here to help:)

So what version of SQL Server 2005 are you running. Is it Express, Developer, Standard or Enterprise? N.B. ; - Standard and Enterprise editions require that you are running a server operating system, e.g. Windows Server 2003, not a desktop operating system such as XP Pro, Vista Business or Windows 7 Pro.

Which version of Windows 7 are you running, Home, Professional, etc?

Did you install the samples from the following location?; - http://msftdbprodsamples.codeplex.com/releases/view/4004

When you installed the samples was their an error message?

Did you attach the MDF files to your server instance? If not I can talk you through this in more detail.

I have Vista business, and SQL Server 2005 developer's edition on my laptop, but I believe with possibly the help of other MSDNers we can help you out.

I hope this helps.

Kind Regards,

Kieran.

 

 

---

If you have found any of my posts helpful then please vote them as helpful. Kieran Wood PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/bileeds

Answer 2

Thanks Kieran,

answer to your questions:

Which version of Windows 7 are you running, Home, Professional, etc?

1. Windows 7 Home Premium (see point 4)

Did you install the samples from the following location?; - http://msftdbprodsamples.codeplex.com/releases/view/4004

2. Yes I did

When you installed the samples was their an error message?

3. There was 2 errors, one regards a version of .NET not running/registsred to the right version, ran some scripts to make that work (interesting you actually have to run scripts to install a sample database). Then I got a message regards an IIS feature, since than I found out the 7 Home Premium does not have

Windows Authentication	Security
IIS Metabase	Management Tools
IIS 6 WMI	Management Tools

Is this correct?

4. I have now purchased an upgrade to Premium unfortunatly (this is not mentioned in a lot of places as a difference between the versions, I finally found this out at http://technet.microsoft.com/en-us/library/cc753473.aspx aaargh, not very well documented if you google "difference 7 home and premium" where they only talk about things like bitlocker etc. Is there a page which describes the REAL differences between the versions?

Did you attach the MDF files to your server instance? If not I can talk you through this in more detail.

5. I did not because I could not find them anywhere, thanks for the offer but I know how to attach databases.

Its still frustrating that to simply install samples (which are supposed to teach you how to things work) you have to figure out so many different things to make the samples work.

I appreciate your help though!

Answer 3

Hi Ronald,

SQL Server 2005 Developer's Edition should work with Windows 7 Professional or Windows 7 Premium, so you are heading in the right direction there.

I agree this should be made clear on the following page; - http://technet.microsoft.com/en-us/library/ms143506(SQL.90).aspx

So I have added community content at the foot of this page echoing your concerns.

The SQL Server 2005 SP3 page stated supported operating system; Windows 7; -

http://www.microsoft.com/downloads/details.aspx?FamilyId=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en

So in summary; -

Upgrade to Windows 7 Pro or Premium,
Install SQL Server Developer's Edition with Service Pack 3,
Try installing the samples.

If you have an further issues please create a new question thread.

I hope this helps,

Kieran.

 

---

If you have found any of my posts helpful then please vote them as helpful. Kieran Wood PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/bileeds

Answer 4

About to give up, I have installed 7 Ultimate, than Office, and Visual studio, than about 1 gb worth of updates. I now try to install sql2005 developer extended and still get a error message.

"32-bit ASP.Net is Registered. Required 64-bit ASP.Net to install Microsoft Reporting Services 2005(64-bit)."

I have tried the following script

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

but no luck again, still get this message, sigh.

Then I tried whats stated on http://www.mike-tech.com/article.php?gif=iis&article=281

Still no luck.

For the time being I'll ignore the message and hope for the best....

Honestly, this is a serious attack on my patience....

 

Answer 5

Ok, so I installed everything again, Express with Visual Studio was running fine, then I installed SQL 2005 developer extended edition, hoping this would allow me to install reporting services. Now I have lost all instances, even my express version. I can see my service "MSSQLSERVER" is running but can'tt connet to it. I did the provisioning and switched on named pipes, still nothing.

 

Is there anything more I can do?

Answer 6

Ok, so for anybody who is following this, I have changed all the services to "Local System Account " and allowed interaction with the desktop, I also re-installed SQL Express Advanced and I now have my SQLExpress back, and it looks like I also have Report Server. I now miss my MSSQLSERVER and my analysis and intergration only :)

Answer 7

AND I canm now connect to my default instance (which is not called MSSQLSERVER as stated in the services but "computername").

Looks like I am getting there, finally...

ps, my default instances also have the sample databases on there.