å®ç½ä¸è½½
SQL Server Express ä¸è½½
http://msdn.microsoft.com/zh-cn/express/bb410792.aspxå®æ´å®è£
ï¼
ä¸ï¼å®è£
åé
ç½®IIS
sql server 2005éè¦IISçæ¯æï¼å¨âæå¼æå
³éwindowsç»ä»¶âéå¾éä¸Internet ä¿¡æ¯æå¡ï¼å¹¶ä¸å±å¼åå¾éä¸ä»¥ä¸å 个ç»ä»¶ï¼
1ãWeb 管çå·¥å
·IIS 6 管çå
¼å®¹æ§IIS 6 WMI å
¼å®¹æ§
2ãWeb 管çå·¥å
·IIS 6 管çå
¼å®¹æ§IIS 6 å
æ°æ®åºåIIS 6é
ç½®å
¼å®¹æ§
3ãä¸ç»´ç½æå¡åºç¨ç¨åºå¼ååè½Asp.net
4ãä¸ç»´ç½æå¡å¸¸è§Httpåè½Httpéå®å
5ãä¸ç»´ç½æå¡å®å
¨æ§Windows 身份éªè¯
ç¡®å®å¹¶å®è£
IISã
äºãå®è£
æ åçSQL Server 2005
æç
§æ示å®è£
å³å¯
ä¸ãå®è£
SQL Server 2005 SP3
å®è£
å®sql server 2005åï¼æ们ç»å½sql æ¶åï¼å¯è½åç°ç»å½ä¸äºï¼æ示18456 login error,æ们çadministrator ä¸åææéç»å½sql server.è¿æ¯å°±éè¦ä»å¾®è½¯å®ç½ä¸ä¸è½½sql server 2005 SP3并å®è£
å°çµèä¸ã
åãå¯ç¨ SQL Server Browser æå¡
åå»âå¼å§âï¼ä¾æ¬¡æåâç¨åºâãâMicrosoft SQL Server 2005âåâé
置工å
·âï¼ç¶ååå»âSQL Server å¤å´åºç¨é
ç½®å¨âã
å¨âSQL Server 2005 å¤å´åºç¨é
ç½®å¨â页ä¸ï¼åå»âæå¡åè¿æ¥çå¤å´åºç¨é
ç½®å¨âã
å¨âæå¡åè¿æ¥çå¤å´åºç¨é
ç½®å¨â页ä¸ï¼åå»âSQL Server Browserâï¼å¨âå¯å¨ç±»åâä¸åå»âèªå¨âé项ï¼ç¶ååå»âåºç¨âã
äºã å建é²ç«å¢ä¾å¤
æå¼ Windows é²ç«å¢ï¼è¯·åå»âå¼å§âï¼ååå»âè¿è¡âï¼é®å
¥ firewall.cplï¼ç¶ååå»âç¡®å®âã
ç¶åå¨ Windows é²ç«å¢ä¸ä¸º SQL Server 2005 åSQL Server Browser æå¡å建ä¾å¤ã
å
ãé
ç½®SQLServer2005 è¿ç¨è¿æ¥
1ï¼SQL Server Configuration Manager -> SQL Server 2005 Services å° SQL Server Browser 设置为 runningï¼
å¦æ没æEnableçè¯ï¼å³é®Properties -> Service -> StartMode = Auotomatic
注æï¼åæ¶å¿
é¡»æå¼SQL Server Browser æå¡
2ï¼ SQL Server 2005 Network Configuration -> Protocols for SQLXPRESS ä¸åæ¶ä½¿ç¨TCP/IPånamed pipes
3ï¼SQL Native Client Configuration ä¸åæ¶ä½¿ç¨TCP/IPånamed pipes
4ãç»éæ¹ä¸ºæ··å模å¼:
æå¼manage管çå¨->以windowsæ¹å¼è¿æ¥å¹¶è¿å
¥æ°æ®åº->å³é®ç¹å»ä½ çæ°æ®æå¡å¨->å±æ§ ->security>éä¸Sql server and windows Authentication
5ãæ°å»ºSQL serveræ¹å¼çç¨æ·ååå¯ç :
manage管çå¨ -> security -> å³é®ç¹å»logins->new loginâ¦-> éä¸sql server authentication ->设置login name åpassword(confirm password)以å é»è®¤çæ°æ®åº
æ好å»æâenforce password expirationâåçå°é©ï¼å¦åæ¯æ¬¡ç»éé½è¦ä¿®æ¹å¯ç ã
注æ ï¼ ä¸å®è¦å¨User Mapping 页é¢ä¸éæ©è¯¥ç¨æ·å¯¹åºçæ°æ®åº(å³ä½¿åé¢å·²ç»éæ©äºé»è®¤æ°æ®åº)ï¼å¦åè¿æ¯ä¼ç»å½ä¸ä¸
å¦æéè¦ä¿®æ¹æ°æ®åºï¼å¿
é¡»åé
db_Owner è§è²
6ãéæ°å¯å¨æå¡å¨
è½ç¶ç½ä¸å¥½å¤æç« é½è¯´åªéè¦éæ°å¯å¨SQLæå¡å°±å¯ä»¥ï¼ä½æ¯ç»è¿éªè¯ï¼å¿
é¡»éæ°å¯å¨æºå¨æè¡
In order to get things to work. You might need to completely reboot the server machine after making the changes. There have been reports (thanks P.C.) that starting and stopping the SQL Server and Browser software is not enough.
7ã使ç¨SQL Server Configuration Manager æµè¯
注æ ï¼ Server Name ä¸å®è¦ SereverSQLEXPRESS
åæ¶è¿è¦å¨ Options -> Network protocol ä¸éæ©TCP/IPæè½é¡ºå©ç»å½
http://blog.csdn.net/cxin917/archive/2010/05/02/5549935.aspxå¸æå¯¹ä½ è½ææ帮å©ã