Friday, February 24, 2012

access problem while connecting sql 2k in win 2k3

when i am connecting the sql server in windows 2003 using the sql analyser t
he following error occurs
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server do
es not exist or access denied.
the authentication mode is mixed.
ICF is enabled.
aliasing used is TCP/ip
NetBios is also enabled
Message posted via http://www.droptable.comHi
Is port 1433 opened? You need a minimum of this when using SQL
authentication.
If you use Integrated, you need the 135, 136 and 139 open too.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"abhilash c via droptable.com" <forum@.droptable.com> wrote in message
news:5c7648275a5d424f9056a2250fce8d53@.SQ
droptable.com...
> when i am connecting the sql server in windows 2003 using the sql analyser
the following error occurs
> Server: Msg 17, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not

exist or access denied.
> the authentication mode is mixed.
> ICF is enabled.
> aliasing used is TCP/ip
> NetBios is also enabled
> --
> Message posted via http://www.droptable.com

No comments:

Post a Comment