如何解决其他计算机打开数据库的问题？ [英] How to fix problem in opening database of other computer?

问题描述

我有SQL Server 2014，我在PC1中使用VBNET 2015制作了一个系统。然后我通过PC2中的WLAN连接我的数据库..现在允许PC2的SQL Server 2014打开我的数据库及其表..所以，我使用PC2在Debug文件夹中打开我的程序的.exe文件..我做了一个我在程序中登录表单，但每次登录时都会出现错误说

  无法打开数据库 NEWCMO  登录请求。登录失败。用户登录失败 ACE \ LOUSA   

我尝试过：



我从不尝试任何东西，只能通过PC2访问PC1的数据库

解决方案

尝试没有集成安全性，即通过用户名和密码创建一个SQL用户SQL Server Management Studio并将凭据添加到连接串。请参阅以下链接中的标准安全性



.NET Framework数据提供程序SQL Server连接字符串 - ConnectionStrings.com [ ^ ]

I have SQL Server 2014 and I made a system using VBNET 2015 in PC1. Then I connect my database through WLAN in PC2.. The SQL Server 2014 of PC2 is now allowed to open my database and its tables.. So, I open the .exe files of my program in Debug folder using PC2.. I made a Login Form in the program that I made but everytime I log in the error occurs saying

" Cannot open database "NEWCMO" requested by the login. The login failed. Login failed for user "ACE\LOUSA""

What I have tried:

I never try anything but to access only by PC2 the database of PC1

解决方案

Try without integrated security, ie create a SQL User with a username and password via the SQL Server Management Studio and add the credentials to the connection string. See "Standard security" in the following link

.NET Framework Data Provider for SQL Server Connection Strings - ConnectionStrings.com[^]

这篇关于如何解决其他计算机打开数据库的问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！