Can someone help me setup the server so i am able to connect to it, i did everything the tutorials said, but i can't seem to get it working
Printable View
Can someone help me setup the server so i am able to connect to it, i did everything the tutorials said, but i can't seem to get it working
too many tutorials and post your problems with logs so we can help you :)
i dont know how to find the logs but it just stops some of the services when i start the server
Centos OS:6.4 32 bit
Windows OS:10 64 bit
Centos LAN IP:192.168.163.129
Windows LAN IP:192.168.1.103
Do u have turned off firewall?(Yes/No):Yes on both systems
Describe ur problem:Some of my services are stopped, name of them are: ChatNode_01, LoginSvr_01, WorldSvr_01_01, AgentShop_01, EventMgrSvr
Logs: I have logs for them all
Djbette's Pastebin - Pastebin.com
First thing you need to fix your problem.
Check your database connection.
Quote:
[unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
I know but i cant seem to get it to connect, i tried searching for the error code 20009, which it said in the logs. But couldn't figure out how to get it workingQuote:
Originally Posted by netsstea
Then, be sure that your MSSQL DB is allowing connections through port 1433, that SQL Server is not blocking the incoming server's IP address, and that you have the correct password.
using nmap and ping to 1433 port
it saidQuote:
Originally Posted by netsstea
http://i.imgur.com/hrFMM4D.png
It seem one of your OS was filtered and blocked port 1433.
Let's make sure, you disabled firewall of windows and firewall of Antivirut program
When you using nmap and get result is opepned, cabal services will work normally.
Attachment 157205
Quote:
Originally Posted by djbette
cant get it to say open, still says filteredQuote:
Originally Posted by netsstea
and firewall are disabled
- - - Updated - - -
i got it to work, but i cant create a account
tried
gmtools
exec [Account].[dbo].[cabal_tool_registerAccount] 'YOUR ACC NAME', 'PASSWORD', null, null
use
[Account].[dbo].[cabal_tool_registerAccount_web]
i used the one you said and i got this errorQuote:
Originally Posted by netsstea
Code:Msg 8152, Level 16, State 11, Procedure cabal_tool_registerAccount_web, Line 11
String or binary data would be truncated.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount_web, Line 17
Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount_web, Line 20
Cannot insert the value NULL into column 'UserNum', table 'CabalCash.dbo.CashAccount'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 208, Level 16, State 1, Procedure cabal_tool_registerAccount_web, Line 23
Invalid object name 'CabalCash2.dbo.CashAccount'.
Msg 266, Level 16, State 2, Procedure cabal_tool_registerAccount_web, Line 23
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Quote:
Originally Posted by djbette
Are you using SQL Server 2014?
yeah is that bad?Quote:
Originally Posted by PunkS7yle
Not sure if this helps
http://forum.ragezone.com/f451/cabal...014-a-1103746/
