King Computer Solutions
spacer

Archive for the SQL 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 […]

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

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 […]