AutoCAD MAP3D and Microsoft SQL Server: 2. Installation of Microsoft SQL Server 2008 R2

 Let's install MS Server which we downloaded in the past blog-post. I have to repeat again and again, ensure yourself that you downloaded Microsoft SQL Server 2008 R2 SP1, because Auto-CAD MAP3d supports only this version!

1. I am so exited to tell you about this installation ;), because when we gonna have the SQL server installed, then we can start to connect AutoCAD MAP3D to this server and then start to have a fun. What do you thing? Let's start with running installation file we downloaded in past blog post, hopefully with name SQLEXPRADV_x64_ENU.exe. Note: You should have Administrator rights. By the way, installation files, are extracted to that crazy folder (in my case it was D:\877fecce798aecc26a8e7e7338b06155). If you want to have access to installation folder, just copy everything, which is inside to your own location.
   
2. When everything is extracted, application SQL Server Installation Center is ran automatically. Click on "New installation or add features to an existing installation"
   
3. Then another installation application is started, called SQL Server 2008 R2 Setup. Which will finally install your SQL server. Just accept License terms and click on NEXT button.
   
4. In this step ("Features selection"), click on Select all button, and if you want to install these features to custom directory, just change directory in "Shared feature directory:" and "Shared feature directory (x86):" textbox. And click NEXT.
   
5. In instance configuration wizard you can specify whether to create a default instance or a named instance of SQL Server. If an instance of SQL Server is not already installed, a default instance will be created unless you specify a named instance. If you are installing first instance of SQL server on you local computer, just leave it as it is. And click NEXT.
   
6.  Next step is Server configuration. First tab is under what user will be services operate.
   
   
     Second one, is  "Collation", set up somethinkg charset, and other interesting stuff. If you want to play around, just click Customize... After you set up everything you want, go to next...
   
   
7. Database engine configuration is basic configuration of you database! For our needs we can leave "Windows authentication mode" on. You can add another user as administrator,
   
   and on your second tab you can set up Database directories. Location where your databases are going to be stored.
   
   
8. In Reporting Services Configuration Wizzard click on first option "Install the native default configuration."
   
   
9. If everything is all right, as it was in my case, you will install your new Microsoft SQL server! I am proud of you.
   
   
10. If you want to test, if everything is all right, just start "Microsoft SQL Server Management Studio" with computer name(domain)\service name.
    
    
    Here you are. It is working!
    
    

Important note: If you have Firewall active, you have to open ports which is used by this service (in my case it was 1433.) To find out what port you are using, run "SQL Server Configuration Manager". In this application click on SQL Native Client 10.0 Configuration > then Client Protocols (on the left side). On the right side, right click on TCP/IP protocol, and Properties from contextual menu. There you can find "Default Port". This port number allow in Firewall.

Next step is to connect Autodesk AutoCAD MAP3D with this SQL server! Then we will try to create simple data model.