SQL Server 2008 R2: Enable the remote connection and sa login
来源:互联网 发布:祖玛的复仇2mac版 编辑:程序博客网 时间:2024/05/16 09:41
Step1: Change SQL Server authentication mode
1. Open SQL Server Management Studio,
2. In the Connect to Server dialog box, type ipAddress/InstanceName, just type (local) as for default local instance, in the Server name text box and then connect just with the default Windows Authentication mode.
3. In the Object Explorer, right-click the connected ipAddress/instance node and then click Properties.
4. Server Properties dialog box --> in Securtity page --> Server authentication area, select the SQL Server and Windows Authentication mode.
5. Server Properties dialog box --> Connections page, make sure the Allow remote connections to this server is checked.
6. OK.
Step2: Enable sa account
1. In Object Explorer, find out Securtity --> Logins --> sa, right-click sa and click Properties.
2. Login Properties --> General page, set password for sa.
3. Login Properties --> Status page, Enable sa.(don't miss this step)
4. OK.
Step3:Restart SQL Server service.
1. In Object Explorer, right-click the connected ipAddress/instance node, then Restart.
2. Try to connect to server with sa and password you just specified.
The above solution may also apply to SQL Server 2008 and 2005.
- SQL Server 2008 R2: Enable the remote connection and sa login
- SQL SERVER sa login 18456 Error with 2012 R2 server
- Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. [SQLSTATE 28000] (Error 18452). The st
- SQL server 2008 R2 sa登陆设置
- SQL Server 2008 R2 error: sa 18456
- How to enable remote connections in SQL Server 2008?
- Sql server 2008 R2 Forget Password for Sa
- SQL Server 2008 R2 sa登录密码忘记
- sql server 2008R2修改sa密码的简单方式
- SQL server 2008 R2 增加sa身份验证登陆
- Login failed for user 'sa'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)
- HOWTO: Enable and control the gnome VNC vino-server from an SSH connection
- sql server 2008 r2 修改sa密码 通过sql server 身份验证登陆
- Configuration the Remote desktop Connection in Windows 2012R2
- Login failed for user 'username'. The user is not associated with a trusted SQL Server connection
- Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)
- Trouble shooting:login failed for user 'sa' ,the user is not associated with a trusted SQL Server
- Enable Remote Login to Start SSH Server in Mac OS X
- 软件外包人员的出路
- decimal constant is so large that it is unsigned
- Oracle导入/导出数据库的语法
- 网游经济系统的自动调节?
- Problem 46
- SQL Server 2008 R2: Enable the remote connection and sa login
- java高级视频-IO输入与输出[学习中……]
- django model API参考
- poj 3233 Matrix Power Series
- Git使用
- How to install DBDesigner 4
- PHP代码:验证IPV6地址是否合法的正则
- Everyone dreams of getting a perfectly slim and trim body
- c# 右下角弹出和关闭窗口