I am trying to change the password of the sa
account via SQL Server Management Studio, but it's not changing it, i tried all the techniques describe here http://blog.sqlauthority.com/2009/08/04/sql-server-forgot-the-password-of-username-sa/
WhenI tried to enter the management studio by sa it gave this error
Login failed for user 'sa'. (.Net SqlClient Data Provider)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
Server Name: MY-PC\SQLEXPRESS
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
after changing password I got this error
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.) (.Net SqlClient Data Provider)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
Server Name: MY-PC\SQLEXPRESS
Error Number: 233
Severity: 20
State: 0
Best Answer
I got it done , the password changes here http://web.archive.org/web/20180115133134/http://www.rickwargo.com/2010/09/14/installing-dotnetnuke-community-edition-on-microsoft-webmatrix/
then open sql server from windows account and set remote connection to true and set security both "windows and sql server security"
it also needs to first allow TCP/IP and pipes in sql server configuration to be set as Enabled , then you must restart SQL server ad restart the SQLEXPRESS services