CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2011
    Posts
    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=&quot;Data Source=Tushar\SQLEXPRESS;Initial Catalog=Sports;Integrated Security=True;uid=tusharsim;Password=tusharsim;MultipleActiveResultSets=True&quot;" 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

  2. #2
    Join Date
    Jul 2001
    Location
    Sunny South Africa
    Posts
    11,284

    Re: System.Data.SqlClient.SqlException: Cannot open database requested in login

    [ Moved ]

  3. #3
    Join Date
    Apr 2011
    Posts
    23

    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
  •  





Click Here to Expand Forum to Full Width

Featured