«

Ok, I've installed MS Sql Server Express, and I've created a database
'ProbnaBaza' and a table 'clan' in Management Studio. I tried using the
database locally through a project in Visual
Studio. I used the following connection string:

"Server=.\\SQLEXPRESS;Initial Catalog=clan;Integrated Security=SSPI";

It worked perfectly.
Then, I tried using the database by setting an IP address within the
connectionString,
but only to be given an error message:

System.Data.SqlClient.SqlException: An error has occurred while
establishing a connection to the server. When connecting to SQL Server
2005, this failure may be caused by the fact that under the default
settings SQL Server does not allow remote connections. (provider: TCP
Provider, error: 0 - A connection attempt failed because the connected
party did not properly respond after a period of time, or established
connection failed because connected host has failed to respond.)

Can anyone help?

Here is my source:

SqlConnection conn = null;

private void Form1_Load(object sender, EventArgs e)
{
conn = new SqlConnection();
conn.ConnectionString = "Data Source=89.172.48.15,1433;" +
"Initial Catalog=clan;Trusted_Connection=False;";
}

private void button1_Click(object sender, EventArgs e)
{
conn.Open();
SqlCommand comm = new SqlCommand("SELECT * FROM clan;",
conn);
SqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
label1.Text += reader[0].ToString() +
reader[1].ToString()
+ reader[2].ToString() + '\n';
}
conn.Close();
}

Make sure you have a protocol to connect other than Shared Memory using the
config tool.

You may also have to turn on SQL Browser

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*************************************************
Think outside the box!
*************************************************
<> wrote in message
news: oups.com...
> Ok, I've installed MS Sql Server Express, and I've created a database
> 'ProbnaBaza' and a table 'clan' in Management Studio. I tried using the
> database locally through a project in Visual
> Studio. I used the following connection string:
>
> "Server=.\\SQLEXPRESS;Initial Catalog=clan;Integrated Security=SSPI";
>
> It worked perfectly.
> Then, I tried using the database by setting an IP address within the
> connectionString,
> but only to be given an error message:
>
> System.Data.SqlClient.SqlException: An error has occurred while
> establishing a connection to the server. When connecting to SQL Server
> 2005, this failure may be caused by the fact that under the default
> settings SQL Server does not allow remote connections. (provider: TCP
> Provider, error: 0 - A connection attempt failed because the connected
> party did not properly respond after a period of time, or established
> connection failed because connected host has failed to respond.)
>
> Can anyone help?
>
> Here is my source:
>
> SqlConnection conn = null;
>
> private void Form1_Load(object sender, EventArgs e)
> {
> conn = new SqlConnection();
> conn.ConnectionString = "Data Source=89.172.48.15,1433;" +
> "Initial Catalog=clan;Trusted_Connection=False;";
> }
>
> private void button1_Click(object sender, EventArgs e)
> {
> conn.Open();
> SqlCommand comm = new SqlCommand("SELECT * FROM clan;",
> conn);
> SqlDataReader reader = comm.ExecuteReader();
> while (reader.Read())
> {
> label1.Text += reader[0].ToString() +
> reader[1].ToString()
> + reader[2].ToString() + '\n';
> }
> conn.Close();
> }
>

by default sqlexpress does not allow tcp/ip connects, only local shared
pipes.

-- bruce (sqlwork.com)


<> wrote in message
news: oups.com...
> Ok, I've installed MS Sql Server Express, and I've created a database
> 'ProbnaBaza' and a table 'clan' in Management Studio. I tried using the
> database locally through a project in Visual
> Studio. I used the following connection string:
>
> "Server=.\\SQLEXPRESS;Initial Catalog=clan;Integrated Security=SSPI";
>
> It worked perfectly.
> Then, I tried using the database by setting an IP address within the
> connectionString,
> but only to be given an error message:
>
> System.Data.SqlClient.SqlException: An error has occurred while
> establishing a connection to the server. When connecting to SQL Server
> 2005, this failure may be caused by the fact that under the default
> settings SQL Server does not allow remote connections. (provider: TCP
> Provider, error: 0 - A connection attempt failed because the connected
> party did not properly respond after a period of time, or established
> connection failed because connected host has failed to respond.)
>
> Can anyone help?
>
> Here is my source:
>
> SqlConnection conn = null;
>
> private void Form1_Load(object sender, EventArgs e)
> {
> conn = new SqlConnection();
> conn.ConnectionString = "Data Source=89.172.48.15,1433;" +
> "Initial Catalog=clan;Trusted_Connection=False;";
> }
>
> private void button1_Click(object sender, EventArgs e)
> {
> conn.Open();
> SqlCommand comm = new SqlCommand("SELECT * FROM clan;",
> conn);
> SqlDataReader reader = comm.ExecuteReader();
> while (reader.Read())
> {
> label1.Text += reader[0].ToString() +
> reader[1].ToString()
> + reader[2].ToString() + '\n';
> }
> conn.Close();
> }
>

Please follow the procedure outlined here :
http://support.microsoft.com/default...b;EN-US;914277

Doing that will fix your problem.



Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espanol : http://asp.net.do/foros/
===================================
<> wrote in message news: oups.com...
> Ok, I've installed MS Sql Server Express, and I've created a database
> 'ProbnaBaza' and a table 'clan' in Management Studio. I tried using the
> database locally through a project in Visual
> Studio. I used the following connection string:
>
> "Server=.\\SQLEXPRESS;Initial Catalog=clan;Integrated Security=SSPI";
>
> It worked perfectly.
> Then, I tried using the database by setting an IP address within the
> connectionString,
> but only to be given an error message:
>
> System.Data.SqlClient.SqlException: An error has occurred while
> establishing a connection to the server. When connecting to SQL Server
> 2005, this failure may be caused by the fact that under the default
> settings SQL Server does not allow remote connections. (provider: TCP
> Provider, error: 0 - A connection attempt failed because the connected
> party did not properly respond after a period of time, or established
> connection failed because connected host has failed to respond.)
>
> Can anyone help?
>
> Here is my source:
>
> SqlConnection conn = null;
>
> private void Form1_Load(object sender, EventArgs e)
> {
> conn = new SqlConnection();
> conn.ConnectionString = "Data Source=89.172.48.15,1433;" +
> "Initial Catalog=clan;Trusted_Connection=False;";
> }
>
> private void button1_Click(object sender, EventArgs e)
> {
> conn.Open();
> SqlCommand comm = new SqlCommand("SELECT * FROM clan;",
> conn);
> SqlDataReader reader = comm.ExecuteReader();
> while (reader.Read())
> {
> label1.Text += reader[0].ToString() +
> reader[1].ToString()
> + reader[2].ToString() + '\n';
> }
> conn.Close();
> }
>

Already enabled shared memory and named pipes.

As for the link, thnx, i'll look into it!


Juan T. Llibre je napisao/la:
> Please follow the procedure outlined here :
> http://support.microsoft.com/default...b;EN-US;914277
>
> Doing that will fix your problem.
>
>
>
> Juan T. Llibre, asp.net MVP
> asp.net faq : http://asp.net.do/faq/
> foros de asp.net, en espanol : http://asp.net.do/foros/
> ===================================
> <> wrote in message news: oups.com...
> > Ok, I've installed MS Sql Server Express, and I've created a database
> > 'ProbnaBaza' and a table 'clan' in Management Studio. I tried using the
> > database locally through a project in Visual
> > Studio. I used the following connection string:
> >
> > "Server=.\\SQLEXPRESS;Initial Catalog=clan;Integrated Security=SSPI";
> >
> > It worked perfectly.
> > Then, I tried using the database by setting an IP address within the
> > connectionString,
> > but only to be given an error message:
> >
> > System.Data.SqlClient.SqlException: An error has occurred while
> > establishing a connection to the server. When connecting to SQL Server
> > 2005, this failure may be caused by the fact that under the default
> > settings SQL Server does not allow remote connections. (provider: TCP
> > Provider, error: 0 - A connection attempt failed because the connected
> > party did not properly respond after a period of time, or established
> > connection failed because connected host has failed to respond.)
> >
> > Can anyone help?
> >
> > Here is my source:
> >
> > SqlConnection conn = null;
> >
> > private void Form1_Load(object sender, EventArgs e)
> > {
> > conn = new SqlConnection();
> > conn.ConnectionString = "Data Source=89.172.48.15,1433;" +
> > "Initial Catalog=clan;Trusted_Connection=False;";
> > }
> >
> > private void button1_Click(object sender, EventArgs e)
> > {
> > conn.Open();
> > SqlCommand comm = new SqlCommand("SELECT * FROM clan;",
> > conn);
> > SqlDataReader reader = comm.ExecuteReader();
> > while (reader.Read())
> > {
> > label1.Text += reader[0].ToString() +
> > reader[1].ToString()
> > + reader[2].ToString() + '\n';
> > }
> > conn.Close();
> > }
> >