المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Connecting to SQL db from several computers



C# Programming
11-19-2009, 09:42 AM
I've got SQL 2005 Express and db located on server. Clients computers connect to it and server application also connect to db to perform SQL queries.
How to enable simultanious access to db?
If server connected to db, it remains unavailable for connections from client with error:

System.Data.SqlClient.SqlException in Void OnError(System.Data.SqlClient.SqlException, Boolean): Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITY\SYSTEM'

Or vice versa, if client connected to db and read some date, server can not connect to it for some period of time

????????