This question was
closed
by
ThomasRushton for the following reason: Duplicate of
http://ask.sqlservercentral.com/questions/103153/connect-sql-server-express-on-network.html
asked
SQL Express Connection error on network
Dear Friends, I have a windows server 8 and installed Sqlserver 2008 Express on server. its Ip address is 192.168.1.12, subnet mask is 255.255.255.0 and gateway 192.168.1.13 and pref DNS is 218.248.255.162 and alternet DNS is 218.248.255.163. I have a database offlinework on it and create login test1 with sql authentication. Now i want to connect its database from another machine having win xp prof sp 2 ver. and its ip is 192.168.1.15 and pref DNS is 192.168.1.12 and rest settina same as server. when i try to connect this database system gives erro =================================== Cannot connect to 192.168.1.12. =================================== A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
Is this a named instance or the default? (SQL Browser enabled?) Have you checked Configuration Manager to confirm the protocol being used is enabled? Is this instance listening on the default port 1433? Are 2 instances trying to listen on the same port?
14 People are following this question.
