A few days ago installed the WIN8 Enterprise Edition on the computer, and installed the MS Sql Server2008, the local development is relatively smooth, but other computer's client cannot access the database.
Ping first, but it can ping the other computer, may be set up the problem:
1, enter gpedit.msc in the operation, or enter the management tool, find the computer settings,->windows settings, security settings, local policy, user rights assignment, and deny access to this computer from the network, remove the guest user, Are you sure. (No problem solved)
2. Open the Control Panel, enter the management tool, open the Guest account, the Guest account. (No problem solved)
3, find the network settings, start Network discovery; (Resolve ping issues)
But the database is still not connected.
4, close the firewall;
5. Set the authentication mode of SQL Server.
SQL has two authentication modes one, Windows Authentication mode, two, mixed mode. If set to this mode, the client can log on with the SQL database user name and add a user name.
Again the connection is OK.
This article is from the "CSharp" blog, make sure to keep this source http://dawn0919.blog.51cto.com/2954252/1614952
Unable to connect MS SQL Server2008 Database issues