Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Yahya 4 posts 84 karma points
    Jan 26, 2023 @ 07:39
    Yahya
    0

    Umbraco 11: works fine on VS but Blank page when deploy

    Hi All, i just try umbraco 11 and install Umbraco Form and everything works fine wehn run via Visual Studio, when i try to depoy on IIS 8.5.9600 i see the blank page (error 500) and i also check MYapp.dll using powershell "dotnet myapp.dll" running without display error, (otherwhise i deploy umbraco 10 in same server and works. )

    Regards

    Copy Link
  • Alex Skrypnyk 6134 posts 23953 karma points MVP 8x admin c-trib
    Jan 26, 2023 @ 14:51
    Alex Skrypnyk
    0

    Hi,

    Anything in logs? Umbraco Logs and IIS logs check please

    Copy Link
  • Yahya 4 posts 84 karma points
    Jan 27, 2023 @ 00:05
    Yahya
    0

    Hi Alex, Here the Umbraco trace log:

    @mt":"Connection ID \"{ConnectionId}\", Request ID \"{TraceIdentifier}\": An unhandled exception was thrown by the application.","@l":"Error","@x":"Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database \"MYDB_11\" requested by the login. The login failed.\r\nLogin failed for user 'IIS APPPOOL\\MyAPPP'.\r\n   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject,"Connection ID \"{ConnectionId}\", Request ID \"{TraceIdentifier}\": An unhandled exception was thrown by the application.","@l":"Error","@x":"

    i using same connection string with my umbraco 10 but different DB 

     "umbracoDbDSN": "Server=H8190431715VM\\SQLEX17;Database=MYDB_11;User Id=myuser;Password=myPass",

    i also try add 

    "Server=H8190431715VM\\SQLEX17;Database=MYDB_11;User Id=myuser;Password=myPass ;Trusted_Connection=True;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=True

    but still blank page error 500, and on trace log write same error report,

    (note: my IIS site binding using IP and port 89 (http://104.x.x.x:89))

    Copy Link
  • Alex Skrypnyk 6134 posts 23953 karma points MVP 8x admin c-trib
    Jan 27, 2023 @ 12:10
    Alex Skrypnyk
    0

    Hi,

    Try to use some settings from here - https://stackoverflow.com/questions/7698286/login-failed-for-user-iis-apppool-asp-net-v4-0

    Copy Link
  • Huw Reddick 1875 posts 6421 karma points MVP 2x c-trib
    Jan 27, 2023 @ 13:40
    Huw Reddick
    0

    Hi Yahya,

    Does the SQL user definately have permissions on the database? and are they in the db_owner group for that database?

    Copy Link
  • FailureTeste 1 post 20 karma points
    May 20, 2024 @ 09:39
    FailureTeste
    0

    I have the same problem. Connection to SQL server is ok, because I can login into back office local.websiteTest.com/umbraco, but If I open front end local.websiteTest.com - I have blank page. The same happens if I deploy it to azure.

    Copy Link
  • Kooksta 6 posts 86 karma points
    May 20, 2024 @ 13:18
    Kooksta
    0

    Can you connect to that SQL server using MS SQL Management Studio and the credentials your using above?

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft