Óû§"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
ÎÊÌâ½â¾ö£¡
Ïà¹ØÎĵµ£º
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Êý¾Ý¿â³õʼ»¯ÁË£¬ÔÚÍøÉÏÕÒÁ˰ëÌì·¢ÏÖÁ˼¸ÆªÌû×Ó£¬ÊÜÒæ·Çdz£¬¼Ç¼ÏÂ
DB2ÖпÉÒÔʹµÃÊý¾Ý¿â»Ø¸´µ½Ö¸¶¨µÄʱ¼äµã£¬SQL ServerÊý¾Ý¿âµÄRecovery ModelΪfull »òÕßBulk copyµÄʱºò£¬ÊÇ¿ÉÒÔ´ÓÈÕÖ¾À´»Ö¸´Êý¾Ý¿âµÄ¡£Êµ¼ÊÉÏÈÕÖ¾ÖмǼµÄÒ»ÌõÒ»ÌõµÄtransact sqlÓï¾ä£¬»Ö¸´Êý¾Ý¿âµÄʱºò»áredoÕâЩsqlÓï¾ä¡£&nb ......
Ë÷ÒýµÄ´´½¨¼°Ê¹ÓÃ(sqlserver 2005)
Ϊָ¶¨±í»òÊÓͼ´´½¨¹ØÏµË÷Òý£¬»òΪָ¶¨±í´´½¨ XML Ë÷Òý¡£¿ÉÔÚÏò±íÖÐÌîÈëÊý¾Ýǰ´´½¨Ë÷Òý¡£¿Éͨ¹ýÖ¸¶¨ÏÞ¶¨µÄÊý¾Ý¿âÃû³Æ£¬ÎªÁíÒ»¸öÊý¾Ý¿âÖеıí»òÊÓͼ´´½¨Ë÷Òý¡£
Transact-SQL Óï·¨Ô¼¶¨
Óï·¨
Create Relational Index CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] IN ......
ÊÀʶ´Ã÷½ÔѧÎÊ£¬ÈËÇéÁ·´ï¼´ÎÄÕ¡£×öASPʱ£¬×î³£ÓõÄÊý¾Ý¿â¼´SqlserverÓëAccessÊý¾Ý¿âĪÊôÁË£¡
µ«Ê¹Óûᾳ£·¢ÏֺܶàSQLÖ´ÐеÄÎÊÌâ¡£ÕâÀïÕûÀí³öÖ®¼äµÄ²îÒ죬×ö¸öÊ®´ó²îÒìµÄ×ܽᡣ
ACCESS½á¹¹¼òµ¥ÈÝÒ×´¦Àí£¬¶øÇÒÒ²ÄÜÂú×ã¶àÊýµÄÍøÕ¾³ÌÐòÒªÇó£¬Ò²ÊdzõѧÕßµÄÊÔÅ£µ¶¡£
ACCESSÊÇСÐÍÊý¾Ý¿â£¬¼ÈÈ»ÊÇСÐ;ÍÓÐËû¸ù±¾µÄ¾ÖÏÞÐÔ£º
......
ÊÂÎñµÄ¹¦ÄÜÔÚsqlserverÖÐÓÉÀ´ÒѾã¬ÒòΪ×î½üÔÚ×öÒ»¸öÊý¾Ýͬ²½·½°¸£¬ËùÒÔÓлú»áÔÙ´ÎÑо¿Ò»ÏÂËüÒÔ¼°¿ìÕյȣ¬·¢ÏÖ»¹ÊÇÓкܶ಻´íµÄ¹¦Äܺ͸ĽøµÄ¡£ÕâÀïÒÔsqlserver2008µÄÊÂÎñ·¢²¼¹¦ÄÜΪÀý£¬¶Ô·¢²¼¶©Ôĵķ½Ê½¼òÒª½éÉÜһϲÙ×÷Á÷³Ì£¬Ò»·½Ãæ×ö¸ö×ܽᱸ·Ý£¬Ò»·½ÃæÓë´ó¼Ò½øÐÐһϷÖÏíºÍ½»Á÷¡£·Ñ»°¾Í² ......