AdventureWorks 2008R2 SR1

Rating:        Based on 222 ratings
Reviewed:  166 reviews
Downloads: 0
Released: Nov 17, 2010
Updated: Apr 24, 2012 by akiwhit
Dev status: Stable Help Icon

Available Downloads

There are no downloads associated with this release.

Release Notes

Alternative AdventureWorks2008R2 database

Because of issues related to the AdventureWorks 2008 R2 SR1 installer, as an alternative to the SR1 installer, you can download the AdventureWorks2008R2 database, or scripts, from AdventureWorks2008R2 without filestream. This is a database only download that you will need to attach. More information about attaching the database is at Readme for Adventure Works Sample Databases.

Please give us your feedback in the samples forum! (Yes, even the complaints. We do try to respond to them.)

Reviews for this release

     
la necesito para trabajar con ella, en algunos ejemplos de analysis services
by Carolina55 on Wed at 1:02 AM
     
muy buena data para ejemplos
by SerAnt on Nov 2 at 8:54 PM
     
thanx i will use that
by bugmenot2 on Oct 29 at 12:57 AM
     
hfgjldksfghjkdfghjkgfghjklnbvbn
by ofsahinler on Jul 22 at 2:04 PM
     
dssdfdvasdwswsdfwwwvasvw
by hzx834998360 on Jul 22 at 2:08 AM
     
nice!!~~~~~
by rdxxrr on May 8 at 7:37 AM
     
nice!!~~~~~
by hackerlian on Apr 25 at 10:54 AM
     
sağolun çok
by oguz302 on Apr 13 at 3:40 PM
     
try~~~~~~~~~~~~~~
by warofnine on Apr 1 at 6:37 AM
     
good..........................
by penidas on Mar 11 at 12:59 AM
     
will see......................
by ultimacave on Mar 7 at 8:40 PM
     
ok I will check it!
by Junior_caigao on Mar 4 at 4:03 PM
     
ok i will check then will inform
by sali007 on Feb 28 at 7:05 AM
     
it is very good!
by zzyjtt on Feb 20 at 3:09 AM
     
Gerçekten çok güzel bir veritabanı
by Laglagaa on Nov 17, 2013 at 3:13 PM
     
Where is download?
by qwersin on Oct 29, 2013 at 6:05 PM
     
Herşey karşılıklı.
by bbbaaarrriiisss on Oct 15, 2013 at 4:39 PM
     
下下来看看,找了好久才找到
by clfdragon on Oct 7, 2013 at 10:01 AM
     
ne sacmalık yaaa
by programmerboy1 on Sep 2, 2013 at 8:19 AM
     
Just download for test。
by johnsmart on Aug 19, 2013 at 1:38 PM
     
download for test
by KXLF1220 on Aug 13, 2013 at 3:32 AM
     
great~~~~~~~~~
by wmlw1213 on Aug 8, 2013 at 2:35 PM
     
asdfsdffffffff
by blublood on Jul 31, 2013 at 5:51 PM
     
Database Developer
by noorzad110 on Jul 25, 2013 at 8:10 AM
     
aaaaaaaaaaaaaaaaaaaaaaaaaa
by aghallab on Jul 21, 2013 at 6:27 PM
     
good day good study thx
by chaos741206 on Jul 12, 2013 at 5:00 PM
     
good one to study
by remadagain on Jul 5, 2013 at 6:53 AM
     
indirme linki yorum yapınca mı gelecek ? Edit: yorum yaptım yine çıkmadı link kırık beyler
by byscul on Jun 20, 2013 at 5:55 PM
     
niceeeeeeeee
by candoguss55 on Jun 8, 2013 at 7:12 PM
     
good program
by misto_27 on Jun 2, 2013 at 12:01 AM
     
Zorla yorum mu olur arkadaş ?
by okanyuksel on May 22, 2013 at 11:42 AM
     
thank you very much
by maruihhy on May 6, 2013 at 10:58 AM
     
very very good program and easy to use :)
by oziyn on May 1, 2013 at 7:00 PM
     
next next next :)
by ultralion90 on Apr 29, 2013 at 12:51 PM
     
perfect database !!
by bnone on Apr 27, 2013 at 7:08 PM
     

by Saxosued on Apr 18, 2013 at 7:40 PM
     
its very good
by sametkckc on Apr 17, 2013 at 11:06 PM
     
Okkkkkkksadasfsadfdsfdsfdsfsdfdsa
by nonatotoc on Apr 17, 2013 at 1:50 PM
     
good!!!!!!!!!!!!!!!!!!!!!
by ajdopteronmomo on Apr 15, 2013 at 7:56 AM
     
on numara veritabanı. yorumların da çoğu türkçe la ne iştir anlamadım.
by roser137 on Apr 6, 2013 at 9:37 PM
     
deneme yapalım
by GSISONYA_BH on Apr 6, 2013 at 8:08 AM
     
deneyecegiz bakıcaz
by mratgrgn on Apr 1, 2013 at 11:24 PM
     
yılan gibi
by daghan51 on Mar 28, 2013 at 3:10 PM
     
zorla yorum mu yaptırılır arkadaş!
by onurmarangoz on Mar 28, 2013 at 2:08 PM
     
deneyelim birde biz
by fotococuk23 on Mar 23, 2013 at 4:42 PM
     
deneme amaçlı
by mukedo on Mar 18, 2013 at 1:45 PM
     
this is very good
by lscool on Mar 18, 2013 at 5:58 AM
     
fine very good
by yuksel_67 on Mar 10, 2013 at 3:41 PM
     
henhao,verygoods!
by sandea on Feb 23, 2013 at 2:36 PM
     
aaaaaaaaaaaaaaaaaaaaa
by EksenGrup on Feb 18, 2013 at 8:53 PM
     
test for data base
by moscatelli_1 on Jan 19, 2013 at 7:23 PM
     
asdfasdfasdfsadfdsfsdf
by dutamca on Jan 18, 2013 at 3:53 PM
     
aaaaaaaaaaaaaaaaaaa
by ayaz323 on Jan 14, 2013 at 7:07 AM
     
Microsoft senin yapacağın indirme sistemini...
by NavarinTR on Dec 19, 2012 at 11:30 PM
     
first to use
by bryan_zhang on Dec 15, 2012 at 6:59 AM
     
its very good
by DarkStern on Dec 9, 2012 at 12:47 PM
     
it's very good.
by coolkid4689 on Dec 5, 2012 at 3:05 AM
     
I like this project
by ngocvuong on Nov 17, 2012 at 1:36 AM
     
this site is not easy
by yfirat on Oct 29, 2012 at 3:15 PM
     
I like this project.
by hector28 on Sep 29, 2012 at 4:53 PM
     
this is fucking cool!
by timer85 on Aug 25, 2012 at 7:27 PM
     
i don't see download :(
by alosolanlan on Aug 19, 2012 at 12:48 PM
     
I like it ,it can help me to do some thing
by wanggf1010 on Aug 17, 2012 at 8:54 AM
     
its good enough :)
by ehsanM on Jul 30, 2012 at 8:36 AM
     
I like this!!!
by chenyi2006520 on Jul 29, 2012 at 7:15 AM
     
adjaksdjalsdkas
by Yildizalis on Jul 28, 2012 at 2:05 AM
     
aaaaaaaaaaaaaaaa
by velociraptor on Jul 15, 2012 at 9:37 PM
     
aaaaaaaaaaaaaaaaaa
by seal19871223 on Jul 3, 2012 at 6:05 AM
     
microsoft sql server
by akrep035 on Jun 25, 2012 at 5:26 PM
     
xcxcxxvcbcbcbc
by fevziyilmaz on Jun 16, 2012 at 1:50 AM
     
... ... ... ...
by barthex on Jun 14, 2012 at 11:21 AM
     
great project
by jmendoza_79 on Jun 13, 2012 at 11:54 PM
     
super project
by lada_slavka on Jun 9, 2012 at 9:43 PM
     
that is all
by dp3jimzhu on Jun 1, 2012 at 4:39 AM
     
asdfasdfasdfa
by jefferson_roma on May 21, 2012 at 7:18 PM
     
this is all
by jeffm0623 on May 21, 2012 at 2:27 PM
     
thanksgiving,good
by aresyh on May 16, 2012 at 5:37 PM
     
excellent!
by mehmetali on May 16, 2012 at 8:47 AM
     
i like this project.
by shinang on May 15, 2012 at 7:37 AM
     
anikor like this project
by anikor on May 15, 2012 at 3:48 AM
     
learn the report
by liuhaierok on May 14, 2012 at 2:23 PM
     
He was struggling for precise information on how to download the sample database. I would like to share the link from where you can find the AdventureWorks for SQL Server 2008 R2 Recently we moved from Newtonsoft.Json 3.5 to 4.0 version. We noticed that we were getting Could not load file or assembly 'Newtonsoft.Json, Version=3.5.0.0.. while working with Twitter authentication which we were usinga
by trongchiitspk on May 12, 2012 at 1:59 PM
     
Very like Very like Very like Very like
by pingzy on May 10, 2012 at 1:43 AM
     
i love you, you love me too.
by tomzou on May 9, 2012 at 3:22 PM
     
very like.for testing
by hijason88 on May 8, 2012 at 8:14 AM
     
Very like Very like Very like Very like
by fumingming on May 6, 2012 at 1:17 PM
     
for testing
by digtallin on May 6, 2012 at 12:16 PM
     
dshnthsfhbsdhfdh fdhgfdhnf
by sql_k on May 3, 2012 at 9:28 AM
     
I like 70 porcent
by SaraFerran on Apr 30, 2012 at 9:54 AM
     
nasıl indirildiği hakkında bir fikrim yok. Bu nasıl indiriliyor ki böyle. Dikkatlice de bakıyorum ama ben mi göremiyorum şu anda indirilemez diyor hem de indirme yapılabilir diyor nasıl iş bende mi bir sorun var...
by orhangazi on Apr 29, 2012 at 11:46 PM
     
This DOES suck. Did not install. It should come with SQL Server. So lame.
by smbaxter1265 on Apr 23, 2012 at 3:07 PM
     
This sucks. Doesnt install. This should just be part of sql server install
by arunsun on Apr 14, 2012 at 6:39 AM
     
This did not install for me either on Windows 7 Enterprise edition. But I found a work around: download universal extractor (uniExtract http://legroom.net/software/uniextract) and extract the sample csvs, sql scripts etc. from the .exe manually. Works perfectly that way.
by 8bitme on Apr 2, 2012 at 3:43 PM
     
The adventure works database and DW database and also the SSAS projects are very well made but where is the sample SSIS package that does the ETL from AW database to AW DW database? That would make it a perfect sample set to me.
by DennisMul on Mar 28, 2012 at 2:18 PM
     
Simply cannot get the Sample databases to install. 2008 R2 SP1 on Windows 7 Professional (64 bit). I did find the adventureworks.mdf for the OLTP and attached it successfully however, I was really going for the DataWarehouse components. I would really like a way to bypass the installer.
by medamo on Mar 15, 2012 at 8:53 PM
     
SQL Server 2012 databases are very simple to attach, and the BI project is simple to build and deploy.
by andrewwhitten on Mar 14, 2012 at 8:57 AM
     
Worked like a charm; matter of seconds to install. Just copied the install script and modified the path and that was it. Applied to to the 64 bit environment.
by wdwcodeplex on Mar 12, 2012 at 5:19 PM
     
Dreadful... Needlessly complicated. Should be distributed with SQL Server Setup anyway. Single machine with one instance of SQLExpress. AW setup could not find my instance. Finally turned on TCP/IP, NamedPipes, and SQL Browser (all defaulted to disabled...) Then AW Setup saw my instance. Could not get full text search enabled (not available as a feature on my downloaded installation).... Hideous
by DundeeDevl on Feb 22, 2012 at 6:53 PM
     
Cannot attach. 661/655 problem mentioned by others. Is there something I'm doing wrong?
by RGOConnor on Feb 17, 2012 at 3:40 PM
     
Installed with no issues on Windows 7 x64 with named instance. Nice work!
by NingBing on Feb 11, 2012 at 6:07 AM
     
Installed well on Windows 7 64-bit
by MarkTab on Feb 10, 2012 at 9:28 PM
     
1. Win 7+SQL Server 2008-download 'AdventureWorks 2008R2 SR1' default location. 2. Copy and paste in 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA' and extract here. 3. 'Attach' AdventureWorks2008 database through SQL Server 2008 RS 4. Also check FILE STREAM is enabled. It was initially challenging to download AdventureWorks2008 db onto Win 7, perseverance prevailed.
by deepthiy on Feb 5, 2012 at 7:31 AM
     
Please fix. There is no AdventureWorks2008R2 database in the installation. The database is necessary for AdventureWorks2008R2 Sample Reports project.
by bkejser on Feb 5, 2012 at 1:37 AM
     
yes~It ready good use
by weiham on Jan 31, 2012 at 9:02 AM
     
Worked perfectly for me with SQL Server 2008 R2 Express. I'm running Windows 7 Home Premium on a HP Pavilion p7-1174.
by ProfessorMetal on Jan 20, 2012 at 6:10 AM
     
Doesn't install on Denali.
by Bill_Ross on Jan 9, 2012 at 4:55 PM
     
Installer worked perfectly on my Win 7 Home Premium with SQL Server 2008 R2 Express.
by gby on Jan 4, 2012 at 10:25 PM
     
There is no AdventureWorks2008R2 database in this installation. This database is necessary for AdventureWorks2008R2 Sample Reports project. Where I can find this database?
by vbeths on Dec 13, 2011 at 10:15 AM
     
Unable to download the file
by ajjeys on Dec 11, 2011 at 9:06 AM
     
Does not work with the online tutorials. Tables in the online tutorials completely different than the AdventureWorks2008Re sample database. One star for easy down load on 64bit window7 on laptop. Finally got the right databas - AdventureWorks, but now i get error on sp.BusinessEntityID. I added one more star. I'll add one more when I figure out query error,
by Ron_2012 on Dec 11, 2011 at 12:57 AM
     
Just for study
by Lvtie1987 on Nov 24, 2011 at 3:25 AM
     
Excellent. The installer (SR1 version) worked without any problems. Windows 7 Home Premium Laptop.
by Emiro on Nov 21, 2011 at 11:55 AM
     
Excellent. Quick download. Installer worked fine, SSAS samples optional and also easy to install after running main program.
by Kluke63 on Nov 17, 2011 at 3:09 PM
     
The installer worked for me. I'd rather not have the OLAP rolled into it but other then that it worked fine.
by ArtOfSQL on Nov 16, 2011 at 10:37 PM
     
This is not a proper downloadable. The exe(AdventureWorks2008R2_SR1.exe) which is downloading is some scrap. Can you please correct the downloadable? My rating will definitely change for this once we have this working.
by snsrinivasan on Nov 4, 2011 at 4:06 PM
     
in Windows XP SP3 ,just downloads 2 bytes of exe which gives error when I execute. Stuck with it now. please resolve the download issue ASAP
by sjegadison on Nov 2, 2011 at 11:59 AM
     
not working, tried many times but it just downloads 2 bytes of exe which gives error when I execute. is it not available anymore?
by mranjank on Nov 1, 2011 at 6:20 PM
     
The database 'AdventureWorks2008R2' cannot be opened because it is version 661. This server supports version 662 and earlier. A downgrade path is not supported. I would think that 661 is included when it says 662 and earlier. Nice.
by dave456578 on Oct 20, 2011 at 6:22 PM
     
Try 'Run as Administrator' to run under 64-bit Windows. Otherwise, the setup fails.
by JefferyP2100 on Oct 4, 2011 at 7:56 PM
     
Very good, 3Q for your share.
by zfm850722 on Sep 8, 2011 at 8:37 AM
     
Installation provided helpful tips and went as expected. Env: Win7 x64, Default Instance.
by tdracz on Aug 29, 2011 at 11:31 PM
     
The documentation of the samples doesn't match the table names and design provided in the databases. i.e. AdventureWorks2008R2 database doesn't exist, however AdventureWorks exists, and so on... It is quite painfull to use this release to follow the tutorials.
by vhinzu on Aug 29, 2011 at 4:15 PM
     
It installed just fine but doesn't have the tables for the SSRS tutorials for SQL2008R2. Microsoft desperately needs to remove the cheap labor from its documentation department. It's just not working out. Now going over to the forums to try and figure out what to use.
by baybear2004 on Aug 26, 2011 at 5:20 PM
     
Installed mine on SQL 2008 Standard no problemo.......
by msimango on Aug 24, 2011 at 11:34 AM
     
The same problem like been mentioned by someone on 2nd Aug - for 64 bit platform setup button is disabled. I have managed myself to install it. 1 I extract the archve and found that executable inside the archve doesn't want to run on 64 bit platform. 2 I went to the folder with reqired database and fount *.sql file 3 I have modified the parameters :setvar 4 run script in SQLCMD mode
by gretchkosiy on Aug 17, 2011 at 2:52 AM
     
i like the sample ,because of it's beautiful report and database schema.
by breathhard on Aug 13, 2011 at 6:16 PM
     
I have two instances(default + named) on SQL Server 2008 R2 on Win 7 64bit. The install button is disabled for both instances.
by anildwa on Aug 2, 2011 at 9:15 AM
     
averagely good
by xelio789 on Jul 30, 2011 at 1:30 PM
     
Essential download for demos and producing samples. Installation straight forward and no issues on Windows Server 2008 R2/SQL Server 2008 R2.
by SamadKhan on Jul 2, 2011 at 4:02 PM
     
handsome guy
by hp1920 on Jun 22, 2011 at 3:33 PM
     
I had no problems at all. Installed in 4+ minutes. I must point out, though, that when I installed SQL Server 2008 R2, I selected Full Text Search and FILESTREAM, and added another instance (to keep the play and the work separate). So when I attempted the samples installation everything was ready to go. I suggest to those with problems to check the server installation or re-install.
by Anaristos on Jun 12, 2011 at 6:18 PM
     
Install not success. A fatal error occurred during installation. Details: Failed object initialization (ISupportlnitializeEndlnit). An exception occurred in SMO while trying to manage a service. Error at object DatabaseSelection’ in markup file Databaselnstaller;component/ databaseselection.xaml Line 78 Position 3.
by saknarak on May 31, 2011 at 4:55 AM
     
Mine installed without a problem on my Vista System. If you have a problem installing, then resolve it, since that is going to be your job anyway, if your are a MCDBA. Do not be deceived, Oracle has the same kind of issues too. TC
by webreviews on May 29, 2011 at 5:54 PM
     
It is a five because it worked like a charm on first installation. No hurdles or anything..just went through!!!
by husseinsamwel on May 23, 2011 at 8:59 AM
     
zuberztaha
by zuberztaha2010 on May 12, 2011 at 1:29 PM
     
Wow. Who knew.... the download file must be put in the 'C:\Program Files\Microsoft SQL Server\MSSQL10_50."named instance(i.e. SQLEXPRESS)" folder before you try to install it. Otherwise, you get the dreaded "Failed object initialization (ISupportInitialize.EndInit). An exception occurred while executing a Transact-SQL statement or batch. Error at object ‘DatabaseSelection’ in markupfile" message
by mascott on May 10, 2011 at 8:58 PM
     
There appears to be no installer for SQL Server 2008 Developer Edition/x86. The FILESTREAM option under the R4 release is mandatory, but not supported for 2K8 Dev/x86 when running under WOW (as I am). The AdvWorks "no FILESTREAM" version indicates it must run against a later version of the database than the one I have. Is it really this complicated to install the demo database?
by OklahomaDave on Apr 12, 2011 at 7:13 PM
     
As a newbe to MS SQL server I appreciate the sample databases and scripts. I’m presently having issues connecting with Crystal Reports & SAP. Can anyone provide a reference to get me going fast?
by CJHisthebest01 on Mar 30, 2011 at 4:35 AM
     
i very want to get this ths
by tippoint on Mar 7, 2011 at 7:03 AM
     
It worked. Is it not possible to automate the prerequisite-checking?
by GreatBittern on Feb 24, 2011 at 4:03 PM
     
OKed ededede
by fjimenez on Feb 24, 2011 at 2:55 PM
     
Didn't work for my default instance. Many thanks to HilaryCotter for the suggestion provided in her rating above. That got me access to the tables and I could proceed from there. This 30 min project took 3 hours. This release needs work.
by MarioAnz on Feb 21, 2011 at 3:15 PM
     
Worked a treat, as a newbie I am very relieved. Well done.
by alnis on Feb 20, 2011 at 4:32 AM
     
I have SQL Server 2008, R2 on Windows Server 2008, standard, R2. I used individual domain accounts to run the services. Before installing the sample databases I made sure (checked and double check) that the individual domain accounts had the correct access. The last step was to install the sample AdventureWorks. The instructions for the sample db were perfect, worked perfectly the first time.
by VSCoder60 on Feb 5, 2011 at 6:45 PM
     
Installed without a hitch, and the steps to configure my database for this install were clear and concise, thanks!
by briansboyd on Jan 7, 2011 at 10:41 PM
     
Installed without a problem.
by afulmer on Jan 2, 2011 at 4:15 AM
     
It worked well without any problem.
by gavesh on Dec 30, 2010 at 2:00 AM
     
Installed without any problems :)
by petrzima on Dec 10, 2010 at 11:13 AM
     
ARE YOU SERIOUS - - first, several errors installing 2008r2 (MOF error, WMI bull, instances switching, NOW there are glitches trying to get even the simple examples loaded for a presentation on why we need to move from Oracle - - TWO solid wasted days trying to get a fresh machine off of the ground - - get it together guys, you have plenty of time and bucks on your hands - - shameful PERIOD...
by turbothis on Dec 10, 2010 at 4:04 AM
     
There was an error in the install package when there was only a single instance of SQL Server. This has been fixed. Folks that received the error message "No valid sql server instances are accessible for installation" should try the install again. Gail Erickson [MSFT] SQL Server Documentation Team
by Gaile on Dec 6, 2010 at 9:46 PM
     
No problems at all,.... Just unzipped and installed them without any problems. Do you guys have the right SQL server edition?
by BryanVanRijn on Dec 3, 2010 at 3:25 PM
     
These samples install and work like charm and I'm sure no one would have any issues if first have READ and DONE the "Database Prerequisites for SQL Server 2008R2" http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Prerequisites%20for%20SQL%20Server%202008R2 Just one service needs to be set to Automatic, and then start it. And FILESTREAM to be enabled as described. Wish u success!
by skarakolev on Dec 3, 2010 at 12:04 PM
     
This doesn't work. When is someone at Microsoft going to notice? None of the earlier suggestions work for me.
by rjback on Dec 2, 2010 at 3:06 PM
     
Doesn't work. To get it to work after you get the error go to a command prompt and change directories to cd %temp% then do this dir /od You should find a directory which looks something like this: WZSE0.TMP go inside that directory and type explorer . Then you will see all the folders. Copy these folders to a known location on your hard drive (I use C:\temp). Open up SSMS run instawdb.sql
by HilaryCotter on Dec 2, 2010 at 12:54 PM
     
Honestly, this defective install is a stupid waste of time. It does not work on a default installation. I ended up having to compile the examples manually from the script files because I don't know how to create a new instance (nor do I want one). I presume that this is intended for beginners??? Why wasn't it actually tested in a default environment???
by GlenT on Nov 30, 2010 at 11:01 PM
     
Yep. it needed one more instance to work. Was trying to figure out for couple weeks now. Glad that smart people figured out what is the work around. Once pass that install issue, things seems to be in order. Can not give better rating if the taking off is so tough.
by another_coder on Nov 30, 2010 at 5:22 PM
     
For the others who are trying to install this: It does not seem to work on an install to the default instance. You need to create a new instance (e.g. MYSQLSERVER) then run the sample data on the new instance and it'll work fine. That's what i did and it is working. Give it a try. G'luck.
by cr8zymike on Nov 30, 2010 at 1:54 PM
     
Same problem: "No valid SQL Server instances are accessible for installation". Fresh installation of Win7, SQL Server 2008, all prerequisites met. Ended up installing 2008 SR4. Please fix!
by leahcimp on Nov 28, 2010 at 12:07 PM
     
I had the same "no valid SQL Server instances are accessible" error. I installed a 2nd DB instance (was going to anyway) and when I re-ran setup being able to toggle between the instances did the trick. Switched to my 2nd instance, then back to default (where I want the sample DB) and it gave me the option to select components to install. Windows 7 x64 install.
by iwkid on Nov 24, 2010 at 3:06 PM
     
same install problem No valid SQL Server instances are accessible for installation. If instances are available the problem could be due to SMO issues. This is a default installation on Windows 2008 R2 Enterprise server, everything is 64bit. SQL 2008 R2 Enterprise 64bit, complete install. Please fix.
by wickedHangover on Nov 24, 2010 at 2:25 PM
     
In fact I now know nothing about it
by xiashiwendao on Nov 24, 2010 at 6:11 AM
     
Message from Install:"No valid SQL Server instances are accessible for installation. If instances are available the problem could be due to SMO issues." The install in the tools directory was run - same message(sam program) but the install program dropdown shows the 3 SQL instances running on the laptop and the SQL2008R2 is the one it shows - how can it say no instances when it runs. (XP SP3)
by MarkMitchell on Nov 22, 2010 at 3:38 PM
     
Same error on Win7 64bit SQL 2008R2 fresh install
by Joshka on Nov 22, 2010 at 3:04 AM
     
same issue - I got around this issue by creating an Instance on : C:\Program Files\Microsoft SQL Server. Installer does appear to find Instances in this "default" location.
by amrit on Nov 20, 2010 at 4:59 PM
     
Same issue... no instance found... Thank you for fixing
by UtilisaCP on Nov 19, 2010 at 10:22 AM
     
Attempted to install multiple times: Fresh setup of Windows 2008R2 and then SQL 2008R2. I am getting message that no instance found - tried 4 times. Setup copies files to directory, but because instance not found - no DBs are created. Then installed 2008 SR4 samples - worked no problem for first attempt. Please fix this setup.
by vidas_m on Nov 19, 2010 at 12:06 AM