| Author |
Topic |
|
IvanMD1
Starting Member
5 Posts |
 Posted - 2009-11-23 : 10:43:00
|
| Hi, I use Windows authentication to connect to SQL Server 2005 which is installed on remote desktop. My Windows account keeps being locked out every few seconds. I was told by the system administrator that some application sitting in the SQL Server is repeatedly tries to log in with invalid credentials and that causes my account being locked out few seconds after it is unlocked by the admin. Do you know what this might be and how to make it submit correct credentials. Thank you for your help! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-23 : 11:01:32
|
| open the services applet and look for any service running under your accountstart/administrative tools/services |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
IvanMD1
Starting Member
5 Posts |
Posted - 2009-11-23 : 11:47:15
|
| Thank you for your suggestions but there are no services running under my account.The only possible 'logs on' are 'Local System', 'Network Service' and 'Admin'...aaa |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-23 : 12:37:05
|
| have your network admin tell you which machine the failed logins are coming from.could it be a connection string in a web app perhaps? |
|
|
|
IvanMD1
Starting Member
5 Posts |
Posted - 2009-11-23 : 13:29:41
|
| Failed logins come from a remote computer (a server where SQL is set up)It can be a connection string to a web application as we use SQL Server Reporting Services to run reports online. Do you know how to trace and remove (or amend) those strings? Thank you.aaa |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-23 : 13:39:38
|
| look in the config files. also look at any linked servers you may have created on that machine.did you recently change your password? |
|
|
|
IvanMD1
Starting Member
5 Posts |
Posted - 2009-11-23 : 14:20:45
|
| Yes I have recently changed password and that is when all problems began.Where can I find config files and look at linked servers?aaa |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-23 : 15:31:36
|
| in the reportmanager directory. location depends on where you installed it to.see here: http://technet.microsoft.com/en-us/library/ms159133.aspx |
|
|
|
IvanMD1
Starting Member
5 Posts |
Posted - 2009-11-24 : 07:14:45
|
| The solution to that problem was found in Reporting Services Configuration Manager. A new account had to be created in Windows Service Identity section. Thanks Russell.aaa |
|
|
|
|
Windows Authentication vs SQL Server 2005