Back   How to Register for New SQL Server Database Select Enterprise Manager for Start > Programs > Microsoft SQL Server 7.0    Right click the Server or Server group, then click New SQL Server Registration. Server Registration Wizard will be started. Click Next on the Welcome screen of the Register SQL Server Wizard. Select the Server alias name listed in the Available Servers and click Add to the Add Servers box.       Select the authentication mode to connect to SQL Server. This always prompts for the username and password.       Click Next Give the Login name and Password to connect to the SQL Server.       Click Next Select the SQL Server Group as the default name by selecting the option and click Next. Now the wizard prompts to check the details given and press Finish . It will take few minutes to complete the registration process and a screen will be displayed similar to the picture shown below once the registration is completed.       Click Close How to transfer data using Data Transformation Services Wizard Expand the Server Group and select the server.       Right-click, point to All Tasks and select Export Data. Data Transformation Services Wizard will be displayed and follow the steps. Select your data source in the Source box.  In order to connect to SQL, give the username and password for authentication. In the Database box, select your database that is listed, similar to the screen displayed below.   Click Next In the Choose Database Destination, enter the details and a similar screen will be displayed.       Click Next Specify the tables or queries to be transferred by choosing one of the option, as shown in the following screen.       In our example, Transfer objects and data between SQL Server 7.0 databases Click Next, and follow the steps as the Wizard prompts, and select options that are applicable to you. Click Finish, once all the given information is successfully specified, and your data has been transferred to the specified destination.