且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在Linq中设置sp_setapprole以执行存储过程

更新时间:2023-10-02 22:52:04

立即听起来您正在使用Windows身份验证而不是SQL身份验证.尝试删除连接字符串中的Integrated Security位,并提供一个sql用户名和密码

例如:
Offhand it sounds like you''re using Windows authentication instead of SQL authentication. Try removing the Integrated Security bit in the connection string and supplying a sql username and password

For example:
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;



请查看此页面以获取有关SQL Server连接字符串和示例的更多信息:

http://www.connectionstrings.com/sql-server-2008 [



Check out this page for more info on SQL Server connection strings and examples:

http://www.connectionstrings.com/sql-server-2008[^]

HTH, Good luck.