• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 20. Exploring Access Data Projec... > Connecting to a Remote SQL Server Da...

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.

  3. If you're connecting 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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint