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


  • Luís Costa 26 posts 148 karma points
    May 03, 2018 @ 09:26
    Luís Costa
    0

    Umbraco cannot connect to SQL Database

    Hey guys,

    These days I try to migrate umbraco from SQL CE to SQL Server, first i export the SQL CE script and then i ran it on the SQL Server to create a new database to Umbraco on that server. I changed the connectiong string to this new server and then everything goes wrong. I got this error: enter image description here

    strangely if a run in my notebook with win 10, with the same connectiong string the Umbraco works, but if i run i my IIS server directly it do not run. Anyone knows why?

    Copy Link
  • Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib
    May 03, 2018 @ 09:28
    Alex Skrypnyk
    0

    Hi Luis

    Check please that IIS process has access to the connection.

    THanks,

    Alex

    Copy Link
  • Luís Costa 26 posts 148 karma points
    May 03, 2018 @ 09:33
    Luís Costa
    0

    What do you mean?

    I already give full access to user IIS_IUSRS to entirely folder :s

    Copy Link
  • Matthew Wise 271 posts 1373 karma points MVP 5x c-trib
    May 03, 2018 @ 09:45
    Matthew Wise
    0

    Hi Luis,

    Have you updated the providername attribute on the connection string in the web.config from System.Data.SqlServerCe.4.0 to System.Data.SqlClient?

    Cheers Matt

    Copy Link
  • Luís Costa 26 posts 148 karma points
    May 03, 2018 @ 10:02
    Luís Costa
    0

    Yes, i updated to System.Data.SqlClient

    enter image description here

    Thanks for the answer

    Copy Link
  • Luís Costa 26 posts 148 karma points
    May 10, 2018 @ 12:14
    Luís Costa
    0

    Hi guys,

    I found the solution. When i connect to umbraco from outside of the server, everything is okay, but in inside of server the same connection string does not work because of security (security policies) implemented by a company that support us. So the solution was to change to a connection string that has the local sql server name (in domain) and works xD.

    Thank you all!

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft