Connecting to a Remote SQL Server Database

To connect to an SQL Server database on a production server, such as the database you transferred in the preceding section, do this:

  1. Choose File, Connection, to open the Data Link Properties dialog.

  2. Open the Select Server or Enter a Server Name drop-down list and select the NetBIOS name of the server (see Figure 20.43). If the server doesn't appear in the list, type its name in the list's text box.

    Figure 20.43. All instances of SQL Server on machines running Windows 2000 or NT appear in the server name list. On a client running Windows 98/Me, you must type the NetBIOS name of the server.

    graphics/20fig43.jpg

  3. If you're connecting with Access 2000 or 2002 from a machine running Windows 98/Me, select Use a Specific User Name and Password to connect to the server, and type the logon ID (sa, unless you've added SQL Server accounts) and password, if the account is secured. Otherwise, accept the default Use Windows NT Integrated Security option.

  4. Select the database name, and click Test Connection.

  5. Click OK to connect to the remote SQL Server database.

Note

If you used the Copy Database File Feature to copy an .mdf file, you can attach the copied file to your local instance of SQL Server, as shown in Figure 20.44. This process emulates SQL Server Enterprise Manager's capability to attach .mdf files, but you aren't connected to a remote SQL Server. (Only the file is remote.)


Figure 20.44. If you need to attach an SQL Server .mdf file to a database, you can do so by selecting the Attach a Database File as a Database Name option, typing the database name to use, and navigating to the location of the file.

graphics/20fig44.jpg



Special Edition Using Microsoft Office Access 2003
Special Edition Using Microsoft Office Access 2003
ISBN: 0789729520
EAN: 2147483647
Year: 2005
Pages: 417

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net