pf » I give up! Installing SQL Server 2005 Express

I installed SQL Server 2005 Express on my laptop without issues. Howver, I did not have any prior versions such as MSDN 2000. First I installed Visual Studio 2005 and then SQL Server Express 2005.

Here is what MS has to say about the install. Source: MSDN SQL Server 2005 Express Edition Overview http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp

"The Visual Studio 2005 version of the .NET Framework is a prerequisite for the installation of SQL Server Express, and the setup produces an error if the correct version is not found on the machine."

No I couldn't get it to install alongside my SQL 2000 Dev Edition either. Eventually put it on yet another partition. With VB6, .net various editions of CF, SQL Oracle and umpteen versions of IE I am finally about to install Virtual PC from MS so I can run all these various configs from just the one core ennvironment.

I just have a fresh copy of Windows XP installed on my system. Installed SP2 and then the latest version of framework 2.0 to date, namely 2.0.50215. Tried to install SQL Server 2005 Express and have the same problem. :\

Have you tried with the most recent release that was just posted on microsoft.com/downloads? It's called "June CTP" and there are links to get the matching framework and express versions on the box together. Also the error message you get about incompatible components has nothing to do with your SQL2000 instance and ONLY relates to some version of SQL2005 that was on the box previously, or more than likely a version of dotnet framework that setup deems incompatible with the version of SQL Express that you downloaded. Try the instructions on this page below, and download the newest paired versions of dotnet framework and the sqlexpress package. First you'll need to clean-up anything that you have in your Add/Removes that is related to Visual Studio 2005 or SQL 2005:

http://www.microsoft.com/downloads/details.aspx?FamilyID=1a722b0f-6cca-4e8b-b6ea-12d9c450ed92&DisplayLang=en

@Edna Lynx

I did as you and got the same problem. Both .net framework 2 beta 2 and sql express 2005 was downloaded from MS's site only minutes before the install.

In the error log (%program files%\Sqlserver ...) I get the following message: Product "{7A1ADD0C-17F3-47B8-B033-A06E189C835D}" versioned 2.0.50215 is not compatible with current builds of SQL Server.Expected at least version: 2.0.50215.311

Quite frustrating since I just downloaded the framework.

I am not sure what happened. Plz make sure you clean up any framework you have in your Add/Remove progams and follow the first 2 links on this page to setup the combination of Express and the Framework:

https://blogs.msdn.com/nikop/archive/2005/06/16/429884.aspx

I know it works as I tested it, so it's a matter of making sure we get the right versions on the box for you. Also it would be good to know where you downloaded that version of the framework, and where you downloaded that version of the sqlexpress package.

thx..

Hi Niko

Thanks for your feedback. I will attempt another installation, using the files you link to, tomorrow.

I got the .net framework from this link: http://www.microsoft.com/downloads/details.aspx?FamilyID=7ABD8C8F-287E-4C7E-9A4A-A4ECFF40FC8E&displaylang=en (which states that this is "the most recent update" to the Microsoft .NET Framework...) The sql express 2005 was downloaded from http://www.microsoft.com/downloads/details.aspx?FamilyId=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en

Best regards Andreas

That's the problem, the first link you specify is the framework from a previous version so that is causing the conflict with the new setup. The 2nd link is correct.

thx.

Ok great! It should work then. I'll test it later today...

Btw. one should consider changing the wording of the .net framework 2 beta 2 download site since, obviously, it is NOT the "most recent update".

Best regards Andreas

YUKON'un ke_ke setup için optionlar1 olsa, ben boyle ak1ll1 setuplar1n.....

My goodness, I've tried over and over, and I just cannot get past the "detected incompatible beta components" message. I've run the build clean thing, and I uninstalled the net framework. Then I downloaded the 2.0.50215.45 version from Microsoft (so it says in the website). I installed this version, and somehow it gets registered simply as the 2.0.50215 version, so when I run the SQL SErver 2005 Express setup, I get the incompatible components message.

Product "{7A1ADD0C-17F3-47B8-B033-A06E189C835D}" versioned 2.0.50215 is not compatible with current builds of SQL Server.Expected at least version: 2.0.50215.311

I'm pretty close to giving up on this software

Any ideas???

Take all your log files and zip them into a zip file, and email it to me at nikop@microsoft.com

Also send me the actual URL's from where you downloaded the framework and sql server edition. I swear, if you follow the links in my blog for getting the framework and sql edition that you need, it works!

http://blogs.msdn.com/nikop/archive/2005/06/16/429884.aspx

I have exactly same problem. Very frustruted!

I found the problem and fixed it in my machine. Somehow, the old version SQL Server 2005 has been uninstalled incompletely in my machine. So I searched the registry using the product ID (such as "7A1ADD0C-17F3-47B8-B033-A06E189C835D" in your case) and found the product entry. After deleting the entry in the registry, the installation works.

See this blog entry, solved my problem: http://blogs.msdn.com/nikop/archive/2005/03/04/384972.aspx

thenx man I use 2 have the same problem and it's work for me

thenx

If youre still having this problem or for anyone else:

I had this problem as of 10/17/05 and resolved it. Do this: Uninstall .net Framework beta (and older versions). Download the latest .net Framework and reinstall it. SQL Server Express does not consider the latest Framework an incompatible version.

Hi there running SQL Server Setup file version 2000.90.1187.00 product version 9.00.1187.07 i receive the error "Microsoft SQL Server 2005 CTP Setup SQL Server CTP Setup has detected incompatible beta components...." Now, the problem is that, as I run .. \Setup Tools\Build Uninstall Wizard\sqlbuw.exe from same build of SQL Server Setup (9.00.1187.07) i receive following message: "Microsoft SQL Server 2005 Cleanup Wizard There are no SQL Server 2005 or .NET Framework components to uninstall. You may now run setup wizard to install new instances of SQL Server 2005." So what? It seems as if the setup file detect a previous version of some component installed while the un-install file does not ... (strange kind of a uninstall program...) No way i get further with installing this software... i have developed using Matrix + sqlexpress for months and now i just can't go on because i was forced to update to a new version of sql and everything crumbled into pieces Could you please suggest me a hint? Thank in advance for your kind cooperation

Go to this link and you can install the correct ASP NET framework compatible with the beta sql. Don't use the windows update framework.

http://go.microsoft.com/fwlink/?LinkId=47248

the links that you have provided no longer active, if you have new updated links please let me know .. I am almost give up to Sql Server Ex.

I found the following discussion very usefull - resolved my installation of SQLServer Express issues.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=2&SiteID=1&PostID=114878&PageID=1

this discussion solved it for me aswell

Hi,

I followed your instruction very prissily but still got the following error:

SQL Server 2005 Setup has detected incompatible components from beta versions of visual studio, .Net framework, or SQL server 2005. Use add or remove programs to remove these components, and then run SQL server 2005 setup again. For detailed instructions, on uninstalling SQL server 2005, see the SQL server 2005.

Thanks,

Lawk Salih www.lawksalih.com

I have tried too but I uninstalled a previous MS SQL database fully and cleaned the Registry. Its completely useless.

Hi guys,

I have read what you are writing and I have the following issue:

Install .NET2.0.50215 (latest version). Go to install SQLServer and it comes up with and error stating that it can't install SQL SERVER because it needs .NET2.0 to do so. Tells me to update this prerequisite. But I have...and it is updated...

I notice one of the posts say that v2.0.50215 wont work with SQl Server 2005...is that true?

Hi Guys I'm getting the following message 'SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005' what should i do? thanks for your help

I am facing the same problem, I get same error messages while installing sql server 2005 after installing visual studio 2005.

i have vs2005 and sqlserver 2005 installed on my computer, sqlserver is running fine, but in vs2005, it is not showing northwind. in VS2005, when i go through these steps: server explorer -->data connection --> add connection -->data source (Microsoft SQL Server (SqlClient)), after giving server name -->use sql server authentication (giving username & password) -->and after refresh --> it is not showing northwind database (just showing master, model, msdb, report server, report server tempdb, tempdb,and my created databases and gives test connection succeededbut, but it is not showing northwind database. it was fine with sqlserver2000

The best way to get this to work is to backup all your files, format your hard drive and install a new copy of Windows XP then install a fresh copy of the express package. This works like a charm.

Lawk Salih www.lawksalih.com

Thanks for your reply, please write me the sequence of installation. first VS2005 or SQLserver2005 have to install

I installed VS2005 Express first then SQL and I also installed C# Express.

Works fine.

Lawk

i have installed Microsoft SQL Server 2005 Enterprise Evaluation Edition 180 days trial from this link http://www.microsoft.com/downloads/details.aspx?FamilyId=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en

i want to know that whether thi is not working for development. or i have to install express edition? please suggest

in my c drive there is C:\Program Files\Microsoft SQL Server\MSSQL.1, MSSQL.2, MSSQL.3, MSSQL.4 and in MSSQL.1\MSSQL\Data (master, model, msdbdata, mssqlsystemresource, tempdb) but not northwind can u tell me why this is so. or in sqlserver2005 no northwind database is provided. please help me out.

oh i'm so sorry for the inconvenience, i got the answer, it is not provided in sqlserver2005. Thank you very much for your help

I give up on microsoft. I have tried and tried to get SQL Server working with visual basic express but no matter what I do everything is riddled with errors. I can install, create databases, but cannot retrieve any data from them. What works one day doesn't work the next, with no changes made. All the errors reported are unhelpful, and none of the suggestions found in the support materials fix the problems. I've wasted many days trying to get the simplest of things working, and I've had enough. Microsoft has driven me to the point of insanity.

The link to download SQL Server 2005 Express is not available ¿can you tell me where can I download that version?

I download sql server enterprise evaluation 2005. Now I can not see in all programs. I opened in explorer , I can see . now what should I have to do ? I am a student. please forgive me.