Last post Jun 25, 2013 02:23 AM by Angie xu - MSFT
Jun 19, 2013 08:36 AM|bz6djs|LINK
Hi Guys, wow ...I have come a long way - still a LONG way to go (obvious from this question).... So app is now fully functional in my lab - I am very Pleased! THANK YOU to everyone here who have been patient enough to answer my questions... unfortunately
I have 1 more. I Published my app this morning (I use file publish and copy the files over to PROD). I ran my app but it fails to login to the SQL server becasue it is still trying to use LocalService to login and that is not permitted in Prod. Walked
through a number of websites (not putting in the correct search parameters I guess cause not finding what I need) and looked through the files in my app - but cannot locate where to change the login from LocalService to user and password. I'd be grateful
if someone could point me in the right direction.
Jun 20, 2013 03:05 AM|syed amjad|LINK
what do you mean by local service ?
did you create a copy of database in you server like local system, if not create a new database and create a user name in this database and try to connect with your app.
Jun 25, 2013 02:23 AM|Angie xu - MSFT|LINK
When you deploy a Web application that uses a SQL Server database, you might also have to propagate data structures, data, or both. Visual Studio can automatically create scripts (.sql files) to do this in the destination database, and these scripts can
be included in the Web package. You can also include custom SQL Server scripts and specify the order in which the scripts should run. Web Deploy runs the scripts on the destination server when the package is installed.
You specify SQL Server deployment options on the Package/Publish SQL tab of the project Properties page.
You can learn more about ASP.NET Web Application Project Deployment with SQL Server database from link below,
#ASP.NET Web Application Project Deployment