blocks|key|308110|text|可以创建“数据库登录”对话框，通过使用文本框、按钮或其他对话框控件提示用户获取数据库连接信息。通常，当您在文本框中键入文本时，文本将显示为您键入的文本。但是，您可以使用(VBA)+Edition用户窗体的属性创建用于创建密码对话框的隐藏或“屏蔽”文本框的效果，在该对话框中，您不希望文本框中键入的文本是“可见的”。这里，你会发现如何做到这一点。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|308111|用户在“数据库登录”上键入的信息可以用于构建上面发布的连接字符串。|308112|若要在Excel中创建自定义对话框，请遵循这说明。|308113|entityMap|0|LINK|mutability|MUTABLE|url|https://support.microsoft.com/en-us/help/830258/how-to-create-a-masked-password-dialog-box-in-office-programs-by-using|1|https://learn.microsoft.com/en-us/office/vba/excel/Concepts/Controls-DialogBoxes-Forms/create-a-custom-dialog-box^0|4D|2|0|0|0|L|1|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]]]

You can create a "Database login" dialog box to prompt a user for database connection information by using text boxes, buttons, or other dialog box controls. Typically, when you type text in a text box, the text appears as you type. However, you can use a property of the Microsoft Visual Basic for Applications (VBA) Edition User Form to create the effect of a hidden or "masked" text box for creating a password dialog box, where you do not want the text that is typed in a text box to be "visible". <a href="https://support.microsoft.com/en-us/help/830258/how-to-create-a-masked-password-dialog-box-in-office-programs-by-using" rel="nofollow noreferrer">Here</a> you will find how to do that.

The information the user types on the "Database login" can be used to build the connection string you posted above.

To create a custom dialog in Excel please follow <a href="https://learn.microsoft.com/en-us/office/vba/excel/Concepts/Controls-DialogBoxes-Forms/create-a-custom-dialog-box" rel="nofollow noreferrer">this</a> instructions.

blocks|key|1693055|text|根据您的评论，我有一个想法，您可以为Azure+SQL数据库创建一个新的登录/用户。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1693056|然后使用此用户和密码作为公共帐户，从Excel中的Azure+SQL数据库获取或写入数据。|1693057|下面是示例T语句，这段代码是在Azure+SQL数据库中创建一个新登录名和一个用户。您可以在SSMS中运行此查询：|1693058|--running+in+master+db
USE+[master]
GO
CREATE+LOGIN+[sagarreadonly]+WITH+PASSWORD='password'
GO
--+running+in+Azure+SQL+DB
USE+[DataEncryptDemo]
GO
CREATE+USER+[sagarreadonly]+FOR+LOGIN+[sagarreadonly]+WITH+DEFAULT_SCHEMA+=+Marketing;+
GO
EXEC+sp_addrolemember+'db_owner',+'sagarreadonly';
GO|code-block|syntax|javascript|1693059|新用户作为“db_owner”创建到指定的数据库。|1693060|有关数据库角色的详细信息，请参阅数据库级角色。|offset|length|1693061|关于登录和用户：|1693062|登录名用于用户身份验证。|unordered-list-item|1693063|数据库用户帐户用于数据库访问和权限验证。|1693064|登录通过安全标识符(SID)与用户关联。访问server服务器需要登录名。验证特定登录名是否有效的过程称为“身份验证”。此登录必须与Server数据库用户相关联。使用用户帐户控制在数据库中执行的活动。如果数据库中没有针对特定登录名的用户帐户，则使用该登录名的用户即使能够连接到Server，也无法访问数据库。|1693065|登录是用于连接到Server实例的标识。用户允许您登录到Server数据库并映射到登录。因此，您需要先创建一个登录，然后才能在Server中创建用户。|1693066|希望这能有所帮助。|1693067|entityMap|0|LINK|mutability|MUTABLE|url|https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?redirectedfrom=MSDN&view=sql-server-ver15^0|0|0|0|0|0|G|6|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1C|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1D|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|1E|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|1F|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1G|8|@]|9|@$O|1H|P|1I|1|1J]]|A|$]]|$1|Q|3|R|5|6|7|1K|8|@]|9|@]|A|$]]|$1|S|3|T|5|U|7|1L|8|@]|9|@]|A|$]]|$1|V|3|W|5|U|7|1M|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|1N|8|@]|9|@]|A|$]]|$1|Z|3|10|5|6|7|1O|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|1P|8|@]|9|@]|A|$]]|$1|13|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]]|14|$15|$5|16|17|18|A|$19|1A]]]]

According your comment, I have an idea that you can create a new login/user for you Azure SQL database.

Then you use this user and password as public account to get or writer data from your Azure SQL database within Excel.

Here's the example T-SQL statement, this code is create a new login and a user in your Azure SQL database. You can run this query in SSMS:

<pre><code>--running in master db
USE [master]
GO
CREATE LOGIN [sagarreadonly] WITH PASSWORD='password'
GO
-- running in Azure SQL DB
USE [DataEncryptDemo]
GO
CREATE USER [sagarreadonly] FOR LOGIN [sagarreadonly] WITH DEFAULT_SCHEMA = Marketing; 
GO
EXEC sp_addrolemember 'db_owner', 'sagarreadonly';
GO
</code></pre>

The new user is created as 'db_owner' to the specified database.

For more details about database roles, please see <a href="https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?redirectedfrom=MSDN&amp;view=sql-server-ver15" rel="nofollow noreferrer">Database-Level Roles</a>.

About login and user:

<ul>
<li>A login is used for user authentication</li>
<li>A database user account is used for database access and permissions
validation.</li>
</ul>

Logins are associated to users by the security identifier (SID). A login is required for access to the SQL Server server. The process of verifying that a particular login is valid is called "authentication". This login must be associated to a SQL Server database user. You use the user account to control activities performed in the database. If no user account exists in a database for a specific login, the user that is using that login cannot access the database even though the user may be able to connect to SQL Server.

A Login is an identity used to connect to a SQL Server instance. A User allows you to log into a SQL Server database and is mapped to a Login. So you will need to first create a Login, before you can create a User in SQL Server.

Hope this helps.

I have a SQL Database on Azure to which I can successfully get connected from within an Excel file. I am using ADO and the connection string uses my own username and password. Since this file will be used by many users, how can I create a generic login and password so that I would not give out my own username and password in the code? The Excel file runs many VBA macros to communicate with the Azure SQL database.

I am using Excel 2010 (yeah, it is old, I have to) and this is my connection string:

<pre><code>mstrConnectionString = "Driver={SQL Server Native Client 11.0};" &amp; _
 "Server=tcp:&lt;servername&gt;.database.windows.net,1433;" &amp; _
 "Database=&lt;databasename&gt;;" &amp; _
 "Uid=&lt;myusername&gt;@&lt;servername&gt;;" &amp; _
 "Pwd={MyPassword};" &amp; _
 "Encrypt=yes;Connection Timeout=30;"
</code></pre>

Using Excel as the front end, Azure as the backend

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

我有一个Azure上的SQL数据库，可以从Excel文件中成功地连接到该数据库。我使用ADO，连接字符串使用我自己的用户名和密码。由于这个文件将被许多用户使用，我如何才能创建一个通用的登录和密码，这样我就不会在代码中给出我自己的用户名和密码？Excel文件运行许多VBA宏来与Azure SQL数据库通信。我正在使用Ex...

问使用Excel作为前端，Azure作为后端
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用Excel作为前端，Azure作为后端EN