If you want to grant some users the execute rights on all stored procedures under a database in SQL. Use the script below. Now map your users / groups to this new role.Read more
I’ve come across a lot of sites where VMware has been deployed using a SQL Express Database. This is normally fine for a handful of VMware hosts. However when used in conjunction with Veeam you might find that your SQL database reaches the Express size limit and then dismounts. The problem is caused by VMwareRead more
There might be occasions when trying to connect to a SQL 2008 R2 Instance with SQLCMD that you might receive the error :- Named Pipes Provider: Could not open a connection to SQL Server. Microsoft SQL Server Native Client 10.0 : Login timeout expired. The full error can be seen in the screenshot below :Read more
In order to start SQL 2008 R2 Express in Single User Mode you need to carry out the following steps. 1) Find out your SQL Instance Name. In my example its called VIM_SQLEXP. 2) Stop all the existing SQL services. 3) Open an Elevated command prompt 4) Change directory to the Binn folder in yourRead more
When trying to do a backup of a SQL Database in SQL Server Management Studio you might get the error :- Backup failed for Server ‘SERVERNAME\INSTANCE’ (Microsoft.SQLServer.SmoExtended) System.Data.SQLClient.SqlError: A nonrecoverable I/O error occurred on file “LOCATION\DATABASE:” 112(failed to retrieve text for this error. Reason: 15105). (Microsoft.SQLServer.Smo)Read more
There are loads of situations where you need to use a SQL database for something. In some cases a SQL Express database will do the job fine rather than installing the full version of SQL. I’ve created mainly so that when I cover other topics I can link to this article rather than repeating myself.Read more
Had an issue this morning where the Backup Exec 2010 services wouldn’t start on a 2008 SBS server. The Backup Exec Job engine service would just time out when starting up. In the application event log there was Event ID : 58068 Source : Backup Exec The Backup Exec Device and Media Service could notRead more
When trying to add a new user to a Business Contact Manager Database you might receive the following message once you have selected the database. System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values. at System.Data.SqlClient.SqlBuffer.get_String() at System.Data.SqlClient.SqlDataReader.GetString(Int3 2 i) at Microsoft.BusinessSolutions.eCRM.BusinessLayer.Bcm DataStore.GetDBOUser To fix it carry out the followingRead more
I am Dale Hayter, a Microsoft and VMware certified Technical Consultant.
My blog has been built up over the years from my experience of working on an IT helpdesk and also from being out on-site.