连接到数据库时出现SQL Express连接错误 [英] SQL Express Connection Error When Connecting to Database

问题描述

我一直试图将Visual Basic连接到SQL，因为这是我们的经验教训，但是当我执行它时，它表明了这一点.我该如何解决?

I've been trying to connect my Visual basic to SQL because this is what we are taught off but when I execute it, it shows this. How do I fix this?

推荐答案

此Windows用户需要被授予对SQL Server和该特定数据库的访问权限.通常在SQL Server的安装过程中进行配置.您仍然可以通过打开SSMS并在安全性->>"下添加此用户来完成此操作.对象资源管理器"面板中的登录"节点.

This Windows user needs to be granted access to SQL Server and that specific database. It is usually configured during installation process of SQL Server. You can still do it by opening SSMS and adding this user under Security -> Logins node from Object Explorer panel.

当然，要实现上述目的，您需要首先连接到SQL Server Express.您可能需要使用其他Windows用户或SQL Server用户.只有在安装过程中通过选择混合模式进行身份验证(Windows + SQL Server)启用了SQL Server身份验证后，后者才有可能.

Of course, to be able to do above, you need to connect to your SQL Server Express first. You may need to use another Windows user or a SQL Server user. The latter would be possible only if SQL Server Authentication has been enabled during installation process by choosing Mixed Mode for authentication (Windows + SQL Server).

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