Configuring SQL Server for Data Access

In Access 2003, you didn't need to do any special SQL Server setup before upsizing an Access database to SQL Server using the Microsoft Database Engine (MSDE), the predecessor to SQL Server 2005 Express. But the situation in Office 2007 is very different. In addition to preparing your Access database, you also have a considerable number of setup chores to do to make SQL

SQL Server Books Online

ou can download a set of books on SQL Server 2005 from www.microsoft.com/technet/ prodtechnol/sql/2 0 05/downloads/books.mspx.

Once downloaded and installed, you can open the SQL Server Books Online from the newly created Documentation and Tutorials group under the Microsoft SQL Server 2005 program group:

Windows Defender Windows DVD Maker Windows Fax and Scan Windows Live Messenger Download Windows Mail Windows Media Center Windows Media Player Windows Meeting Space ^ Windows Movie Maker ^ Windows Photo Gallery I Windows Update Accessories Broderbund CA

Extras and Upgrades

Games

Maintenance

Microsoft .NET Framework SDK v2.0 Microsoft Developer Network Microsoft Office Microsoft SQL Server 2005 tf) SQL Server Business Intelligence Dev r>5. SQL Server Management Studio Analysis Services Configuration Tools Documentation and Tutorials SQL Server Books Online [\ . Tutorials I Back

Opening SQL Server Books Online Help.

The books include documentation for both the regular version of SQL Server 2005 and SSE:

Books Online SQL Servei 2005 Books Online (July 2006) Miciosolt Document Exploiei

File Edit View Tools Window help

È 1» Af 1 ©'How Do I - Search .¿Index .^Contents help Favorites | jf . | ■*) Ask a Question \J jAjj

Contents ▼ fl X

Books Online "Search | -w X

Filtered byi

Fl Qptions: (choose) ^ m

(unfiltered) v

-

ffl- SQL Server 2005 Books Online

É- SQL Server 2005 Tutorials

(B- SQL Server Express Edition Books Online

è- SQL Server 2005 Mobile Edition Books Online

S- Help on Help (Microsoft Document Explorer Help)

Books Online

□ Collapse All 0 send

-

Welcome to Microsoft SQL Server 2005 Books Online. This set of documentation helps you understand SQLServer 2005, and how to J implement data management and business intelligence projects. ;! SQL Server 2005 includes several data management and analysis technologies, To learn more about these technologies, click the 1 following links.

1 To download a local copy of Books Online or to update a local coov. see Downloadina and Uodatina Books Online,

[=] Categories

General

| Database Engine Information

^Contents ]Index ||T]Help Favorites

Kl - II >

iss«_

The Contents page of SQL Server Books Online.

If you have upgraded SQL Server 2005 to Service Pack 2, make sure to also download the equivalent upgrade for SQL Server Books Online (available from the same web page as the SP2 patch for SQL Server, www.microsoft.com/sql/ctp.mspx), so the documentation will reflect the SP2 changes.

Server (or SSE) available as a back end for Access. By default, when SQL Server (or SSE) is installed, it may not be set to run on startup. To ensure that SQL Server is running and available, follow these steps:

1. Open the SQL Server Configuration Manager from the SQL Server (or SSE) group on the Start menu, as shown in Figure 18.2.

2. Select SQL Server 2005 Services in the left pane of the SQL Server Configuration Manager (Figure 18.3). In Vista, you may get a User Account Control (UAC) message. If so, just click Continue.

Part III

Selecting the SQL Server Configuration Manager item on the Start menu.

^ Default Programs

-

desktop.ini

£ j desktop,ini

A File Transfer Manager

& Internet Explorer

Microsoft Beta Client

El Windows Calendar

4) Windows Contacts

¡ää Windows Defender

Windows DVD Maker

ügj) Windows Fax and Scan

Windows Live Messenger Download

Windows Marl

© Windows Media Center

Windows Media Player

Windows Meeting Space

^ Windows Movie Maker

=

^ Windows Photo Gallery

^ Windows Update

j, Accessories

J,, Broderbund

,. Extras and Upgrades

j, Games

J»: Internet Security 14

Jg Maintenance

|b Matrox GraphicsInc

St Microsoft .NET Framework SDK v2.0

, Microsoft Developer Network

Jj Microsoft Office

J. Microsoft SQL Server 2005

J,, Configuration Tools

§1 SQL Server ConfiguratiomManac

i]^ SQL Server Error and Usa\^/Repe

SQL Server Surface Area Configu -

0 0

Post a comment