Huge Collections of Software Manuals and Knowledgebase

GreatManuals.com
Huge Collections of Software Manuals and Knowledgebase
 
Home Contact Us Request to publish your help manuals Request to remove your help manuals
Introduction
» MSSQL-to-Access
» Requirements
» Limitations
Using MSSQL-to-Access
» Command Line
» Connect to MS SQL Server
» Merging & Overwriting
» Select Databases
» Select Tables
» Troubleshooting
 

Connect to MS SQL Server

On this wizard screen you should enter the necessary settings to establish connection with Microsoft SQL Server. In "MS SQL Server" field you should specify the name of an instance of MS SQL Server to which you want to connect. If you leave it empty, the local server is assumed.

database migration utility Migrating from Microsoft Access to MSSql
Convert Database database conversion tool

Then you should specify the type of authentication to use when connecting to MS SQL Server:

  • Windows authentication - SQL Server will validate the connection using the Windows NT user information. This option is only available when connecting to an instance of MS SQL Server on Windows NT. The client should be member of a Windows NT/2000 domain or workgroup. The user needs to be validated as a Windows NT user before access is granted.
  • SQL Server authentication - SQL Server will use the standard security validation. To log in you should specify user name and password recognized on the target MS SQL Server.
Home | Contact Us | Request to publish your help manuals | Request to remove your help manuals