SQL cannot connect, general view the following issues can be resolved.
1.SQL Service is started
2. Network connection port (1433) is open
3. Database roles for logged-in users
Above cannot be resolved, Progress view Event Viewer
If you are updating SQL, the following issues occur:
Event Type: Information
Event Source: Mssqlserver/msde
Event Type: None
Event id:5400
Date: 2006-8-13
Event: 8:24:25
Users: N/A
Computer: LIUZJ
Describe:
The version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that you are running contains a known vulnerability when used with this version of Windows. To reduce computer vulnerabilities from specific virus attacks, you should disable Microsoft SQL Server 2000, MSDE (or concurrent) TCP/IP and UDP network ports. To enable these ports, you must install the hotfix from Http://www.microsoft.com/sql/downloads/default.asp or the latest service PA for Microsoft SQL Server 2000 or MSDE Ck.
For more information, see the Help and Support Center in http://go.microsoft.com/fwlink/events.asp.
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.