I have created a window application in c# and Sqlserver 2005. Now on my server the connection string is working properly, but on client machine my databse is not conecting. my connection string is :
are you using the same account when accessing server and client? Just for testing purposes, try to use a connection string which passes the userid and password.
it could also be that the sql server doesn't accept remote connections. check if it's already enabled via the surface area configuration -> surface area configuration for services and connections -> MSSQLServer-> Database Engine -> Remote connections: choose Local And remote connections using TCP/IP only or whatever suits your need. I haven't yet used sql express. but that's what I would with SQL Server 2005.
Ryan AlfordPosted Aug 31, 2008, 8:56 AM
Bhim KunwarPosted Aug 31, 2008, 6:39 AM
you better try using this code
server=;database=;uid=;pwd=
and see properly client network utility properly if u r using mssql. omit "integrated security = true"
Jan MontanoPosted Jun 30, 2008, 3:43 AM
it could also be that the sql server doesn't accept remote connections. check if it's already enabled via the surface area configuration -> surface area configuration for services and connections -> MSSQLServer-> Database Engine -> Remote connections: choose Local And remote connections using TCP/IP only or whatever suits your need. I haven't yet used sql express. but that's what I would with SQL Server 2005.