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

½â¾ö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


Ïà¹ØÎĵµ£º

SQL ×óÍâÁ¬½Ó£¬ÓÒÍâÁ¬½Ó£¬È«Á¬½Ó£¬ÄÚÁ¬½Ó

 Áª½ÓÌõ¼þ¿ÉÔÚ   from   »ò   WHERE   ×Ó¾äÖÐÖ¸¶¨£¬½¨ÒéÔÚ   from   ×Ó¾äÖÐÖ¸¶¨Áª½ÓÌõ¼þ¡£WHERE   ºÍ   HAVING   ×Ó¾äÒ²¿ÉÒÔ°üº¬ËÑË÷Ìõ¼þ£¬ÒÔ½øÒ»²½É¸Ñ¡Áª½ÓÌõ¼þËùÑ¡µÄÐС£   
   
Áª½Ó¿É·ÖΪÒÔϼ¸Àࣺ      ......

Sql Server·¢ÓʼþÅäÖÃ

¡¡Ç°Ì᣺°²×°sqlserver£¬°²×°outlook£¬outlookÒѾ­ÕýÈ·ÅäÖá£
    £¨1£©ÅäÖÃsqlserverµÄÆô¶¯Óû§ÎªÓòÓû§¡£sqlserverÆô¶¯Ä¬Èϵı¾µØÕË»§£¬±¾µØÕË»§Æô¶¯µÄ·þÎñÊÇÎÞ·¨Íê³ÉÓʼþµÄ·¢ËͽÓÊܹ¦Äܵġ£
     ÅäÖÃÓòÓû§Æô¶¯£º´ò¿ª¿ØÖÆÃæ°åµÄ--¹ÜÀí¹¤¾ß--·þÎñ£¬ÕÒµ½sqlserver·þÎñ£¬²é¿´ÊôÐÔ¡£Ô ......

SQL Server Ë«»úÈȱ¸1(based on log shipping)

        ÈÕÖ¾´«ËÍÊÇSQL SERVER2000ÆóÒµ°æ½øÐÐË«»úÈȱ¸µÄÒ»¸öÖ÷Òª½â¾ö·½°¸£¬ÆäÔ­Àí±È½Ï¼òµ¥£¬ÊµÏÖÒ²±È½Ï·½±ã£¬Ö»ÊÇÓÉÓÚºÍWindowsÖ®¼ä´í×Û¸´ÔӵĹØϵ£¬µ¼ÖÂÉèÖÃÆðÀ´Óв»ÉÙÀ§ÄÑ£¬³öÏÖÎÊÌâÒ²²»ÈÝÒ×Õï¶Ï¡£
1.ʵÏÖ¸ÅÊö
 *Ë«»úÈȱ¸Õë¶ÔµÄÊǾßÌåµÄij¸öÊý¾Ý¿â¶ø²»ÊÇÕû¸ö·þÎñÆ÷
 Ë«» ......

ʹÓÃOracleµÄDBMS_SQL°üÖ´Ðж¯Ì¬SQLÓï¾ä

 ÔÚijЩ³¡ºÏÏ£¬´æ´¢¹ý³Ì»ò´¥·¢Æ÷ÀïµÄSQLÓï¾äÐèÒª¶¯Ì¬Éú³É¡£OracleµÄDBMS_SQL°ü¿ÉÒÔÓÃÀ´Ö´Ðж¯Ì¬SQLÓï¾ä¡£±¾ÎÄͨ¹ýÒ»¸ö¼òµ¥µÄÀý×ÓÀ´Õ¹Ê¾ÈçºÎÀûÓÃDBMS_SQL°üÖ´Ðж¯Ì¬SQLÓï¾ä£º
DECLARE
       v_cursor NUMBER;
       v_stat NUMBER;
  & ......

ÅäÖÃʹÓà SQL ServerÌṩ³ÌÐò ¡£

 ÅäÖÃʹÓà SQL ServerÌṩ³ÌÐò
 <configuration>
  <system.web> <-- ¸ü¸ÄÌṩ³ÌÐòÅäÖ㺠-->
    <membership defaultProvider="AspNetSqlProvider" />
  </system.web>
  <membership> <--ÅäÖÃÌṩ³ÌÐò -->
  <prov ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ