Documentation: Aqua Data Studio 6.0 - New Features		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. Sybase IQ   VII. Informix   VIII. PostgreSQL   IX. MySQL   Memory Configuration   Character sets   Registering Servers   I. MSDE 2000   II. SQL Express 2005   III. PostgreSQL SSL   Application   I. Browser and Scripting   II. Visual Editing   III. SQL History   IV. Shortcut Toolbar   V. Key Mappings   VI. Custom Keymap Profiles   VII. Options   VIII. Settings   Query Window   I. Basics   II. Toolbar   III. Server Side Comments   IV. SQL Automation   V. Variable Binding   VI. Results   VII. Save Results   VIII. Auto-completion   IX. SQL Formatter   X. Permissions   XI. Parameterized   Editors   I. SQL Editor   II. Text Editor   III. HTML Editor   IV. XML Editor   V. Regular Expressions   Image Viewer   Visual Explain Plan   I. Basics   II. Explain Plan   III. Explain Diagram   IV. Whiteboard   Procedure/Package Editor   Tools   I. Table Data Editor   II. Script Generator   III. ER Diagram   IV. Query Builder   V. Import Tool   VI. Export Tool   VII. Execution Monitor   Difference Tools   I. Schema Diff   II. Tab Diff   III. Directory Diff   IV. File Diff   V. Copy History Diff   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 DBA Tools   I. Instance Manager   II. Storage Manager   III. Security Manager   IV. Session Manager   V. SQL Agent Manager   Sybase DBA Tools   I. Instance Manager   II. Storage Manager   III. Security Manager   IV. Session Manager

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 • Contact

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