You need to ensure that the connection string value that is stored in the web.config file is updated to the production server’s connection string value during publishing