问题描述
我已经创建了一个云数据库，并能够通过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连接时出现云数据库问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！