Last post Aug 12, 2013 08:53 AM by Starain chen - MSFT
Aug 05, 2013 10:58 AM|Omer Burak Colak|LINK
I have a MVC 2 web application with .NET Framework 3.5 on Microsoft Visual Studio 2010.
I bought domain and hosting service on turhost.com and I have already uploaded my mssql database to server.
When I debug my app and connect via localhost, the app works perfectly with successful database connection. But after publishing my app to my domain with ClickOnce Application using the Publish Wizard, the problem starts. The app works but when I type username
and password and click enter, it gives an error.
I think there is a problem with the connection between application and database but I could not find it.
PS: just type some username and password and click the button, you will see; http://innomoproject.net/
<add name="innomoConnectionString" connectionString="Data Source=mssql02.turhost.com; user id=myId; password=myPassword; database=innomodb"
Thanks in advance,
Aug 06, 2013 12:33 AM|dotnetnerd|LINK
What is the error message? Please advise.
Aug 08, 2013 11:21 AM|Starain chen - MSFT|LINK
Thanks for your post!
According to your description, we don't know the inner error message, it would be better if you can provide the detail error messages, then we can provide further suggestions to you.
There are some information that you should check.
1. Please check whether your SQL Server service status, if it's stop, please start the service.
2. Please check whether your database has already been in your server. If no, please add database to your SQL Server
3. Please check the SQL account has already been in the SQL Server and it has enough permission, if no, please add the SQL Account and grant enough permission.
4. Please check the SQL account status has already been enabled, if not, please enable it.
Aug 12, 2013 08:53 AM|Starain chen - MSFT|LINK
Since we haven't heard from you for a long time, I temporarily close this case. I mark useful reply as answer. If you have any concerns, please free feel to reopen it or submit
a new question. Thanks for your understanding.