Use this tab of the Database Connection Properties dialog box to set parameters required for SQL server:
Server
Select the SQL Server to connect to. Usually you just need to enter a server name or choose a server from the recently used ones. If the server works on non-default port (default is 1433), you may specify the port in the following form: <server>,<port>. In more advanced cases you can specify the protocol to connect through. You can specify the protocol in the following form: <protocol identifier>: <server>. Allowed protocol identifiers are listed below:
tcp - TCP/IP protocol
np - named pipes
lpc - shared memory
spx - NWLink IPX/SPX
To connect to an active user instance of SQL Server 2005 Express Edition, connect using named pipes protocol specifying the pipe name, such as np:\\.\pipe\3C3DF6B1-2262-47\tsql\query. For more information, see the SQL Server documentation.
Authentication
Authentication method. Can be Windows (use Windows user account name and password) and SQL Server (User name and password should be provided).
User
The SQL Server login account.
Password
The password for the SQL Server login account.
Allow saving password
If set to true the password is stored among the other connection parameters and next time you should not enter it again.
Database
Select a name of SQL Server database you want to connect from drop-down list or enter it manually. The list is available only if you specify other connection parameters.
Connection name
Enter a required connection name. It will be displayed in the header of the Schema comparison document. If not specified, the connection name is autogenerated in the following way: <database>.<host>. Note, the connection name does not affect SQL statement syntax or execution. It cannot be used as your database alias.
Test connection
Press this button to verify that you have correctly specified all required parameters and the connection can be established.
See Also