SQL server name not found:Admin-PC\MSSQLSERVER,1433

[Stanciu Vlad]

If the firewall is turned off then that should be ok, this means that the port is not blocked. And if all the conditions are met, then you should be able to connect to your server, but you stil can't. Try connectiong without telling the port in the connection string (something like @"Data Source=Admin-PC\MSSQLSERVER;Initial Catalog=GMAO;User ID=sa;Password=sa;"), if this stil fails, try connectiong with other applications, like the sql management studio, or visual studio in order to see if it works. If other applications work and your's fails then the problem is in the connection string (server name or instance name), else the problem is in the server configuration (like network access). By the way, what is the exact error it you get?

I have no smart signature yet...

[Tunisien86]

Hi, I really verify many propositions but still this error annoying me a lot:

Specified sql server doesn't exist or access denied

One thing I don't understand from u last reply:else the problem is in the server configuration (like network access). I am really fed up with this error:mad: Thank u for u contribution Marwen

[Stanciu Vlad]

As a sugestion, drop the 1433 port from the connection string, just leave it to serverName\instanceName (Admin-PC\MSSQLSERVER) I assume you can't connect to the sql server from any other application, not just yours. If you have the sql server on the same pc with the application then the application will use named pipes for communication. If the sql server is on another pc then the application will use TCP/IP packeges for communication. If you server is on the same pc with the application then you either have the wrong server name, or the wrong instance name (which you said it is not true). If the sql server is on another pc then you haven't congiured the server for remote access. This link explains (with images) how to enable remote connections for sql server (it works for 2005 as well). Enable Remote Connection on SQL Server 2008 Express[^]

I have no smart signature yet...

[Tunisien86]

Hi Vlad, I try without number port but doesn't work. I assume you can't connect to the sql server from any other application, not just yours?????I don't understand it. For the information given in DataSource field,when clicking on run, typing services.msc, scroll down to see list of services with name starting with sql server,I found that only the instance existing is the default one SQL Server (MSSQLSERVER)(For more clarification,see this link http://www.sqlservercentral.com/Forums/Topic918470-323-1.aspx[^]) Thanks

[Stanciu Vlad]

Tunisien86 wrote:

I assume you can't connect to the sql server from any other application, not just yours?????I don't understand it

Any other application that uses the sql server, like Management Studio, or Visual Studio are able to connect to the server? Now back to the topic, in that link you supplied, there is something like this:

SQL Server (MSSQLSERVER) is your default Instance.
SQL Server (<Instance Name>) is your named instance.

Default instance means that there is no named instance, so if you have that default instance installed then you don't have a named one. In shorter words, the right connection string for you is

string sConnection = @"Data Source=Admin-PC;Initial Catalog=GMAO;User ID=sa;Password=sa;";

You said in the thread on sqlservercentral that you can successfully connect to Management Studio, what is entered in login form there (like server name, username or trusted connection)?

I have no smart signature yet...

[Tunisien86]

Hi, I had all suggestions tried but still not working !!!!!!!! I am really crazy :(( Thanks

[Tunisien86]

Hi, To verify my parametres given in my connection string,I create a file .udl and I verify my connexion that is good fine and connexion works well.The problem is that the info in this file are the same that i write in my code. I wanna ask how can I use this file in my code without need of the connexion string??? Thanks

[Tunisien86]

Hi barts, Finally I depass the problem of the connexion to server by the DB File's attachment :laugh: . No exception apperas.Still now the problem of the filling of my combobox .I try with sqldataset instead of the sqlreader like this:

string sConnection = "Data Source=127.0.0.1,1433;Persist Security Info=True;Initial Catalog=GMAO;User ID=sa;Password=sa";
string sSQL = "SELECT com FROM energie; ";
SqlConnection conn = new SqlConnection(sConnection);
SqlCommand comm = new SqlCommand(sSQL, conn);
DataSet ds = new DataSet();
SqlCeDataAdapter da = new SqlCeDataAdapter();
SqlDataReader dr = null;
try
{

comm.Connection.Open();
da.Fill(ds, "SQL Temp Table");
foreach(DataRow d in ds.Tables\[0\].Rows)
comboBox1.Items.Add(d.ToString());

}
catch (SqlException ex)
{
//MessageBox.Show("connexion impossible");
MessageBox.Show(ex.Message);
return;
}

dr.Close();
comm.Connection.Close();
}

but nothing is added to my combobox. Thanks in all cases for u collaboration :laugh:

[Stanciu Vlad]

Hey, Glad to see you've progressed! I have a couple of commentaries: 1) 127.0.0.1 is the ip of the loopback interface, so if you use the loopback then you use no network (so this was a network problem, probably missing network connection?) 2) the data adapter da is not retriving any rows because it has no select command. You should use this line of code SqlCeDataAdapter da = new SqlCeDataAdapter(comm); 3) there is no use form the data reader dr 4) sql ce data adapter does not work with sql command or sql connection... 5) it is usefull to bind data to the combo box in order to maintain relation with your database entity. I recommend this snippet of code:

string sConnection = "Data Source=127.0.0.1,1433;Persist Security Info=True;Initial Catalog=GMAO;User ID=sa;Password=sa";
string sSQL = "SELECT ID, com FROM energie";

SqlConnection conn = new SqlConnection(sConnection);
SqlCommand comm = new SqlCommand(sSQL, conn);
SqlDataAdapter da = new SqlDataAdapter(comm);

try
{
DataSet ds = new DataSet();

comm.Connection.Open();

da.Fill(ds);

comboBox1.DataSource = da.Table\[0\];
comboBox1.DisplayMember = "com";
comboBox1.ValueMember = "ID";

}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
comm.Connection.Close();
}

I have no smart signature yet...

[Tunisien86]

Hi, I experiment u suggestion but still my combobox wants to be always empty :( .It refuses to be filled what a strong combobox!!! Thank u