Re: SQL server problem ...
Is your database password even correct? Does the one stated in CentOS match the one given in your SQL Database? :o
Re: SQL server problem ...
Yes the password is correct ... even in ODBC Source when I want to connect to SQL server i got the error : SQL Server connection timed out or SQL Server doesen`t exist ... i don`t know what i should do ... :-s
Re: SQL server problem ...
This is going to be exactly the same as every other "cannot connect to sql server" error. SQL installed incorrectly.
Run the query below on any db 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
Re: SQL server problem ...
Back with another problem ... i installed the SQL Server by following a guide ... but i don`t know what i made ... :-s
I tryed to connect with sa and password ... and local windows connection ... both doesen`t work
http://www.pict.com/view/1669369/0/1
EDIT : i figured out what was the problem ... i will try now the server with the new changes ... i will post if it works/doesen`t works :) thx anyway chumpy a lot ... :)
Re: SQL server problem ...
you forgot creating linked servers.
1 Attachment(s)
Re: SQL server problem ...
I`m back again :| with another problem ... my router is an D-Link DI 524UP ... i don`t know how to forward the ports ... my routers firewall is down ... and i don`t know why i`m not connecting to server ... logs = no error ...
Re: SQL server problem ...
Quote:
Originally Posted by
walkernight88
i don`t know how to forward the ports
That is the reason. If you don't forward ports your router doesn't know where to send the connections. If you don't know how then look in my sig for my "simple port forwarding" guide as your router is supported.
1 Attachment(s)
Re: SQL server problem ...
Man i have forwarded the ports like you said ... btw it doesen`t work ... i don`t know what it has ... everything was checked and double checked ... :|
Re: SQL server problem ...
If you use a router don't test it yourseld in "public" mode liek this as not all routers work well. See if somebody from outside can log on because if they can and you can't you have a router that can't host properly.
Alos you need to have your wan ip in internal.txt as whatever ip address is in the worldsvr ini file (IPAddress=) is what should be in internal.txt.
