Skip to main content

Optimising SQL Server 2005 TempDB

Microsoft’s whitepaper on Optimising TempDB in SQL Server 2005 contains a lot of useful information for anyone trying to push the performance of SQL Server 2005. Along with the internal improvements to tempdb, there are a number of things a database administrator should do as part of any installation: Increase the number of data files […]

Error: SQL Server Replication Requires The Actual Server Name

If while trying to setup a new subscription for SQL Server 2005 Replication using Management Studio you receive this error: TITLE: New Subscription Wizard —————————— Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic […]

Google searches for SQL Server 2005

While tracing through my search history today, I came across the Google Trends tool. Its interesting to see the comparison of searches for SQL Server 2000 verses SQL Server 2005. It will be interesting to see if in the coming months just how many more searches will be for 2005 as there are more installations […]

SQL Server 2005 Login Error 18452

SQL Server 2005 Login Error 18452

If you are trying to connect to SQL Server 2005 with a SQL Server User Login and receive this error: Login failed for user ‘RptSvcUser’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) Remember to check that the servers authentication is set to "SQL Server and Windows […]

Site Update & Email Notifications

Well its been a busy couple of months and my blogging has fallen behind. Over the last couple of weeks, a number of small improvements have been made on my blog. Unused features have been removed, spam prevention has been improved, and I even remembered to post some new entries. I’m also going to trial […]