Procitao sam temu http://www.elitesecurity.org/t...Hosting-ASP-net-sajta-na-somee ali kod mene je samo malo drugacija situacija jer ja bazu punim podacima na serveru preko C# aplikacije a na web aplikaciji je moguce samo citati bazu, bez menjanja sadrzaja.
Kratko cu opisati moj problem:
Nakon problema koji sam resio u proslom pitanju http://www.elitesecurity.org/t...podataka-iz-ASP-NET-aplikacije sada zelim i ja da dodam sajt na somee. :)
Prateci forume nasao sam da je potrebno omoguciti TCP/IP u SQL Server Confgiuration Manageru, dodao sam exceptions za portove 1433 i 1434, SQL Server Browser omogucen, i sve tako redom... Na somee sam uploadovao projekat koji mogu da pokrenem na lokalnom hostu preko IIS-a i ostali racunari u mrezi. Radi testa da je sve ok, dodao sam i jednu stranicu sa ispisom nekog teksta bez poziva baze i to radi bez problema na somee. Ali kada pokusam da pokrenem stranicu u kojoj se poziva sadrzaj baze onda dobijam gresku:
Server Error in '/' Application.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Pretpostavljam da je problem u connection stringu. Trenutno, moj connection string je
<connectionStrings>
<add name="_web_server_test.Properties.Settings.Baza1ConnectionString"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Database Somee web\Baza1.mdf";Integrated Security=True;Connect Timeout=30"
providerName="System.Data.SqlClient" />
</connectionStrings>
Da li imate savet kako ovo mogu resiti?