asp.net中用sqlclient访问数据库出错解决办法

asp.net中用sqlclient访问数据库出错
错误现象：login failed for user:localhostaspnet
解决办法：在命令行运行如下命令
osql -E -S (local)NetSDK -Q "sp_grantlogin "localhostASPNET""

osql -E -S (local)NetSDK -d Pubs -Q "sp_grantdbaccess "localhostASPNET""
osql -E -S (local)NetSDK -d Pubs -Q "sp_addrolemember "db_owner", "localhostASPNET""
以上是对数据库Pubs授予localhostASPNET用户访问权