#Adventureworkslt database install
Otherwise, download the SQL Server Express Management Studio from the Microsoft SQL Server Express page ( express/bb410792.aspx) and install it on your machine. If you already have the SQL Server client tools installed, open the SQL Server Management Studio (Start ^ All Programs ^ Microsoft SQL Server 2005 ^ SQL Server Management Studio) and connect to the local SQL Server Express database.ī. Attach the sample database to SQL Server Express using one of the following methods:Ī. Restart [stop and then start) selected service.įigure 9-10. J [3 SQL Server ❰05 Network Configuration 2 Protocolsfor MSSQLSERVER Q Protocols for SQLEXPRESS t 111 SQL Native Client Configuration SQL Server Configuration Manager j SQL Server 2005 Services In the left pane, select SQL Server 2005 Services, then right-click SQL Server (SQLEXPRESS) and select Restart to restart SQL Server, as shown in Figure 9-10. Enabling the Named Pipes protocol in SQL Server 2005 ExpressĤ. In the right pane, right-click the Named Pipes protocol and select Enable, as shown in Figure 9-9. In the left pane, select SQL Server Configuration Manager (Local) ^ SQL Server 2005 Network Configuration ^ Protocols for SQLEXPRESS.ģ. Open the SQL Server Configuration Manager (Start ^ All Programs ^ Microsoft SQL Server 2005 ^ Configuration Tools ^ SQL Server Configuration Manager).Ģ. If you are using SQL Server Express (included in Visual Studio 2008), you will need to enable the Named Pipes protocol:ġ. Otherwise, install the database to the Data subdirectory under its installation directory. If SQL Server is installed in the default directory, install the sample database to C:\Program Files\ Microsoft SQL Server\MSSQL.1\MSSQL\Data\. msi package applicable for your platform (32-bit, 圆4, or IA64).
The examples in this chapter will not work with the full AdventureWorks database. Please note that while this database is a simplified version of the more comprehensive AdventureWorks, the two are quite different. Sample database, which you can download from. The rest of the examples in this chapter use the SQL Server 2005 AdventureWorksLT
0 kommentar(er)
