NPS Server Migration: Appendix A - Data Collection Worksheet

Updated: November 11, 2009

Applies To: Windows Server 2008 R2

Migration data collection worksheet

You can use this migration data collection worksheet to collect data about your source server and help ensure that the destination server functions properly after the migration.

NPS data worksheet

# Source server essential settings Setting values


Server name

At a command prompt, type the following command, and then press ENTER.

ipconfig /all

The host name of a server is the first part of the fully qualified domain name (FQDN). The FQDN is the full computer name, including both the host name and the primary DNS suffix, separated by dots (.). For example, the FQDN of a computer named host with a primary DNS suffix of is

Computer host name: _____________________________

FQDN: _______________________


Authentication, authorization, and accounting (AAA) roles

Determine what types of network access requests are validated using the RADIUS protocol on the source server.

Check all that apply (√)

  Network Access Protection (NAP)

  RADIUS server for dial-Up or VPN connections

  RADIUS server for 802.1X wireless or wired connections


Text logging

Record the path and settings used for text logging. By default, local file accounting logs are stored in %windir%\system32\LogFiles.

Local file logging directory: _____________________________

Format: _______________________

Create a new log file: _______________________


SQL settings

Manually record any customized SQL data link properties.

Application Name: __________________________

Auto Translate: _______________________

Connect Timeout: _______________________

Current Language: _______________________

Data Source: _______________________

Extended Properties: _______________________

General Timeout: _______________________

Initial Catalog: _______________________

Initial File Name: _______________________

Integrated Security: _______________________

Locale Identifier: _______________________

Network Address: _______________________

Network Library: _______________________

Packet Size: _______________________

Password: _______________________

Persistent Security Info: _______________________

Replication server name connect option: _______________________

Tag with column collation when possible: _______________________

Use Encryption for Data: _______________________

Use Procedure for Prepare: _______________________

User ID: _______________________

Workstation ID: _______________________

See Also


NPS Migration Guide
NPS Server Migration: Preparing to Migrate
NPS Server Migration: Migrating the NPS Server
NPS Server Migration: Verifying the Migration
NPS Server Migration: Post-migration Tasks