明辉手游网中心:是一个免费提供流行视频软件教程、在线学习分享的学习平台!

asp.net中用sqlclient访问数据库出错处理方法

[摘要]asp.net中用sqlclient访问数据库出错错误现象:login failed for user:pole\aspnet解决办法:在命令行运行如下命令osql -E -S (local)\NetSDK -Q "sp_grantlogin 'POLE\ASPNET'&...
asp.net中用sqlclient访问数据库出错错误现象:login failed for user:pole\aspnet解决办法:在命令行运行如下命令osql -E -S (local)\NetSDK -Q "sp_grantlogin 'POLE\ASPNET'"osql -E -S (local)\NetSDK -d Pubs -Q "sp_grantdbaccess 'POLE\ASPNET'"osql -E -S (local)\NetSDK -d Pubs -Q "sp_addrolemember 'db_owner', 'POLE\ASPNET'"以上是对数据库Pubs授予POLE\ASPNET用户访问权