Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Óû§"sa "µÇ½ʧ°Ü SQLServer ´íÎó18456

ÓÃwindowsÕ˺ݹÊÇ¿ÉÒԵǼµÄ¡£
²éÕÒÎÊÌâµÄ¹ý³Ì£º
µÚÒ»²½£º Æô¶¯ËùÓÐÓëSQLÓйصķþÎñ£¬ÎÊÌâÒÀ¾É£»
µÚ¶þ²½£º ²é¿´windows·À»ðǽ£¬±»Ä¬ÈÏÆô¶¯ÁË£¬²»Æô¶¯Ñ¡ÔñÏî±»Disabled¡£Á½¸öÌáʾ“ÓÉÓÚ°²È«¿¼ÂÇ,ijЩÉèÖÃÓÉ×é²ßÂÔ¿ØÖÆ”“Windows·À»ðǽÕýÔÚʹÓÃÄúµÄÓòÉèÖÔ£¬ÏÈÓÃgpedit.msc´ò×é²ßÂԱ༭Æ÷£¬»úËã»úÅäÖÃ--¹ÜÀíÄ£°å--ÍøÂç--ÍøÂçÁ¬½Ó--Windows·À»ðǽ--±ê×¼ÅäÖÃÎļþ£¬²é¿´Óұ߸÷Ñ¡ÏîÊôÐÔ£¬¶¼ÊÇδÅäÖÃ״̬£¬ÎÊÌâ²»ÔÚÕâÀï¡£
ÁíÍâÒ»¸öÌáʾÖÐÌáµ½ÓòÉèÖã¬ÓòÉèÖò»¿ÉÄܽûÓÃSQL Server,²¢ÇÒÎҲ鿴±¾µØ¿ª·Å¶Ë¿Ú£¨netstart -an£©£¬25£¬1433£¬1434¶¼ÊÇ¿ª·¢×´Ì¬¡£
ÔΣ¬»á²»»áÊÇÃÜÂë´íÎó£¿
 µÚÈý²½£ºÎÒÓÃwindowsÕ˺ŵǼ£¬Á¬½Ó³É¹¦ºó,, Ñ¡Ôñ"ÊôÐÔ"£¬
ÓÒ¼üʵÀý£¬ÔÚ"ÊôÐÔ"´°¿ÚÖÐ, תµ½"Security"(°²È«ÐÔ)Ïî, ²é¿´"·þÎñÆ÷Éí·ÝÑéÖ¤"ÖÐÉèÖÃȷΪ"SQL ServerºÍWindowsÉí·ÝÑé֤ģʽ", 
 È»ºóÖ´ÐÐÏÂÃæµÄÓï¾äÆôÓÃsaÓû§, ͬʱ¸ü¸ÄsaµÄÃÜÂë
EXEC sp_password 'sa',null,'sa'
ALTER LOGIN sa ENABLE
Ö´Ðгö´í£º
ÏûÏ¢ 15116£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
ÃÜÂëÓÐЧÐÔÑé֤ʧ°Ü¡£¸ÃÃÜÂëÌ«¶Ì£¬²»·ûºÏ Windows ²ßÂÔÒªÇó¡£
¹þ¹þ£¬ÎÊÌâÕÒµ½¡£
±¾µØÉèÖÿÉÄܱ»ÓòÉèÖø²¸Ç¡£¶øÓòÉèÖÃÖÐÖ¸¶¨Á˰²È«²ßÂÔ£¬ÃÜÂë±ØÐëÓÐÒ»¶¨µÄ¸´ÔÓÐÔ¡£ÖØÐ¸ü¸ÄsaÃÜÂ룬
EXEC sp_password 'sa','Uiop_098Mn','sa'
ALTER LOGIN sa ENABLE
ÎÊÌâ½â¾ö£¡


Ïà¹ØÎĵµ£º

sqlServer ÖÐ »ñÈ¡ºº×Ö×Ö´®µÄÆ´ÒôÉùĸ

 CREATE        function fGetPy(@str varchar(500)='')
returns varchar(500)
as
begin
    declare @strlen int,@return varchar(500),@ii int
    declare @c nchar(1),@chn nchar(1)
    select @strlen=len(@str),@retur ......

sqlserver »¹Ô­µ½Ê±¼äµã

½ñÌìÒ»²»Àä¾²¾Í°ÑsqlserverÊý¾Ý¿â³õʼ»¯ÁË£¬ÔÚÍøÉÏÕÒÁ˰ëÌì·¢ÏÖÁ˼¸ÆªÌû×Ó£¬ÊÜÒæ·Çdz£¬¼Ç¼ÏÂ
DB2ÖпÉÒÔʹµÃÊý¾Ý¿â»Ø¸´µ½Ö¸¶¨µÄʱ¼äµã£¬SQL ServerÊý¾Ý¿âµÄRecovery ModelΪfull »òÕßBulk copyµÄʱºò£¬ÊÇ¿ÉÒÔ´ÓÈÕÖ¾À´»Ö¸´Êý¾Ý¿âµÄ¡£Êµ¼ÊÉÏÈÕÖ¾ÖмǼµÄÒ»ÌõÒ»ÌõµÄtransact sqlÓï¾ä£¬»Ö¸´Êý¾Ý¿âµÄʱºò»áredoÕâЩsqlÓï¾ä¡£&nb ......

Ë÷ÒýµÄ´´½¨¼°Ê¹ÓÃ(sqlserver 2005)

Ë÷ÒýµÄ´´½¨¼°Ê¹ÓÃ(sqlserver 2005)
Ϊָ¶¨±í»òÊÓͼ´´½¨¹ØÏµË÷Òý£¬»òΪָ¶¨±í´´½¨ XML Ë÷Òý¡£¿ÉÔÚÏò±íÖÐÌîÈëÊý¾Ýǰ´´½¨Ë÷Òý¡£¿Éͨ¹ýÖ¸¶¨ÏÞ¶¨µÄÊý¾Ý¿âÃû³Æ£¬ÎªÁíÒ»¸öÊý¾Ý¿âÖеıí»òÊÓͼ´´½¨Ë÷Òý¡£
 Transact-SQL Óï·¨Ô¼¶¨
Óï·¨
 
Create Relational Index CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] IN ......

SqlserverÓëaccessÊý¾Ý¿âsqlÓ﷨ʮ´ó²îÒì

ÊÀʶ´Ã÷½ÔѧÎÊ£¬ÈËÇéÁ·´ï¼´ÎÄÕ¡£×öASPʱ£¬×î³£ÓõÄÊý¾Ý¿â¼´SqlserverÓëAccessÊý¾Ý¿âĪÊôÁË£¡
µ«Ê¹Óûᾭ³£·¢ÏֺܶàSQLÖ´ÐеÄÎÊÌâ¡£ÕâÀïÕûÀí³öÖ®¼äµÄ²îÒ죬×ö¸öÊ®´ó²îÒìµÄ×ܽᡣ
ACCESS½á¹¹¼òµ¥ÈÝÒ×´¦Àí£¬¶øÇÒÒ²ÄÜÂú×ã¶àÊýµÄÍøÕ¾³ÌÐòÒªÇó£¬Ò²ÊdzõѧÕßµÄÊÔÅ£µ¶¡£
ACCESSÊÇСÐÍÊý¾Ý¿â£¬¼ÈÈ»ÊÇСÐ;ÍÓÐËû¸ù±¾µÄ¾ÖÏÞÐÔ£º
......

ʹÓÃSqlserverÊÂÎñ·¢²¼ÊµÏÖÊý¾Ýͬ²½

      ÊÂÎñµÄ¹¦ÄÜÔÚsqlserverÖÐÓÉÀ´ÒѾã¬ÒòΪ×î½üÔÚ×öÒ»¸öÊý¾Ýͬ²½·½°¸£¬ËùÒÔÓлú»áÔÙ´ÎÑо¿Ò»ÏÂËüÒÔ¼°¿ìÕյȣ¬·¢ÏÖ»¹ÊÇÓкܶ಻´íµÄ¹¦Äܺ͸ĽøµÄ¡£ÕâÀïÒÔsqlserver2008µÄÊÂÎñ·¢²¼¹¦ÄÜΪÀý£¬¶Ô·¢²¼¶©Ôĵķ½Ê½¼òÒª½éÉÜһϲÙ×÷Á÷³Ì£¬Ò»·½Ãæ×ö¸ö×ܽᱸ·Ý£¬Ò»·½ÃæÓë´ó¼Ò½øÐÐһϷÖÏíºÍ½»Á÷¡£·Ñ»°¾Í² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ