Navigation:  Installation >

Installation MS-SQL 2008

 Print this Topic Previous pageReturn to chapter overviewNext page

Please note, that the installation of a SQL Server does not have anything to do with our Xpert-Timer software. It's a completly different product, supported by Microsoft. This instruction includes the most common steps to install the server on your system. Most of the times, the access rights to connect to the server from the client need to be managed. Connection failures can be caused by firewalls, settings in the Windows system or domain access rights. Please refer to the SQL Server Help if you run into installation problems.

Step by step installation:

1. Download the SQL Server 2008 Express Edition from the Microsoft website or get the latest version here:

symbol_linkhttp://www.microsoft.com/express/sql/download/default.aspx (Runtime with Management Tools is perfect)

If you don't use domains in your company, make sure you install the SQL Server with "mixed mode", as you have to connect with username and password through our XTAdmin later.
 

2. Check if you have Microsoft .NET Framework 2.0 installed on your computer. If not, download it at:

symbol_linkhttp://www.microsoft.com/

 
3. If you install the SQL Server as a new instance (necessary on a SharepointServer), make sure you memorize the name of your instance. You'll need it later again.
 

4. Install "Microsoft SQL Server Native Client"

The Native Client contains the OLEDB-Provider to connect to the MS-SQL Database. This driver has to be installed on the server as well as on all clients, connecting to the database.

symbol_linkhttp://download.microsoft.com/download/2/0/6/206f68f6-9035-476c-9aa0-05f36e75543b/sqlncli.msi
 

5. Install "SQL Management Studio Express" if you haven't already with number 1.

Configure your settings of the SQL-Server through this SQL Management studio. If you plan to backup your database you should definitely install this tool.

symbol_linkhttp://www.microsoft.com/downloads/details.aspx

ATTENTION: Network access to the service is deactivated by default. In order to allow access to the server from the clients, you need to activate TCP/IP. Go to START -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration, then hit Network configuration and activate TCP/IP. Restart the SQL Server for the settings to take effect.

Also, please double check, if your SQL Browser is running. This allows you to see the Server in your drop down list in Xpert-Timer..

Please remember to allow the clients to connect to the server through the Firewall. If you are using XP, the port 1433 will be used by SQL Servers.

If the client cannot connect to the server, most of the times it's an access right problem. Try to add a new user in the Management Studio Express and use the fuction Search to search for the new user in the network. If you can't find the user, there seems to be an access right problem. If you see the user, add it to the system, grant db_owner and public rights and assing the XpertTimer Database to the user. Now try to connect again.

 

6. Download the Xpert-Timer Setup from Xpert-Design Software website:

symbol_linkhttp://english.xpertdesign.de/download.php

Choose the file "XTInstEN.exe"
 

7. Run the setup. After the setup is finished, XTAdmin will start automatically to create the database.

The database info is saved in the "xperttimer.ini" file in the program directory.

The database info gives you an overview of your Users, patchlevel, ADO-Version and database type.

Please send further questions to: service@xpertdesign.de

 

 

Page url: http://manual.xperttimer.com/pro2/xtadmin_newdb.htm