I need to use Microsoft SQL Server Management Studio (SSMS) to connect to a remote server for my work. I have never used SSMS before and I did not install it myself as I do not have admin rights on my work computer. I have been given a Server Name and told to choose Database Engine as Server Type and Windows authentication in the Connect to Server window. I have asked for firewall authorisation and I have been added among the users authorised to use the remote server.
但 我迄今未能建立联系,因为每次我开放SSMS并使用与服务器接口的连接,我总是会遇到同样的错误:
在建立与SQ服务器的链接时,出现了与网络有关的或针对具体情况的错误。 服务器没有发现或无法使用。 证明试样名称正确,并配置服务器,以便远程连接。 (供应商:TCP提供商,错误:0 - 远程计算机拒绝网络连接) (Microsoftker服务器,Error:1225)。 ->
I double checked multiple times that the server name is correct and that I have firewall authorisation and that I am an authorised user for the remote server. It makes me think that my version of SSMS is not enabled for remote access. I checked possible solutions all over Google but with no success. One suggestion is to right-click on the server name and in the Server Properties allow the remote connection. However i do not have any server instance in the Object Explorer window so nothing on which I could right-click on.
是否有任何建议?
事先感谢你