blocks|key|242327|text|连接字符串：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|242328|Server=tcp:[serverName].database.windows.net;Database=myDataBase;User+ID=[LoginForDb]@[serverName];Password=myPassword;Trusted_Connection=False;Encrypt=True;|code-block|syntax|javascript|242329|当您在连接字符串中写入'+database‘属性时，您可以更改连接默认数据库。|242330|SSMS正在连接到数据库框，该框是连接对话框中option->secont选项卡。|242331|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Connection String:

<pre><code>Server=tcp:[serverName].database.windows.net;Database=myDataBase;User ID=[LoginForDb]@[serverName];Password=myPassword;Trusted_Connection=False;Encrypt=True;
</code></pre>

You can change connect default database, when you write 'Database' property at connection string.

SSMS is connect to database box which is option->secont tab at conecct dialog.

blocks|key|2913766|text|使用SSMS登录时，您可以轻松更改默认数据库。单击登录对话框上的选项按钮，然后单击连接属性选项卡。在“连接到数据库”框中输入数据库的名称。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2913767|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can easily change the default database when loging in with SSMS. Click the Options button on the Login Dialog then click on the Connection Properties tab. In the "Connect to database" box enter the name of your database.

blocks|key|3128099|text|正如您已经发现的，DEFAULT_DATABASE选项在SQL+Azure中不可用。因此，如果您不能更改通常在其中指定数据库名称的应用程序的连接字符串，则只能使用master。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3128100|然而..。是否可以创建ODBC连接，并将您的应用程序配置为使用ODBC？使用ODBC将允许您指定默认数据库。|3128101|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

As you already discovered the DEFAULT_DATABASE option is not available in SQL Azure. So if you cannot change the connection string of your application in which you would normally specify the database name, you are stuck to master. 

However... is it possible to create an ODBC connection, and configure your application to use ODBC? Using ODBC would allow you to specify a default database.

blocks|key|240077|text|您必须使用下面的命令才能更改“默认”数据库|type|unstyled|depth|inlineStyleRanges|entityRanges|data|240078|240079|使用"SQL+Server+Native+Client+10.0“或更高版本，而不是使用"SQL+Server作为驱动程序|ordered-list-item|240080|使用完整的用户id，如UserName@AzureConnnectString|240081|240082|对我来说，它就是NorthWind@w6ywertsd8h.database.windows.net|240083|更多详细信息请点击此处http://debugmode.net/2011/04/22/connecting-microsoft-access-to-sql-azure/|offset|length|240084|entityMap|0|LINK|mutability|MUTABLE|url|http://debugmode.net/2011/04/22/connecting-microsoft-access-to-sql-azure/^0|0|0|0|0|0|0|B|21|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|X|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|Y|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|Z|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@$M|13|N|14|1|15]]|A|$]]|$1|O|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

You have to use use following to be able to change "default" Database

<ol>
<li>Use "SQL Server Native Client 10.0" or higher instead on using "SQL Server as Driver</li>
<li>Use full user id like UserName@AzureConnnectString</li>
</ol>

For me it is
NorthWind@w6ywertsd8h.database.windows.net

More details here
<a href="http://debugmode.net/2011/04/22/connecting-microsoft-access-to-sql-azure/" rel="nofollow">http://debugmode.net/2011/04/22/connecting-microsoft-access-to-sql-azure/</a>

blocks|key|2913937|text|另一种选择是在主数据库中创建一个映射用户，并对托管数据库执行操作。这将允许SSMS连接到服务器并使用master作为默认数据库，然后用户可以打开数据库。我不是DBA，所以我不知道这意味着什么，但这就是我如何解决它的。我的数据库只是用于POC项目，所以它没有太多的安全要求。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2913938|entityMap^0|B|J|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Another option is to create a mapped user in the master database and the hosted database. This will allow SSMS to connect to the server and use master as the default db, then the user can open the database. I am not a DBA so I do not know the implications of this, but that is how I solved it. My database is just being used for a POC project so it doesn't have many security requirements.

blocks|key|240128|text|到目前为止，SSMS中最简单的方法是使用additional+parameters选项卡并提供初始目录，例如|type|unstyled|depth|inlineStyleRanges|entityRanges|data|240129|​|240130|📷|atomic|offset|length|240131|240132|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/da1d67869a917c65a550f8ca1f66c064.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

By far the easiest way in SSMS is to use the additional parameters tab and supply the initial catalog, e.g.

<a href="https://i.stack.imgur.com/mR6V4.png" rel="noreferrer"><img src="https://i.stack.imgur.com/mR6V4.png" alt="Initial Parameters tab"></a>

blocks|key|2914036|text|在我的例子中，我是通过直接在master数据库中创建一个登录名来实现的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2914037|CREATE+LOGIN+newlogin+WITH+password='password'
GO

CREATE+USER+newlogin+FOR+LOGIN+newlogin+WITH+DEFAULT_SCHEMA=[dbo]
GO|code-block|syntax|javascript|2914038|然后，我在想要访问的数据库中创建了一个用户：|2914039|CREATE+USER+newlogin+FOR+LOGIN+newlogin+WITH+DEFAULT_SCHEMA=[dbo]
GO|2914040|最后将其添加到特定数据库中的角色，以获得正确的权限：|2914041|Alter+role+db_owner+add+member+newlogin|2914042|希望这对你也有效。|2914043|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

In my case I managed to do it by creating a login directly in the master database:

<pre><code>CREATE LOGIN newlogin WITH password='password'
GO

CREATE USER newlogin FOR LOGIN newlogin WITH DEFAULT_SCHEMA=[dbo]
GO
</code></pre>

Then I created a user in the database I wanted to gain access to:

<pre><code>CREATE USER newlogin FOR LOGIN newlogin WITH DEFAULT_SCHEMA=[dbo]
GO
</code></pre>

At last adding it to a role in the particular database to gain the right permissions:

<pre><code>Alter role db_owner add member newlogin
</code></pre>

Hope this works for you too.

I would like to change the default database for a login to support software that can access SQL Azure but does not allow easy alteration of a connection string. It appears that SQL Azure defaults to the <code>master</code> database.

I've already considered:

<ul>
<li>Stored procedures. I can't find a stored procedure that does this (<code>sp_defaultdb</code> is not implemented in SQL Azure as far as I can tell)</li>
<li>Alter Login. <code>ALTER LOGIN</code> does not permit the <code>DEFAULT_DATABASE</code> option.</li>
<li>SSMS. SSMS doesn't seem to allow much user control through the interface for SQL Azure.</li>
</ul>

Ideas?

Changing the default database for a SQL Azure login

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我想要更改登录名的默认数据库，以支持可以访问SQL Azure但不允许轻松更改连接字符串的软件。看起来SQL Azure默认使用master数据库。我已经考虑过了：存储过程。我找不到这样做的存储过程(据我所知，sp_defaultdb没有在SQL Azure中实现)，Alter Login。ALTER LOGIN不允许...

问更改SQL Azure登录名的默认数据库
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问更改SQL Azure登录名的默认数据库EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问更改SQL Azure登录名的默认数据库
EN