Here’s how to set the TCP/IP port in your new SQL Express instance:
When you install SQL Express, it doesn’t set your TCP/IP port, so you’ll have to do that using the SQL Server Configuration Manager. Show-stopper # 1 – Setup the TCP/IP port on your SQL Express instance.ĭon’t skip this step or you will not be able to proceed any further. This will be a combination of the computer name \ instance name.Ī successful login of the Management Studio proves you now have a working SQL Server Express instance on your machine. In either case you will need to enter the Server Name when you first login. You can login with either Windows Authentication or SQL Server Authentication. Once the installation is complete, test that everything is working OK by logging in using the SQL Server Management Studio tool.
Make a note of this password, you will need it whenever you need to add database to the instance you are installing.
exe file to install the MS SQL Server using default settings except on the dialogs pointed out in the following: You will need the Management Studio Express tool to administer the database and the SQL Server Configuration Manager to solve the first of our show-stopper items: and these are included in any executable that contains the letters WT in the file name. When you download an SQL Server install package, just make sure you get the ‘With Tools’ version. We’ve tested it on SQL 2005, 2008, 2008 R2 & 2012 without issues and in all likelihood you’ll be fine with 2014 too.
The Details: Install Microsoft SQL Server Express This blog highlights a couple of key show-stoppers that you must know about before attempting this operation: nothing too serious, but frustrating if you have to figure them all out for yourself. Sound reasonably simple right? Well as always, the devil is in the details.
That said, for those P6 R8.3 users wishing to move off the Oracle XE and on to something simpler, there’s still the Microsoft SQL Express database option. Oracle clearly recognizes that consumers of Primavera P6 Professional aren’t necessarily Oracle database experts, and thus removed that need for standalone users making everything very simple. In fact, unlike the Oracle XE install, which can take upwards of 20 minutes to install on your machine, you will not even be aware that SQLite got installed. See our blog about installation of the Primavera P6 Professional R8.4 release. On a side note: with the recent release of Primavera P6 Professional R8.4, Oracle themselves have abandoned the Oracle XE database for P6 in favor of SQLite, a popular, open source database that installs quickly and easily as part of the standalone installation options: a smart move indeed. However, this doesn’t always go smoothly and we’ve received numerous enquiries for help getting P6 to connect to that XE database once the installation completes: it’s evidently a common problem. Primavera P6 R8.3 installs a copy of the free Oracle XE database on your computer when you choose the standalone installation option. This article looks at the process for setting up Primavera P6 Professional R8.3 to use the Microsoft SQL Server database, rather than with Oracle XE for standalone use. If you’ve been having issues trying to run Primavera P6 Professional as standalone on the Oracle XE database, or you simply want to run standalone when not on the company network and are not an Oracle database expert you can use a Microsoft SQL Server Express database instead.