Cannot open database "DataBase" requested by the login. When Site is deployed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Jambo Jet

    Cannot open database "DataBase" requested by the login. When Site is deployed

    Code:
    <connectionStrings>
         <add name="Tenders" connectionString="Data Source=CV\SQLEXPRESS;Initial Catalog=Tenders; user id=sa; password=orc ;Integrated Security=True" providerName="System.Data.SqlClient" />
         <add name="TenderConnectionString" connectionString="Data Source=CV\SQLEXPRESS;Initial Catalog=Tender;user id=sa; password=orc; Integrated Security=True; Persist Security Info=True;User ID=sa;MultipleActiveResultSets=False;Microsoft SQL Server Management Studio&quot;"
             providerName="System.Data.SqlClient" />
         <add name="TenderConnectionString2" connectionString="Data Source=CV\SQLEXPRESS;Initial Catalog=Tender;user id=sa; password=orc;Integrated Security=True; Persist Security Info=True;User ID=sa;MultipleActiveResultSets=False;Microsoft SQL Server Management Studio&quot;"
             providerName="System.Data.SqlClient" />
         <add name="TenderConnectionString3" connectionString="Data Source=CV\SQLEXPRESS;Initial Catalog=Tender;user id=sa; password=orc;Integrated Security=True;Persist Security Info=True;User ID=sa;MultipleActiveResultSets=False;Microsoft SQL Server Management Studio&quot;"
             providerName="System.Data.SqlClient" />
     </connectionStrings>
    	<system.web>
    Last edited by Dormilich; Nov 12 '10, 11:27 AM. Reason: please use [CODE] [/CODE] tags when posting code
  • khurramzeb
    New Member
    • Oct 2010
    • 8

    #2
    I think you have to mention the port number of DatabAse server in the connection string as well
    like CV\SQLEXPRESS,p ortnumber

    Comment

    Working...