Óû§"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
ÎÊÌâ½â¾ö£¡
Ïà¹ØÎĵµ£º
if exists (select * from dbo.sysobjects where name='SplitStr' )
drop FUNCTION SplitStr
go
CREATE FUNCTION SplitStr (@splitString varchar(8000), @separate varchar(10))
RETURNS @returnTable ......
²éѯnorthwindÊý¾Ý¿âÖÐordersÖеÄ10µ½20Ìõ¼Ç¼
select top 10 * from orders
where orderid > ( select max(orderid) from (select top 10 orderid from orders order by orderid) as t&nbs ......
select case when c.colid=1 then object_name(c.id) else '' end as ±íÃû
,c.name as ×Ö¶ÎÃû
,t.name Êý¾ÝÀàÐÍ
,c.prec as ³¤¶È ......
ÊÂÎñµÄ¹¦ÄÜÔÚsqlserverÖÐÓÉÀ´ÒѾã¬ÒòΪ×î½üÔÚ×öÒ»¸öÊý¾Ýͬ²½·½°¸£¬ËùÒÔÓлú»áÔÙ´ÎÑо¿Ò»ÏÂËüÒÔ¼°¿ìÕյȣ¬·¢ÏÖ»¹ÊÇÓкܶ಻´íµÄ¹¦Äܺ͸ĽøµÄ¡£ÕâÀïÒÔsqlserver2008µÄÊÂÎñ·¢²¼¹¦ÄÜΪÀý£¬¶Ô·¢²¼¶©Ôĵķ½Ê½¼òÒª½éÉÜһϲÙ×÷Á÷³Ì£¬Ò»·½Ãæ×ö¸ö×ܽᱸ·Ý£¬Ò»·½ÃæÓë´ó¼Ò½øÐÐһϷÖÏíºÍ½»Á÷¡£·Ñ»°¾Í² ......
ÍÐÁ˼¸ÌìµÄÄÑÌ⣬ÖÕÓÚ½â¾öÁË¡£ÌØ·ÖÏíÒ»ÏÂ
ÒÔÏÂÊÇÒ»¸ö´æ´¢¹ý³Ì
CREATE PROCEDURE deleteAccountAll
@id int
AS
SET XACT_abort ON
BEGIN DISTRIBUTED TRAN
delete from AccountCapital where accountid = @id
delete from logininfo where username = @id
delete from CapitalRecord where accountid ......