Browse by Tags

Unable to install SQL Server Express - Error SQL Server service failed to start?

Published 7 November 7 1:33 PM | SSQA.net

Imagine a simple installation of SQL Server Express 2005 edition fails with an error "SQL Server service failed to start?" Whether it may be on a X64 based operating system or on a simple desktop with XP PRO, as usual you would go with default...

Filed under: sql server, microsoft, services, error, sql express, installation, encryption, build, log file, 15029

How to suppress SQLSTATE messages when executing scripts using SQLCMD?

Published 6 November 7 11:48 AM | SSQA.net

Say you are executing a scheduled job using a batch file and output is stored to a file, then in that output file you will see Warning messages such as SQLSTATE. So how to suppress these messages on the output file. Simply using -i option in SQLCMD as...

Filed under: sql server, error, sql express, sqlcmd, loading, warning, sqlstate

An error has occured 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.(provider:Named Pipes ....)

Published 26 July 7 7:49 AM | SSQA.net

Error: An error has occured 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.(provider:Named Pipes Provider...

Filed under: sql server, performance, management, security, ssms, error, access, sql express, tcp, named pipes, remote