Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Can't connect to my srv.

Experienced Elementalist
Joined
May 5, 2009
Messages
207
Reaction score
20
As chumpy said i made new log files etc... i'm waiting for some answers. thx
 
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
[unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.

It can't connect to SQL. First check centos can ping windows and that the windows firewall is off.

If it still doesn't work then it's almost certainly an SQL configuration problem. Run the query below on any database and post the results which will tell me if SQL is correct or not.

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
 
Upvote 0
Experienced Elementalist
Joined
May 5, 2009
Messages
207
Reaction score
20
It can't connect to SQL. First check centos can ping windows and that the windows firewall is off.

If it still doesn't work then it's almost certainly an SQL configuration problem. Run the query below on any database and post the results which will tell me if SQL is correct or not.


here is the result
FastBlade - Can't connect to my srv. - RaGEZONE Forums
 
Upvote 0
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
Hmmm. Intesteringly my script didn't pick it up but you have installed as a named instance (which is the default). See how it has the "\sqlexpress" after the name? This is why it doesn't work and unfortunately only a reinstall of sql can fix it.

Have a look on the old guides topic in my sig and pay careful attention to the top of page 3, you must have a "default instance" for it to work.
 
Upvote 0
Back
Top