ESET Smart Security & NOD32 Offline Update - June 6rd 2010
ESET Smart Security & NOD32 Offline Update - June 3rd 2010 (5169) | 50.2MB
Update your NOD32 or ESS without internet connection (32 and 64 bit Compatible).
* Extract to any folder. You should get a folder called "nod_upd" along with the update files inside.
* Move that folder to the C:\. (You should have "c:\nod_upd")
* Open up the NOD32 Control Center by clicking on the system tray icon.
* Open the "Update" screen and click on "Setup"
* In the "Server" dropdown list, choose the last item which should point to C:\nod_upd.
* Click OK to close the update setup window.
* Back at the update screen, click "Update now"
http://ugotfile.com/file/1517266/20100606-5169-n32upd.rar
windows tricks Windows XP Problems, Errors, Updates, Virus Removal, Hacking Tips, Hardware Problems, Software Problems,System Upgrading, Port Numbers, Microsoft 2003 & 2008, Red Hat Server, Fedora 9, Registry Tweaks,Networking Concepts, Blogging Tips, Domains Registration Search Engine Optimization,Softwares.
Sunday, June 6, 2010
Yahoo! Messenger 10.0.0.1270 Final + Mega Skins Pack http://cramit.in/h70ztdy4lnj6
Yahoo! Messenger 10.0.0.1270 Final + Mega Skins Pack | 27 MB
Yahoo! Messenger is a popular advertisement-supported instant messaging client and associated protocol provided by Yahoo!, that allows you to see when friends come online and to send them instant messages.
It also can alert you to new e-mail in your Yahoo Mail or Yahoo Personals accounts, or when you have upcoming events recorded in your Yahoo Calendar. Yahoo Messenger offers firewall support, a standby mode that minimizes the program until an Internet connection is made, the ability to save and print your conversations, and a tabbed interface that provides quick access to your favorite stocks, news, and sports scores.
Yahoo! Messenger is provided free of charge and can be downloaded and used with a generic "Yahoo! ID" which also allows access to other Yahoo! services, such as Yahoo! Mail, where users can be automatically notified when they receive new email.
Yahoo! also offers PC-PC, PC-Phone and Phone-to-PC service, file transfers, webcam hosting, text messaging service, and chat rooms in various categories.
Other features include the ability to create a chat room automatically, stock price alerts, the ability to send messages to friends (even if they're not online when you are), a Quick Compact mode that hides the Messenger tools to maximize your viewing area, Messenger Themes, and voice chat, which allows you to talk for free to anybody else on the Internet. It also includes Launchcast Radio, Yahoo Games, and Yahoo Audibles. Using a Webcam, you can see who you're chatting with or view the Webcam of any Yahoo member who has granted you access.
- Yahoo! Messenger Mega Skins Pack
- A Lil Bit Girly
- Alien.rar
- All American
- Apollo
- Aqua
- Aqua Blue.rar
- Atlanta Falcons.rar
- Baby Blue P ink.zip
- Baby Blue.zip
- Baby Doll
- Baby Doll.zip
- Base Blue.zip
- Base Faces.zip
- Battleship Gray.zip
- Bio Hazard
- Black and White
- Black Widow
- Black Widow 2
- Black.zip
- Blue
- Blue Jeans
- BlueSky
- Bronze
- Budweiser.zip
- Care Bears
- Celadon
- Christmas Wreath.rar
- Classic Christmas.zip
- Coral Blue.rar
- Corona
- Crimson Night
- D-Devil
- December.zip
- Dutch Treat
- ENHigh Tech.rar
- Gel LED (Blue).zip
- Gel LED (Green)
- Google Talk
- Graphite
- Gray&Orange
- Green Bay Packers.rar
- Half Life 2
- Halloween.zip
- Halloweenish
- Halo 2
- Hannelore s Skin
- Heaven.zip
- Hunter Green
- Hunter Green.zip
- Indigo
- iTunes
- iYahoo!
- Jack Daniels.rar
- Longhorns.rar
- M&M s
- MacOS X Tiger
- Mango Italiano
- Maverick Blue
- Mechanized.zip
- Metallic Black
- Old Skool
- OliveXP
- Orange Insanity
- Pepsi.rar
- Pink
- Pink Lilac.zip
- Pipeline
- Pretty in Pink
- Purple Haze.zip
- Purple Passion.zip
- Queeeenz Blue
- Queeeenz Dusty Rose
- Queeeenz Forest
- Queeeenz Purple
- Teck
- The Victorian.zip
- Toe Bee s Dolphins
- Toe Bee s Skins
- Valentine.zip
- Vortex Pink
- Vortex Red
- Windows Media 10.zip
- XBOX 360
- Xminimum
- Xtreme XP (Blue)
- XtremeXP (Blue).rar
- Y! Vista
Install the skins:
if the files are ZIP-ed:
1. Open the .zip file with WinZip.
2. Extract all the files into C:\. Make sure that "Use folder names" is checked. If Yahoo! Messenger is installed on a different hard drive, replace "C:\" with the appropriate drive letter.
3. Select Change Skin... from the Messenger menu.
Download
http://cramit.in/h70ztdy4lnj6
Wednesday, March 10, 2010
Longtion Software AutoRun Pro Enterprise II 4.0.0.59
Longtion Software AutoRun Pro Enterprise II 4.0.0.59
Longtion Software AutoRun Pro Enterprise II 4.0.0.59 | 14.7 MB
AutoRun Pro Enterprise II is a popular design tool for rapid creation of autorun CD browsers and presentations. Offering a simple point-and-click design environment, AutoRun Pro Enterprise II allows anyone, regardless of computer competence and creative ability, to blend texts, images, video and audio into an interactive front-end for CDs and DVDs. In doing this, you can make use of wizards, templates and demos that let you jumpstart your autorun project in minutes. The end result can be compiled as a single executable file and burned onto a CD or DVD disk directly using the built-in CD Burner.
Create your own custom autorun menus, interactive presentations, multimedia applications, and custom software in just minutes. AutoRun Pro Enterprise II features a completely visual drag and drop environment. Simply add content such as buttons, photos and text to your pages and position them using your mouse. Even if you have absolutely no programming experience you'll be able to get started creating your own custom applications in just minutes.
The best in AutoRun Pro Enterprise II is that it has been designed with the ordinary user in mind, the one who doesn’t want to take the time to learn how to use a complicated design tool or hire a designer to do the work. It lets you create and edit a front-end in much the same way as you would design a presentation in Microsoft PowerPoint. Just click, drag, position in the desired area and preview to see whether you have the intended result. In just a few clicks, you can create a main page, a splash screen, an agreement form, a security form and an exit form, plus add the unlimited number of sub pages. Pages can be connected by using transition effects like page fade in, fade out and others. You can elaborate pages by adding buttons, images, simple text, links and many other objects and associate each of them with actions so that end users can interact with and navigate through the front-end content. The front-end can let them open and execute files, print documents, send email, visit web sites, browse CD and more.
AutoRun Pro Enterprise II is a powerful visual tool to create professional autorun (autoplay) interfaces and presentations for your CD/DVDs. It is the easiest way to create, edit professional autorun (autoplay) interface and generate autorun files for CD/DVDs in a WYSIWYG environment, just click, point, place and test (preview). So all is visual, fast, simple. AutoRun Pro is easy to learn, with demos and wizards you can get started in just minutes!
35 Objects: ScrollBox, Panel, TabNotebook, TabSheet, GroupBox, Button, ImageButton, Image, Bevel, SimpleText, ScrollText, Link, Splitter, FadeButton, Label, Text, Shape, Balloon, Note, ListBox, DropDownList, ListView, TreeView, ShellListView, ShellTreeView, TextBox, RichText, Browser, MediaPlayer, FlashPlayer, SlideShow, Edit, UserPassword, CheckBox and RadioButton.
ScrollBox, Panel, TabNotebook, TabSheet, GroupBox are container objects. The container object can serve as a container (parent) for other objects. The parent of an object is the object that contains the object. For example, if a page includes three RadioButton objects in a GroupBox object, the GroupBox object is the parent of the three RadioButton objects, and the RadioButton objects are the child objects of the GroupBox object.
It's fast and easy to use. Anyone can quickly create autorun CD-ROMs within minutes.
Features:
• Display of every registered document (e.g.: TXT, DOC, HTML) via automatic start of the corresponding application.
• Print of every registered document (e.g.: TXT, DOC, HTML) via automatic start of the corresponding application.
• Start any program.
• Start the default browser with document URL.
• Send email.
• Integrated Web browser and internal commands.
• Integrated sound player.
• Integrated RTF (Rich Text) viewer.
• Integrated Media Player.
• Slide Show images (Photo album), more than 100 styles.
• Background color, Gradient color and Transparent Form.
• Background sound.
• Splash screen, splash screen sound.
• Full screen background and logo image.
• License agreement. You can display a license agreement before any files are launched. The user is required to accept the license in order to continue. If the user does not accept the license, then the AutoRun exits.
• Security. You can protect your CD from being started by unlicensed users by requiring users to submit a User Name and Password or an Authentication Code.
• Exit Form. Show information or confirm exit before program exits
• Unlimited Sub Pages.
• Page FadeIn, FadeOut.
• Images include bitmap, icon, JPEG, EMF, WMF, GIF (Static or Animated), PNG images.
• Page template.
• Object template.
• CD Icon and Page icon can be displayed in the title bar.
• Test without burning CD.
• Burn project to CD-R/CD-RW directly with built-in CD Burner.
• Create a single executable file.
• Publish project to new folder.
• Create ISO CD-ROM image file.
• Install Software - You may want to install a default viewer for the files if the user does not have one on his computer. For example, if you are launching a PDF file, you may want to include Adobe Acrobat Reader software on your CD and install it if the user does not already have it installed. You can define one or more files to be installed.
• Create drop down menu bar (main menu), tool bar and status bar for pages like most standard windows to make your page more professional.
• Create popup menu, you can define the pop-up menu that appears when the user clicks on an object or page background with the right mouse button, like mostprofessional applications.
• CD expire date, Specifies an expiration date for the CDs.
• Set object(s) Enable or Disable, Show or Hide Object(s).
• No programming knowledge required.
• No registry entry necessary.
• Runs from CD-ROM without installation.
• No runtime module required.
Home Page -
Longtion Software AutoRun Pro Enterprise II 4.0.0.59 | 14.7 MB
AutoRun Pro Enterprise II is a popular design tool for rapid creation of autorun CD browsers and presentations. Offering a simple point-and-click design environment, AutoRun Pro Enterprise II allows anyone, regardless of computer competence and creative ability, to blend texts, images, video and audio into an interactive front-end for CDs and DVDs. In doing this, you can make use of wizards, templates and demos that let you jumpstart your autorun project in minutes. The end result can be compiled as a single executable file and burned onto a CD or DVD disk directly using the built-in CD Burner.
Create your own custom autorun menus, interactive presentations, multimedia applications, and custom software in just minutes. AutoRun Pro Enterprise II features a completely visual drag and drop environment. Simply add content such as buttons, photos and text to your pages and position them using your mouse. Even if you have absolutely no programming experience you'll be able to get started creating your own custom applications in just minutes.
The best in AutoRun Pro Enterprise II is that it has been designed with the ordinary user in mind, the one who doesn’t want to take the time to learn how to use a complicated design tool or hire a designer to do the work. It lets you create and edit a front-end in much the same way as you would design a presentation in Microsoft PowerPoint. Just click, drag, position in the desired area and preview to see whether you have the intended result. In just a few clicks, you can create a main page, a splash screen, an agreement form, a security form and an exit form, plus add the unlimited number of sub pages. Pages can be connected by using transition effects like page fade in, fade out and others. You can elaborate pages by adding buttons, images, simple text, links and many other objects and associate each of them with actions so that end users can interact with and navigate through the front-end content. The front-end can let them open and execute files, print documents, send email, visit web sites, browse CD and more.
AutoRun Pro Enterprise II is a powerful visual tool to create professional autorun (autoplay) interfaces and presentations for your CD/DVDs. It is the easiest way to create, edit professional autorun (autoplay) interface and generate autorun files for CD/DVDs in a WYSIWYG environment, just click, point, place and test (preview). So all is visual, fast, simple. AutoRun Pro is easy to learn, with demos and wizards you can get started in just minutes!
35 Objects: ScrollBox, Panel, TabNotebook, TabSheet, GroupBox, Button, ImageButton, Image, Bevel, SimpleText, ScrollText, Link, Splitter, FadeButton, Label, Text, Shape, Balloon, Note, ListBox, DropDownList, ListView, TreeView, ShellListView, ShellTreeView, TextBox, RichText, Browser, MediaPlayer, FlashPlayer, SlideShow, Edit, UserPassword, CheckBox and RadioButton.
ScrollBox, Panel, TabNotebook, TabSheet, GroupBox are container objects. The container object can serve as a container (parent) for other objects. The parent of an object is the object that contains the object. For example, if a page includes three RadioButton objects in a GroupBox object, the GroupBox object is the parent of the three RadioButton objects, and the RadioButton objects are the child objects of the GroupBox object.
It's fast and easy to use. Anyone can quickly create autorun CD-ROMs within minutes.
Features:
• Display of every registered document (e.g.: TXT, DOC, HTML) via automatic start of the corresponding application.
• Print of every registered document (e.g.: TXT, DOC, HTML) via automatic start of the corresponding application.
• Start any program.
• Start the default browser with document URL.
• Send email.
• Integrated Web browser and internal commands.
• Integrated sound player.
• Integrated RTF (Rich Text) viewer.
• Integrated Media Player.
• Slide Show images (Photo album), more than 100 styles.
• Background color, Gradient color and Transparent Form.
• Background sound.
• Splash screen, splash screen sound.
• Full screen background and logo image.
• License agreement. You can display a license agreement before any files are launched. The user is required to accept the license in order to continue. If the user does not accept the license, then the AutoRun exits.
• Security. You can protect your CD from being started by unlicensed users by requiring users to submit a User Name and Password or an Authentication Code.
• Exit Form. Show information or confirm exit before program exits
• Unlimited Sub Pages.
• Page FadeIn, FadeOut.
• Images include bitmap, icon, JPEG, EMF, WMF, GIF (Static or Animated), PNG images.
• Page template.
• Object template.
• CD Icon and Page icon can be displayed in the title bar.
• Test without burning CD.
• Burn project to CD-R/CD-RW directly with built-in CD Burner.
• Create a single executable file.
• Publish project to new folder.
• Create ISO CD-ROM image file.
• Install Software - You may want to install a default viewer for the files if the user does not have one on his computer. For example, if you are launching a PDF file, you may want to include Adobe Acrobat Reader software on your CD and install it if the user does not already have it installed. You can define one or more files to be installed.
• Create drop down menu bar (main menu), tool bar and status bar for pages like most standard windows to make your page more professional.
• Create popup menu, you can define the pop-up menu that appears when the user clicks on an object or page background with the right mouse button, like mostprofessional applications.
• CD expire date, Specifies an expiration date for the CDs.
• Set object(s) Enable or Disable, Show or Hide Object(s).
• No programming knowledge required.
• No registry entry necessary.
• Runs from CD-ROM without installation.
• No runtime module required.
Home Page -
Code:
http://www.longtion.com/autorunenterpriseii/autorunpro.htm
Download Links
rapidshare
http://rapidshare.com/files/357049134/AutoRun_Pro_Enterprise_II_v4.0.0.59-spicyforums.com.rar
hotfile
http://hotfile.com/dl/31106072/744f9a6/AutoRun_Pro_Enterprise_II_v4.0.0.59-spicyforums.com.rar.htm
http://rapidshare.com/files/357049134/AutoRun_Pro_Enterprise_II_v4.0.0.59-spicyforums.com.rar
hotfile
http://hotfile.com/dl/31106072/744f9a6/AutoRun_Pro_Enterprise_II_v4.0.0.59-spicyforums.com.rar.htm
Friday, February 26, 2010
JPEG Recovery 4.0
JPEG Recovery is a handy tool to repair corrupted JPEG picture or photo
which is restored by a photo or data recovery software. JPEG Recovery
supports combining 2 JPEG pictures for recovery, just in case the original
picture was split into 2 files by the photo or data recovery software.
Version 4.0 improves detection and handling on corrupted JPEG data and fixes some bugs.
What's new in this version:
Version 4.0 improves detection and handling on corrupted JPEG data and fixes some bugs.
Link to Download
Keygen Download
Software Download
Thursday, February 25, 2010
IndiMail
IndiMail
IndiMail is a mailing solution built using following packages qmail, serialmail, qmailanalog, dotforward, fastforward, mess822, daemontools, ucspi-tcp, Courier IMAP/POP3, Bogofilter - A Bayesian Spam Filter, Fetchmail, other useful utilities (pack, unpack, altermime, ripmime, flash). IndiMail also provides Management of Virtual domains. Lot of the integration has been done by modifying some of the core components. IndiMail works on 32 / 64 bit Unix platforms.
The power of IndiMail lies in the ability to distribute the users across multiple hosts in a non-proprietary, simple way. You can have multiple hosts hosting a domain placed anywhere and tied up by IndiMail. This allows you to migrate seamlessly from a proprietary solution like Lotus Notes or MS Exchange to IndiMail. Just install the proxy IMAP/POP3 and point the MX record to IndiMail.
Though IndiMail uses the power of qmail, it has multiple queues (called a queue collection). The collection allows IndiMail to process a very high incoming rate of mails. The system ids, configuration files used by IndiMail are all configurable through a set of environment variables. This gives the ability of a single installation of IndiMail have a different behavior for each queue, sender, recipient, source host, destination host.
Download
SQLTools for Oracle
SQLTools for Oracle
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of sql utilities. You can use it for dial-up connection and it will work as fast as SQLPlus. It is small and not required an installation so SQLTools will help you anywhere because it is small enough for floppy and available for downloading on the Web. SQLTools is free and probably going to be a public source project.
SQLTools is:- Powerful editor (actually it'll be more powerful in the next release), which supports drag & drop, syntax highlighting, code template expansion, etc. It is possible to find a database object under cursor and get its description. Context sensitive help provides information about the current sql statement.
- SQL console, which is embedded in the editor. It supports DML & DDL statements and provides additional information about database statistics and timing.
- Object Browser is designed for getting any object DDL definition. One of useful features is support group operations, for example, you can select and disable a set of constraints in one operation.
- Extract Schema utility, which loads all objects definition and stores on local disk.
Wednesday, February 24, 2010
IP Multicasting
IP Multicasting is a technique of distributing the data across multiple servers over the WAN. It is simply the delivery of the same data packets to the multiple destinations. It allows the multiple recipients to receive the same data packets from a single source. Multicasting allows the distributed applications to work over the WAN with great performance. It is an excellent alternative for the unicast and broadcast transmissions.
In Multicasting, the information is sent to only the destined recipients. It is like the TV or radio transmission system in which only those terminals receive the information who have tuned themselves to receive it.
It is the bandwidth-conserving technology that reduces the traffic load over the network. The ideal applications that uses the multicast technology includes video conferencing, stock quotes, distance learning, weather updates, video streaming, news and other distributed software applications in the LAN/WAN network. IP multicasting mechanisms depends upon the two protocols i.e. group management protocol and the routing protocols.
Group Management protocols establish the multicast groups and the routing protocols routes the traffic to the destination. Multicast routing protocols makes the distribution tree for the data forwarding in the network. It is an ideal solution for the distribution applications in the TCP/IP based LAN/WAN networks.
Though it has been successful in many businesses but it is not extensively deployed and used by the average users. Special addressing scheme is assigned while implementing the IP multicasting. These addresses are assigned from the Class D i.e. 224.0.0.0 to 239.255.255.255. The typical multicast applications include the following.
Multicasting can be implementing in the following situations.
In Multicasting, the information is sent to only the destined recipients. It is like the TV or radio transmission system in which only those terminals receive the information who have tuned themselves to receive it.
It is the bandwidth-conserving technology that reduces the traffic load over the network. The ideal applications that uses the multicast technology includes video conferencing, stock quotes, distance learning, weather updates, video streaming, news and other distributed software applications in the LAN/WAN network. IP multicasting mechanisms depends upon the two protocols i.e. group management protocol and the routing protocols.
Group Management protocols establish the multicast groups and the routing protocols routes the traffic to the destination. Multicast routing protocols makes the distribution tree for the data forwarding in the network. It is an ideal solution for the distribution applications in the TCP/IP based LAN/WAN networks.
Though it has been successful in many businesses but it is not extensively deployed and used by the average users. Special addressing scheme is assigned while implementing the IP multicasting. These addresses are assigned from the Class D i.e. 224.0.0.0 to 239.255.255.255. The typical multicast applications include the following.
- Video conferencing
- Audio conferencing
- Stock Quotes
- Distributed LAN/WAN Software Applications
- Weather Updates
- Data Conferencing
- Network-based games
- Online Training
- Database replication
Multicasting can be implementing in the following situations.
- For better bandwidth utilization.
- Less Router/Hosts Processing.
- When sending the same data to the multiple receivers is required.
- When the recipient address is unknown.
- When a one-to-many communication systems model is required.
- Enhanced performance.
- Optimized performance.
- One-to-many communication system.
How to Install SQL Server 2008 - A Step by Step Guide
A Step by Step guide to installing SQL Server 2008 simply and successfully with no prior knowledge
Developers and system administrators will find this installation guide useful, as will seasoned DBAs. It will teach you the basics required for a typical, problem-free installation of SQL Server 2008, allowing you to add other components later if you wish. Remember to install the .Net Framework 3.5Before you start the installation, you’ll need to install the .Net 3.5 Framework. This comes pre-installed on Windows 2008 Server, but for earlier versions of Windows, you’ll need to install it first. This is a straightforward pre-requisite and is usually included as part of the SQL Server 2008 installation. However, if you don’t know how to do this, or for some reason you need to download it, check out the guide Installing .Net Framework 3.5 for SQL Server 2008.
Once this Framework in installed you can commence the installation of SQL Server 2008. STEP 1 : Copy the installation filesFirst off I’d recommend you copy the entire directory structure from the SQL Server 2008 installation disc to the C: drive of the machine you are going to install it on.
Although this means you need to grab a cup of coffee whilst it’s copying, this has three advantages:
After a few seconds a dialog box appears: This will disappear from the screen and then the main installation page appears: STEP 3 : SQL Server Installation Center
Click on the Installation hyperlink on the left hand side of the screen: STEP 4 : SQL Server Installation CenterClick on the "New Server stand-alone installation" link on the right side of the screen: The following dialog appears on the screen whilst the install program prepares for installation: After a minute or so (the timing will vary according to your system), the following screen appears: STEP 5 (optional) :
If any checks have failed, click on the Show details button or "View detailed report link" to find out the cause, correct it, then click on the Re-run button to perform the checks again.STEP 6 : Product key
If all checks have passed, click on the OK button. After a few moments, the option to select the edition and to enter the license key (or “product key”) will appear. Note that the product key box may already be populated, depending on which edition you have. Don’t enter the product key we’ve shown here, it won’t work on your system!: STEP 7 : License TermsEnter the product key into the box, or choose the free edition if you're evaluating SQL Server 2008, and click on the Next button:
Click in the "I accept the license terms" check box, then click on the Next button again.STEP 8 : Setup Support Files
The following screen appears; click on the Install button:
The following screen will appear whilst Windows Installer prepares itself for the installation. This will take a short while:
After 30 seconds or so the dialog appears again: STEP 9 : Setup Support Rules
If all is well, the following screen appears:
Click on the Next button again.STEP 10 : Feature Selection
Select the features you want to install.
At a minimum, the following are useful (I'd argue essential), but what you need will depend on your needs:
Click on the Next button.STEP 11 : Instance Configuration
After a short while the following screen appears:
For most installations, keep the default settings.
Click on the Next button.STEP 12 : Disk Space Requirements
This screen just tells you if you have sufficient disk space on the drive you’re installing to, and what’s going to be installed where.
Click on Next.
STEP 13 : Server Configuration
This step allows you to set up the service accounts that will be used to run SQL Server. If you have created Windows NT or Active Directory accounts for use with services, use these.If not, then just to get the installation up and working, use the built-in Network Service account for all three services listed (this account does not require a password).
This allows SQL Server to start up after installation. However, it can be easily changed later to another account through the Services applet (Control Panel -> Administrator Tools -> Services):
In addition, remember to change the Startup Type to Automatic, for all three services. This automatically starts the SQL Server database engine, SQL Agent and SQL Browser services when the server is re-booted.The first service runs the SQL Server database engines executable process. The other two services allow scheduled jobs to run after installation (and after a re-boot), and allow the SQL Server to be found by clients on the network.
Do not worry about changing the collation tab, unless there is a specific requirement for anything other than the default collation sequence. Finally, click on Next.STEP 14 : Database Engine Configuration – Account Provision
This screen allows you to set up database engine security.
Change the Authentication Mode to Mixed Mode unless you are certain you only need Windows-only authentication.
Note that you MUST also provide a Windows NT account on the local machine as a SQL Server administrator. If you do not want Windows system administrators to be able walk up to the box and login to SQL Server, create a new, local, dummy Windows user and add this account instead. Otherwise, add in the local administrator account, or your own Windows account on the domain in which the SQL Server will reside.STEP 15 : Database Engine Configuration – Data Directories
Click on the Data Directories tab.
Change the directories to specify which drives in your system will be used for the various types of database files.Generally it’s advisable to put the User database directory and User log directory on separate physical drives for performance, but it will depend on how Windows has been configured and how many disk drives you have available.
If you are installing on a single drive laptop or desktop, then simply specify:
Do not click on the FILESTREAM tab unless you know you need to change these options, as it is not generally required for most installations, but can easily be changed by using sp_configure 'filestream_access_level', ''after SQL Server has been installed. Click on Next.
STEP 16 : Error Usage ReportingThis screen simply asks if you want to send error information to Microsoft and can safely be skipped if you do not want to share any information.
Click boxes if you want to help Microsoft help you.
Click on Next again…STEP 16 : Installation Rules
This screen simply checks if there are any processes or other installations running which will stop the installation of SQL Server 2008.
Click on Next again – you’re almost ready to install: STEP 17 : Ready to InstallThis screen summarises what you are about to install and gives you a last chance to cancel or change anything that’s wrongly configured: Check that what’s being installed is what you want and then click on Install when you’re sure you want to start the installation process: Installation ProgressSQL Server 2008 will now install. How long it takes depends on the speed of your machine, what load it’s under, the installation media (CD is slower) and what you’ve chosen to install. …More Installation Progress
... and Finally
Finally, the installation will complete:
...and the following dialog box will appear: Click on OK, the machine will NOT reboot.
The following will appear:
…followed by: Click on the Next button again...STEP 18 : Installation Complete
The following screen appears:
It may be worth clicking on the installation log at the top of the screen to check everything’s gone as expected. Not that this is MUCH smaller than the usual SQL Server installation log files of old.Finally, click on the Close button. The following dialog will appear: Click on OK – your server will NOT re-boot at this point.
The dialog box will disappear and you will be returned to the Installation Center: Click on the Close button (the “x”) in the top right of the screen.
Finally, manually reboot your machine to complete the SQL Server 2008 installation.Top Tips :
How to check that SQL Server 2008 has installed correctlyHere are a short number of post-installation checks which are useful to perform after re-booting your new SQL Server. You don’t have to run these, and there are other ways to check, but they are very useful for non-DBAs to be sure that the installation is basically sound and a connection can be made to the new SQL Server before handing it over to someone else. Check 1: Has the SQL Server Service Started?Check SQL Server 2008 has started. Check 2: Does Management Studio Work?
Check Management Studio works by firing it up. Click on NO when you see this dialog box: Check 3: Can you run a basic query against the new SQL Server?Check SQL Server works by running a simple query from Management Studio: Enter the query shown below and hit F5 to run it: Check 4: Is SQL Server Agent Running?
Check SQL Server Agent is running for scheduled jobs. There should be a green arrow next to the SQL Server Agent database symbol (it’s small, you might have to look hard): Check 5: Can SQL Server be seen from the Network?Check that the new SQL Server can be seen from another SQL Server on the same domain by running isql –L (or osql –L):
If you can’t see the new SQL Server in this list, check that the SQL Server Browser service is started on the machine where you have just installed SQL Server.Check 6: Has the TCP/IP network protocol library been enabled on the server?
If the browser service is started but you still cannot connect to the server, click on Start ->Programs -> SQL Server 2008 -> SQL Server Configuration Manager (on the server where SQL Server’s just been installed)
The SQL Server Configuration Manager window opens.
Click on the SQL Server Network Configuration node and expand it.In the example below, we have MSSQLSERVER (a base instance of SQL Server), and SQLEXPRESS showing as installed.
If in doubt, click on Protocols for MSSQLSERVER. In the above screenshot, the TCP/IP network protocol library is disabled. We need to enable it in order that remote servers can talk to the newly installed SQL Server.
If it shows as DISABLED (above), double click on the TCP/IP protocol line, and the following window will appear: Ensure that Enabled is set to Yes, and click on OK.
The following warning will appear:
Click on OK, and you will be returned to the Configuration Manager window, where TCP/IP will now be shown as enabled:
Go back to the Services applet, and re-start the MSSQLSERVER service so that the TCP/IP protocol can be used to connect to your new SQL Server.Then try to connect to it again from a remote machine.
If you have experienced problems with the previous connectivity tests, you should now be able to repeat at least some of them successfully.
Developers and system administrators will find this installation guide useful, as will seasoned DBAs. It will teach you the basics required for a typical, problem-free installation of SQL Server 2008, allowing you to add other components later if you wish. Remember to install the .Net Framework 3.5Before you start the installation, you’ll need to install the .Net 3.5 Framework. This comes pre-installed on Windows 2008 Server, but for earlier versions of Windows, you’ll need to install it first. This is a straightforward pre-requisite and is usually included as part of the SQL Server 2008 installation. However, if you don’t know how to do this, or for some reason you need to download it, check out the guide Installing .Net Framework 3.5 for SQL Server 2008.
Once this Framework in installed you can commence the installation of SQL Server 2008. STEP 1 : Copy the installation filesFirst off I’d recommend you copy the entire directory structure from the SQL Server 2008 installation disc to the C: drive of the machine you are going to install it on.
Although this means you need to grab a cup of coffee whilst it’s copying, this has three advantages:
- It makes the installation process much faster than running it from CD/DVD once it gets started.
- It allows you to easily add or remove components later, without having to hunt around for the CD/DVD.
- If your media is damaged and a file won’t copy, you get to find out now, rather than halfway through the installation.
After a few seconds a dialog box appears: This will disappear from the screen and then the main installation page appears: STEP 3 : SQL Server Installation Center
Click on the Installation hyperlink on the left hand side of the screen: STEP 4 : SQL Server Installation CenterClick on the "New Server stand-alone installation" link on the right side of the screen: The following dialog appears on the screen whilst the install program prepares for installation: After a minute or so (the timing will vary according to your system), the following screen appears: STEP 5 (optional) :
If any checks have failed, click on the Show details button or "View detailed report link" to find out the cause, correct it, then click on the Re-run button to perform the checks again.STEP 6 : Product key
If all checks have passed, click on the OK button. After a few moments, the option to select the edition and to enter the license key (or “product key”) will appear. Note that the product key box may already be populated, depending on which edition you have. Don’t enter the product key we’ve shown here, it won’t work on your system!: STEP 7 : License TermsEnter the product key into the box, or choose the free edition if you're evaluating SQL Server 2008, and click on the Next button:
Click in the "I accept the license terms" check box, then click on the Next button again.STEP 8 : Setup Support Files
The following screen appears; click on the Install button:
The following screen will appear whilst Windows Installer prepares itself for the installation. This will take a short while:
After 30 seconds or so the dialog appears again: STEP 9 : Setup Support Rules
If all is well, the following screen appears:
Click on the Next button again.STEP 10 : Feature Selection
Select the features you want to install.
At a minimum, the following are useful (I'd argue essential), but what you need will depend on your needs:
Click on the Next button.STEP 11 : Instance Configuration
After a short while the following screen appears:
For most installations, keep the default settings.
Click on the Next button.STEP 12 : Disk Space Requirements
This screen just tells you if you have sufficient disk space on the drive you’re installing to, and what’s going to be installed where.
Click on Next.
SQL Server Club Membership Benefits | |||||
Articles written by experienced DBAs and developers | Membership is free forever | ||||
Get your content published - articles, news, blogs, events | No spam - guraranteed! | ||||
|
This step allows you to set up the service accounts that will be used to run SQL Server. If you have created Windows NT or Active Directory accounts for use with services, use these.If not, then just to get the installation up and working, use the built-in Network Service account for all three services listed (this account does not require a password).
This allows SQL Server to start up after installation. However, it can be easily changed later to another account through the Services applet (Control Panel -> Administrator Tools -> Services):
In addition, remember to change the Startup Type to Automatic, for all three services. This automatically starts the SQL Server database engine, SQL Agent and SQL Browser services when the server is re-booted.The first service runs the SQL Server database engines executable process. The other two services allow scheduled jobs to run after installation (and after a re-boot), and allow the SQL Server to be found by clients on the network.
Do not worry about changing the collation tab, unless there is a specific requirement for anything other than the default collation sequence. Finally, click on Next.STEP 14 : Database Engine Configuration – Account Provision
This screen allows you to set up database engine security.
Change the Authentication Mode to Mixed Mode unless you are certain you only need Windows-only authentication.
- Many third party applications rely on SQL Server logins to operate correctly, so if you are setting up a server for a third party application, rather than one developed in-house, enabling Mixed Mode authentication is a good idea.
Note that you MUST also provide a Windows NT account on the local machine as a SQL Server administrator. If you do not want Windows system administrators to be able walk up to the box and login to SQL Server, create a new, local, dummy Windows user and add this account instead. Otherwise, add in the local administrator account, or your own Windows account on the domain in which the SQL Server will reside.STEP 15 : Database Engine Configuration – Data Directories
Click on the Data Directories tab.
Change the directories to specify which drives in your system will be used for the various types of database files.Generally it’s advisable to put the User database directory and User log directory on separate physical drives for performance, but it will depend on how Windows has been configured and how many disk drives you have available.
If you are installing on a single drive laptop or desktop, then simply specify:
Data root directory | C:\Program Files\Microsoft SQL Server |
User database directory | C:\Data |
User log directory | C:\Logs |
Temp DB directory | C:\TempDB |
Temp Log directory | C:\TempDB |
Backup directory | C:\Backups |
STEP 16 : Error Usage ReportingThis screen simply asks if you want to send error information to Microsoft and can safely be skipped if you do not want to share any information.
Click boxes if you want to help Microsoft help you.
Click on Next again…STEP 16 : Installation Rules
This screen simply checks if there are any processes or other installations running which will stop the installation of SQL Server 2008.
Click on Next again – you’re almost ready to install: STEP 17 : Ready to InstallThis screen summarises what you are about to install and gives you a last chance to cancel or change anything that’s wrongly configured: Check that what’s being installed is what you want and then click on Install when you’re sure you want to start the installation process: Installation ProgressSQL Server 2008 will now install. How long it takes depends on the speed of your machine, what load it’s under, the installation media (CD is slower) and what you’ve chosen to install. …More Installation Progress
... and Finally
Finally, the installation will complete:
...and the following dialog box will appear: Click on OK, the machine will NOT reboot.
The following will appear:
…followed by: Click on the Next button again...STEP 18 : Installation Complete
The following screen appears:
It may be worth clicking on the installation log at the top of the screen to check everything’s gone as expected. Not that this is MUCH smaller than the usual SQL Server installation log files of old.Finally, click on the Close button. The following dialog will appear: Click on OK – your server will NOT re-boot at this point.
The dialog box will disappear and you will be returned to the Installation Center: Click on the Close button (the “x”) in the top right of the screen.
Finally, manually reboot your machine to complete the SQL Server 2008 installation.Top Tips :
How to check that SQL Server 2008 has installed correctlyHere are a short number of post-installation checks which are useful to perform after re-booting your new SQL Server. You don’t have to run these, and there are other ways to check, but they are very useful for non-DBAs to be sure that the installation is basically sound and a connection can be made to the new SQL Server before handing it over to someone else. Check 1: Has the SQL Server Service Started?Check SQL Server 2008 has started. Check 2: Does Management Studio Work?
Check Management Studio works by firing it up. Click on NO when you see this dialog box: Check 3: Can you run a basic query against the new SQL Server?Check SQL Server works by running a simple query from Management Studio: Enter the query shown below and hit F5 to run it: Check 4: Is SQL Server Agent Running?
Check SQL Server Agent is running for scheduled jobs. There should be a green arrow next to the SQL Server Agent database symbol (it’s small, you might have to look hard): Check 5: Can SQL Server be seen from the Network?Check that the new SQL Server can be seen from another SQL Server on the same domain by running isql –L (or osql –L):
If you can’t see the new SQL Server in this list, check that the SQL Server Browser service is started on the machine where you have just installed SQL Server.Check 6: Has the TCP/IP network protocol library been enabled on the server?
If the browser service is started but you still cannot connect to the server, click on Start ->Programs -> SQL Server 2008 -> SQL Server Configuration Manager (on the server where SQL Server’s just been installed)
The SQL Server Configuration Manager window opens.
Click on the SQL Server Network Configuration node and expand it.In the example below, we have MSSQLSERVER (a base instance of SQL Server), and SQLEXPRESS showing as installed.
If in doubt, click on Protocols for MSSQLSERVER. In the above screenshot, the TCP/IP network protocol library is disabled. We need to enable it in order that remote servers can talk to the newly installed SQL Server.
- A word of explanation : In most installations, Named Pipes can be ignored, unless there is a requirement for it. In virtually all environments, VIA can also be ignored as this protocol requires a special network card. Shared memory is the “local” protocol that SQL Server uses when talking to a client application on the same server as itself, for example when SQL Server Management Studio connects to it. It is usually best to leave this enabled.
If it shows as DISABLED (above), double click on the TCP/IP protocol line, and the following window will appear: Ensure that Enabled is set to Yes, and click on OK.
The following warning will appear:
Click on OK, and you will be returned to the Configuration Manager window, where TCP/IP will now be shown as enabled:
Go back to the Services applet, and re-start the MSSQLSERVER service so that the TCP/IP protocol can be used to connect to your new SQL Server.Then try to connect to it again from a remote machine.
If you have experienced problems with the previous connectivity tests, you should now be able to repeat at least some of them successfully.
Subscribe to:
Posts (Atom)