The PIAB installer is set up to create the 'piab' database on a typical, local instance of SQL Server, normally SQL Express 2008, SQL Express 2005 or MSDE (SQL 2000). PIAB can also use a remote SQL instance - you will need to know the instance name and have sufficient permissions to restore and administer a database on that SQL instance.
Using a local copy of SQL Server Express, or the older MSDE, the default instance name is as follows:
|SQL Sever Version||Default SQL instance Name|
|SQL Express 2008||(local)\SQLEXPRESS|
|SQL Express 2005||(local)\SQLEXPRESS|
There are various valid reasons why this may need manual installation on your PC:
In this case we provide tools to address these issues - in the PROJECT in a box Server program. Alternatively you can use your own Microsoft SQL Server administration tools.
NOTE If your SQL Server is on a remote PC, then you will need to install the PROJECT in a box Server program on that remote PC, and run it from there. You can do this with the PIAB installer, no extra licencing is required.
The task is to restore the piab database from a SQL Server .bak backup file that will have been placed in the PIAB install folder by the installer.
Program Files\Microsoft SQL Server\MSSQL\Data
You must set the piab database to allow access from the PROJECT in a box application. In practice this means granting permissions to the Windows user that runs the server's ASP.NET Application.
|Windows 2008R2 Server||IIS APPPOOL\DefaultAppPool|
|Windows 2008 Server||IIS APPPOOL\DefaultAppPool|
|Windows 2003 Server||NT AUTHORITY\NETWORK SERVICE|
|Windows 2000 Server||%machinename%\ASPNET|
|Separate SQL Server and Webserver PCs on a Domain||%domain%\%machinename%$|
|Vista with IIS||NT AUTHORITY\NETWORK SERVICE|
|Vista with Personal Web Server||%yourusername%|
|Windows XP Professional||%machinename%\ASPNET|
|Windows 2000 Professional||%machinename%\ASPNET|