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

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

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用户访问权
 

asp.net中用sqlclient访问数据库出错解决办法';return true">
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>