RE: Unable toconnect to database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Eliassal,
Thanks for your reply,

SQL Profile cannot provider more information than the event log you have
got. It just helps on confirm if the issue is accused by TFSSERVICE Login
Failure.

I'm afraid there is no tool/procedure to validate useraccount. But I think
we can achieve by ourselves. Do you still remember the password for
TFSSERVICE account? My suggestion is we may consider trying to connect to
this SQL Server by this account directly.
For example:

System.Data.SqlClient.SqlConnectionStringBuilder ssb = new
System.Data.SqlClient.SqlConnectionStringBuilder();
ssb.DataSource = "";
ssb.UserID = "";
ssb.Password = "";
ssb.InitialCatalog = "";
System.Data.SqlClient.SqlConnection sc = new
System.Data.SqlClient.SqlConnection();
sc.ConnectionString = ssb.ConnectionString;
sc.Open();
sc.Close();

Do you get any error message when running this application?
Please let me know the result. This helps on research very much.

If you have any more concern, please also feel free to update here. We are
glad to assist you.

Have a great day,
Best regards,

Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.