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...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...C# – BinaryFormatter.Deserialize is “Unable to find assembly”
While testing a SQL CLR procedure recently I came across an issue with the binary formatter deserialization failing because it could not find the assembly for the type (even though the type is within the same assembly as the deserialization code).
Continue Reading...SQL Server – Service Broker – Message Types across Databases
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...