明輝手游網(wǎng)中心:是一個(gè)免費(fèi)提供流行視頻軟件教程、在線學(xué)習(xí)分享的學(xué)習(xí)平臺(tái)!

asp.net中用sqlclient訪問(wèn)數(shù)據(jù)庫(kù)出錯(cuò)處理方法

[摘要]asp.net中用sqlclient訪問(wèn)數(shù)據(jù)庫(kù)出錯(cuò)錯(cuò)誤現(xiàn)象:login failed for user:pole\aspnet解決辦法:在命令行運(yùn)行如下命令osql -E -S (local)\NetSDK -Q "sp_grantlogin 'POLE\ASPNET'&...
asp.net中用sqlclient訪問(wèn)數(shù)據(jù)庫(kù)出錯(cuò)錯(cuò)誤現(xiàn)象:login failed for user:pole\aspnet解決辦法:在命令行運(yùn)行如下命令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'"以上是對(duì)數(shù)據(jù)庫(kù)Pubs授予POLE\ASPNET用戶訪問(wèn)權(quán)