Connecting to a database remotely through VS2005

  • Thread starter Thread starter axel22
  • Start date Start date
A

axel22

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!
*************************************************
 
by default sqlexpress does not allow tcp/ip connects, only local shared
pipes.

-- bruce (sqlwork.com)
 
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.aspx?scid=kb;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/
===================================
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();
}
Click to expand...
Click to expand...
 
Back
Top