I am experiencing the following erros while trying to log-into the Sql 2000 DB on Win-2003 Server.
At a given point of time only one users is allowed to log in and we
are getting the following errors :
SQLState : '01000'
SQL Server Error:232
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
SQL Server Error:11
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.Check your
I have check the SQL-Server properties and set the Authenticatiion to mixed mode (Win Nt and SQL server). Also I have intalled the latest Service Pack SP-3 . But even then i am encountering the above error.
How to rectify this issue. Can anyone please reply immediately.
AS far as the explore is concerned we are able to share directories between the server and work station. The problem is only through SQL. We we try to create ODBC from the first client it is going throuhg. Next when we try from the second clinet it hangs as the Server is not visible in the wizard and it is incomplete. After disconnecting the first client and trying in second client again it work. So at a given point of time only one user is able to log-inot the DB /Company.