Troubleshoot SQL Server 2005 SA account not logged on issues

It is dangerous to allow SA users to be remote. The recommended practice is to create a new local user that allows remote connections.

1. Enable the TCP/IP protocol.

2. Configure the listening port (1433).

Net-an Check if the local port is listening, use the online IP port test tool to test if the remote port is open.

3. Create a remote login user

4.

1. Using Management Studio Express

With

Windows

Authentication "Login, select

Sql

Service

Name, right-click on the mouse to select Properties, on the Server Properties Options page, select "Security" to authenticate server authentication by

“

Windows

Authentication "Change to"

SQL Server

And

Windows

Authentication, click OK.

2.

Use

Sql

Server 2005

Surface Area Configurator, select the service and connection surface area Configurator, choose

SQL Express

–

>database Engine

–

>

Service, first stop, restart, reboot

SQL Server

Server.

3.

and back to

Management Studio Express

, select "Security" –

>

Login Name –

>sa

, right-click the mouse,

Login Properties

-sa

Page, select a status, change the login from "disabled" to "enabled" (This can be set

Sa

Login Password or take

To remove the login password, in the General Options), click OK.

Specific operation

:

1.

First Use

Windows

Authentication logged in.

2.

See two first entries, whether to allow connection to the database engine – grant

Troubleshoot SQL Server 2005 SA account not logged on issues