| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mssql >> SQL Server shu ju ku sa mi ma xiang guan wen ti de jie jue fang fa
 

SQL Server shu ju ku sa mi ma xiang guan wen ti de jie jue fang fa

2008-07-30 06:50:44 编辑來源:互联网 评论
 
本文为【SQL Server数据库sa密码相关问题的解决方法】的拼音翻译版
  1、 qing jiao ru he cha zhao sqlserver de sa mi ma ?
  cha xun fen xi qi , lian jie shi , shen fen yan zheng shi yong " shi yong windows shen fen yan zheng "
  ran hou , zhi xing :
  EXEC sp_password NULL, 'NewPassword', 'Sa'
  qi ye guan li qi --> shi li ming --> an quan xing --> deng lu --> shuang ji you bian de SA--> geng gai mi ma
  wen : diu shi SA mi ma ru he zhao hui ?
  da : yong hu cao zuo shi wu zao cheng mi ma diu shi 。 you liang zhong fang fa :
  ru guo shu ju bu duo , ke chong zhuang TNSDB shu ju ku 。 ru guo zhi xiang zhao hui mi ma , ke jiang an zhuang pan zhong de tnsdb.txt wen jian zhong de “insert into
  tns_secu_user(c_user_name,c_user_pwd,c_user_code,i_user_type,
  c_expiry_date,c_user_lock,c_user_disa,c_who_crea,c_when_crea,
  c_who_modi,c_when_modi) values('sa','c12e01f2a13ff5587e1e9e4aedb8242d','',1,'','1','1','','','','')
  %” xing 。 qi zhong ‘sa’ hou de ‘c12e01f2a13ff5587e1e9e4aedb8242d’ zi chuan wei sa de mi ma 。
  yong ta lai ti huan tnsdb ku zhong tns_secu_user biao zhong de sa mi ma 。 zi duan wei c_user_pwd.
  2、sql server2000 wang ji sa mi ma de jie jue fang fa
  yi “windows shen fen yan zheng ” fang shi deng lu SQL cha xun fen xi qi , ran hou zhi xing
  EXEC sp_password NULL,'hello','sa'
  jiu ke yi jiang sa de mi ma gai wei hello le 。
  3、SQL wang ji sa mi ma xiu gai fang fa
  ru guo ni zai NT xia ( bao kuo 2000) zhuang de SQL Server, ze ke yi zhe yang zuo :
  zhi jie da kai " cha xun fen xi qi "( zhu yi bu shi cong " qi ye guan li qi " zhong jin ru , ke yi cong kai shi cai dan de cheng xu zu jin qu , ru guo zhao bu dao de hua , zhi jie zai " yun xing " zhong shu ru "isqlw.exe" ye ke );
  xuan ze "Windows shen fen yan zheng " jin ru , bu xu yao shu ru mi ma , zhi yao ni shi ben ji de xi tong guan li yuan huo zhe yu guan li yuan , ci shi zi dong cheng wei SQL Server de guan li yuan ;
  zai cha xun fen xi qi chuang kou zhong shu ru xia mian de yu ju zhi jie geng gai SA mi ma :
  sp_password Null,\\\'ok\\\',\\\'sa\\\'
  yun xing hou sa de mi ma bian wei "ok"
  sp_password cun chu guo cheng de gong neng shi geng gai SQL Server deng lu de mi ma ;
  yu fa ge shi :
  sp_password [ [ @old = ] http://support.microsoft.com/kb/256986/EN-US/) Microsoft Windows zhu ce biao shuo ming
  jing gao : zhu ce biao bian ji qi shi yong bu dang ke dao zhi yan chong wen ti , ke neng xu yao chong xin an zhuang cao zuo xi tong 。Microsoft bu neng bao zheng nin ke yi jie jue yin zhu ce biao bian ji qi shi yong bu dang er dao zhi de wen ti 。 shi yong zhu ce biao bian ji qi xu yao nin zi dan feng xian 。
  ru guo bu neng que ding ru he yan zheng MSDE an zhuang de shen fen yan zheng mo shi , ke yi cha kan xiang ying de zhu ce biao xiang 。 mo ren qing kuang xia , dui yu Windows shen fen yan zheng ,Windows LoginMode zhu ce biao zi xiang de zhi she zhi wei 1。 ru guo qi yong le hun he mo shi shen fen yan zheng , ze ci zhi wei 2。
  ? LoginMode zi xiang de wei zhi qu jue yu nin shi jiang MSDE zuo wei mo ren MSDE shi li an zhuang huan shi zuo wei ming ming shi li an zhuang 。 ru guo MSDE shi zuo wei mo ren shi li an zhuang de , ze LoginMode zi xiang wei yu yi xia zhu ce biao zi xiang zhong :
  HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
  ? ru guo MSDE shi zuo wei ming ming shi li an zhuang de , ze LoginMode zi xiang wei yu yi xia zhu ce biao zi xiang zhong :
  HKLM\Software\Microsoft\Microsoft SQL Server\%InstanceName%\MSSQLServer\LoginMode
  zhu yi : qie huan shen fen yan zheng mo shi zhi qian , bi xu she zhi sa mi ma , yi mian bao lu qian zai de an quan lou dong 。
  you guan qi ta xin xi , qing dan ji xia mian de wen zhang bian hao , yi cha kan Microsoft zhi shi ku zhong xiang ying de wen zhang :
  274773 (http://support.microsoft.com/kb/274773/EN-US/) FIX:If You Change Windows Security to Windows/SQL Security the SA Password is Blank
  yao cong hun he mo shi qie huan dao ji cheng (Windows) shen fen yan zheng mo shi , qing an yi xia bu zhou cao zuo : 1. yao ting zhi MSSQLSERVER yi ji suo you qi ta xiang guan fu wu ( ru SQLSERVERAgent), qing zai “ kong zhi mian ban ” zhong da kai fu wu cheng xu 。
  2. da kai zhu ce biao bian ji qi 。 yao da kai zhu ce biao bian ji qi , qing yi ci dan ji kai shi he yun xing , ran hou jian ru :“regedt32”( bu bao kuo yin hao )
  dan ji que ding 。
  3. zhao dao yi xia liang ge zi xiang zhi yi ( qu jue yu MSDE shi zuo wei mo ren MSDE shi li an zhuang de huan shi zuo wei ming ming shi li an zhuang de ):
  HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer
  - huo zhe -
  HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\\MSSQLServer\
  4. zai you chuang ge zhong , shuang ji LoginMode zi xiang 。
  5. zai DWORD bian ji qi dui hua kuang zhong , jiang ci zi xiang de zhi she zhi wei 1。 que bao xuan ze le Hex xuan xiang , ran hou dan ji que ding 。
  6. chong xin qi dong MSSQLSERVER he SQLSERVERAgent fu wu yi shi geng gai sheng xiao 。
  SQL Server an zhuang de zui jia an quan fang an
  xia mian de mei yi xiang dou hui zeng qiang xi tong de an quan xing , bing qie ta men dou shu yu ren he SQL Server an zhuang de biao zhun an quan “ zui jia fang an ”。 ? shi yong fei kong mi ma bao hu sa deng lu zhang hu 。 you xie ru chong cheng xu jin dang nin wei dui sa deng lu zhang hu cai qu an quan cuo shi shi cai hui fa zuo 。 you guan qi ta xin xi , qing dan ji xia mian de wen zhang bian hao , yi cha kan Microsoft zhi shi ku zhong xiang ying de wen zhang :
  313418 (http://support.microsoft.com/kb/313418/EN-US/) PRB: shi yong kong (NULL) SA mi ma de fei an quan de SQL Server hui gei ru chong cheng xu yi ke cheng zhi ji
  yin ci , yao que bao nei zhi sa zhang hu ju you qiang mi ma , bi xu an zhao SQL Server lian ji cong shu de “ xi tong guan li yuan (SA) deng lu ” zhu ti zhong de jian yi jin xing cao zuo ( ji shi nin cong wei zhi jie shi yong sa zhang hu )。
  ? zu sai wei yu Internet wang guan de duan kou 1433, ran hou fen pei SQL Server zhen ting bei yong duan kou 。
  ? ru guo zai Internet wang guan shang bi xu shi yong duan kou 1433, qing qi yong jin chu guo lv gong neng yi fang zhi wu yong duan kou 。
  ? zai Microsoft Windows NT zhang hu ( er fei ben di xi tong zhang hu ) xia yun xing SQLServer fu wu he SQL Server dai li 。
  ? qi yong Microsoft Windows NT shen fen yan zheng , ran hou qi yong dui cheng gong he shi bai deng lu de shen gai 。 ran hou , ting zhi bing chong xin qi dong MSSQLServer fu wu 。 pei zhi nin de ke hu duan shi yong Windows NT shen fen yan zheng 。
  =============================
  SQL Server 2000 de sa mi ma wang ji zhi hou de jie jue fang fa :
  jin tian , fa xian wo wei hu de fu wu qi de SQL2000 chu cuo le 。 qian yi duan shi jian ba fu wu qi de mi ma gao su le ling yi ge tong shi , ta zai shang mian zhuang le ge ta zuo de xi tong , ye bu zhi dao bei ta zen me gao de yi xia 。
  xian zai jing ran qi dong qi ye guan li qi ye lian jie bu shang 。 yuan lai de sa mi ma ye bu shi wo she zhi de 。 ta shuo ye mei you dong guo SQL2000, zhen de shi ma fan 。
  yi xia shi wo zhao dao de jie jue fang fa , dan shi dui yu wo de ji qi hao xiang huan bu tai xing 。
  " wu fa lian jie dao fu wu qi , yong hu xxx deng lu shi bai "
  gai cuo wu chan sheng de yuan yin shi you yu SQL Server shi yong le " jin Windows" de shen fen yan zheng fang shi ,
  yin ci yong hu wu fa shi yong SQL Server de deng lu zhang hu ( ru sa ) jin xing lian jie . jie jue fang fa ru xia suo shi :
  1. zai fu wu qi duan shi yong qi ye guan li qi , bing qie xuan ze " shi yong Windows shen fen yan zheng " lian jie shang SQL Server
  2. zhan kai "SQL Server zu ", shu biao you jian dian ji SQL Server fu wu qi de ming cheng , xuan ze " shu xing ", zai xuan ze " an quan xing " xuan xiang ka
  3. zai " shen fen yan zheng " xia , xuan ze "SQL Server he Windows ".
  4. chong xin qi dong SQL Server fu wu .
  zai yi shang jie jue fang fa zhong , ru guo zai di 1 bu zhong shi yong " shi yong Windows shen fen yan zheng " lian jie SQL Server shi bai ,
  na jiu tong guo xiu gai zhu ce biao lai jie jue ci wen ti :
  1. dian ji " kai shi "" yun xing ", shu ru regedit, hui che jin ru zhu ce biao bian ji qi
  2. yi ci zhan kai zhu ce biao xiang , liu lan dao yi xia zhu ce biao jian :
  [HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer/MSSQLServer]
  3. zai ping mu you fang zhao dao ming cheng "LoginMode", shuang ji bian ji shuang zi jie zhi
  4. jiang yuan zhi cong 1 gai wei 2, dian ji " que ding "
  5. guan bi zhu ce biao bian ji qi
  6. chong xin qi dong SQL Server fu wu .
  ci shi , yong hu ke yi cheng gong di shi yong sa zai qi ye guan li qi zhong xin jian SQL Server zhu ce ,
  dan shi reng ran wu fa shi yong Windows shen fen yan zheng mo shi lai lian jie SQL Server.
  zhe shi yin wei zai SQL Server zhong you liang ge que sheng de deng lu zhang hu :
  BUILTIN/Administrators
  < ji qi ming >/Administrator bei shan chu .
  yao hui fu zhe liang ge zhang hu , ke yi shi yong yi xia de fang fa :
  1. da kai qi ye guan li qi , zhan kai fu wu qi zu , ran hou zhan kai fu wu qi
  2. zhan kai " an quan xing ", you ji " deng lu ", ran hou dan ji " xin jian deng lu "
  3. zai " ming cheng " kuang zhong , shu ru BUILTIN/Administrators
  4. zai " fu wu qi jiao se " xuan xiang ka zhong , xuan ze "System Administrators"
  5. dian ji " que ding " tui chu
  6. shi yong tong yang fang fa tian jia < ji qi ming >/Administrator deng lu .
  shuo ming :
  yi xia zhu ce biao jian :
  HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer/MSSQLServer/LoginMode de zhi jue ding le SQL Server jiang cai qu he zhong shen fen yan zheng mo shi .
  1. biao shi shi yong "Windows shen fen yan zheng " mo shi
  2. biao shi shi yong hun he mo shi (Windows shen fen yan zheng he SQL Server shen fen yan zheng ).
  wo zai chu li zhe ge wen ti shi zhe yang zuo de :
  1. chong xin zhu ce SQL fu wu qi , shu ru fu wu qi ming wei : LOCALHOST , zhe ge shi hou xi tong ke yi chong xin lian jie dao SQL shu ju ku
  2. da kai LOCALHOST xia mian de an quan xing -> deng lu , xiu gai sa de mi ma
  3. bian ji mo ren de Local fu wu lian jie de shu xing , xiu gai wei zheng que de sa de mi ma 。
  zhe yang jiu ke yi zheng que de qi dong le LOCAL lian jie le 。
  zui hou dang ran ke yi shan chu LOCALHOST lian jie 。【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
1、 qing jiao ru he cha zhao sqlserver de sa mi ma ? cha xun fen xi qi , lian jie shi , shen fen yan zheng shi yong " shi yong windows shen fen yan zheng " ran hou , zhi xing : EXEC sp_password NULL, 'NewPassword', 'Sa' qi ye guan li qi --> shi li ming --> an quan xing --> deng lu --> shuang ji you bian de SA--> geng gai mi ma wen : diu shi SA mi ma ru he zhao hui ? da : yong hu cao zuo shi wu zao cheng mi ma diu shi 。 you liang zhong fang fa : ru guo shu ju bu duo , ke chong zhuang TNSDB shu ju ku 。 ru guo zhi xiang zhao hui mi ma , ke jiang an zhuang pan zhong de tnsdb.txt wen jian zhong de “insert into tns_secu_user(c_user_name,c_user_pwd,c_user_code,i_user_type, c_expiry_date,c_user_lock,c_user_disa,c_who_crea,c_when_crea, c_who_modi,c_when_modi) values('sa','c12e01f2a13ff5587e1e9e4aedb8242d','',1,'','1','1','','','','') %” xing 。 qi zhong ‘sa’ hou de ‘c12e01f2a13ff5587e1e9e4aedb8242d’ zi chuan wei sa de mi ma 。 yong ta lai ti huan tnsdb ku zhong tns_secu_user biao zhong de sa mi ma 。 zi duan wei c_user_pwd. 2、sql server2000 wang ji sa mi ma de jie jue fang fa yi “windows shen fen yan zheng ” fang shi deng lu SQL cha xun fen xi qi , ran hou zhi xing EXEC sp_password NULL,'hello','sa' jiu ke yi jiang sa de mi ma gai wei hello le 。 3、SQL wang ji sa mi ma xiu gai fang fa ru guo ni zai NT xia ( bao kuo 2000) zhuang de SQL Server, ze ke yi zhe yang zuo : zhi jie da kai " cha xun fen xi qi "( zhu yi bu shi cong " qi ye guan li qi " zhong jin ru , ke yi cong kai shi cai dan de cheng xu zu jin qu , ru guo zhao bu dao de hua , zhi jie zai " yun xing " zhong shu ru "isqlw.exe" ye ke ); xuan ze "Windows shen fen yan zheng " jin ru , bu xu yao shu ru mi ma , zhi yao ni shi ben ji de xi tong guan li yuan huo zhe yu guan li yuan , ci shi zi dong cheng wei SQL Server de guan li yuan ; zai cha xun fen xi qi chuang kou zhong shu ru xia mian de yu ju zhi jie geng gai SA mi ma : sp_password Null,\\\'ok\\\',\\\'sa\\\' yun xing hou sa de mi ma bian wei "ok" sp_password cun chu guo cheng de gong neng shi geng gai SQL Server deng lu de mi ma ; yu fa ge shi : sp_password [ [ @old = ] [url=http://support.microsoft.com/kb/256986/EN-US/]http://support.microsoft.com/kb/256986/EN-US/[/url]) Microsoft Windows zhu ce biao shuo ming jing gao : zhu ce biao bian ji qi shi yong bu dang ke dao zhi yan chong wen ti , ke neng xu yao chong xin an zhuang cao zuo xi tong 。Microsoft bu neng bao zheng nin ke yi jie jue yin zhu ce biao bian ji qi shi yong bu dang er dao zhi de wen ti 。 shi yong zhu ce biao bian ji qi xu yao nin zi dan feng xian 。 ru guo bu neng que ding ru he yan zheng MSDE an zhuang de shen fen yan zheng mo shi , ke yi cha kan xiang ying de zhu ce biao xiang 。 mo ren qing kuang xia , dui yu Windows shen fen yan zheng ,Windows LoginMode zhu ce biao zi xiang de zhi she zhi wei 1。 ru guo qi yong le hun he mo shi shen fen yan zheng , ze ci zhi wei 2。 ? LoginMode zi xiang de wei zhi qu jue yu nin shi jiang MSDE zuo wei mo ren MSDE shi li an zhuang huan shi zuo wei ming ming shi li an zhuang 。 ru guo MSDE shi zuo wei mo ren shi li an zhuang de , ze LoginMode zi xiang wei yu yi xia zhu ce biao zi xiang zhong : HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode ? ru guo MSDE shi zuo wei ming ming shi li an zhuang de , ze LoginMode zi xiang wei yu yi xia zhu ce biao zi xiang zhong : HKLM\Software\Microsoft\Microsoft SQL Server\%InstanceName%\MSSQLServer\LoginMode zhu yi : qie huan shen fen yan zheng mo shi zhi qian , bi xu she zhi sa mi ma , yi mian bao lu qian zai de an quan lou dong 。 you guan qi ta xin xi , qing dan ji xia mian de wen zhang bian hao , yi cha kan Microsoft zhi shi ku zhong xiang ying de wen zhang : 274773 ([url=http://support.microsoft.com/kb/274773/EN-US/]http://support.microsoft.com/kb/274773/EN-US/[/url]) FIX:If You Change Windows Security to Windows/SQL Security the SA Password is Blank yao cong hun he mo shi qie huan dao ji cheng (Windows) shen fen yan zheng mo shi , qing an yi xia bu zhou cao zuo : 1. yao ting zhi MSSQLSERVER yi ji suo you qi ta xiang guan fu wu ( ru SQLSERVERAgent), qing zai “ kong zhi mian ban ” zhong da kai fu wu cheng xu 。 2. da kai zhu ce biao bian ji qi 。 yao da kai zhu ce biao bian ji qi , qing yi ci dan ji kai shi he yun xing , ran hou jian ru :“regedt32”( bu bao kuo yin hao ) dan ji que ding 。 3. zhao dao yi xia liang ge zi xiang zhi yi ( qu jue yu MSDE shi zuo wei mo ren MSDE shi li an zhuang de huan shi zuo wei ming ming shi li an zhuang de ): HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer - huo zhe - HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\\MSSQLServer\ 4. zai you chuang ge zhong , shuang ji LoginMode zi xiang 。 5. zai DWORD bian ji qi dui hua kuang zhong , jiang ci zi xiang de zhi she zhi wei 1。 que bao xuan ze le Hex xuan xiang , ran hou dan ji que ding 。 6. chong xin qi dong MSSQLSERVER he SQLSERVERAgent fu wu yi shi geng gai sheng xiao 。 SQL Server an zhuang de zui jia an quan fang an xia mian de mei yi xiang dou hui zeng qiang xi tong de an quan xing , bing qie ta men dou shu yu ren he SQL Server an zhuang de biao zhun an quan “ zui jia fang an ”。 ? shi yong fei kong mi ma bao hu sa deng lu zhang hu 。 you xie ru chong cheng xu jin dang nin wei dui sa deng lu zhang hu cai qu an quan cuo shi shi cai hui fa zuo 。 you guan qi ta xin xi , qing dan ji xia mian de wen zhang bian hao , yi cha kan Microsoft zhi shi ku zhong xiang ying de wen zhang : 313418 ([url=http://support.microsoft.com/kb/313418/EN-US/]http://support.microsoft.com/kb/313418/EN-US/[/url]) PRB: shi yong kong (NULL) SA mi ma de fei an quan de SQL Server hui gei ru chong cheng xu yi ke cheng zhi ji yin ci , yao que bao nei zhi sa zhang hu ju you qiang mi ma , bi xu an zhao SQL Server lian ji cong shu de “ xi tong guan li yuan (SA) deng lu ” zhu ti zhong de jian yi jin xing cao zuo ( ji shi nin cong wei zhi jie shi yong sa zhang hu )。 ? zu sai wei yu Internet wang guan de duan kou 1433, ran hou fen pei SQL Server zhen ting bei yong duan kou 。 ? ru guo zai Internet wang guan shang bi xu shi yong duan kou 1433, qing qi yong jin chu guo lv gong neng yi fang zhi wu yong duan kou 。 ? zai Microsoft Windows NT zhang hu ( er fei ben di xi tong zhang hu ) xia yun xing SQLServer fu wu he SQL Server dai li 。 ? qi yong Microsoft Windows NT shen fen yan zheng , ran hou qi yong dui cheng gong he shi bai deng lu de shen gai 。 ran hou , ting zhi bing chong xin qi dong MSSQLServer fu wu 。 pei zhi nin de ke hu duan shi yong Windows NT shen fen yan zheng 。 ============================= SQL Server 2000 de sa mi ma wang ji zhi hou de jie jue fang fa : jin tian , fa xian wo wei hu de fu wu qi de SQL2000 chu cuo le 。 qian yi duan shi jian ba fu wu qi de mi ma gao su le ling yi ge tong shi , ta zai shang mian zhuang le ge ta zuo de xi tong , ye bu zhi dao bei ta zen me gao de yi xia 。 xian zai jing ran qi dong qi ye guan li qi ye lian jie bu shang 。 yuan lai de sa mi ma ye bu shi wo she zhi de 。 ta shuo ye mei you dong guo SQL2000, zhen de shi ma fan 。 yi xia shi wo zhao dao de jie jue fang fa , dan shi dui yu wo de ji qi hao xiang huan bu tai xing 。 " wu fa lian jie dao fu wu qi , yong hu xxx deng lu shi bai " gai cuo wu chan sheng de yuan yin shi you yu SQL Server shi yong le " jin Windows" de shen fen yan zheng fang shi , yin ci yong hu wu fa shi yong SQL Server de deng lu zhang hu ( ru sa ) jin xing lian jie . jie jue fang fa ru xia suo shi : 1. zai fu wu qi duan shi yong qi ye guan li qi , bing qie xuan ze " shi yong Windows shen fen yan zheng " lian jie shang SQL Server 2. zhan kai "SQL Server zu ", shu biao you jian dian ji SQL Server fu wu qi de ming cheng , xuan ze " shu xing ", zai xuan ze " an quan xing " xuan xiang ka 3. zai " shen fen yan zheng " xia , xuan ze "SQL Server he Windows ". 4. chong xin qi dong SQL Server fu wu . zai yi shang jie jue fang fa zhong , ru guo zai di 1 bu zhong shi yong " shi yong Windows shen fen yan zheng " lian jie SQL Server shi bai , na jiu tong guo xiu gai zhu ce biao lai jie jue ci wen ti : 1. dian ji " kai shi "" yun xing ", shu ru regedit, hui che jin ru zhu ce biao bian ji qi 2. yi ci zhan kai zhu ce biao xiang , liu lan dao yi xia zhu ce biao jian : [HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer/MSSQLServer] 3. zai ping mu you fang zhao dao ming cheng "LoginMode", shuang ji bian ji shuang zi jie zhi 4. jiang yuan zhi cong 1 gai wei 2, dian ji " que ding " 5. guan bi zhu ce biao bian ji qi 6. chong xin qi dong SQL Server fu wu . ci shi , yong hu ke yi cheng gong di shi yong sa zai qi ye guan li qi zhong xin jian SQL Server zhu ce , dan shi reng ran wu fa shi yong Windows shen fen yan zheng mo shi lai lian jie SQL Server. zhe shi yin wei zai SQL Server zhong you liang ge que sheng de deng lu zhang hu : BUILTIN/Administrators < ji qi ming >/Administrator bei shan chu . yao hui fu zhe liang ge zhang hu , ke yi shi yong yi xia de fang fa : 1. da kai qi ye guan li qi , zhan kai fu wu qi zu , ran hou zhan kai fu wu qi 2. zhan kai " an quan xing ", you ji " deng lu ", ran hou dan ji " xin jian deng lu " 3. zai " ming cheng " kuang zhong , shu ru BUILTIN/Administrators 4. zai " fu wu qi jiao se " xuan xiang ka zhong , xuan ze "System Administrators" 5. dian ji " que ding " tui chu 6. shi yong tong yang fang fa tian jia < ji qi ming >/Administrator deng lu . shuo ming : yi xia zhu ce biao jian : HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer/MSSQLServer/LoginMode de zhi jue ding le SQL Server jiang cai qu he zhong shen fen yan zheng mo shi . 1. biao shi shi yong "Windows shen fen yan zheng " mo shi 2. biao shi shi yong hun he mo shi (Windows shen fen yan zheng he SQL Server shen fen yan zheng ). wo zai chu li zhe ge wen ti shi zhe yang zuo de : 1. chong xin zhu ce SQL fu wu qi , shu ru fu wu qi ming wei : LOCALHOST , zhe ge shi hou xi tong ke yi chong xin lian jie dao SQL shu ju ku 2. da kai LOCALHOST xia mian de an quan xing -> deng lu , xiu gai sa de mi ma 3. bian ji mo ren de Local fu wu lian jie de shu xing , xiu gai wei zheng que de sa de mi ma 。 zhe yang jiu ke yi zheng que de qi dong le LOCAL lian jie le 。 zui hou dang ran ke yi shan chu LOCALHOST lian jie 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
我们约会吧
漂亮白皙的模特
好纯好美的女生
靓丽的网络美女
痞子的甘南日记
疑是银河落九天
雪域坝上四——纯美色
冬日恋歌——西城杨柳弄轻柔
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有