ªãºãäëèéí ñàíòàé õîëáîõ
Friday, March 20, 2009
Thursday, March 19, 2009
ASP.NET ëåêö ¹6
IIS áóþó Internet Information Services èéí òóõàé
Ýíý IIS áóþó Internet Information Service íü Microsoft êîìïàíè á¿òýýñýí Microsoft Windows ñåðâåð äýýð èíòåðíýòýä ñóóðèëñàí ¿éë÷èëãýý ¿ç¿¿ëäýã âýá ñåðâåð þì. Ýíýõ¿¿ ñåðâåð íü õýðýãëýýãýýðýý äýëõèéä õî¸ðäóãààð îðäîã áºãººä íýãä¿ðýýð áàéðàíä Apache HTTP ñåðâåð îðäîã. 2008 îíû 11 ñàðûí áàéäëààð íèéò âýáèéí 34.49 õóâü íü òóõàéí ñåðâåðèéã àøèãëàñàí áàéíà. Òóñ ñåðâåð íü FTP, FTPS, SMTP, NNTP áîëîí HTTP, HTTPS àãóóëñàí áàéäàã.
Õóâèëáàðóóä
• IIS 1.0, Windows NT 3.51
• IIS 2.0, Windows NT 4.0
• IIS 3.0, Windows NT 4.0 Service Pack 3
• IIS 4.0, Windows NT 4.0 Option Pack
• IIS 5.0, Windows 2000
• IIS 5.1, Windows XP Professional, Windows XP Media Center Edition
• IIS 6.0, Windows Server 2003 áà Windows XP Professional x64 Edition
• IIS 7.0, Windows Server 2008 áà Windows Vista (Business, Enterprise, Ultimate Editions)
• IIS 7.5, Windows Server 2008 R2 (Beta) and Windows 7 (Beta)
Ò¿¿õýí çàìíàë
Microsoft èéí àíõíû âýá ñåðâåðèéí øèíæèëãýý ñóäëàãààíû òºñëèéã Scotland äàõü Edingburgh – èéí Èõ Ñóðãóóëèéí Åâðîïûí Microsoft Windows NT академийн òºâ õýðýãæ¿¿ëñýí. Èéíõ¿¿ Windows NT 3.51 õóâèëáàðààñ ýõëýí Internet Information Services – èéã íýìýëò áîëãîí ñóóëãàõ áîëîìæòîé áîëñîí. IIS 3.0 îîñ ýõëýí Active Server Pages äèíàìèê ñêðèïò ãàðñàí.
Microsoft âýá ïëàòôîðì
Microsoft âýá ïëàòôîðì ñóóëãàõ íü ìàø õÿëáàð äàðààõ ç¿éëñèéã àãóóëíà:
• IIS
• Visual Web Developer 2008 Express Edition
• SQL Server 2008 Express Edition
• Microsoft .NET Framework
• Silverlight Tools for Visual Studio
Òóñ âýá ïëàòïîðìûã äýìæèõ ¿éëäëèéí ñèñòåì¿¿ä: Windows Vista RTM, Windows Vista SP1, Windows XP, Windows Server 2003, Windows Server 2008 Supported Architectures: x86 and 64-bit
Ñóóëãàõ áîëîí àøèãëàõ
Start --> Settings --> Control Panel --> Add or Remove Programs --> Add/Remove Windows Components
"Internet Information Services (IIS)" ãýñýí ñîíãîëòûã ñîíãî.
“Next” òîâ÷ äàðàõàä Insert CD ãýñýí ìýäýýëýë ãàðíà. Ýíý ¿åä òà XP ¿éëäëèéí ñèñòåìòýé CD ãýý CD-ROM íäîî õèéãýýä OK äàðñíààð ñóóëãàæ ýõýëíý. Çà îäîî áèäíèé ñóóëãàñàí ç¿éë ìààíü àæèëëàæ áàéãàà ýñýõèéã øàëãàÿ. Start --> Run --> Type in "cmd" DOS êîìàíä õýñýãò “netstat -a” ãýæ áè÷ýýä ENTER òîâ÷ äàð. Ftp, smtp, http, áîëîí HTTPS ã áýëýí áóþó active ãýñýí ìýäýýëýë ãàðíà. Îäîî âýá ñåðâåðèéí àæèëëàæ áàéãàà ýñýõèéã øàëãàÿ. ªºðèéí àøèãëàäàã âýá áðîóçåðýý /Firefox, IE-Internet Explorer / íýýãýýä Address õýñýãò http://localhost/localstart.asp ãýæ áè÷ýýä ENTER äàð.
ªºð áóñàä íýìýëò òîõèðãîî õèéõ øààðäëàãàòàé.
Start -> Settings -> Control Panel -> Administrative Tools -> Internet Information Services
Òà ººðèéí êîìïüþòåð íýð äýýð äàðàõàä âýá ñàéòóóä õàðàãäàíà. Òà çàðìûã íü /web, FTP, SMTP/ áàðóóí òîâ÷îî äàðæ ò¿ð çîãñîîæ, çîãñîîæ áîëíî. Âýá ñàéòóóäûí ¿íäñýí òîõèðãîî áîëîí øèíæ ÷àíàðóóäûã ººð÷ëºõ人 “Default Web Site” äýýð áàðóóí òîâ÷îî äàðààä Properties ñîíãîëòûã ñîíãî.
Web Site öýñ
• Description – òàéëáàð
• IP Address – òàíû êîìïüþòåðèéí IP õàÿã
• TCP Port – ýíý ñóóëãàñíû äàðàà 80 áàéõ áà õýðâýý òà øààðäëàãàòàé áîë ººð÷èëæ áîëíî. Õýðýâ òà 8080 áîëãîæ ººð÷èëñºí áîë http://localhost:8080/myweb ãýæ àøèãëàíà.
• Connections - õîëáîëòûí õ¿ëýýëãèéí õóãàöàà òóõàéí õóãàöààíä õîëáîëò õèéãäýíý.
• Enable logging – ýíý âýá ñàéòûí õàíäàëòûí á¿ðòãýë õèéæ ýñýõèéã áîëîí òóõàéí á¿ðòãýëèéã ÿìàð òºðëèéí ôàéëààð õàäãàëàõ òîõèðãîî
Home Directory öýñ
• Local Path – Ýíý íü òàíû âýá ñàéòûí êîäûí áàéðëàëûã çààæ ºãíº.
• Write – òóõàéí êîä õýñãèéí õàâòàñàíä áè÷èëò õèéõ áóþó ôàéë õóóëàõ ººð÷ëºëò õèé áîëîõ ýñýõ
• Directory Browsing – Òóõàéí âýáèéí êîäûí õàâòàñóóä ðóó õàíäàæ áîëîõ ýñýõ
Documents öýñ
Ýíý öýñýíä âýá ñàéòûã äóóäàõàä ýõýëæ äóóäàãäàõ ôàéëûã á¿ðòãýõ õýñýã
Server Extensions öýñ
The FTP service. In Internet Information Services, click on "FTP Sites" to see the status of your FTP server. Default FTP Site äýýð áàðóóí òîâ÷îî äàðààä Properties ñîíãîëòûã ñîíãî.
FTP Site öýñ
• Description – íýðèéã äóðûí íýðýý𠺺ð÷èëíº.
• IP Address – òàíû êîìïüþòåðèéí IP õàÿã
• TCP Port -
• Connections - õîëáîëòûí õ¿ëýýëãèéí õóãàöàà õàìãèéí èõäýý 10 õîëáîëò õèéãäýíý.
• Log Files –
• Current Sessions – æàãñààëòàí äàõ õ¿ì¿¿ñ âýá ñàéòàíä çî÷ëîõ
Security Accounts öýñ
• Allow Anonymous Connections – This depend on what you want to do with your FTP server.
• Username - This is the account name that is given to the ftp user. It takes the form "IUSR_(your computer name)". Do not delete this account in your control panel otherwise people will not be able to use any of your Internet Services.
• FTP Site Operators - Controls who gets to administer your FTP site.
Tab: Messages
• Welcome: Type in your greeting or leave it blank.
• Exit: Same as Welcome
• Maximum connections: Insert any number less than 10 since you're capped at 10. If you have 10 ftp connections, that means that nobody will be able to visit your website since the ftp and web both share 10 connections together.
Tab: Home Directory
• Local path: This you can change. Actually it makes more sense to make the root FTP directory one level up from your website since you will probably administer your website using FTP.
The SMTP service. In Internet Information Services, click on "Default SMTP Virtual Server" to see the status of your FTP server.
Email! Before the email will work correctly, we must setup a few things.
Click on "Default SMTP Virtual Server" and then click on "Domains". Right click on "Domains" and select "New" -> "Domain"
A wizard pops up and then you should click on "Alias" then "Next".
Type in the domain name that the email server should respond to. In my case, it's "dslwebserver.com". Click "Finish".
Right click on "Default SMTP Virtual Server" then select "Properties". Most of these functions depend on what your needs are. You can simply experiment with the settings and keep sending email to yourself to see if the changes work for you.
Tab: Access
• You may have to play with the "Relay" settings to allow computers on your network to use the SMTP server to relay mail out. Make sure you check these settings carefully since you don't want to be an open relay for spam.
Ýíý IIS áóþó Internet Information Service íü Microsoft êîìïàíè á¿òýýñýí Microsoft Windows ñåðâåð äýýð èíòåðíýòýä ñóóðèëñàí ¿éë÷èëãýý ¿ç¿¿ëäýã âýá ñåðâåð þì. Ýíýõ¿¿ ñåðâåð íü õýðýãëýýãýýðýý äýëõèéä õî¸ðäóãààð îðäîã áºãººä íýãä¿ðýýð áàéðàíä Apache HTTP ñåðâåð îðäîã. 2008 îíû 11 ñàðûí áàéäëààð íèéò âýáèéí 34.49 õóâü íü òóõàéí ñåðâåðèéã àøèãëàñàí áàéíà. Òóñ ñåðâåð íü FTP, FTPS, SMTP, NNTP áîëîí HTTP, HTTPS àãóóëñàí áàéäàã.
Õóâèëáàðóóä
• IIS 1.0, Windows NT 3.51
• IIS 2.0, Windows NT 4.0
• IIS 3.0, Windows NT 4.0 Service Pack 3
• IIS 4.0, Windows NT 4.0 Option Pack
• IIS 5.0, Windows 2000
• IIS 5.1, Windows XP Professional, Windows XP Media Center Edition
• IIS 6.0, Windows Server 2003 áà Windows XP Professional x64 Edition
• IIS 7.0, Windows Server 2008 áà Windows Vista (Business, Enterprise, Ultimate Editions)
• IIS 7.5, Windows Server 2008 R2 (Beta) and Windows 7 (Beta)
Ò¿¿õýí çàìíàë
Microsoft èéí àíõíû âýá ñåðâåðèéí øèíæèëãýý ñóäëàãààíû òºñëèéã Scotland äàõü Edingburgh – èéí Èõ Ñóðãóóëèéí Åâðîïûí Microsoft Windows NT академийн òºâ õýðýãæ¿¿ëñýí. Èéíõ¿¿ Windows NT 3.51 õóâèëáàðààñ ýõëýí Internet Information Services – èéã íýìýëò áîëãîí ñóóëãàõ áîëîìæòîé áîëñîí. IIS 3.0 îîñ ýõëýí Active Server Pages äèíàìèê ñêðèïò ãàðñàí.
Microsoft âýá ïëàòôîðì
Microsoft âýá ïëàòôîðì ñóóëãàõ íü ìàø õÿëáàð äàðààõ ç¿éëñèéã àãóóëíà:
• IIS
• Visual Web Developer 2008 Express Edition
• SQL Server 2008 Express Edition
• Microsoft .NET Framework
• Silverlight Tools for Visual Studio
Òóñ âýá ïëàòïîðìûã äýìæèõ ¿éëäëèéí ñèñòåì¿¿ä: Windows Vista RTM, Windows Vista SP1, Windows XP, Windows Server 2003, Windows Server 2008 Supported Architectures: x86 and 64-bit
Ñóóëãàõ áîëîí àøèãëàõ
Start --> Settings --> Control Panel --> Add or Remove Programs --> Add/Remove Windows Components
"Internet Information Services (IIS)" ãýñýí ñîíãîëòûã ñîíãî.
“Next” òîâ÷ äàðàõàä Insert CD ãýñýí ìýäýýëýë ãàðíà. Ýíý ¿åä òà XP ¿éëäëèéí ñèñòåìòýé CD ãýý CD-ROM íäîî õèéãýýä OK äàðñíààð ñóóëãàæ ýõýëíý. Çà îäîî áèäíèé ñóóëãàñàí ç¿éë ìààíü àæèëëàæ áàéãàà ýñýõèéã øàëãàÿ. Start --> Run --> Type in "cmd" DOS êîìàíä õýñýãò “netstat -a” ãýæ áè÷ýýä ENTER òîâ÷ äàð. Ftp, smtp, http, áîëîí HTTPS ã áýëýí áóþó active ãýñýí ìýäýýëýë ãàðíà. Îäîî âýá ñåðâåðèéí àæèëëàæ áàéãàà ýñýõèéã øàëãàÿ. ªºðèéí àøèãëàäàã âýá áðîóçåðýý /Firefox, IE-Internet Explorer / íýýãýýä Address õýñýãò http://localhost/localstart.asp ãýæ áè÷ýýä ENTER äàð.
ªºð áóñàä íýìýëò òîõèðãîî õèéõ øààðäëàãàòàé.
Start -> Settings -> Control Panel -> Administrative Tools -> Internet Information Services
Òà ººðèéí êîìïüþòåð íýð äýýð äàðàõàä âýá ñàéòóóä õàðàãäàíà. Òà çàðìûã íü /web, FTP, SMTP/ áàðóóí òîâ÷îî äàðæ ò¿ð çîãñîîæ, çîãñîîæ áîëíî. Âýá ñàéòóóäûí ¿íäñýí òîõèðãîî áîëîí øèíæ ÷àíàðóóäûã ººð÷ëºõ人 “Default Web Site” äýýð áàðóóí òîâ÷îî äàðààä Properties ñîíãîëòûã ñîíãî.
Web Site öýñ
• Description – òàéëáàð
• IP Address – òàíû êîìïüþòåðèéí IP õàÿã
• TCP Port – ýíý ñóóëãàñíû äàðàà 80 áàéõ áà õýðâýý òà øààðäëàãàòàé áîë ººð÷èëæ áîëíî. Õýðýâ òà 8080 áîëãîæ ººð÷èëñºí áîë http://localhost:8080/myweb ãýæ àøèãëàíà.
• Connections - õîëáîëòûí õ¿ëýýëãèéí õóãàöàà òóõàéí õóãàöààíä õîëáîëò õèéãäýíý.
• Enable logging – ýíý âýá ñàéòûí õàíäàëòûí á¿ðòãýë õèéæ ýñýõèéã áîëîí òóõàéí á¿ðòãýëèéã ÿìàð òºðëèéí ôàéëààð õàäãàëàõ òîõèðãîî
Home Directory öýñ
• Local Path – Ýíý íü òàíû âýá ñàéòûí êîäûí áàéðëàëûã çààæ ºãíº.
• Write – òóõàéí êîä õýñãèéí õàâòàñàíä áè÷èëò õèéõ áóþó ôàéë õóóëàõ ººð÷ëºëò õèé áîëîõ ýñýõ
• Directory Browsing – Òóõàéí âýáèéí êîäûí õàâòàñóóä ðóó õàíäàæ áîëîõ ýñýõ
Documents öýñ
Ýíý öýñýíä âýá ñàéòûã äóóäàõàä ýõýëæ äóóäàãäàõ ôàéëûã á¿ðòãýõ õýñýã
Server Extensions öýñ
The FTP service. In Internet Information Services, click on "FTP Sites" to see the status of your FTP server. Default FTP Site äýýð áàðóóí òîâ÷îî äàðààä Properties ñîíãîëòûã ñîíãî.
FTP Site öýñ
• Description – íýðèéã äóðûí íýðýý𠺺ð÷èëíº.
• IP Address – òàíû êîìïüþòåðèéí IP õàÿã
• TCP Port -
• Connections - õîëáîëòûí õ¿ëýýëãèéí õóãàöàà õàìãèéí èõäýý 10 õîëáîëò õèéãäýíý.
• Log Files –
• Current Sessions – æàãñààëòàí äàõ õ¿ì¿¿ñ âýá ñàéòàíä çî÷ëîõ
Security Accounts öýñ
• Allow Anonymous Connections – This depend on what you want to do with your FTP server.
• Username - This is the account name that is given to the ftp user. It takes the form "IUSR_(your computer name)". Do not delete this account in your control panel otherwise people will not be able to use any of your Internet Services.
• FTP Site Operators - Controls who gets to administer your FTP site.
Tab: Messages
• Welcome: Type in your greeting or leave it blank.
• Exit: Same as Welcome
• Maximum connections: Insert any number less than 10 since you're capped at 10. If you have 10 ftp connections, that means that nobody will be able to visit your website since the ftp and web both share 10 connections together.
Tab: Home Directory
• Local path: This you can change. Actually it makes more sense to make the root FTP directory one level up from your website since you will probably administer your website using FTP.
The SMTP service. In Internet Information Services, click on "Default SMTP Virtual Server" to see the status of your FTP server.
Email! Before the email will work correctly, we must setup a few things.
Click on "Default SMTP Virtual Server" and then click on "Domains". Right click on "Domains" and select "New" -> "Domain"
A wizard pops up and then you should click on "Alias" then "Next".
Type in the domain name that the email server should respond to. In my case, it's "dslwebserver.com". Click "Finish".
Right click on "Default SMTP Virtual Server" then select "Properties". Most of these functions depend on what your needs are. You can simply experiment with the settings and keep sending email to yourself to see if the changes work for you.
Tab: Access
• You may have to play with the "Relay" settings to allow computers on your network to use the SMTP server to relay mail out. Make sure you check these settings carefully since you don't want to be an open relay for spam.
ASP.NET ëåêö ¹5
ASP.NET õóóäñûã ºãºãäëèéí ñàíòàé õîëáîõ
ªãºãäëèéí ñàí ãýæ þó âý?
ßìàð íýãýí õýðýãòýé ìýäýýëë¿¿äèéí ýìõ öýãöòýé öóãëóóëãûã ºãºãäëèéí ñàí ãýíý. Ìýäýýëëèéí ñàí, ºãºãäëèéí ñàí ãýäýã íü íýã îéëãîëò þì. Öààøèä áèä Database ãýæ íýðëýõ áà õ¿íèé íººöèéí ºãºãäëèéí ñàíã øèæýý áîëãîí àøèãëàíà.
SQL Server 2000 ãýæ þó âý?
SQL Server 2000 ãýäýã íü òºðºë á¿ðèéí ºãºãäëèéí ñàíãèéí á¿òöèéã òîäîðõîéëîõ, ¿¿ñãýõ, áîëîâñðóóëàõàä àøèãëàãääàã õàìãèéí õ¿÷èðõýã ïðîãðàìóóäûí íýã þì. SQL Server 2000 ïðîãðàì íü PHP, Delphi, Visual Basic, Dot net çýðýã ïðîãðàìóóäûí òóñëàìæòàéãààð ìýäýýëýëòýé õóðäàí øóóðõàé, õÿëáàð õàðüöàõ áîëîìæèéã îëãîäîã.
SQL Server 2000 – èéí îíöëîã äàâóó òàë
• Òîìîîõîí õýìæýýíèé ºãºãäëèéí ñàíã çîõèîí áàéãóóëäàã.
• Òºðºë á¿ðèéí ºãºãäëèéí ñàí, ôàéëòàé õàìòàð÷ àæèëëàäàã.
• Ýíãèéíýýñ áîëîí ºíäºð ò¿âøíèé á¿õ õýðýãëýã÷äýä çîðèóëñàí àøèãëàõàä õÿëáàð.
• Õýðýãëýã÷èéí íóóöëàë õàìãààëàëòûã äýýä çýðãýýð õàíãàäàã.
• Microsoft – èéí á¿òýýãäýõ¿¿í ó÷ðààñ áóñàä ïðîãðàìóóäòàé á¿õ òàëààðàà çîõèöîæ àæèëëàäàã.
• Èæèë òºðëèéí ºãºãäëèéí ñàíãèéí ïðîãðàìóóäààñ äýëõèé íèéòýýðýý õàìãèéí ò¿ãýýìýë àøèãëàäàã.
• Èíòåðíýòòýé õîëáîãäîí àæèëëàõ áîëîìæóóä äàâóó áàéäàã.
SQL Server 2000 Install õèéõ
1. Òåõíèê õàíãàìæèéí øààðäëàãà : SQL Server 2000 ïðîãðàìûã êîìïüþòåð äýýðýý ñóóëãàõàä òàíû êîìïüþòåð äîîðõè øàëãóóðûã õàíãàñàí áàéõ ¸ñòîé. SQL Server 2000 ïðîãðàìûã àëü áîëîõ ºíäºð ¿ç¿¿ëýëòòýé êîìïüþòåð äýýð ñóóëãàæ àøèãëàõûã çºâëºæ áàéíà.
• Processor : Windows NT, Windows 2000, Windows XP çýðýã ¿éëäëèéí ñèñòåì äýýð ñóóëãàõ òîõèîëäîëä õàìãèéí áàãàäàà Intel Pentium 166mhz áà ò¿¿íýýñ äýýø õóðäòàé áàéõ ¸ñòîé. Áóñàä ¿éëäëèéí ñèñòåì äýý𠺺ð áàéäàã.
• Memory : SQL Server Standard Edition, SQL Personal Edition õóâèëáàð íü õàìãèéí áàãàäàà 64ÌÂ RAM øààðääàã áîë SQL Server Enterprise Edition õóâèëáàð íü 124ÌÂ RAM øààðäääàã.
• Hard disk :
Äýýðõ çàé íü çºâõºí ïðîãðàì ñóóëãàõàä øààðäëàãàòàé çàé. Äýýð íü òàíû ºãºãäëèéí ñàíãèéí õýìæýýíýýñ õàìààð÷ äèñêýíä íýìýëò çàé õýðýãòýé áîëíî.
2. Ïðîãðàì õàíãàìæèéí øààðäëàãà : SQL Server – èéí ÿìàð õóâèëáàð ñîíãîñíîîñ õàìààð÷ ººð ººð ¿éëäëèéí ñèñòåìä òîõèðîí àæèëëàõ òóë ñóóëãàõààñ ºìíº õóâèëáàð áîëîí ¿éëäëèéí ñèñòåìèéã àíõààðàõ õýðýãòýé.
¯éëäëèéí ñèñòåì, Internet Explorer – îîñ ººð íýìýëò ïðîãðàì õàíãàìæ ñóóëãàëã¿éãýýð àæèëëóóëæ áîëíî.
SQL Server install õèéõ
Äýýðõ òåõíèê áîëîí ïðîãðàì õàíãàìæèéí øààðäëàãóóäûã õàíãàñàí áîë SQL Server ñóóëãàõàä áýëýí ãýñýí ¿ã. SQL Server 2000 Components – Install Database server – Next – Next ãýõ ìýò
ªºðèéí êîìïüþòåð äýýð ñóóëãàõ ¿åä Local Computer ñîíãîëòûã ñîíãîíî. Õàðèí ººð êîìïüþòåð äýýð ñóóëãàõ áîë Remote Computer ñîíãîëòûã ñîíãîíî. Øèíýýð èíñòàëë õèéõ ¿åä Create a new Instance of SQL server, or install Client Tools ñîíãîëòûã ñîíãîõ áºãººä ºìíº íü ñóóëãàñàí èíñòàëëàà çàñàõ, óñòãàõ ¿åä Upgrade, Remove, or add components to an existing instance of SQL server ñîíãîëòûã ñîíãîíî. Advanced options ñîíãîëòûã ñîíãîâîë èíñòàëë ººð÷ëºõ, èíñòàëëä áàéõã¿é áàéãàà ôàéë ¿¿ñãýõ, íýìýëò ôóíêö¿¿äèéã ã¿éýòãýõ áîëîìæ îëãîäîã. Client Tools Only ñîíãîëòûã ñîíãîâîë áóñàä êîìïüþòåð äýýð ñóóëãàñàí SQL Server ð¿¿ õàíäàæ õàðèëöàã÷ áàéäëààð àæèëëàíà. ªºðèéí êîìïüþòåð äýýð ºãºãäëèéí ñàíã ¿¿ñãýæ ÷àäàõã¿é çºâõºí áóñàä ñåðâåðòýé õàìòàð÷ àæèëëàõ áîëíî. Server and Client tools ñîíãîëòûã ñîíãîâîë ººðèéí áîëîí áóñàä ñåðâåðòýé õàìòàð÷ àæèëëàæ ÷àäíà. Connectivity Only ñîíãîëòûã ñîíãîâîë çºâõºí Microsoft Access – èéí áîëîìæóóäûã àøèãëàæ ìºí ñ¿ëæýýíèé îð÷èíä õàíäàëò õèéæ ÷àäíà. Áóñàä ¿éëäë¿¿äèéã ã¿éöýòãýæ ÷àäàõã¿é. ¯¿íèé äàðààãààð ñåðâåðèéí íýð íýõíý. Ñåðâåðèéí íýðèéã 16-í òýìäýãòýíä áàãòààæ ºãíº. ¿¿íä áè÷ñýí íýðýýð áóñàä ñåðâåð¿¿äýýñ õàíäàõ áîëíî. Default óòãûã ñîíãîñîí áîë òóõàéí êîìïüþòåðèéí íýðèéã àâíà.
ªãºãäëèéí ôàéë, ºãºãäëèéí ººð÷ëºëòèéí ôàéëûí çàìûã çààíà. ªãºãäëèéí ôàéëûí çàìûã çààæ ºãºõ人 windows ñóóëãààã¿é òóñäàà äèñêèéã ñîíãîâîë èë¿¿ òîõèðîìæòîé.
Àíõäàã÷ òîõèðóóëãà áîëîõ Use the same account for each service. Auto start SQL server service òîõèðóóëãûã ñîíãîãäñîí áîë SQL Server áîëîí SQL Server Agent õî¸óëàà äîìàéí õýëáýðýýð àæèëëàõààð áàéäàã.
Install øàëãàõ
Install õèéæ äóóññàíû äàðàà SQL server á¿ðýí ñóóñàí ýñýõ, ñèñòåìèéí ºãºãäëèéí ñàíãóóä çºâ ãàçàðò áàéãàà ýñýõ, á¿ðä¿¿ëýã÷, óäèðäàã÷ ïðîãðàìóóä ñóóñàí ýñýõ, çîãñîîõ, ò¿ð çîãñîîæ áîëîõ ýñýõ, ºãºãäëèéí áààçòàé õîëáîãäîæ ýíãèéí query ãàðãàæ áîëîõ ýñýõèéã øàëãàíà. Õýðýâ install õèéõ ÿâöàä ÿìàð íýãýí àëäààíû ìýäýýëýë ãàðààã¿é áîë ñóóëãàõ ÿâöàä îðóóëñàí ìýäýýëëèéí äàãóó ôîëäåð ¿¿ññýí ýñýõèéã Explorer-îîð, Start menu-ä õýðýãòýé Tools áàéãàà ýñýõ, ìºí Control panel-ä òîõèðãîî çºâ ýñýõèéã õàðàõàä áîëíî.
ªãºãäëèéí ñàí ãýæ þó âý?
ßìàð íýãýí õýðýãòýé ìýäýýëë¿¿äèéí ýìõ öýãöòýé öóãëóóëãûã ºãºãäëèéí ñàí ãýíý. Ìýäýýëëèéí ñàí, ºãºãäëèéí ñàí ãýäýã íü íýã îéëãîëò þì. Öààøèä áèä Database ãýæ íýðëýõ áà õ¿íèé íººöèéí ºãºãäëèéí ñàíã øèæýý áîëãîí àøèãëàíà.
SQL Server 2000 ãýæ þó âý?
SQL Server 2000 ãýäýã íü òºðºë á¿ðèéí ºãºãäëèéí ñàíãèéí á¿òöèéã òîäîðõîéëîõ, ¿¿ñãýõ, áîëîâñðóóëàõàä àøèãëàãääàã õàìãèéí õ¿÷èðõýã ïðîãðàìóóäûí íýã þì. SQL Server 2000 ïðîãðàì íü PHP, Delphi, Visual Basic, Dot net çýðýã ïðîãðàìóóäûí òóñëàìæòàéãààð ìýäýýëýëòýé õóðäàí øóóðõàé, õÿëáàð õàðüöàõ áîëîìæèéã îëãîäîã.
SQL Server 2000 – èéí îíöëîã äàâóó òàë
• Òîìîîõîí õýìæýýíèé ºãºãäëèéí ñàíã çîõèîí áàéãóóëäàã.
• Òºðºë á¿ðèéí ºãºãäëèéí ñàí, ôàéëòàé õàìòàð÷ àæèëëàäàã.
• Ýíãèéíýýñ áîëîí ºíäºð ò¿âøíèé á¿õ õýðýãëýã÷äýä çîðèóëñàí àøèãëàõàä õÿëáàð.
• Õýðýãëýã÷èéí íóóöëàë õàìãààëàëòûã äýýä çýðãýýð õàíãàäàã.
• Microsoft – èéí á¿òýýãäýõ¿¿í ó÷ðààñ áóñàä ïðîãðàìóóäòàé á¿õ òàëààðàà çîõèöîæ àæèëëàäàã.
• Èæèë òºðëèéí ºãºãäëèéí ñàíãèéí ïðîãðàìóóäààñ äýëõèé íèéòýýðýý õàìãèéí ò¿ãýýìýë àøèãëàäàã.
• Èíòåðíýòòýé õîëáîãäîí àæèëëàõ áîëîìæóóä äàâóó áàéäàã.
SQL Server 2000 Install õèéõ
1. Òåõíèê õàíãàìæèéí øààðäëàãà : SQL Server 2000 ïðîãðàìûã êîìïüþòåð äýýðýý ñóóëãàõàä òàíû êîìïüþòåð äîîðõè øàëãóóðûã õàíãàñàí áàéõ ¸ñòîé. SQL Server 2000 ïðîãðàìûã àëü áîëîõ ºíäºð ¿ç¿¿ëýëòòýé êîìïüþòåð äýýð ñóóëãàæ àøèãëàõûã çºâëºæ áàéíà.
• Processor : Windows NT, Windows 2000, Windows XP çýðýã ¿éëäëèéí ñèñòåì äýýð ñóóëãàõ òîõèîëäîëä õàìãèéí áàãàäàà Intel Pentium 166mhz áà ò¿¿íýýñ äýýø õóðäòàé áàéõ ¸ñòîé. Áóñàä ¿éëäëèéí ñèñòåì äýý𠺺ð áàéäàã.
• Memory : SQL Server Standard Edition, SQL Personal Edition õóâèëáàð íü õàìãèéí áàãàäàà 64ÌÂ RAM øààðääàã áîë SQL Server Enterprise Edition õóâèëáàð íü 124ÌÂ RAM øààðäääàã.
• Hard disk :
| Ñóóëãàõ òºðºë | Øààðäëàãàòàé çàé |
| Full Installation | 270MB |
| Typical Installation | 250MB |
| Client Tools | 100MB |
| Analysis Services | 30-50MB |
| English Query | 80MB |
Äýýðõ çàé íü çºâõºí ïðîãðàì ñóóëãàõàä øààðäëàãàòàé çàé. Äýýð íü òàíû ºãºãäëèéí ñàíãèéí õýìæýýíýýñ õàìààð÷ äèñêýíä íýìýëò çàé õýðýãòýé áîëíî.
2. Ïðîãðàì õàíãàìæèéí øààðäëàãà : SQL Server – èéí ÿìàð õóâèëáàð ñîíãîñíîîñ õàìààð÷ ººð ººð ¿éëäëèéí ñèñòåìä òîõèðîí àæèëëàõ òóë ñóóëãàõààñ ºìíº õóâèëáàð áîëîí ¿éëäëèéí ñèñòåìèéã àíõààðàõ õýðýãòýé.
| ¯éëäëèéí ñèñòåì /õóâèëáàð/ | Personal edition | Standard edition | Enterprise Edition | Developer edition | Desktop edition | SQL Server 2000 Windows CE Edition |
| Win98 | | | | | | |
| WinNT 4.0 WorkStation | | | | | | |
| WinNT4.0 Server | | | | | | |
| WinNT 4.0 Enterprise edition | | | | | | |
| Win2000 Professional | | | | | | |
| Win2000 Server | | | | | | |
| Win2000 Advanced server | | | | | | |
| Win2000 Data Center Server | | | | | | |
| Windows CE | | | | | | |
¯éëäëèéí ñèñòåì, Internet Explorer – îîñ ººð íýìýëò ïðîãðàì õàíãàìæ ñóóëãàëã¿éãýýð àæèëëóóëæ áîëíî.
SQL Server install õèéõ
Äýýðõ òåõíèê áîëîí ïðîãðàì õàíãàìæèéí øààðäëàãóóäûã õàíãàñàí áîë SQL Server ñóóëãàõàä áýëýí ãýñýí ¿ã. SQL Server 2000 Components – Install Database server – Next – Next ãýõ ìýò
ªºðèéí êîìïüþòåð äýýð ñóóëãàõ ¿åä Local Computer ñîíãîëòûã ñîíãîíî. Õàðèí ººð êîìïüþòåð äýýð ñóóëãàõ áîë Remote Computer ñîíãîëòûã ñîíãîíî. Øèíýýð èíñòàëë õèéõ ¿åä Create a new Instance of SQL server, or install Client Tools ñîíãîëòûã ñîíãîõ áºãººä ºìíº íü ñóóëãàñàí èíñòàëëàà çàñàõ, óñòãàõ ¿åä Upgrade, Remove, or add components to an existing instance of SQL server ñîíãîëòûã ñîíãîíî. Advanced options ñîíãîëòûã ñîíãîâîë èíñòàëë ººð÷ëºõ, èíñòàëëä áàéõã¿é áàéãàà ôàéë ¿¿ñãýõ, íýìýëò ôóíêö¿¿äèéã ã¿éýòãýõ áîëîìæ îëãîäîã. Client Tools Only ñîíãîëòûã ñîíãîâîë áóñàä êîìïüþòåð äýýð ñóóëãàñàí SQL Server ð¿¿ õàíäàæ õàðèëöàã÷ áàéäëààð àæèëëàíà. ªºðèéí êîìïüþòåð äýýð ºãºãäëèéí ñàíã ¿¿ñãýæ ÷àäàõã¿é çºâõºí áóñàä ñåðâåðòýé õàìòàð÷ àæèëëàõ áîëíî. Server and Client tools ñîíãîëòûã ñîíãîâîë ººðèéí áîëîí áóñàä ñåðâåðòýé õàìòàð÷ àæèëëàæ ÷àäíà. Connectivity Only ñîíãîëòûã ñîíãîâîë çºâõºí Microsoft Access – èéí áîëîìæóóäûã àøèãëàæ ìºí ñ¿ëæýýíèé îð÷èíä õàíäàëò õèéæ ÷àäíà. Áóñàä ¿éëäë¿¿äèéã ã¿éöýòãýæ ÷àäàõã¿é. ¯¿íèé äàðààãààð ñåðâåðèéí íýð íýõíý. Ñåðâåðèéí íýðèéã 16-í òýìäýãòýíä áàãòààæ ºãíº. ¿¿íä áè÷ñýí íýðýýð áóñàä ñåðâåð¿¿äýýñ õàíäàõ áîëíî. Default óòãûã ñîíãîñîí áîë òóõàéí êîìïüþòåðèéí íýðèéã àâíà.
ªãºãäëèéí ôàéë, ºãºãäëèéí ººð÷ëºëòèéí ôàéëûí çàìûã çààíà. ªãºãäëèéí ôàéëûí çàìûã çààæ ºãºõ人 windows ñóóëãààã¿é òóñäàà äèñêèéã ñîíãîâîë èë¿¿ òîõèðîìæòîé.
| Ïðîãðàìûí ìîäóëü | Typical | Minimum | Custom |
| ªãºãäëèéí ñàíãèéí ñåðâåð | Áàéãàà | Áàéãàà | Ñîíãîëòîîð |
| Öààøèä ñàéæðóóëàõ áîëîìæ | Áàéãàà | Áàéõã¿é | Ñîíãîëòîîð |
| Replication | Áàéãàà | Áàéãàà | Ñîíãîëòîîð |
| Òåêñò á¿òíýýð õàéõ | Áàéãàà | Áàéõã¿é | Ñîíãîëòîîð |
| Õýðýãëýã÷ óäèðäàõ õýðýãñýë | Áàéãàà | Áàéõã¿é | Áàéõã¿é |
| Õýðýãëýã÷òýé õîëáîãäîõ | Áàéãàà | Áàéãàà | Áàéãàà |
| Online íîì | Áàéãàà | Áàéõã¿é | Ñîíãîëòîîð |
| Development tools | Ǻâõºí debugger õýëáýðýýð | Áàéõã¿é | Tools –èéí ñîíãîëòóóä |
| Æèøýý êîäóóä | Áàéõã¿é | Áàéõã¿é | Æèøýýíèé ñîíãîëòóóä |
| Æèøýýíèé òîõèðóóëãà | Áàéãàà | Áàéãàà | Òîõèðóóëãûí ñîíãîëòóóä |
Install øàëãàõ
Install õèéæ äóóññàíû äàðàà SQL server á¿ðýí ñóóñàí ýñýõ, ñèñòåìèéí ºãºãäëèéí ñàíãóóä çºâ ãàçàðò áàéãàà ýñýõ, á¿ðä¿¿ëýã÷, óäèðäàã÷ ïðîãðàìóóä ñóóñàí ýñýõ, çîãñîîõ, ò¿ð çîãñîîæ áîëîõ ýñýõ, ºãºãäëèéí áààçòàé õîëáîãäîæ ýíãèéí query ãàðãàæ áîëîõ ýñýõèéã øàëãàíà. Õýðýâ install õèéõ ÿâöàä ÿìàð íýãýí àëäààíû ìýäýýëýë ãàðààã¿é áîë ñóóëãàõ ÿâöàä îðóóëñàí ìýäýýëëèéí äàãóó ôîëäåð ¿¿ññýí ýñýõèéã Explorer-îîð, Start menu-ä õýðýãòýé Tools áàéãàà ýñýõ, ìºí Control panel-ä òîõèðãîî çºâ ýñýõèéã õàðàõàä áîëíî.
Subscribe to:
Posts (Atom)