SQL SERVER 2005 Remote Login 18456 Error Resolution

Source: Internet
Author: User
Tags log microsoft sql server microsoft sql server 2005 connect management studio sql server management sql server management studio

One, SQL SERVER 2005 Landing 18456 Error Resolution

Many friends use MSSQL when this machine can log on SQL2005 SQL Server Management Studio normally.

However, remote cannot log on 1433,sql Server 2005 cannot connect to 1433 remotely. SQL (Microsoft SQL Server 2005) login does not go up, the original is a few small problems, now record my solution to these several situations. (There are a number of solutions, these are just my solutions, for reference only)

Error Tip:

Title: Connecting to the server

------------------------------

Unable to connect to 192.1.1.19.

------------------------------

Additional Information:

User ' shop ' login failed. (Microsoft SQL Server, error: 18456)

For help information, click: Http://go.microsoft.com/fwlink? prodname=microsoft+sql+server&evtsrc=mssqlserver&evtid=18456&linkid=20476

------------------------------

Button:

Are you sure

------------------------------

To find the problem: (Note: Use a Windows account or can log in)

Step one: Start all the SQL-related services, and the problem remains, (after confirming the service, just for troubleshooting)

Related Article

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.