Documentation: Aqua Data Studio 4.7		HTML Documentation download, ZIP: ads-docs.zip (Size: 20MB) / ads-docs-no-shots.zip (Size: 368KB)

Getting Started   Installation   JDBC Drivers   I. Oracle   II. DB2 UDB   III. SQL Server   IV. Sybase ASE   V. Sybase Anywhere   VI. Informix   VII. PostgreSQL   VIII. MySQL   Character sets   Registering Servers   I. MSDE 2000   II. SQL Express 2005   III. PostgreSQL SSL   Application   I. Browser & Scripting    II. Visual Editing   III. SQL History   IV. Shortcut Toolbar   V. Options   VI. Settings   Query Window   I. Basics   II. Shortcut Keys   III. Toolbar   IV. Server Side Comments   V. SQL Automation   VI. Variable Binding   VII. Results   VIII. Save Results   IX. Auto-completion   X. SQL Formatter   XI. Permissions   XII. Parameterized   Visual Explain Plan   I. Basics   II. Explain Plan   III. Explain Diagram   IV. Whiteboard   Procedure Editor   Tools   I. Table Data Editor   II. Script Generator   III. ER Diagram   IV. Query Builder   V. Import Tool   VI. Export Tool   Oracle DBA Tools   I. Instance Manager   II. Storage Manager   III. Rollback Manager   IV. Log Manager   V. Security Manager   VI. Session Manager   VII. SGA Manager   VIII. Server Statistics

SQL Server 2000 MSDE (Desktop Edition) - Configuring MSDE and connecting with Aqua Data Studio. Connecting to SQL Server 2000 MSDE with Aqua Data Studio requires that you have remote connections enabled accepting TCP/IP connections. Once you have TCP/IP network connections enabled, you can connect to SQL Server MSDE using the hostname and instance name in the Host: parameter. 1. Installing MSDE with Network Connections enabled: First step is to install MSDE with network connections enabled. By default, MSDE is installed with network connections disabled. To install MSDE with with network connections, you must run the setup.exe from the command prompt and specifying the DISABLENETWORKPROTOCOLS=0. As described in the MSDE installation docs ... Setup Parameters Installation docs: MSDE Installation Instructions 2. Verifing TCP/IP Remote Connections: To verify that your MSDE installation has remote connections enabled you may run "regedit" to view your registry settings. Verify the following keys ... HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ MSDE\MSSQLServer\SuperSocketNetLib\ProtocolList=[tcp np] HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ MSDE\MSSQLServer\SuperSocketNetLib\Tcp\TcpPort=[Port] 3. Register Connections: Now, register a server connection in Aqua Data Studio using 'Hostname\SQLEXPRESS' as the hostname parameter, where Hostname is the hostname or ip address of the SQL Server and SQLEXPRESS is the instance name.

Home • Screenshots • Downloads • Documentation • Support • Licensing

Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved