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. Step 2): When registering the SQL server in Aqua Data Studio use "single signon" instead of "Windows Authentication" as the connection method.Ĭonnecting and Use with MS SQL Server Debugger (Microsoft SQL Server 2005 and above) - The Advanced Tab requires entering Domain, Username and Password when connecting to SQL Server 2005 for debugging. Step 1): Create a Windows explorer shortcut to the Aqua Data Studio executable (datastudio.exe) then edit the shortcut target as follows (adjusting the domain and user name as necessary)Ĭ:\Windows\System32\runas.exe /netonly /user:TARGET_DOMAIN\TARGET_USER "C:\Program Files\Aqua Data Studio 11.0 - 32bit\datastudio.exe" On the client computer you must do the following: 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. Tip : Using the Keyboard combination "CTRL + SHIFT + P", you may quickly access Server Properties and edit Tab Coloring options. Right Click on the Server - A Popup Menu AppearsĬlick on the Item which displays Server Properties.īased on the Server Type, you can edit the Tab Coloring option to identify your environments. To Identify Server Environments, whether it is a Production, Development or Test, use Tab Coloring feature : 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. ![]() You may specify the authentication as "Windows Authentication" and specify the Domain/Username and password of the user to authenticate with.Ĭonnecting to Multiple Instances of SQL Server on the same machine - 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. Windows Authentication - Aqua 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. Windows Single Sign-On - Aqua Data Studio supports trusted single sign-on connections to SQL Server on the Windows platform. Register Microsoft SQL Server - SQL Server registrations should be straight forward.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |