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. If your SQL Server is not part of a domain, enter its IP address as the domain. The Advanced Tab requires entering Domain, Username, and Password when connecting to SQL Server 2005 for debugging. ![]() Connecting and Use with MS SQL Server Debugger (Microsoft SQL Server 2005 and above) Step 3: If you receive the following warning:Įnsure 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". 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. IN WINDOWS 7, TO GET AQUA DATA STUDIO TO AUTHENTICATE WITH A SQL SERVER SETUP THAT ONLY ALLOWS WINDOW AUTHENTICATION AND WHEN THE CLIENT COMPUTER IS NOT A MEMBER OF A DOMAIN OR TRUSTED DOMAIN. 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. Then you may select the TCP/IP protocol and click properties, this should tell you the default port. You may then select the Instance of SQL Server and make sure the "TCP/IP" protocol is enabled. For SQL Server 2000 you can run the "SQL Server Network Utility". You may also connect to multiple Instances of SQL Server on the same machine by identifying on what ports each Instance is running. 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. ![]() CONNECTING TO MULTIPLE INSTANCES OF SQL SERVER ON THE SAME MACHINE You may specify the authentication as "Windows Authentication" and specify the Domain/Username and password of the user to authenticate with. WINDOWS AUTHENTICATIONĪqua Data Studio supports trusted connections to SQL Server on non-Windows platforms. For other platforms use the "Windows Authentication" option. This is only supported on the Windows platform, and not on Linux, OSX or other platforms. 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. An exception occurs when retrieving data from a table containing a column of the sql_variant data type.Īqua Data Studio supports trusted single sign-on connections to SQL Server on the Windows platform. The SQL Server sql_variant data type is not supported.You can authenticate using SQL Server Authentication or Windows Single Sign-On. Before proceeding with this driver, ensure you have read the following: ![]() Microsoft JDBC Driver has some known limitations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |