SQL Server Settings

TechWriter supports documenting SQL Server 2000, 2005 and 2008 databases through the SQL Server source. When you add a SQL Server source to your project, TechWriter displays the following dialog.

Use this dialog to specify your SQL Server connection settings.

SQL Server Setting Description

Server Name of the server and instance where your SQL Server database is located.

Connect using Windows Authentication Select this option to use Windows Authentication.

Connect using SQL Server Authentication Select this option to use SQL Server Authentication.

User Name The name of a user that has permission to the SQL server and database.

Password The password of the user.

SQL Server Setting	Description
Server	Name of the server and instance where your SQL Server database is located.
Connect using Windows Authentication	Select this option to use Windows Authentication.
Connect using SQL Server Authentication	Select this option to use SQL Server Authentication.
User Name	The name of a user that has permission to the SQL server and database.
Password	The password of the user.

Note: The SQL Server source supports all editions of SQL Server except the Compact edition. For SQL Server Compact databases, use the SQL Server Compact source instead.