SQL SERVER 2005 Remote Login 18456 Error Resolution

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)