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. 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
For other platforms use the "Windows Authentication" option.Īqua Data Studio supports trusted connections to SQL Server on non-Windows platforms. 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:
#Sql aqua data studio driver
Microsoft JDBC Driver has some known limitations. You can choose jTDS or Microsoft JDBC driver and view its details in the Driver tab. Using the Keyboard combination "CTRL + SHIFT + P", you may quickly access Server Properties and edit Tab Coloring options.įrom the Driver drop-down list, choose the driver using which you want to connect to the server. 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:
#Sql aqua data studio registration
Using Filters Options in Registration (Filter Tab).Connecting and Use with MS SQL Server Debugger (Microsoft SQL Server 2005 and above).SQL Server registrations should be straight forward.
0 kommentar(er)
