如何通过网络域登录sqlserver以获取报表查看器？

问题描述：

大家好日子。我在vb 2010中开发了一个使用本地处理的报告的应用程序。应用程序正常使用以下连接字符串：

数据源= 192.168.1.222;初始目录= ITEM_MGR;用户ID = sa;密码= michaels但是每次我尝试查看报告时，都会出现以下错误：登录失败。登录来自不受信任的域，不能与Windows身份验证一起使用。请提供任何帮助，我们将不胜感激。

谢谢

Frank

我尝试过：

1.添加了一个具有相同连接字符串的配置文件。

2.使用的数据源全名，登录名称和密码。

例如。数据源= Amd-pc;初始目录= Itm_mgr; Uiser id = sa;密码= michaels

3.禁用我的Windows防火墙

Good day to you all. I developed an application in vb 2010 that uses reports processed locally. The application is working properly with the following connection string:
"Data Source=192.168.1.222;Initial Catalog=ITEM_MGR;user id=sa; Password=michaels" But the each time i try to view the report, the following error appears: Login failed. The login is from an untrusted domain and cannot be used with windows authentication. Please any help with this will be appreciated.

Thanks
Frank

What I have tried:

1. Added a configuration file with the same connection string.
2. used Data source full name, the login name and the password.

eg. Data source= Amd-pc;initial catalog=Itm_mgr;Uiser id=sa; Password=michaels
3. Disabled my windows fire wall

答

看来您的SQL Server仅为Windows身份验证而设置'尝试在连接字符串中传递sn SQL登录。

您必须修改SQL Server以允许混合身份验证，Windows身份验证和SQL身份验证。

此外，使用SA帐户执行此操作是一个巨大的安全风险。切勿使用SA帐户。

It would appear that your SQL Server is setup for Windows Authentication only and you're trying to pass sn SQL login in the connection string.

You have to modify the SQL Server to allow Mixed authentication, Windows Auth and SQL auth.

Also, using the SA account to do this stuff is a MASSIVE security risk. NEVER use the SA account for anything.

谢谢戴夫。我的SQL设置为使用混合模式进行Windows和SQL身份验证。但是，我确实使用SA进行连接验证，因为DB与应用程序位于不同的PC中。但是Windows帐户可以对连接有效吗？

再次感谢Dave先生。

Thanks Dave. my SQL is setup to use mixed mode for both windows and SQL authentication. However, i did used the SA for the connection authentication as the DB is in a different PC from the application. But can the windows account be valid for the connection?

Thanks again, Mr. Dave.

如何通过网络域登录sqlserver以获取报表查看器？

相关推荐