SQL SERVER 2005 °²×°´íÎó½â¾öÁË~
½ñÌìÔÚһ̨Ðé»úÉϰ²×° sql server 2005£¬¾ÓÈ»±¨1´íÁË£¨ÎÞÓïÁË£¬×°Õâ¸ö¶«Î÷¶¼Åª²»ºÃ%>_<%£©¿ªÊ¼ÒÔΪÊÇÒòΪADÓòµÄÔÒò£¬ºóÀ´É¾µôÓòÓÖÖØ½¨Óò£¬È»ºóÔÙ×°£¬ÓÖ±¨2´í£¬ÓÚÊÇÎʱðÈËËÑË÷µÈµÈ£¬ÕÒµ½ÔÒòËµÒªÖØÐÂ×¢²áinstaller£¬×îÖÕ°²×°³É¹¦ÁË£¬º¦ÎÒ¼Ó°à۵쬏ßÐ˵ÄÊǰ²×°ºÃÀ²£¬¿ÉÊÇÎÒûÓÐŪÃ÷°×µ½µ×ÊÇɶÔÒòµ¼ÖÂsql°²×°²»ÁËÄØ£¿£¿£¿£¿
1´í£º
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup was unable add user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005DTSUser$PCITC5-29.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29512&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroupMember%40Do_sqlGroupMember%40x56c
------------------------------
BUTTONS:
&Retry
Cancel
------------------------------
²éµ½µÄ
½â¾ö·½·¨1£º
Ò»¿ªÊ¼ÔÚ×°database serviceʱÌáʾ"SQL Server Setup was unable add user NT AUTHORITY\SYSTEM to local group SQLServer2005MSFTEUser$RICHIE$SQL2K5"£¬²éÁËÒ»ÏÂSQLServer2005MSFTEUser$RICHIE$SQL2K5Õâ¸ö×é¸ù±¾¾ÍûÓд´½¨£¬ÓÚÊÇÊÖ¹¤´´½¨×飬°ÑSYSTEMÕʺżӽøÈ¥£¬ÖØÐ°²×°Ê±Õâ¸ö²½Öèµ¹ÊǹýÈ¥ÁË£¬ËæºóÊÇÁíÍâһϵÁÐµÄÆäËüÎÊÌâÁË£¬ÌáʾºÃÏñÊǶÔʲôÎļþûÓÐȨÏÞ²Ù×÷£¬ÎÞÂÛÔõôÉèÖÃÎļþ¡¢Ä¿Â¼µÄ°²È«ÐÔÎÞ¼ÃÓÚÊ¡£
½â¾ö·½·¨2£º
created SQLServer2005MSFTEUser$SANORAYA$MSSQLSERVER local group and added local account to the group
×îÖÕûÓвÉÈ¡Õâ¸ö¡£¡£¡£ÒòΪÔÚ “¼ÆËã»ú¹ÜÀí”ÖÐÕÒ²»µ½“Óû§ºÍ×é”ÁË¡£¡£¡£
2´í
The Windows Installer Service could not be accessed.This can occur if you are running Windows in
safe mode,or if the Windows Installer is not correctly installde.
²éµ½µÄ
½â¾ö·½·¨£º
http://support.microsoft.com/kb/319624/zh-cn
×îÖÕÖ»ÊÇ Õâô²Ù×÷ÁËһϾÍokÁË£º
µ¥»÷“¿ªÊ¼”£¬µ¥»÷“ÔËÐД£¬¼üÈë MSIEXEC /UNREGISTER£¬È»ºóµ¥»÷“È·¶¨”¡£Õâʱϵͳ¿ÉÄܲ»»áÓÐÈκη´Ó¦£¬¼´Ê¹ÄúµÄ²Ù×÷ÍêÈ«ÕýÈ·¡£
µ¥»÷“¿ªÊ¼”£¬µ¥»÷“ÔËÐД£¬¼üÈë MSIEXEC /REGSERVER£¬È»ºóµ¥»÷“È·¶¨”
Ïà¹ØÎĵµ£º
¡¡Ç°Ì᣺°²×°sqlserver£¬°²×°outlook£¬outlookÒѾÕýÈ·ÅäÖá£
£¨1£©ÅäÖÃsqlserverµÄÆô¶¯Óû§ÎªÓòÓû§¡£sqlserverÆô¶¯Ä¬Èϵı¾µØÕË»§£¬±¾µØÕË»§Æô¶¯µÄ·þÎñÊÇÎÞ·¨Íê³ÉÓʼþµÄ·¢ËͽÓÊܹ¦Äܵġ£
ÅäÖÃÓòÓû§Æô¶¯£º´ò¿ª¿ØÖÆÃæ°åµÄ--¹ÜÀí¹¤¾ß--·þÎñ£¬ÕÒµ½sqlserver·þÎñ£¬²é¿´ÊôÐÔ¡£Ô ......
ÅäÖÃʹÓà SQL ServerÌṩ³ÌÐò
<configuration>
<system.web> <-- ¸ü¸ÄÌṩ³ÌÐòÅäÖ㺠-->
<membership defaultProvider="AspNetSqlProvider" />
</system.web>
<membership> <--ÅäÖÃÌṩ³ÌÐò -->
<prov ......
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 Serve ......
ÔÚPostgreSQL8.1.3ÉÏ¿ÉÒÔwork
1. È¡Êý¾Ý¿â´óС
SELECT pg_size_pretty(pg_database_size('somedatabase')) As fulldbsize
2. È¡±í´óС
SELECT pg_size_pretty(pg_total_relation_size('someschema.sometable')) As fulltblsize, pg_size_pretty(pg_relation_size('someschema.sometable')) As justthetblsize
ÔÌù£º
......