连接到服务器的问题 [英] issue by connecting to the Server

问题描述

Helo，

我通过连接服务器遇到了一个问题。因为，系统管理员登录已从服务器中删除，该服务器只是具有管理权限的登录，而剩余的具有数据库级权限。



现在，我们无法连接带管理员的服务器登录以执行服务器级活动。



如果您知道此问题的任何解决方法？请建议，

Helo,
I've come across an issue by connecting to the Server. Because, the Sysadmin Login been dropped from the Server which was only the Login with administrative permissions and remaining ones having DB level permissions.

Now, we are unable to connect the Server with admin Login to perform Server level activities.

If you know any workaround for this issue?. Please suggest,

推荐答案

我想这是SQL Server（你提到了sysadmin角色）。如果是这样，您可以创建另一个登录名并将SysAdmin角色分配给该登录名。如果这样做，您可以对sql server执行管理级活动。

I guess it is SQL Server(you mention sysadmin role). If so you can create another login and assign SysAdmin role to that login. If you do so you can perform admin level activities to your sql server.

这篇关于连接到服务器的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！