asp.net中用sqlclient訪問數據庫出錯處理方法
發表時間:2024-02-18 來源:明輝站整理相關軟件相關文章人氣:
[摘要]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用戶訪問權