Installation problems......
Learn all about bird watching
I have installed Bird Tick List and when I run it I get an error, if I ignore the error Bird Tick List starts but I cannot add records, its just blank,
what do I need to do?

95% of installation problem are due to Microsoft SQL not installing or not installing properly.
FIRST CHECK THIS: Right click on start menu icon (bottom left) Choose 'Explore' In the left of the window that opens find C:/ drive and right click on it.
Choose Properties. Check in properties box that the C:/ is _not_ compressed, the tick box at bottom left should be unchecked. (SQL server will not install on
a compressed drive)

THEN THIS; Go to control panel and uninstall all references of SQL starting with Microsoft SQL Server Native Client and then anything else. (you may get
some messages saying it does not exist but dont worry) Now uninstall Bird Tick list, in the windows control panel.

THEN THIS; Make sure your Bird Tick List setup folder is on your desk top and all three files are present, click on 'Setup'. (Ensure you are connected to
internet) You should get a message appear saying that you do not have SQL on your computer and Bird Tick List will download it, consent to this. Just follow
the prompts from then on, it should take about 8 minutes to install Bird Tick list.

IF THIS FAILS; Go to the user support section of the website and click on the download latest SQL files on the left of the page. Install the files and try Bird
Tick List again.
I am running Vista and when installing Microsoft SQL it says there are compatibility issues.

Any incompatibility is negligible, please ignore these messages and continue with the installation. Do not choose the option which asks if you want to update
your operating system, it is not required and very time consuming!
Microsoft SQL server will not install on my computer.

Microsoft SQL Server will not install on a C:/ drive that is compressed. You need to right click on your C:/ drive and uncheck the tick box that mentions drive
compression.
Error: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL
Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.


Something on your computer may have altered the settings of SQL server, try this:

1 Click *Start*, point to *Programs*, point to *Microsoft SQL Server 2005*, point to *Configuration Tools*, and then click *SQL Server Surface Area Configuration*.

2 On the *SQL Server 2005 Surface Area Configuration* page, click *Surface Area Configuration for Services and Connections*.

3 On the *Surface Area Configuration for Services and Connections* page, expand *Database Engine*, click *Remote Connections*, click *Local and remote
connections*, click the appropriate protocol to enable for your environment, ('try third option using both TCP/IP and named pipes') and then click *Apply*.

*Note* Click *OK* when you receive the following message:

Changes to Connection Settings will not take effect until you restart the Database Engine service.

4 On the *Surface Area Configuration for Services and Connections* page, expand *Database Engine*, click *Service*, click *Stop*, wait until the MSSQLSERVER
service stops, and then click *Start* to restart the MSSQLSERVER service.

If that does not work try the various settings mentioned in 3 as these are unique to your machine. If this still fails, go to start, control panel and un-install SQL Server
and then reinstall it.
Error: Windows XP Service Pack 2 or later is required to install SQL Server 2005 Express

This means your windows XP installation needs updating, if you go to the microsoft website:
http://www.microsoft.com/windowsxp/sp2/default.mspx
You can download the files for free; Bird Tick List aside you need to do this as it has several very important security updates for your computers safety and integrity.
When you have done this SQL should then install no problem.
Error: Process exited with code 28062

This is from SQL Server, it means your C:/ drive is compressed and SQL will not install, decompress your hard drive.
Bird Tick List will not run?

Bird Tick List needs two microsoft components which are installed on your computer one is the Microsoft .Net framework the other is microsoft SQL server.
If you have Vista or Win 7 .Net is already installed but SQL is not. Both of these items are used by a multitude of modern programs and are referred to as
common windows add ons. The Bird Tick List setup program checks your computer to see if these items are already installed, if they are not it asks you for
permission to download them from microsoft, you must say yes to this, if you refuse Bird Tick List will not run.
Generating User Instances in SQL server is disabled;. Use sp_configure `user instances enabled` to generate user instances.


Follow these instructions;

1 Go to START your program menu and look for MICROSOFT SQL SERVER 2005

2 On the menu that expands you should have CONFIGURATION TOOLS and possibly SQL SERVER MANAGEMENT STUDIO EXPRESS

3 If you do have SQL SERVER MANAGEMENT STUDIO EXPRESS you need to click on that, if you do not download and install it from here:

     
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-
94b8-5a0f62bf7796&displaylang=en

4 Choose either the 32 or 64 bit version depending on your computer (control panel, system to find out)

5 Ok so you now have SQL SERVER MANAGEMENT STUDIO EXPRESS installed, click on it to open it.

6 A 'CONNECT TO SERVER BOX' will appear, click connect.

7 Click NEW QUERY (top left)

8 In the new window that appears paste this code in (Exactly as is, don't miss the colons of):
EXEC sp_configure 'user instances enabled', 1;
RECONFIGURE;

9 Now click the EXECUTE button (just above page where you pasted the code)

10 Now close SQL SERVER MANAGEMENT STUDIO EXPRESS with the red cross and refuse to save anything if offered.

11 Now close down your computer and restart (don't be tempted to try bird tick list at this point!)

12 When your computer has re-started Bird Tick List should work.
Error: failed to generate a user  instance of SQL server due to failure in starting process for the user instance. The connections will be closed'

Question: Having only recently purchased tick list I find that when I log onto it I get a warning stating 'failed to generate a user instance of SQL server due to failure in
starting process for the user instance. The connections will be closed', Can you help me with this?

Answer: It would appear this can happen when there are multiple user accounts on one computer and one has not logged off properly, try shutting down your machine
and logging on again.
If that does not work, uninstall SQL server express using control panel.
Back to Help & Support
Back to Help & Support
Error: 'This version of SQL Server 2005 Express Edition is not supported for the current processor architecture

This happens when the BTL setup program has not detected that you have a 64 bit operating system/processor. The setup program probably did not identify
your system as being 64 bit because you have a WOW64 directory as part of you operating system, this makes your machine behave like a 32 bit system so
that it can run 32 bit software, however WOW64 systems will not work with certain database applications, hence the error. There is a good article on this here
which may be worth reading for future reference when installing software onto your machine.

To fix this problem you will have to uninstall the 32 bit version and then install the 64 bit version of SQL:

1 Go to your control panel (start > Control Pane l > Programs > Uninstall a Program) and uninstall Microsoft SQL Server 2005.
2 Download the 64 Bit version here.
3 Install the download, accepting all defaults during installation.

Please note that BTL Pro is written in code which is compatible with both 32 & 64 bit systems.