通过SSMS连接时出现云数据库问题 [英] Cloud Database problem while connecting thru SSMS

问题描述

我已经创建了一个云数据库，并能够通过SSMS成功连接. 现在我要在其中创建一个表.

I have created a cloud database and was able to connect successfully thru SSMS. Now I want to create a table in that.

成功连接后(通过SSMS进行)之后，当我尝试连接到数据库，即 可用数据库 MyFirstCloudDB 数据库时> 部分，我收到错误消息无法访问数据库MyFirstCloudDB".

Henceforth after the successful connection ( in am doing thru SSMS) when I am trying to connect to the database i.e. MyFirstCloudDB database which is available in the Available Databases section of SSMS, I am getting the error message " The database MyFirstCloudDB" is not accessible.

现在该怎么办?

我成功完成了我的工作.

I have success accomplished my work.

但是我要做的是，在通过SSM登录到我的SQL AZURE平台之后，首先创建了一个数据库(例如myFirstDB). 然后我注销了.再次连接，这次在选项"->连接到数据库"->中键入myFirstDB，然后连接. 之后，我创建了一个表并插入了一些值.

But what I have done is that after I logged in to my SQL AZURE platform thru SSMs, first I created a database(say myFirstDB). Then I logged out. Again I connected and this time Under Options->Connect to Database->I typed myFirstDB and then connected. After that I created a table and inserted some values.

我之所以包含这些参数，是因为如果像我这样的人遇到同样的问题，那么他们可以继续采用这种解决方案.

感谢罗伯·法利先生在这次旅程中与我在一起的大力支持，并感谢所有SO成员.这个论坛真的很棒(:

Thanks for the great support of Mr. Rob Farley for being with me in this journey and also to all the SO members. This forum is really really great (:

请帮助.

推荐答案

您需要以管理员身份登录到新数据库，并为新登录创建一个用户.然后尝试重新连接为新的登录名.

You need to login to your new db as your admin login and create a user for your new login. Then try connecting as the new login again.

这篇关于通过SSMS连接时出现云数据库问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！