System.Data.SqlClient.SqlException: Cannot open database requested in login
Hi,
I get an error "System.Data.SqlClient.SqlException: Cannot open database requested in login "username". Login failed for user "DomainName\username".
my coonection string is :
"SqlConnection conn = new SqlConnection("Data Source=Tushar\\SQLEXPRESS;Initial Catalog=Sports;Integrated Security=True;uid=tusharsim;Password=tusharsim");"
aslo i give web.config connection string:
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=Tushar\SQLEXPRESS;Initial Catalog=Sports;Integrated Security=True;uid=tusharsim;Password=tusharsim" providerName="System.Data.SqlClient" />
<add name="ApplicationServices" connectionString="Data Source=Tushar\SQLEXPRESS;Initial Catalog=Sports;Integrated Security=True;uid=tusharsim;Password=tusharsim" providerName="System.Data.SqlClient" />
<add name="SportsEntities" connectionString="metadata=res://*/App_Code.Model.csdl|res://*/App_Code.Model.ssdl|res://*/App_Code.Model.msl;provider=System.Data.SqlClient;provider connection string="Data Source=Tushar\SQLEXPRESS;Initial Catalog=Sports;Integrated Security=True;uid=tusharsim;Password=tusharsim;MultipleActiveResultSets=True"" providerName="System.Data.SqlClient" />
<add name="SportsConnectionString" connectionString="Data Source=Tushar\SQLEXPRESS;Initial Catalog=Sports;Integrated Security=True;uid=tusharsim;Password=tusharsim" providerName="System.Data.SqlClient" />
</connectionStrings>
so i will get above error when i am going to particular page.plz give me any solution from any body. Thank u
Re: System.Data.SqlClient.SqlException: Cannot open database requested in login
Re: System.Data.SqlClient.SqlException: Cannot open database requested in login
LOOK AT THIS:
"SqlConnection conn = new SqlConnection("Data Source=Tushar"\"\SQLEXPRESS;Initial Catalog=Sports;Integrated Security=True;uid=tusharsim;Password=tusharsim");"
Is there a reason for the extra "\"