Can't connect to my server / Gm tools problem!

GM Tools Problem: When i put my MSSQL IP: 192.168.1.5 and my logon: sa and pass, i try to connect but i can't, it says that somthing is wrong or 'make sure that no firewall is on the way'

Cant connect to my server. When it asked for Ip adress i put these one.
Server ip Adress: My centOS ip (192.168.1.20)
MSSQL IP Adress: 192.168.1.5
Now i put the files that was on the patch folder in repack 2.8 on my Cabal folder, i change the internal.txt putting my CentOS lan ip <didnt work> and it didnt work too with my lan ip> 192.168.1.1 and 192.168.1.5... I'm using Wireless D-link ADSL2+ Router 2640T, on VmWare i put Bridged, and my VmNetwork's adapter's are disabled!

For issue #1 being the GM tool, try and enter the IP as 127.0.0.1 if you are running the DB's locally.

For #2 when you installed CentOS did you make sure to disable the firewall as mentioned in the install guide?

its the Pre Installed CentOS on VmWare, i should turn off my Windows firewall?

---------- Post added at 06:09 PM ---------- Previous post was at 05:53 PM ----------

this is the problem that im getting on GM Tool Kit - Binary Mass Game, i have all db's installed and xpmd5 is executed on query.
http://img37.imageshack.us/img37/1427/binnary.jpg[COLOR="Silver"]

Based on the SS, it looks like you may have installed SQL wrong.. What version of SQL are you running and did you follow a guide to install it? It looks like you may have installed as a Named Instance which will not work for the Cabal DB's. The only fix for this is to uninstall and reinstall making sure to follow Chumpys guide word for word. I always use SQL Express 2005 and follow the guide making sure to install as a default instance and running the surface area configuration wizard to open up Named Pipes and TCP/IP connections.

Also like I said before, if you are running SQL locally on your windows box it is best to use the loopback address for GM tools.. Instead of using your SQL lan address use 127.0.0.1

For the CentOS VMware, Which image did you use? Post a link to the DL... In CentOS make sure the firewall is disabled and that you are in fact using static IP's that match your network.. From your windows machine can you ping the CentOS IP? Can you reach the internet from CentOS, to test open up Terminal and ping google.com and see if you get a reply, if not you either have the wrong IP's or no default gateway set up..

I always prefer to install CentOS myself rather than use premade images to avoid these kinds of problems. I'm sure people work very hard to create "ready to run" images but the same setup wont work for everyone. If worse comes to worse, you would be better off deleting the image and installing CentOS yourself from a DVD ISO. Chumpy has a guide for doing this.

Hope this helps..

yes, i'm using sql 2005 express(http://www.microsoft.com/downloads/d...displaylang=en) i follow the guide, but there is somes parts in my installation that are missing and have in the Guide, some options on Installation, in my SQL didnt appear, but in the tutorial it appears.

Oh well, i'll need to download CentOS image, but its too big and my internet speed is low ><, i didnt change any ips on WorldSv_Ini and OBDC Ini, because i cant found WorlSv on my root folder, i'm using repack 2.8, maybe this is the problem? I can ping from Windows the centos lan ip fine, and ping google.com too. U mean that the Windows firewall may be disabled?

No, I mean the CentOS firewall, without it disabled the server will refuse connections.

oh, i didnt disabled it, where it is located, i'm using pre-installed image, so there is a firewall or not ?

Not on the pre-installed.

You said your vm network adaptors are disabled and that is bad. One of them is the one you need to communicate with centos on. Once done make sure windows can ping centos and centos can ping windows.

For the SQL problem run the query below in any database and post the results.

Code:

---

Declare @insname varchar(25)
if convert(varchar(25),serverproperty('instancename')) is null
  set @insname='MSSQLSERVER'
else
  set @insname=convert(varchar(25),serverproperty('instancename'))
  select @insname as 'Instance',
  serverproperty('productversion') as 'Ver', serverproperty('productlevel') as 'SP',
  serverproperty('edition') as 'Edition'
  if @insname<>'MSSQLSERVER'
  begin
    select 'THIS IS BAD! You must reinstall MSSQL. Please follow the guides next time.' as 'MSSQL is a named instance!'
  end

  begin
    Declare @inspath varchar(10),@reg varchar(100),@tcpremote as int
    EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
    @key='Software\Microsoft\Microsoft SQL Server\Instance Names\SQL\',
    @value_name=@insname,
    @value=@inspath OUTPUT
    set @reg='Software\Microsoft\Microsoft SQL Server\' + @inspath + '\MSSQLSERVER\SuperSocketNetLib\tcp\'
    EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
    @key=@reg,
    @value_name='Enabled',
    @value=@tcpremote OUTPUT
    select @inspath as 'Instance path',@tcpremote as 'Remote connections enabled?'
    if @tcpremote='0'
      begin
        EXEC master.dbo.xp_regwrite @rootkey='HKEY_LOCAL_MACHINE',
        @key=@reg, @value_name='Enabled', @type='REG_DWORD',@value=1
        select 'I enabled remote connections ! Please reboot !' as 'Remote connections checker'
      end
    else
      begin
        select 'This is good! I have nothing to do :(' as 'Remote connections checker'
      end
    select account.dbo.fn_md5('test') as 'xp_md5.dll check'
  end

---

OK, and other thing, its needed to change the ips on cabal server files, like OBDC an WorldSv isnt it? But, i cant found the WorldSV on my root to change the IP's i thihk that i dont have it >< i'm using repack 2.8
Results:
http://img29.imageshack.us/img29/4905/cant.jpg

These are my logs on the attachment, just remebering, i didnt change any ip on cabal server files, like OBDC.ini and WorldSvr because i cant find it on repack 2.8, i think its missing!

These are the last ones logs on the attachment, i couldnt put all on previous post!

repost those:CashDBAgent.txt
ChatNode_01.txt
DBAgent_01.txt
GlobalDBAgent.txt
GlobalMgrSvr.txt



They are not complete
However you get weird erros:O

OK right now, i installed the CentOS Image according to the Video tut, all fine, installed with th according IPS, i can ping normally without any problems, now my internal txt i've put my CentOS lan ip, but i cant connect to my server, i'm using the patch that is on the /root/clientpatch ;\

well i'm seeing now that i didnt forward the ports correctly, after i do this i post the results! well its not needed, cuz i'm just trying to connect via LAN, but i cant connect ;\

this is my logs on DBAgent and GlobalDB, i'm getting errors on this two logs

Your server does not connect to sql,make sure there is no (windows)Firewall in the way and also be sure you introduced the right login details

so, maybe, the problem that i cant connect to my server is the SQL that i cant connect via my server?

---------- Post added at 05:50 PM ---------- Previous post was at 05:34 PM ----------

i've disabled the firewall, and tried to connect withh all logins that i know in my MSSQL, i'm recieving error.. i changed the MSSQL ip 192.168.1.5 to 192.168.1.15 and now i'm getting error only on DB agent, that is the same error as before

---------- Post added at 07:33 PM ---------- Previous post was at 05:50 PM ----------

bump! i'm re-installing the MSSQL properly, btw, my MSSQL installation don't have the 'ADD user to the SQL Administration ROLE'