½â¾öSQL Server 1069´íÎó:µÇ¼ʧ°Ü
SQL Server ·þÎñÓÉÓڵǼʧ°Ü¶øÎÞ·¨Æô¶¯
1.Ö¢×´
ÔÚÖØÐÂÆô¶¯ SQL Server¡¢SQL Executive »ò SQL Server Agent ʱ£¬¿ÉÄÜÎÞ·¨Æô¶¯¸Ã·þÎñ£¬²¢ÏÔʾÒÔÏ´íÎóÐÅÏ¢£º
Error 1069:The service did not start due to a logon failure.
»òÕß
´íÎó 1069£ºÓÉÓڵǼʧ°Ü¶øÎÞ·¨Æô¶¯·þÎñ
2.ÔÒò
SQL Server¡¢SQL Agent »ò SQL Server Executive Æô¶¯·þÎñÕÊ»§µÄÃÜÂë²»ÕýÈ·£¬ÒòΪÃÜÂë¿ÉÄÜÒѱ»¸ü¸ÄÁË¡£
3.Ìæ´ú·½·¨
ÈôÒª½â¾ö´ËÎÊÌ⣬ÇëÔÚ SQL Server Ö÷»úµÄ Microsoft SQL Server ·þÎñÕÊ»§ÖмüÈëÕýÈ·µÄÃÜÂë¡£
1) ÈôÒªÔÚ Microsoft Windows 2000 Server ºÍ Microsoft Windows XP ÖиüÕý¸ÃÃÜÂ룬Çë°´ÕÕÏÂÁв½Öè²Ù×÷£º
1.
µ¥»÷¿ªÊ¼
£¬Ö¸ÏòÉèÖÃ
£¬È»ºóµ¥»÷¿ØÖÆÃæ°å
¡£
2.
Ë«»÷¹ÜÀí¹¤¾ß
£¬È»ºóË«»÷·þÎñ
¡£
3.
Ë«»÷ MSSQLSERVER
£¬È»ºóµ¥»÷µÇ¼
Ñ¡Ï¡£
4.
ÔÚÃÜÂëºÍÈ·ÈÏÃÜÂë
Îı¾¿òÖмüÈëÕýÈ·µÄÃÜÂ룬Ȼºóµ¥»÷È·¶¨
¡£
2) ÈôÒªÔÚ Microsoft Windows NT 4.0 ÖиüÕý¸ÃÃÜÂ룬Çë°´ÕÕÏÂÁв½Öè²Ù×÷£º
1.
µ¥»÷¿ªÊ¼
£¬Ö¸ÏòÉèÖÃ
£¬È»ºóµ¥»÷¿ØÖÆÃæ°å
¡£
2.
Ë«»÷·þÎñ
£¬È»ºóË«»÷ MSSQLSERVER
¡£
3.
ÔÚÃÜÂëºÍÈ·ÈÏÃÜÂë
Îı¾¿òÖмüÈëÕýÈ·µÄÃÜÂ룬Ȼºóµ¥»÷È·¶¨
¡£
×¢Ò⣺
ͨ¹ý Services С³ÌÐò¸ü¸Ä¸ÃÃÜÂëʹ SQL Server ¿ÉÒԳɹ¦ÖØÐÂÆô¶¯£»µ«ÊÇ£¬Èç¹û°²×°ÁË Microsoft ËÑË÷£¨È«ÎÄËÑË÷·þÎñ£©£¬ÔòËüÒªÇóͨ¹ý SQL ÆóÒµ¹ÜÀíÆ÷ (SEM) ½øÐÐËæºóµÄÃÜÂë¸ü¸Ä¡£
ÒÔÏÂÒ»½ÚÕª×Ô SQL Server 2000 Áª»úͼÊ飺
“After changing the SQL Server service account
information in Control Panel, you must also change the SQL Server
service account in SQL Server Enterprise Manager.This allows the
service account information for Microsoft Search service to remain
synchronized as well. Important:Although the Microsoft Search
service is always assigned to the local system account, the full-text
search engine tracks the SQL Server service account in
Windows.Full-text search and failover clustering are not available if
Windows password changes are not reset using SQL Server Enterprise
Manager.”
(ÔÚ¿ØÖÆÃæ°åÖиü¸Ä SQL Server ·þÎñÕÊ»§ÐÅÏ¢ºó, Äú»¹±ØÐëÔÚ SQL Server ÆóÒµ¹ÜÀíÆ÷Öиü¸Ä SQL
Server ·þÎñÕÊ»§. ÕâÑù, ÓÃÓÚ Microsoft ËÑË÷·þÎñµÄ·þÎñÕÊ»§ÐÅÏ¢Ò²»á±£³Öͬ²½¡£ÖØҪ˵Ã÷: ¾¡¹Ü½« Microsoft
Ïà¹ØÎĵµ£º
Áª½ÓÌõ¼þ¿ÉÔÚ from »ò WHERE ×Ó¾äÖÐÖ¸¶¨£¬½¨ÒéÔÚ from ×Ó¾äÖÐÖ¸¶¨Áª½ÓÌõ¼þ¡£WHERE ºÍ HAVING ×Ó¾äÒ²¿ÉÒÔ°üº¬ËÑË÷Ìõ¼þ£¬ÒÔ½øÒ»²½É¸Ñ¡Áª½ÓÌõ¼þËùÑ¡µÄÐС£
Áª½Ó¿É·ÖΪÒÔϼ¸Àࣺ   ......
¡¡Ç°Ì᣺°²×°sqlserver£¬°²×°outlook£¬outlookÒѾÕýÈ·ÅäÖá£
£¨1£©ÅäÖÃsqlserverµÄÆô¶¯Óû§ÎªÓòÓû§¡£sqlserverÆô¶¯Ä¬Èϵı¾µØÕË»§£¬±¾µØÕË»§Æô¶¯µÄ·þÎñÊÇÎÞ·¨Íê³ÉÓʼþµÄ·¢ËͽÓÊܹ¦Äܵġ£
ÅäÖÃÓòÓû§Æô¶¯£º´ò¿ª¿ØÖÆÃæ°åµÄ--¹ÜÀí¹¤¾ß--·þÎñ£¬ÕÒµ½sqlserver·þÎñ£¬²é¿´ÊôÐÔ¡£Ô ......
ÈÕÖ¾´«ËÍÊÇSQL SERVER2000ÆóÒµ°æ½øÐÐË«»úÈȱ¸µÄÒ»¸öÖ÷Òª½â¾ö·½°¸£¬ÆäÔÀí±È½Ï¼òµ¥£¬ÊµÏÖÒ²±È½Ï·½±ã£¬Ö»ÊÇÓÉÓÚºÍWindowsÖ®¼ä´í×Û¸´ÔӵĹØϵ£¬µ¼ÖÂÉèÖÃÆðÀ´Óв»ÉÙÀ§ÄÑ£¬³öÏÖÎÊÌâÒ²²»ÈÝÒ×Õï¶Ï¡£
1.ʵÏÖ¸ÅÊö
*Ë«»úÈȱ¸Õë¶ÔµÄÊǾßÌåµÄij¸öÊý¾Ý¿â¶ø²»ÊÇÕû¸ö·þÎñÆ÷
Ë«» ......
ÔÚijЩ³¡ºÏÏ£¬´æ´¢¹ý³Ì»ò´¥·¢Æ÷ÀïµÄSQLÓï¾äÐèÒª¶¯Ì¬Éú³É¡£OracleµÄDBMS_SQL°ü¿ÉÒÔÓÃÀ´Ö´Ðж¯Ì¬SQLÓï¾ä¡£±¾ÎÄͨ¹ýÒ»¸ö¼òµ¥µÄÀý×ÓÀ´Õ¹Ê¾ÈçºÎÀûÓÃDBMS_SQL°üÖ´Ðж¯Ì¬SQLÓï¾ä£º
DECLARE
v_cursor NUMBER;
v_stat NUMBER;
& ......
ÅäÖÃʹÓà SQL ServerÌṩ³ÌÐò
<configuration>
<system.web> <-- ¸ü¸ÄÌṩ³ÌÐòÅäÖ㺠-->
<membership defaultProvider="AspNetSqlProvider" />
</system.web>
<membership> <--ÅäÖÃÌṩ³ÌÐò -->
<prov ......