asked
connect sql server express on network
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
Hi Mukesh, By default the TCP/IP connection method (which is probably what you are trying to use to connect over the network - local connections use a different connection method) is disabled - try enabling it per [these simple instructions][1]. Note that if you want to use a different port you can follow [these instructions][2]. You can test it's working by trying to connect to server 127.0.0.1 (assuming the default port) and checking you get a connection. Hope that helps. Dave. [1]:
http://pic.dhe.ibm.com/infocenter/sprotect/v2r8m0/index.jsp?topic=%2Fcom.ibm.siteprotector.doc%2Finstalling%2Fsp_t_enabling_msde_communication_over_tcpip.htm [2]:
http://web.synametrics.com/sqlexpressremote.htm
If the information Dave provided does not resolve the issue can you provide the error messages you mentioned?
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"
17 People are following this question.
