Monday, March 26, 2012

How to connect to a dedicated m/c

Hi,
Recently i installed SQL server 2000(EE)on my remote dedicated server( win
2003). I haven't installed ant Service packs. Now the problem is i am not
able to connect to the SQL server either thru Query Analyzer or thru the
application. I have disabled the firewall, still no use. Can anyone help
me.But thru remote desktop, i was able to connect to the server m/c by
putting the ip address .
regards laraFirst thing to do is install SP3. SQL2000 RTM isn't supported on
Windows 2003.
David Portas
SQL Server MVP
--|||Hi,
I've installed SP3
This is what i get when i run SELECT @.@.Version
"
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
"
I've disabled the firewall, enaled TCP/IP, set default port to 1433. and no
use till now
The same error is diplaying again and again 'Server Msg 17, Level 16, State
1
MS [ODBC Sql Server][DBNETLIB]SQL Server does not exist or access de
nied'
regards lara
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1119436842.190857.7930@.o13g2000cwo.googlegroups.com...
> First thing to do is install SP3. SQL2000 RTM isn't supported on
> Windows 2003.
> --
> David Portas
> SQL Server MVP
> --
>|||Hi,
I've installed SP3
This is what i get when i run SELECT @.@.Version
"
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
"
I've disabled the firewall, enaled TCP/IP, set default port to 1433. and no
use till now
The same error is diplaying again and again 'Server Msg 17, Level 16, State
1
MS [ODBC Sql Server][DBNETLIB]SQL Server does not exist or access de
nied'
regards lara

No comments:

Post a Comment