|
-
April 29th, 2011, 11:29 PM
#1
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
-
April 30th, 2011, 01:59 AM
#2
Re: System.Data.SqlClient.SqlException: Cannot open database requested in login
-
May 1st, 2011, 02:37 PM
#3
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 "\"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|