![]() ![]() ![]() Repeat steps 1 through 6 to install the DW BI and/or LT databases databases.Select the database server and click Next to complete the installation.This option will automatically restore the databases, but it is turned off by default. Turn on the restore database options during the install, as shown below.Run the msi installer and click through the intro and license screens.Ensure you have FILESTREAM services enabled on your SQL Server 2008 server (see notes above).Ensure you have Full-text Filter Daemon Launcher Service running.Download the msi installer for SQL Server 2008 AdventureWorks databases you want to install from CodePlex.To enable FILESTREAM services on SQL Server 2008, see my post, How To Enable FILESTREAM Feature On SQL Server 2008. If you don’t, the AdventureWorks database installation will fail trying to restore the database, and will warn you that FILESTREAM needs to be enabled. If you did not enable FILESTREAM services during the SQL Server 2008 install, you’ll need to light it up prior to installing the sample AdventureWorks OLTP and DW databases. NOTE: You may receive an error stating that FILESTREAM is not enabled during the install if this service is disabled, which is a bit misleading. The AdventureWorks LT (Light) – A highly simplified and smaller sample database which is helpful for those who are new to relational database technology.īefore attempting the installation, ensure the following services:Įnsure you have Full-text Filter Daemon Launcher Service running.This database is excellent for constructing SQL Server Analysis Service (SSAS) OLAP cubes and demonstrating the Business Intelligence (BI) capabilities of SQL Server and BI client technologies like MOSS 2007, Reporting Services, and Excel. AdventureWorks DW – A data warehouse database containing a year of data in a star schema, containing multiple fact and dimension tables.This database is useful for demo scenarios, and includes data for Manufacturing, Sales, Purchasing, Product Management, Contact Management, and Human Resources functions. AdventureWorks OLTP – A standard online transaction processing database containing a year of data of data for a fictitious bicycle manufacturer (Adventure Works Cycles).For SQL Server 2008, there are 3 databases. There are versions for SQL Server 2000, 20, but this post is concentrated on the 2008 versions. If the "AdventureWorks" database is present, this is a finding.There are several versions of the AdventureWorks databases out there. SELECT name from sysdatabases where name like 'AdventureWorks%' Microsoft SQL Server 2012 Database Instance Security Technical Implementation GuideĬheck SQL Server for the existence of the publicly available "AdventureWorks" database by performing the following query: These demonstration and sample objects are meant to provide simple examples of coding specific functions and are not developed to prevent vulnerabilities from being introduced to the SQL Server and the OS. Even though the very popular "AdventureWorks" database is no longer available by default, it introduces a vulnerability to SQL Server and must be removed.ĭemonstration and sample database objects and applications present publicly known attack points for malicious users. Examples include, but are not limited to, installing advertising software, demonstrations, or browser plug-ins not related to requirements and providing a wide array of functionality not required for every mission, but which cannot be disabled.Īpplications must adhere to the principles of least functionality by providing only essential capabilities. It is detrimental for applications to provide, or install by default, functionality exceeding requirements or mission objectives. Some of the functions and services, provided by default, may not be necessary to support essential organizational operations (e.g., key missions, functions). Information systems are capable of providing a wide variety of functions and services. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |