我的网页在安全服务器(https)上,我正在尝试连接sql Server 2008数据库,这是普通的服务器.
我在页面本身上写连接字符串,而不是在web.config文件中.我收到以下错误： –
我在页面本身上写连接字符串,而不是在web.config文件中.我收到以下错误： –
System.Data.sqlClient.sqlException: Login Failed. The login is from an untrusted domain and cannot be used with Windows authentication.
请帮助,如何连接它,我是否必须为它做一些web服务.
我的代码如下：
public void FillCity()
{
sqlConnection con = new sqlConnection();
con.ConnectionString = "integrated security=SSPI;data source=dev-fcb; user id=sa;password=password;"
+"persist security info=False;database=mediapro";
con.Open();
sqlDataAdapter da = new sqlDataAdapter();
da.SelectCommand = new sqlCommand("select * from StateCityMaster where IsActive='1' order by CityName",con);
DataSet ds = new DataSet();
da.Fill(ds);
string CityName = string.Empty;
if (ds.Tables[0].Rows.Count > 0)
{
CityName = ds.Tables[0].Rows[0]["CityName"].ToString();
}
DataSet dset = new DataSet();
da.Fill(dset);
if (dset.Tables[0].Rows.Count > 0)
{
drpCity.DataSource = dset;
drpCity.DataTextField = "CityName";
drpCity.DataValueField = "CityName";
drpCity.DataBind();
}
drpCity.Items.Insert(0,new ListItem("--Select--","0"));
con.Close();
}
