Home Forums SQL Server 2008 SQL Server 2008 - General Cannot open database “” requested by the login. The login failed. Login failed for user 'sa' RE: Cannot open database “” requested by the login. The login failed. Login failed for user 'sa'

  • AndrewSQLDBA (2/25/2013)


    A couple things.

    First

    You should Never, Ever use the SysAdmin account for any app/website to database connections. That is for a SysAdmin only.

    Second

    What is your front-end app? That connection string does not look correct. What kind of app are you designing? Website? Windows app? .NET app?

    Andrew SQLDBA

    hello thank you for your answer.

    It is a Windows Form Application in C# . the application just runs pretty well on my system . but when i test it on my brothers laptop it fails ( I am trying to simulate situations i would face when deploying my application on the customer machine,thats why i am testing it on my brothers laptop ).