King Computer Solutions
spacer

Archive for the Database Category

08.2.2011

MYOB AE Tax error Client application S6 server MSSQL AETAX1 TAX TA not found after dotnet 3.5 update

If client workstations are losing access to the MYOB AE Accounts database with the error Client/Application (S6:\\SERVER\MSSQL\AETAX1\TAX\TA) not found as shown below       The System Release DAL may be getting shut down by dotnet update To resolve this issue you need to Run Exec sp_changedbowner ‘sa’ on the AETax database Run AETaxconfigupdate.exe For […]

04.3.2011

How to Move MySQL database on Windows server

Stop MySQL service   Find the database location On a Windows 2008 server for example it may be in-

07.5.2010

SQL High Memory usage SBS 2003

How to cut down SBS monitoring memory usage on SBS 2003.

04.29.2010

[DBNETLIB][ConnectionOpen (Connect()).]SQL server does not exist or access denied

This may be due to a firewall issue – in particular Allow inbound SQL Server Browser UDP 1434 See further info on opening relevant firewall ports here: http://technet.microsoft.com/en-us/library/ms175043.asp Regards, Brendan

12.6.2009

MySQL basic commands

On a windows server the MySQL executables folder by default will be installed in a folder like C:\Program Files\MySQL\MySQL Server 5.1\bin Executables in this folder will be myisamchk.exe myisamlog.exe myisampack.exe myisam_ftdump.exe mysql.exe mysqladmin.exe mysqlbinlog.exe mysqlcheck.exe mysqld-debug.exe mysqld.exe mysqldump.exe mysqlimport.exe MySQLInstanceConfig.exe mysqlmanager.exe mysqlshow.exe mysqltest.exe mysql_client_test.exe mysql_upgrade.exe my_print_defaults.exe perror.exe replace.exe resolveip.exe Use this to create a database: […]

08.20.2009

The SQL Server (MSSQLSERVER) service terminated with service specific error 126 (0x7E)

This error is associated with the VIA protocol. To disable it Start->All Programs -> Microsoft Sql server 2005 -> Configuration Tools -> SQL Server Configuration Manager. In the SQL SERVER configuration Manager Window, click the plus (+) sign against SQL SERVER 2005 Network Configuration. Highlight ‘Protocols for MS SQL SERVER’. In the right pane you’d […]

07.22.2009

Database connection error installing WordPress

A pre-note on installing WordPress: Read the official installation instructions first! By following the “5 minute install” instructions verbatim, I’ve never had a problem! Problems only happen when you don’t follow the instructions! http://codex.wordpress.org/Installing_WordPress Symptom: You’re installing WordPress and you’re getting database connection errors even though you have the settings correct. Fix: It’s possible that […]

07.21.2009

Install WordPress on Windows IIS server Part 1

Here are the start to finish instructions for setting up your wordpress blog site on a Windows IIS server. This was done on a windows 2003 server. In this instance I am setting up wordpress to use as an intranet site. Part 1 covers install of: MySQL FastCGI Extension PHP   Install MySQL Download MySQL-

06.10.2009

Scheduled backup using Microsoft SQL Server 2005

The Express version of MS SQL 2005 does not include functionality to perform a scheduled backup. To get around this, use the “Script to File” option and then run it from the command line using a batch file and Windows Scheduled Tasks function. 1. Open up SQL Server Management Studio Express 2. Drill down to […]