i.e. anything interesting…
Posts tagged SQL Server
My Photography Website – http://www.simonantony.co.uk
Jan 9th
I’ve developed a new website using asp.net in c# to promote my photography business covering weddings,portraits, parties, events, corporates etc – visit the site and let me know your thoughts:
SQL SERVER – Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.
Oct 7th
This one always catches me out, about time I logged it so I don’t need to googlise it everytime!
SQL SERVER – Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.
April 14, 2007 by pinaldave
Some errors never got old. I have seen many new DBA or Developers struggling with this errors.
Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.
Fix/Solution/Workaround:
Change the Authentication Mode of the SQL server from “Windows Authentication Mode (Windows Authentication)”
to “Mixed Mode (Windows Authentication and SQL Server Authentication)”.
Run following script in SQL Analyzer to change the authentication
ALTER LOGIN sa ENABLE
GO
ALTER LOGIN sa WITH PASSWORD = ”
GO
Taken from SQLAuthority.com
SQL Datetime Woes – The ultimate guide to the datetime datatypes
Oct 3rd
I’ve not worked with SQL Server DateTime values for a while now so was a little rusty. I needed to do some date filtering and came across the following site by MVP Tibor Karaszi that I found really useful:
http://www.karaszi.com/SQLServer/info_datetime.asp
