The PIAB installer is set up to create the 'piab' database on a typical, local instance of SQL Server, normally SQL Express 2005 or MSDE (SQL 2000).
|SQL Sever Version||Default SQL instance Name|
|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.
|Vista with Personal Web Server||%yourusername%|
|Vista with IIS||NT AUTHORITY\NETWORK SERVICE|
|Windows 2000 Professional||%machinename%\ASPNET|
|Windows XP Professional||%machinename%\ASPNET|
|Windows 2000 Server||%machinename%\ASPNET|
|Windows 2003 Server||NT AUTHORITY\NETWORK SERVICE|
|Separate SQL Server and Webserver PCs on a Domain||%domain%\%machinename%$|