asp.net中用sqlclient訪問數(shù)據(jù)庫出錯錯誤現(xiàn)象: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'"以上是對數(shù)據(jù)庫Pubs授予POLE/ASPNET用戶訪問權(quán)
新聞熱點
疑難解答