When we install SQL Server Express on Windows 8 with a default installation, we do not know how to configure SQL, that’s why we now go through the steps in detail and explained, and how this affects when we use a connection string.
Remember that SQL Server Express is free, and you can download it from the internet. Now if we do it with the How-To, since the execution of the SQL Server Express installer, the steps are as follows:
We hope you will load the Assistant’s initial screen, and click next:
Now the Assistant will check our system to see if it meets the requirements, if our PC is normal in some could show us a warning recommending the use of more RAM, the eye is warning, that is, we can continue with the installation, sometimes install it on a PC with 256 RAM and normal. In other cases when installing Reporting Services, you will be required to have IIS, but this is not the case.
Then we select the features that we want to install, and we can also choose in which unit we want to install SQL, of course, it is a new installation, what happens is that SQL depends on the .NET Framework 2.0, and they share the same installation unit, We click Next:
Depending on your installation, it will show this screen indicating the installed components, and if we want to update them in this installation.
Now we must choose the service account. In this case, we can choose an integrated system account or a user account of our domain. In the built-in system account we can choose three options that depend on whether it is the same computer, if we are going to use it in a network, or the privileges that we would like to assign, if you want more details you can read Security considerations for a SQL installation or Configure accounts of Windows service. We choose our type of account, and we can also select if we want to start a service at the end of the installation.
This little screen is also interesting, the authentication mode, only windows to use integrated security in our connection chain, or mixed mode, to be able to use both Windows and SQL authentication. In SQL authentication we must place a password for the user which we use in our connection string as [user id] and password. We select mixed mode, place a password.
Then collation settings, in this case, we can choose SQL Collations, to maintain compatibility with previous versions of SQL Server, we click next:
Check the box to allow users who do not have administrator privileges to run a separate instance (attach file) of the database engine, if we want to know more about the work with instances of user visit the following link.
We mark the options if we wish to report errors or the use of SQL Server,
And we get to the super screen, Ready to install; we click on the Install button, to complete our magnificent configuration, not mine, but what you do ;):
Now we get up from the PC for a while, after N hours sitting, and we have a coffee, a juice, a chelinha, or what they like to drink, and we hope you install:
When installing Visual Studio 2005, select a custom installation and remove the option to install SQL Server Express, of course, as long as you want to do a custom installation of SQL Server Express.
Updated: After installing SQL Server Express, we must install SQL Server Management Studio Express. With this tool we can make queries to the database, it is the famous query analyzer.