Tags: SQL Server

SQL Server 2008: Create administrator account without admin login

on March 6, 2012

{0 Comments}

Category: SQL Server

SQL Server 2008: Create administrator account without admin login

Deploying our development machines from virtual machine templates saves us a lot of time, however every now and then we hit frustrating little speed bumps. Here is the latest – SQL Server 2008 / SQL Server 2008 Express not having an administrator account enabled. To fix this problem you must first stop the SQL Server 2008 instance, and start it …

[ Continue Reading... ]

Tagged in:

SQL Server 2005: Error: 18452 Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection.

on July 1, 2009

{3 Comments}

Category: SQL Server

SQL Server 2005: Error: 18452 Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection.

Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection. This error occurs when you attempt to login to SQL Server using SQL Server Authentication mode (username + password) when the SQL Server instance is only configured for Windows Authentication. To fix the issue: Enable SQL Server Authentication Enable the “sa” user, and configure …

[ Continue Reading... ]

Tagged in:

SQL Server – Service Broker – Message Types across Databases

on June 3, 2009

{0 Comments}

Category: Service Broker

If the message is being sent to another database then the “message type” and “message contract” must exist on both databases, regardless of whether the destination database is on the same or a different server. See: Back To Basics: Service Broker Message Types

[ Continue Reading... ]

Tagged in: ,