DBVisualizer/SQL Explorer will not connect to the right DB instance

I am trying to connect to a SQL Server instance in DBVisualizer on ubuntu and for some reason unknown to me it incessantly connects to the wrong instance. The target is a Windows Server that is running multiple instances of SQL Server on it. I am trying to connect to it using the following string:

jdbc:sqlserver://srv\sql2:1433;DatabaseName=CloudServices

However quite amusingly, it continuously connects to srv\sql1 even though my connection string points to sql2 and not sql1. I can connect to the right db instance (sql2) using SSMS on Windows perfectly fine.

I am having the same issue when I try to connect to this DB using SQL Explorer in Eclipse

Am I missing something here?

Answers


Not sure if you still need the answer for this but try using this connection string in DBvisulizer.

jdbc:sqlserver://srv\sql2:1433;Instance=INSERTYOURINSTANCEHERE;DatabaseName=CloudServices

Port 1433 is the static port of the default instance. Try connecting to the redirector on port 1434 and specifying the instance name property in your connection string.


Need Your Help

AppDomain.AssemblyLoad event catches all exceptions raised within the event handlers

c# .net exception-handling appdomain .net-assembly

It seems the .NET AppDomain.AssemblyLoad event catches any exceptions thrown within it's event handlers, not propagating them to the caller who triggered the assembly load (e.g. Assembly.LoadFile()...

jQuery, PHP: Calling a PHP script from jQuery, but it doesn't appear to be executing

php javascript jquery mysql

I'm using the source code found on this site here: http://webtint.net/tutorials/5-star-rating-system-in-php-mysql-and-jquery/comment-page-1/#comment-2562

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.