| Author |
Topic |
|
casper
Starting Member
5 Posts |
 Posted - 2008-07-30 : 19:13:01
|
| May be an simple question, but driving me crazy...Something out in my network is trying to connect to a DB that does not exist any longer on the 24th and 50th minuet of ever hour. When it cant connect it throws the following error in my application log:#50070: Unable to connect to the database DBNAME on SERVERX. Check the database connection information and make sure that the database server is running.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.I believe this may be the root of problems that are happening elsewhere but cannot figure out for the life of me where the connection attempts are coming from. If I can get a hold of the workstation that is making the calls my problem will be solved. Finding it is the problem.Any help would be greatly appreciated.Cas... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
casper
Starting Member
5 Posts |
Posted - 2008-07-30 : 20:02:09
|
| There is no field for host name... I was able to catch the call, but nothing identifying the source.... |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-30 : 20:09:21
|
| I'm not sure what you mean by there not being a field for hostname. There certainly is. Did you select the option to include that column in your trace?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
casper
Starting Member
5 Posts |
Posted - 2008-07-30 : 20:46:56
|
| That might help... sigh.. not the DBA trying to play one though... :)Thanks for all your help!Cas... |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-30 : 21:12:36
|
| Maybe through Linked server. Try to run batch file to track I.P.Usually i run batch file through windows scheduler task to track What I.p is connecting to my server. But donno about database. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-30 : 22:44:28
|
| >> Finding it is the problem.Can take look ay security event log on sql server, may have entries there. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-07-31 : 11:43:16
|
| By default, SQL Server will give you the IP address of the originator of the failed login in the errorlog. Nothing there? |
|
|
|
casper
Starting Member
5 Posts |
Posted - 2008-07-31 : 13:30:15
|
| Update:I was able to find out, due to your help, that its ther SQL server its self creating these errors,and sharepoint is the culprit, but am still unable to figure out why sharepoint services is making the call. As i said im not the DBA... where can i find what jobs are running at any given time?TIACas... |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-31 : 13:52:51
|
| You can use this:select x.name from dbo.sysjobs x inner joindbo.sysjobactivity y on x.job_id =y.job_idwhere y.run_requested_date between @startdate and @Enddate |
|
|
|
casper
Starting Member
5 Posts |
Posted - 2008-07-31 : 13:53:56
|
| nevermind.. answered my own question. Figured it out. DBA is finally back so im going to throw this at him. Turns out its not a job after all.. who knows. Back to my network! Thanks again for all the help and advice!Cas... |
|
|
|
|
Connections to non existent DBs