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 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.sqlmonster.com
Hi
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 SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:5c7648275a5d424f9056a2250fce8d53@.SQLMonster.c om...
> 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.sqlmonster.com

No comments:

Post a Comment