Tag Archives: SQL Server

SQL Server Reset / Update user password – SQL Server 如何重設/更新使用者密碼?

Leave a reply

今日為自己寫一個 SQL notes
去記下如何重設/更新 使用者密碼[你要有足夠的使用者權限才可以的]
(太久沒有用忘記了User密碼)
解決方法:

ALTER LOGIN [SQL User Name] WITH PASSWORD = '[New Password]';  

-- E.G.
ALTER LOGIN sqluser WITH PASSWORD = 'newP@ssW01D';

hope you find it useful

TF246017: Team Foundation Server could not connect to the database. Verify that the server that is hosting the database is operational, and that network problems are not blocking communication with the server.

Leave a reply

今日公司的同事不能連接公司的 TFS Server.

當嘗試連接時 出現以下的錯誤信息
“TF246017: Team Foundation Server could not connect to the database. Verify that the server that is hosting the database is operational, and that network problems are not blocking communication with the server.”

TF246017

解決方法
重新啟動 這個TFS Server的 Database Server的 SQL Service便可以了

Hope you find it useful