Once installation is completed
and before we can use Manual Logger, we must
attach the database files that were created
to the database.
SQL Server 2005
Express can be used with Manual Logger.
This is a free download from the Microsoft website.
Remember,
the database files were created
in Program Files, PIPC,
PimlWindows inside the Data Folder.
The process of attaching
these files to the database is simple,
but you will need the assistance of your network
administrator. Let me show you how it's done.
Once you install SQL
Server 2005, you will also have to
install the SQL Server
Management Studio. In this case, I installed
the SQL Server Management Studio Express
which is a free download from Microsoft.
Once you open the Management Studio,
you will have to connect to your server where the
database is located. In this case, the name of my
server is OSIsoft-DC.
Once you connect to the server, you will be able
to see your server on the left pane. If
the pane is not available, you can always open the
pane by clicking on View, Object Explorer.
And now, you can
maximum the server that you are looking for.
Under
Databases, we want to attach the new files.
In order to do this, we right-click
Databases and select Attach.
We will have to Browse to the location of these
files. We click Add,
and now we go to C:,
Program Files, PIPC,
PimlWindows, Data Folder.
The file that we are looking for is
PimlWindows.
And now we are ready to attach
the database to the database
server. Once we complete the process,
we can see that PimlWindows
has been attached to the server as a new database.
Once the database
has been attached, we need to insure that Manual Logger
is communicating with the right database.
In order to do that, we want to use the PI
Manual Logger Configuration Tool.
This will be in the PI Manual Logger Folder.
One of the options
in the Configuration Tool is Database.
We want to set up a connection.
In here,
again, we need the name of the server
where the SQL Server is located.
In my case, this is OSIsoft
-DC.
The name of the file or database that we are looking
for is PimlWindows.
So I am going to delete that number two from there.
We can either use
the Windows credentials which will use
our Windows username and password to
log into the SQL Server or
we can use a SQL Server-specific username
and password. I will use
my windows credentials.
And I want to test the connection.
We can see that the connection
was successful. Therefore, we can apply
the changes. And now, our PI
Manual Logger has been set up
to communicate with the correct database
and the server.