tailieunhanh - Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .Net - P5

Tham khảo tài liệu 'programming microsoft sql server 2000 with microsoft visual basic .net - p5', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | using the OPENROWSET function because the linked server syntax is more straightforward and you no longer have to perform the first two steps. Create a linked server for a remote or heterogeneous data source with the sp_addlinkedserver system stored procedure. This procedure can take as many as seven arguments but you can use as few as two arguments for creating a reference to a remote SQL Server source and as few as four arguments for a linked server pointing to an Access data source. After correctly initializing the linked server reference with the sp_addlinkedserver system stored procedure invoke sp_addlinkedsrvlogin for mapping logins on the current SQL Server 2000 instance to logins for the remote or heterogeneous data source. When a user runs a query on the local server against the linked server the local server logs in to the linked server with the credentials specified when the sp_addlinkedsrvlogin system stored procedure was last run for the linked server. You can invoke the sp_linkedservers system stored procedure to itemize in a result set the linked servers defined on a local server. Security for Virtual Directories Virtual directories are necessary for Web data access to SQL Server data sources via XML. Each database that requires Web access via XML must have a virtual directory pointing to it. As described in the Virtual Directory Management section of Chapter 6 you must designate a login for the virtual directory. All access to the database is mapped through the login that you specify on the Security tab of the Properties dialog for a directory. Figure 7-1 shows the Properties dialog box used for the MyNwind virtual directory that served as the source for most of the samples in Chapter 6. Notice that the Security tab specifies IUSR_CCS1 in the User Name text box. The User Name text box contains the login name for the virtual directory. Selecting Windows as the Account Type automatically installs I USR_servername as the login. Windows 2000 Server .