This dialog is used to help form a connection string to a non-Managed MSSQL database.
Select a server name from the drop-down list, or type the location of the server where the MSSQL database you want to access is located.
Click Use NT Authentication to specify that the provider request a secure (or trusted) connection to a the MSSQL Server. When selected, SQL Server uses integrated login security to establish connections using this data source, regardless of the current login security mode at the server. Any login ID or password supplied is ignored. The database administrator must have associated your Windows network ID with a SQL Server login ID.
Enter the user name to use for authentication when you log on to the MSSQL database.
Enter the password for your user name.
Enter the name of the database you are connecting to. Use the combo list to select from a list of databases belonging to the specified server. Note: You must have entered a valid server name, user name and password so that the server can be queried to provide this list.
Click the Test Connection button to test the connection properties that you have entered. The Studio will attempt to connect to the database using these settings. If a connection is established, then a 'success' message will be displayed. If the connection fails, then an error is displayed showing the full connection string that was used.
Click the Make Default button to make the connection settings in this dialog the new default connection settings for the current workspace.
Click OK to use the entered connection properties to form the connection string for the new table that you are creating.
Click Cancel to close this dialog without using the entered connection properties.