Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player

spacer

Archive for the SQL Category

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 (0×7E)

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 find VIA in [...]