how to deploy and publish SQL server with app on IIS SERVER

Question

Hello Guys Please help me . i already puplished web app asp.net on iis local , firstly this app build on my local host but now different connection string to other local server , i ask how to publish this sql server on the new local server . Thanks

Abdalla Elawad · Answer

Hi Mr. Jignesh Kumar i have already build this application with my localhost , but now transfer this app to another localhost . before publish on IIS change the connectionString to new path of server . Still now i have sepcific problem in webservices doesn't get data from database . you can see this photo for web services after publish but i browser it in same server but when we enter to another pc on local network , does not get data .

Jignesh Kumar · Answer

Could you please share your error which you are getting ?

Abdalla Elawad · Answer

Mohamed & Kumar Firstly Thank you to help me , but i already tested and change database name ,user name and password , but i can't ability to fix this problem .

Mohammad Sbeeh · Answer

First step you need to deploy your asp.net app to IIS https://docs.microsoft.com/en-us/visualstudio/deployment/deploy-iis-with-web-deploy?view=vs-2017 Next step you need to Generate SQL Database Script https://docs.microsoft.com/en-us/sql/relational-databases/scripting/generate-and-publish-scripts-wizard?view=sql-server-2017 Next you need to import this SQL Script https://onlinehelp.coveo.com/en/ces/7.0/administrator/running_a_script_in_microsoft_sql_server.htm Finally, you need to change the SQL Server Name and Database Name in web.confing in connection string on new server. Connection string example providerName="System.Data.SqlClient" connectionString="Data Source= SQLInstanceServerName; Initial Catalog= DatabaseName ;Integrated Security=True "/>

Jignesh Kumar · Answer

Hi, No need to publish SQL server just you need to change in your webconfig file for datasouce: SQLSERVERNAME(where you have your database) Initial Catelog : DatabaseName