When we try to connect to a sql server 2000 using SQL server authentication, we are facing the below mentioned error msg.
"Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied"
But, once we connect to server using Windows NT login from the client machine, i.e., execute the below command in the run prompt and provide the credentials for windows login, we are able to connect to the server using sql server authentication(user
When we went though some of the msdn links, found that windows firewall was the major cause. But, in the server
1. Windows Firewall is turned off
2. TCP/IP and NamedPipes are enabled
3. Default Port Number is 1433
Any user, who wants to connect to the SQL Server using SSMS, first have to perform a Windows NT login and then connect using SQL authentication.
Due to the above error, the DTS packages which are executing in a different server are getting failed.
NOTE: Even after connecting to the server using Remote Desktop connection in a local machine, SQL authentication fails. Its manadatory to run the command
\\server_ipaddress\c$ in each of the local machine.
Any suggestion to resolve the above error is very much appreciated.
Thanks in advance,
View Complete Post