{"id":2674,"date":"2010-12-03T11:03:15","date_gmt":"2010-12-03T19:03:15","guid":{"rendered":"https:\/\/www.zubairalexander.com\/stage\/?p=2674"},"modified":"2025-03-29T16:39:57","modified_gmt":"2025-03-29T23:39:57","slug":"sql-server-adventureworks-installation-issue","status":"publish","type":"post","link":"https:\/\/www.zubairalexander.com\/blog\/sql-server-adventureworks-installation-issue\/","title":{"rendered":"SQL Server AdventureWorks Installation Issue"},"content":{"rendered":"

The other day I was installing the AdventureWorks sample database for SQL Server 2008 R2 SR1 from CodePlex. When I executed the AdventureWorks2008R2_SR1.exe file the installation wizard started as normal.<\/p>\n

\"\"<\/a><\/p>\n

On the next screen, the Installation Instance box was empty.<\/p>\n

\"\"<\/a><\/p>\n

I was logged in with an account that was a member of the Administrators group. I use this account (SP_Admin) to manage SharePoint Server 2010 on a Hyper-V image that we use to teach SharePoint 2010 classes for my company. I tried a few additional things, including enabling FILESTREAM for Transact-SQL access for the default SQL instance (SQL Server Configuration Manager -> SQL Server Services -> SQL Server (MSSQLSERVER) -> Properties -> FILESTREAM tab -> Enable FILESTREAM for Transact-SQL access) but nothing worked.<\/p>\n

I realized that the account that had the sysadmin server role was the Administrator account on the server which runs Active Directory, SQL Server 2008 R2 and SharePoint Server 2010. I had a couple of choices. I could have logged in as the Administrator account and installed AdventureWorks, or I could give the SP_Admin account the sysadmin role for the SQL Server. I decided to take the easy rout since this is not a production server and added SP_Admin to the sysadmin server role. After that I was able to see the Default instance in the installation wizard and the path was pointing to the correct location.<\/p>\n

\"\"<\/a><\/p>\n

I was able to successfully install AdventureWorks sample databases that we use in our SharePoint 2010 Bootcamp demos.<\/p>\n

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

The other day I was installing the AdventureWorks sample database for SQL Server 2008 R2 SR1 from CodePlex. When I executed the AdventureWorks2008R2_SR1.exe file the installation wizard started as normal. On the next screen, the Installation Instance box was empty. I was logged in with an account that was a member of the Administrators group. […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[54,59,11],"tags":[],"class_list":["post-2674","post","type-post","status-publish","format-standard","hentry","category-sharepoint","category-sql-server","category-tips-tricks"],"aioseo_notices":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts\/2674","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/comments?post=2674"}],"version-history":[{"count":2,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts\/2674\/revisions"}],"predecessor-version":[{"id":16235,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts\/2674\/revisions\/16235"}],"wp:attachment":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/media?parent=2674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/categories?post=2674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/tags?post=2674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}