I have a hosted Windows Server 2008 virtual machine. It is for my Internet sites. I installed IIS services on my Windows Server 2008. It is normal work. I installed SQL Server 2008 R2 on my Windows Server 2008. It's for site database. My site is written in ASP. IP address of my Windows Server 2008 is 22.214.171.124. Name of my SQL Server database is TVERREMONT. I created an account on SQL Server with login: MyUser and password: MyPwd. The connection string in my web.config is:
<connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="Data Source=126.96.36.199;Initial Catalog=TVERREMONT;User ID=MyUser;Password=MyPwd;" providerName="System.Data.SqlClient" /> </connectionStrings>
I can't connect my site with sql server database. The following error is shown in the browser:
Error HTTP 500.19 - Internal Server Error
How I can to connect sql server database with my site? Is there a SQL Service that I have not started maybe? Maybe something more?