创建可访问所有数据库的注册帐户 [英] Creating Registered Account with access to all database

问题描述

我在桌面计算机上安装了SQL Management Studio 2008，其连接处于Windows身份验证模式。是否可以创建一个帐户并使用笔记本电脑从我的桌面访问数据库？我该怎么做？

I have a SQL Management Studio 2008 on a desktop computer and its connection is on Windows authentication mode. Is it possible to create an account and use a laptop to access the database from my desktop? How do I do this?

推荐答案

从SQL Server Management Studio转到Security->从对象资源管理器登录。右键单击登录，您将能够创建新用户（前提是您具有适当的权限。）。将新创建的用户的权限分配给特定数据库。



另外要从另一台机器连接到SQL服务器实例，你需要确保它配置为允许远程连接，否则你将得到着名的错误26或错误40.发生网络相关或实例特定错误

From your SQL Server Management Studio go to Security-> Logins from Object Explorer. Right click on logins and you will be able to create a new user ( Provided you have proper permissions.) . Assign rights to the newly created user to specific database.

Also to connect to the SQL server instance from another machine you need to make sure that it is configured to allow remote connection otherwise you will get the famous Error 26 or Error 40. "Network related or instance specific error occurred"

这篇关于创建可访问所有数据库的注册帐户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！