Unable to connect MS SQL Server2008 Database issues

Source: Internet
Author: User
Tags database issues

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.