مشکل در اتصال به sql در پروژه

[asrah6]

سلام
در هنگام لاگین کردن به برنامه ایراد زیر گرفته می شود لطفا کمک کنید ..
Cannot open database "db_arad" requested by the login. The login failed.
Login failed for user 'owner-PC\owner'.

[tarsim]

سلام کد لاگین را قرار بدید تا راحت تر بشه کمک کرد

[asrah6]

سلام یک baseclass.cs دارم در پوشه app-code که کد آن به صورت زیر است
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
/// <summary>
///
/// </summary>
public class BaseClass
{
public BaseClass()
{
//
//
//
}
public static SqlConnection DBCon()
{
return new SqlConnection("server=.;database=db_arad;uid=sa;pwd=");
}

public static void BindDG(GridView dg, string id, string strSql, string Tname)
{
SqlConnection conn = DBCon();
SqlDataAdapter sda = new SqlDataAdapter(strSql, conn);
DataSet ds = new DataSet();
sda.Fill(ds, Tname);
dg.DataSource = ds.Tables[Tname];
dg.DataKeyNames = new string[] { id };
dg.DataBind();
}
public static void OperateData(string strsql)
{
SqlConnection conn = DBCon();
conn.Open();
SqlCommand cmd = new SqlCommand(strsql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
, ودر ضمن connectionStrings در وب کانفیگ به صورت زیر است
<connectionStrings >
<add name="examConnectionString" connectionString="Data Source=localhost;Initial Catalog=db_arad;Persist Security Info=True;User ID=sa" providerName="System.Data.SqlClient"/>
</connectionStrings>

[tarsim]

دوست عزیز برای کانکشن به این شکل بنویس

SqlConnection my_cn = new SqlConnection(System.Configuration.ConfigurationMa nager.ConnectionStrings["db"].ConnectionString);


وتنضیمات وب کانفیک هم به این شکل


<connectionStrings>
<add name="db" connectionString="Data Source=.;Initial Catalog=نام بانک;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

[asrah6]

سلام با تشکر ولی باز هم جواب نداد . دایم ایراد زیر را می گیرد
Cannot open database "db_arad" requested by the login. The login failed.
Login failed for user 'owner-PC\owner'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database "db_arad" requested by the login. The login failed.
Login failed for user 'owner-PC\owner'.

Source Error:

Line 48: //´ò¿ªÊý¾Ý¿âÁ¬½Ó£¬²¢µ÷Óù«¹ ²ÀàÖеÄgetcon·½·¨ Line 49: SqlConnection con = dataconn.getcon(); Line 50: con.Open(); Line 51: //´´½¨Ò»¸öеÄSqlCommandʵÀý¶ÔÏó Line 52: SqlCommand com = con.CreateCommand();
Source File: k:\source\arad source\wxam \ar\NE\Default.aspx.cs Line: 50

Stack Trace:

[SqlException (0x80131904): Cannot open database "db_Examination" requested by the login. The login failed. Login failed for user 'owner-PC\owner'.] System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5295167 System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +242 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1682 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +69 System.Data.SqlClient.SqlInternalConnectionTds.Com pleteLogin(Boolean enlistOK) +30 System.Data.SqlClient.SqlInternalConnectionTds.Att emptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) +317 System.Data.SqlClient.SqlInternalConnectionTds.Log inNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) +889 System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) +307 System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions) +434 System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) +225 System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnectionPool pool, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) +37 System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnectionOptions userOptions) +558 System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnectionOptions userOptions) +67 System.Data.ProviderBase.DbConnectionPool.TryGetCo nnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +1052 System.Data.ProviderBase.DbConnectionPool.TryGetCo nnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +78 System.Data.ProviderBase.DbConnectionFactory.TryGe tConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +167 System.Data.ProviderBase.DbConnectionClosed.TryOpe nConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +143 System.Data.SqlClient.SqlConnection.TryOpen(TaskCo mpletionSource`1 retry) +83 System.Data.SqlClient.SqlConnection.Open() +96 _Default.getcom(Int32 i) in k:\source\quiz source\wxam codefons\codefans.net\NE\Default.aspx.cs:50 _Default.Button1_Click(Object sender, EventArgs e) in k:\source\quiz source\wxam codefons\codefans.net\NE\Default.aspx.cs:41 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9553594 System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +103 System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +35 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.17929

[asrah6]

این هم سورس datacon.cs
در صورت امکان خطا را بیابید.
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.Common;

/// <summary>
///
/// </summary>
public class Datacon
{
public Datacon()
{

}
public sealed class SqlException : DbException
{
}
public SqlConnection getcon()
{
string strCon = "Data Source=(local);DataBase=db_arad;Integrated Security=true";
SqlConnection sqlCon = new SqlConnection(strCon);
return sqlCon;
}
public bool eccom(string sqlstr)
{
SqlConnection con=this.getcon();
con.Open();
SqlCommand mycommand=new SqlCommand(sqlstr,con);
try
{
mycommand.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
con.Close();
}
}
public bool ecDropDownList(DropDownList DDL, string sqlstr3, string DTF, string DVF)
{
//
SqlConnection con = this.getcon();
//
con.Open();
//
SqlDataAdapter mydataadapter = new SqlDataAdapter(sqlstr3,con);
//mydataset
DataSet mydataset = new DataSet();
//
mydataadapter.Fill(mydataset);
DDL.DataSource = mydataset;
DDL.DataTextField = DTF;
DDL.DataValueField = DVF;
try
{

DDL.DataBind();
return true;
}
catch
{
return false;
}
finally
{
//
con.Close();
}
}
public bool ecadabind(GridView gv,string sqlstrl4)
{
//
SqlConnection con = this.getcon();
//
con.Open();
//
SqlDataAdapter mydataadapter = new SqlDataAdapter(sqlstrl4,con);
//mydataset
DataSet mydataset = new DataSet();
//
mydataadapter.Fill(mydataset);
//
gv.DataSource=mydataset;
try
{
//
gv.DataBind();
//
return true;
}
catch
{
return false;
}
finally
{
//
con.Close();
}
}
public bool ecadabindinfostring(GridView gv,string sqlstr5,string DNK)
{
SqlConnection con = this.getcon();
con.Open();
SqlDataAdapter mydataadapter = new SqlDataAdapter(sqlstr5,con);
DataSet mydataset = new DataSet();
mydataadapter.Fill(mydataset);
gv.DataSource=mydataset;
gv.DataKeyNames = new string[] { DNK };
try
{
gv.DataBind();
return true;
}
catch
{
return false;
}
finally
{
con.Close();
}
}
public SqlDataReader ExceRead(string SqlCom)
{
SqlConnection con = this.getcon();
con.Open();
//SqlCommandSqlCom
SqlCommand sqlcom = new SqlCommand(SqlCom, con);
SqlDataReader read = sqlcom.ExecuteReader();
return read;
}
}

[asrah6]

لطفا یک نفر کمک کند:گریه:

[General-Xenon]

لطفا یک نفر کمک کند:گریه:
سلام ببین . مشکل کدت اینه که Login مربوط به Database اجازه دسترسی به Database رو نداره

اگر روی Host این مشکل رو داری . باید از طریق Control Panel یک Login جدید درست کنی براش و درون ConnectionString بریزی ...

اگر روی سیستم خودت هست . به جای User و Pass اینجوری بنویس . اگر هم SQL رو دستکاری کردی مثل روش اول باید Login درست کنی
Data source=.;initial Catalog=Database;integrated Security=SSPI;

موفق باشی

[asrah6]

سلام و خسته نباشید
باز هم نشد من که هنگ کردم دو فایل ضمیمه می کنم لطفا در صورت امکان بگو مشکل از کجاست با تشکر فراوان:عصبانی++::گریه:

[General-Xenon]

سلام و خسته نباشید
باز هم نشد من که هنگ کردم دو فایل ضمیمه می کنم لطفا در صورت امکان بگو مشکل از کجاست با تشکر فراوان:عصبانی++::گریه:

سلام . نسخه SQL رو بگو ... Express استفاده کردی ؟