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 […]
Stop MySQL service Find the database location On a Windows 2008 server for example it may be in-
How to cut down SBS monitoring memory usage on SBS 2003.
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
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: […]
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 […]
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 […]
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-
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 […]