Posts
33
Comments
153
Trackbacks
0
January 2016 Entries
MS SQL Server - 'sa' user locked out
If you come across a scenario where 'sa' user is locked out and you do not have any other ways to reset or unlock the user. 

Use the below MSDN reference to get SQL server back and running.

https://msdn.microsoft.com/en-us/library/dd207004(v=sql.110).aspx
Posted On Tuesday, January 26, 2016 6:33 PM | Comments (32)
setting up SMTP on windows server and getting it up and running
install smtp server features through server manager if its windows server machine or through add windows features from 'add/remove programs' dialog option

even if you are on iis 7 or anything higher, open up iis 6 manager and make sure smtp virtual server is  running (specially if you are getting error message saying 'Remote machine actively refused connection)

if you get 5.7.1 relay error - check the properties of smtp virtual server , general tab ..instead of all 'All UnAssigned' select the ip address of machine and on Access tab ..relay option add 127.0.0.1 and server machine address to the list 
Posted On Monday, January 25, 2016 10:46 PM | Comments (5)