Hi guys, I'm hoping someone here might have an idea / solution to the below.
On Monday, I went through the process of detaching and deleting a bunch of databases from our MOSS environment (these databases were duplicated and then we used the db attach method to upgrade them to SPS2010 last year) Today, tech services brought to my attention a bunch of errors in the event log (I have no idea when they started, but the oldest records are from 4am yesterday - the events registered were coming through at around 4 per second, so my guess is the event log dropped older items) Anyway, the specific errors are as follows: Login failed for user DOMAIN\Acc1. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>] (This is the DB server) Login failed for user DOMAIN\Acc2. Reason: Failed to open the explicitly specified database. [CLIENT: 10.9.30.20] (This is our IDX/CA server) I've gone through this and related posts<http://www.eraofdata.com/sql-18456-login-failures/> and set up SQL Profiler to capture some info. In all cases, the database mentioned as being unavailable is 'master' (see screenshot from SQL Profiler below). The ClientProcessID on the DB box correlates to the PID for SQLAGENT.EXE (I haven't checked the other box yet) So far, I've changed the default databases for both accounts to a different database, given both accounts 'public' and 'db_datareader' to the master database, mapped them etc. all to no avail - the errors are still coming through constantly. I'm unsure if detaching the old databases could have caused this, and I'm stumped as to how to fix it. Nigel [cid:image001.png@01CD8B6B.05D74D10] Nigel Hertz SharePoint Administrator / Developer, Information Systems Stockland, Level 22, 133 Castlereagh Street, Sydney NSW 2000 T +61 2 9035 2617 M +61 401 034 605 F +61 2 8988 2617 E nigel.he...@stockland.com.au<mailto:nigel.he...@stockland.com.au> http://www.stockland.com.au/ BEFORE PRINTING THIS EMAIL PLEASE CONSIDER THE ENVIRONMENT ________________________________ Stockland Notice: If this communication has been sent to you by mistake, please delete and notify us. If it has been sent to you by mistake, legal privilege is not waived or lost and you are not entitled to use it in any way. Stockland and its subsidiaries reserve the right to monitor e-mail communication through its networks.
<<inline: image001.png>>
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
