Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

Hosting ASP.net sajta na somee - baza podataka se azurira preko C# aplikacije

[es] :: .NET :: ASP.NET :: Hosting ASP.net sajta na somee - baza podataka se azurira preko C# aplikacije

[ Pregleda: 2546 | Odgovora: 2 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

crnobrada
Student
FTN

Član broj: 325485
Poruke: 12
85.186.121.*



Profil

icon Hosting ASP.net sajta na somee - baza podataka se azurira preko C# aplikacije09.10.2014. u 20:55 - pre 115 meseci
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=&quot;C:\Database Somee web\Baza1.mdf&quot;;Integrated Security=True;Connect Timeout=30"
providerName="System.Data.SqlClient" />
</connectionStrings>

Da li imate savet kako ovo mogu resiti?
 
Odgovor na temu

Laki123

Član broj: 16706
Poruke: 98
*.dynamic.sbb.rs.



+4 Profil

icon Re: Hosting ASP.net sajta na somee - baza podataka se azurira preko C# aplikacije10.10.2014. u 18:12 - pre 115 meseci
Moras attachovati bazu na serveru
Create an empty MS SQL database
Attach database
Posle toga ces dobiti connection string, i izmeni web.config.
 
Odgovor na temu

crnobrada
Student
FTN

Član broj: 325485
Poruke: 12
85.186.121.*



Profil

icon Re: Hosting ASP.net sajta na somee - baza podataka se azurira preko C# aplikacije11.10.2014. u 10:28 - pre 115 meseci
Zdravo,

To sam vec i ranije probao. Evo npr. kreiram bazu "Database1Somee" i dobijem connection string

workstation id=Database1Somee.mssql.somee.com;packet size=4096;user id=NETWORK;pwd=*******;data source=Database1Somee.mssql.somee.com;persist security info=False;initial catalog=Database1Somee

Opcija 1. Uploadujem baze na somee i pokusam attach. Greska...

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.UnauthorizedAccessException: Access to the path '\\198.37.116.30\d$\DZHosts\LocalUser\********\www.*******.somee.com\Baza1.mdf' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite, Boolean checkHost) at System.IO.File.Copy(String sourceFileName, String destFileName) at DZWebSvc.DZWebAgent.AttachNewUserDB(String DBName, String LoginName, String OriginalDBFileName, String OriginalLogFileName, String NewDBFileName, String NewLogFileName, Int32 MaxDataFileSizeMB, Int32 MaxLogFileSizeMB, String ConnectionString, Boolean ChangeDefaultSchemaToDbo, String tk) in c:\Projects\Doka\Zin1_branch\DZWebSvc\DZWebAgent.asmx.cs:line 2057 --- End of inner exception stack trace ---

Opcija 2. Upload sa hard diska. Greska...

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: The database 'Database1Somee' cannot be opened because it is version 782. This server supports version 706 and earlier. A downgrade path is not supported. Could not open new database 'Database1Somee'. CREATE DATABASE is aborted. User does not have permission to alter database 'Database1Somee', the database does not exist, or the database is not in a state that allows access checks. ALTER DATABASE statement failed. Changed database context to 'master'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DZWebSvc.DZWebAgent.AttachNewUserDB(String DBName, String LoginName, String OriginalDBFileName, String OriginalLogFileName, String NewDBFileName, String NewLogFileName, Int32 MaxDataFileSizeMB, Int32 MaxLogFileSizeMB, String ConnectionString, Boolean ChangeDefaultSchemaToDbo, String tk) in c:\Projects\Doka\Zin1_branch\DZWebSvc\DZWebAgent.asmx.cs:line 2057 --- End of inner exception stack trace ---
 
Odgovor na temu

[es] :: .NET :: ASP.NET :: Hosting ASP.net sajta na somee - baza podataka se azurira preko C# aplikacije

[ Pregleda: 2546 | Odgovora: 2 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.