Dear Friends, I need your help. plz guide me how to resolve this problem. I installed SQL Server 2008 Express edition on windows server 2008 with mix mode authentication and create login with Sql server authentication. this server is attached with 3 node. Now I want to connect its database from node. but not succed. is it possible to connect sql express database with multiple user on network. Sqlserverexpress installed on its default port i.e 1433 and i configure ip add of server is 192.168.1.12, subnet mask is 255.255.255.0 and gate way is 192.168.1.13 and ip address of node is 192.168.1.15 subnet mask is 255.255.255.0 and gate way is 192.168.1.13 and on node i add ip of server 192.168.1.12 as prefered dns. and check it in both way means add server ip as DNS and without adding this ip as DNS Regards Mukesh
check that the port used by sql server is added in exception in **Firewall** check the TCP/IP is **enabled** in SQL Native Client COnfiguration-> CLint Protocols->TCP?IP right click on the server-> secutity->Servert authentication _> select SQL Server and Windows authentication_" please do remember this change requires SQL Server Restart"