Re: [Guide] Setting up a server based on VSRO server files
I had this problem "cannot establish keep alive session : 192.168.X.X 15880 (bind 0.0.0.0)"
I think is bcuz bad connection string in DBCoonect.asp
Then i changed like this:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=MI-PCNAME\SQLEXPRESS;UID=sa;PWD=sa_psw;DATABASE=SRO_VT_ACCOUNT;"
DBConnA.Open strConnectA
%>
Put attention to string parameters changed:
Initial catalog change to
DATABASE and positioned to final
User iD change to
UID
Password change to
PWD
You can test this dowloading this file and paste into wwwroot folder, later open browser en write localhost:8080 (this if you change the port to 8080 in IIS):
Note: this code will check records in TB_User and return all rows in a table, if you can see that records, the connection Works fine, ofc you need to have at least 1 record in that table.
You must be registered to see links
I test that and Works perfectly, solve connection problem and stop that message. Another important thing is, check if filezilla is working fine before run all services and the URL in server.cfg is well written.
For the files that open and close instantly, require remove from DEP, to do this, press windoes key + pause key, or go to mypc icon right click and open properties, now go to Advanced system settings, after that click in 'Advanced' tab and press Settings button in Performance área,, in the new Windows go to Data Execution Prevention and add all .exe in your server folder, including smc, and silkroad game exes too.
I hope this help someone
I use Windows 7 64bit and SQLServer 2008 R2 Express. I set in IIS DefaultAppPool to .NET 4, check that
