英文:
Azure Serverless SQL Serverless Database
问题
我在Azure中创建了一个无服务器的SQL Server数据库，并尝试在本地使用我的SQL Server Management Studio访问它，但无法使其工作。
它总是给我这个消息：
我还尝试在Azure中将我的IP添加到白名单，但仍然得到相同的结果。
是否有可能连接它？
英文:
I Created SQL Server Database in Azure which is serverless and tried to access it using my SQL Server Management Studio in my local but I couldn't get it work.
It always gives me this message:
I tried to whitelist also my IP in Azure but still I get the same result.
Is there a possible way to make it connect?
答案1
得分: 2
数据库当前在线还是暂停？
我将重复来自@David Browne链接的文本：
如果服务器无服务数据库已暂停，那么首次登录将恢复数据库并返回错误，指出数据库不可用，错误代码为40613。一旦数据库恢复，必须重试登录以建立连接。具有连接重试逻辑的数据库客户端不应需要修改。
所以：
- 假设数据库已暂停，这是正常操作
- 请阅读文档
- 在数据库启动后，您需要重试，或者可以使用下面链接中提供的PowerShell手动预启动它
https://learn.microsoft.com/en-us/azure/sql-database/sql-database-serverless#connectivity
是的，您还需要将您的IP地址列入白名单，就像您已经做过的那样。
显然，这种SQL版本不适用于某些类型的应用程序 - 链接中有更多信息 - 我建议您阅读整个内容。
英文:
Is the database currently online or paused?
I'll repeat the text from @David Browne's link:
>> If a serverless database is paused, then the first login will resume the database and return an error stating that the database is unavailable with error code 40613. Once the database is resumed, the login must be retried to establish connectivity. Database clients with connection retry logic should not need to be modified.
So;
- Assuming the database is paused, this is normal operation
- Please read docs
- You need to retry after the database starts OR manually pre-start it using the Powershell provided in the link below
https://learn.microsoft.com/en-us/azure/sql-database/sql-database-serverless#connectivity
And yes, you also need to whitelist your IP address as you have already done.
Obviously this flavour of SQL is unsuitable for some types of applications - there is more information in the link - I suggest you read the whole thing.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论