What's New

SQL

Server is in script upgrade mode. Only administrator can connect at this time

April 20, 2012 // 1 Comment

So I was placed in charge of two things to do on the SQL 2008 server. Update to SQL Server 2008 Service Pack 1 Add the Full Text Search Feature After all was done, I was to [...]

Microsoft SQL Server Error 18456 Login Failed for User

March 20, 2012 // 38 Comments

18456 Error Problem So I was connecting to Microsoft SQL Server and trying to use the SQL Authentication method and I received this event ID error 18456 login failed for [...]

How to Configure SQL Server 2008 to Allow Network Connections

February 18, 2012 // 5 Comments

This is a very common problem after you do a new install of SQL Server on a server. The moment you try to access it over the network, following error pops up: "A network [...]

How to Configure SQL Server 2005 to Allow Remote Connections

February 5, 2012 // 0 Comments

Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition You must enable remote connections for each instance of SQL Server 2005 that you [...]