SQLServerÔ¶³Ì·þÎñÆ÷²»´æÔÚ£¬Î´±»Ö¸¶¨ÎªÓÐЧµÄ·¢²¼·þÎñÆ÷£¬»òÄúÎÞȨ²é¿´¿ÉÓõķ¢²¼·þÎñÆ÷

2015-11-21 02:09:10 ¡¤ ×÷Õß: ¡¤ ä¯ÀÀ: 8

´´½¨ÁËÊÂÎñ·¢²¼£¬ÔÚ³õʼ»¯Ê±³öÏÖ´íÎ󣬲鿴Ïà¹Ø´úÀíÐÅÏ¢ÈçÏ£º

ÈÕÖ¾¶ÁÈ¡Æ÷´úÀí´íÎó£º

״̬: 0£¬´úÂë: 20015£¬Îı¾: 'Ô¶³Ì·þÎñÆ÷ "serverName" ²»´æÔÚ£¬Î´±»Ö¸¶¨ÎªÓÐЧµÄ·¢²¼·þÎñÆ÷£¬»òÄúÎÞȨ²é¿´¿ÉÓõķ¢²¼·þÎñÆ÷¡£'¡£
Ô¶³Ì·þÎñÆ÷ "serverName" ²»´æÔÚ£¬Î´±»Ö¸¶¨ÎªÓÐЧµÄ·¢²¼·þÎñÆ÷£¬»òÄúÎÞȨ²é¿´¿ÉÓõķ¢²¼·þÎñÆ÷¡£

¿ìÕÕ´úÀí´íÎó£º

Òì³£ÏûÏ¢: Ô¶³Ì·þÎñÆ÷ "serverName" ²»´æÔÚ£¬Î´±»Ö¸¶¨ÎªÓÐЧµÄ·¢²¼·þÎñÆ÷£¬»òÄúÎÞȨ²é¿´¿ÉÓõķ¢²¼·þÎñÆ÷¡£

ÒÑÒÔÓû§ Óò\Óû§ µÄÉí·ÝÖ´ÐС£ ¸´ÖÆ´úÀíÓöµ½ÎÊÌâ¡£ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄÉÏÒ»¸ö×÷Òµ²½ÖèÀúÊ·¼Ç¼ÏûÏ¢»ò¸´ÖƼàÊÓÆ÷¡£. ¸Ã²½Öèʧ°Ü¡£

ÒÑÒÔÓû§ NT AUTHORITY\NETWORK SERVICE µÄÉí·ÝÖ´ÐС£ ½«½Ø¶Ï×Ö·û´®»ò¶þ½øÖÆÊý¾Ý¡£ [SQLSTATE 22001] (´íÎó 8152). ¸Ã²½Öèʧ°Ü¡£

·Ö·¢´úÀí´íÎó£º

Startup Delay: 1042 (msecs)
ÕýÔÚÁ¬½Óµ½ ·Ö·¢·þÎñÆ÷¡°serverName¡±
´úÀíÏûÏ¢´úÂë 14080¡£ Ô¶³Ì·þÎñÆ÷ "serverName" ²»´æÔÚ£¬Î´±»Ö¸¶¨ÎªÓÐЧµÄ·¢²¼·þÎñÆ÷£¬»òÄúÎÞȨ²é¿´¿ÉÓõķ¢²¼·þÎñÆ÷¡£

ÅäÖÃÓ¦¸Ã²»»á´í£¬´úÀí×÷ÒµËùÓÐÕßÒ²¸ÄΪÁË¡°sa¡± £¬¿ÉÄܾÍÊÇȨÏÞµÄÎÊÌ⣡

½â¾ö·½·¨£º

1. ¸ÃÓû§ Óò\Óû§ ÊÇÖ´ÐдúÀíµÄÓû§£¬ÊÚÓèÓû§·þÎñÆ÷½ÇÉ«£º sysadmin

EXEC master.dbo.sp_addsrvrolemember @loginame = Óò\Óû§', @rolename = N'sysadmin'
GO

2. ÓÒ¼ü·¢²¼ÊôÐÔ£¬µã»÷ ·¢²¼·ÃÎÊÁÐ±í£¬½«¸ÃÓû§Ìí¼Óµ½ÆäÖС£



3. ÖØÐ³õʼ»¯£¬Õý³£ÁË£¡~