Connectivity problems

[TheSim]

Hi All,
with other tool developed in .NET I can connect to my servers but query commander not. Why?
I obtain message: "SQL Server does not exists or access denied". The details windows refer:
   at QueryCommander.FrmDBObjects.RefreashTreeView()
   at QueryCommander.MainForm.PopulateDBConnections()

I use
SQL Query Analyzer
SSMS Express edition
Apex Sql Edit
Killer Bite Sql Visualizer

I have VS.NET 2003 Professional installed onto my PC?

Can anyone help me, please?

Thanks in advance

Pierpaolo Simoncini

[Nobody/Anonymous]

The error you get is a SqlClient exception. I'm not sure the other editors are using SqlClient, but you have to be sure you are using the same paramathers (username, password, server...etc).

Start out by removing the "default connection" and create a new one.

If it still doesn't -Try using ip instead of domain name, and username and password instead of trusted connection.

If nothing else works, create a console application in Visual Studio, and paste in the code in the main method:

string connectionString = String.Empty;
// Standard Security - Apply your serverAddress, database, user and password
connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; ";

// or

// Trusted Connection
connectionString = "Data Source=localhost;Initial Catalog=master;Integrated Security=SSPI; ";

System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectionString);
connection.Open();
System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand("select * from sysobjects");
connection.Close();

This is basicly the same code as QueryCommander is using. If it doesn't work, you are providing the the wrong paramethers.
Also, try connecting to other servers.

Let me know how it goes.
//Mikael