Pessoal.... Bom dia.
Alguém consegue entender pq dessa mensagem ? Ainda não consegui resolver.
O problema ocorre apenas ao publicar no servidor com Sql Express2008 e win server 2008
Deixei no web config dessa forma:
<connectionStrings>
<add name="Banco" connectionString="Data Source=.\SQLExpress2008; Initial Catalog=MeuDataBase;user id=sa;password=sa" providerName="System.Data.SqlClient"/>
</connectionStrings>
E no codigo deixei assim:
string bancox = "";
bancox = ConfigurationManager.ConnectionStrings["Banco"].ConnectionString;
SqlDataReader dr = null;
SqlConnection con = new SqlConnection(bancox);
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
cmd.CommandText = "SELECT campo1, campo2 Tb_LOGIN WHERE campo1 = @user and campo2 =@senha";
cmd.Parameters.AddWithValue("@user", login);
cmd.Parameters.AddWithValue("@senha", System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(senha.ToUpper().Trim(), "SHA1"));
dr = cmd.ExecuteReader();
Como está sendo apresenado o seguinte erro:
Server Error in '/SIPES' Application.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
O que eu fiz para tentar simular foi criar uma aplicação windows form. E no appconfig eu deixei a seguinte string de conexão:
<connectionStrings>
<add name="Banco" connectionString="Data Source=.\SQLExpress2008; Initial Catalog=MeuDataBase;user id=sa;password=sa"/>
</connectionStrings>
e no codigo eu faço assim:
string str = ConfigurationManager.ConnectionStrings["Banco"].ConnectionString;
SqlConnection cn = new SqlConnection(str);
SqlDataAdapter adp = new SqlDataAdapter();
adp.SelectCommand = new SqlCommand("Select * from tabelaqualquer", cn);
cn.Open();
DataSet ds = new DataSet();
adp.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
RESUMINDO:
REalmente não consigo entender qual o problema, tem algo errado?
Pls me ajude!!
Abs
Abs, Adriano_SP
