Cant Connect to server

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 ^_^

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

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.

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

Quote:

---

Originally Posted by shadowking810

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

---

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

emi here is the log file u requested

In your DB agent logs...

Quote:

---

[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.

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

---

here is snap shot of the results

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

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

Did you set the server LAN or WAN?

i switched it to LAN

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

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

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