all groups > sql server connect > january 2005 >
You're in the

sql server connect

group:

win 2k3 , sql server server acceaa denied



win 2k3 , sql server server acceaa denied abhic
1/29/2005 3:01:06 AM
sql server connect: the following error occurs when connected to a sql server hosted in a win
2k3 .

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.

i am able to connect locally but when connected over internet it generates
the error.

Re: win 2k3 , sql server server acceaa denied gdog
2/9/2005 1:35:27 PM
Try this dude...I had a similar problem and picked this up from another
newsgroup and it worked.


Go to The Microsoft SQL Server program Group
Open Server Network Utility
Change the TCP/IP port from 1433 to anything (pick something safe above
1000)
Restart the SQL Service
Open Server Network Utility
Change the TCP/IP port back to 1433
Restart the SQL Service

*** Sent via Developersdex http://www.developersdex.com ***
AddThis Social Bookmark Button