Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
SQL Server registrations should be straight forward.
To Identify Server Environments, whether it is a Production, Development or Test, use Tab Coloring feature:
Using the Keyboard combination "CTRL + SHIFT + P", you may quickly access Server Properties and edit Tab Coloring options.
From the Driver drop-down list, choose the driver using which you want to connect to the server. You can choose jTDS or Microsoft JDBC driver and view its details in the Driver tab.
Aqua Data Studio supports trusted single sign-on connections to SQL Server on the Windows platform. You may specify the authentication as "Windows Single Sign-On", which will allow ADS to login into a server using the currently logged in authentication of the OS. This is only supported on the Windows platform, and not on Linux, OSX or other platforms. For other platforms use the "Windows Authentication" option.
Aqua Data Studio supports trusted connections to SQL Server on non-Windows platforms. You may specify the authentication as "Windows Authentication" and specify the Domain/Username and password of the user to authenticate with.
When registering an SQL Server you may specify in the Hostname text the name of the SQL Server and the Instance name in the format \\ServerName\InstanceName without a port, to enable an Instance connection. You may also connect to multiple Instances of SQL Server on the same machine by identifying on what ports each Instance is running. For SQL Server 2000 you can run the "SQL Server Network Utility". You may then select the Instance of SQL Server and make sure the "TCP/IP" protocol is enabled. Then you may select the TCP/IP protocol and click properties, this should tell you the default port.
Once you know the port of each Instance you may register a connection for each Instance by specifying the hostname and the port for each connection/instance.
On the client computer you must do the following:
Step 1): Create a Windows explorer shortcut to the Aquadata executable then edit the shortcut target as follows (adjusting the domain and user name as necessary)
C:\Windows\System32\runas.exe /netonly /user:TARGET_DOMAIN\TARGET_USER "C:\Program Files\Aqua Data Studio 12.0 - 32bit\datastudio.exe"
Step 2): When registering the SQL server in Aqua Data Studio use "single signon" instead of "Windows Authentication" as the connection method.
Step 3): If you receive the following warning:
Ensure that you've included the path to your USER_HOME directory within the datastudio.ini file as detailed within the bottom of the section "Troubleshooting Missing Connections on Windows".
The Advanced Tab requires entering Domain, Username and Password when connecting to SQL Server 2005 for debugging. If your SQL Server is not part of a domain, enter its IP address as the domain.
When registering an SQL Server for use with the MS SQL Server Debugger it is important to set the security on the server itself to allow for the debugger’s connection. On the server hosting SQL Server 2005, the following must be set correctly to allow for debugging.
In case granting "administrators" permission is a concern, then:
(You can also go to a specific component in the Component Services section to grant permission, instead of granting permission from "My Computer" which is a blanket grant)
Edit the Server Properties, to use FILTER options for a Server in Aqua Data Studio:
Using the drop-down at the top of the Filter Tab, quickly change your Schema or Folder View.
If your intention is to show only the tables that start with XXPKD, then you'll need to change your main filter to "Exclude All", and secondary filter to "+XXPKD*". Note the "+" in front of the XXPKD pattern. Also, note that the filter pattern is case sensitive.
The filter shown below is set to exclude all databases except those that start with "aq". This is similar to the above example where all schemas, except the XXPKD schema, are excluded. Then, there is an "Object Folder" filter on the Tables folder, which excludes everything except those that start with "forum".
Edit the Server Properties to use Advanced Properties in Aqua Data Studio:
With options in Advanced properties of a Server, you can:
Debugger (see the section above "Connecting and Use with MS SQL Server Debugger")
Using the drop-down at the bottom of the Advanced Tab, quickly change your Object Display in the Server Browser.
Edit the Drivers Properties to use Driver Parameters in Aqua Data Studio:
With options in Driver properties of a Server, you can edit/view the:
Edit the Permissions in Server Properties in Aqua Data Studio:
With options in Permissions Tab of a Server, you can:
Edit Scripts in Server Properties in Aqua Data Studio:
With scripts in the Script Tab of a Server, you can:
Edit Shell Scripts in Server Properties in Aqua Data Studio:
With scripts in the FluidShell Tab of a Server, you can:
Configuring SQL Express and connecting with Aqua Data Studio.
Connecting to SQL Server Express 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 Express using the hostname and instance name in the Host: parameter.
1. Launching ’SQL Server Surface Area Configuration’ tool: First step is to launch the SQL Server surface area configuration tool that is installed with SQL Server Express.
2. Configuring TCP/IP Remote Connections: Select ’Surface Area Configuration and Services and Connections’ option and then select ’Remote Connections’ in the tree browser. Choose the ’Using TCP/IP Only’ or ’Using both TCP/IP and named pipes’, the click on ’Ok’ or ’Apply’.
3. Register Connections: Now, register a server connection in Aqua Data Studio using ’HostnameSQLEXPRESS’ as the hostname parameter, where Hostname is the hostname or ip address of the SQL Server and SQLEXPRESS is the instance name.
The MS SQL Server Debugger works with MS SQL Server 2005 Express just as it does for MS SQL Server 2005. Click here for more information on how to register a server for debugging with the MS SQL Server Debugger.
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:
The First step is to install MSDE with network connections enabled. By default, MSDE is installed with network connections disabled. To install MSDE 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 ...
MSDE Installation Instructions
MSDE SupeSocketNetLib Registry
MSDE TCP Registry
2. Verifying 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\
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\
Registration - SQL Server
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.