Cant Connect to server

[shadowking810]

MSSQL connection is up, i tested with GM tool
I can ping from windows to centos and centos to windows
Im using DMZ to allow everything to the centos IP
Im using windows 7 64bit

it still wont connect can anyone help me here pls ^_^

[MentaL]

[emi]

can you please post the logs from \var\log\cabal ?

[chumpywumpy]

Don't use DMZ, it isn't for purposes like this and will stop it working. You need to forward the individual ports (or a range) rather than using a DMZ.

[shadowking810]

emi can u add me via msn shadowking810@live.com

[emi]

emi can u add me via msn shadowking810@live.com

No.I am sorry.All the help i can give is right here!

[shadowking810]

emi here is the log file u requested

[chumpywumpy]

In your DB agent logs...

[unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.

Not good.

Either your SQL server is configured wrong or your windows firewall is blocking the server.

Run the whole query below on any database and post the results if checking your firewall doesn't work.

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

[shadowking810]

here is snap shot of the results

[emi]

All seems ok :)
The problem is the firewall,disable it!:)
If you have a router did you forward ports?

[shadowking810]

ok i got it to work until the ch selection after that whole bar loads but wont let me in

[emi]

Did you set the server LAN or WAN?

[shadowking810]

i switched it to LAN

[TanGzkie]

goto your MSSQL
delete your Link server then
make again try it :)

[shadowking810]

already did that help if anyone can help with this tiny problem add me on msn shadowking810@live.com

[chumpywumpy]

Post the log files from /var/log/cabal on the server (remember to try logging in first so we can see the errors).

[knight90]

Seems i got the same problem like him,can someone tell me where i wrong?

[TanGzkie]

try to Login on your cabal maybe 2 or 3 times then post your logs here..
cause we didn't see your attempting to login in your cabal..

[knight90]

Here some logs,with 3 times login,it can be something wrong from centos then?

[Alphakilo23]

Here some logs,with 3 times login,it can be something wrong from centos then?

Your server isn't even noticing that you try to log in.
Check your network settings, including what you entered during cabal_config

[knight90]

Well my firewall is of,i forward port for centos and in cabal_config i set it for wan ip...

[Alphakilo23]

Well my firewall is of,i forward port for centos and in cabal_config i set it for wan ip...

Then you can't connect from LAN side, since the cabal server isn't listening to requests from your subnet.
Read this thread.

[knight90]

problem solved it was from my sql,now i`m useing a friend database and it seems to work good,thx for your support!

[fredsterj]

pls help i try to run your query everythinh is ok exept of the 'xp_md5.dll it say's it's NULL, what shall i do now?