Situation: There is a SQL 2008 instance here that we would like access to. The person who setup the instance is no longer with the company and, apparently, did not set the instance up with the proper users as admins. However, the proper users are admins on the machine that is running the SQL instance.
Some informative links I've been able to dig up on the subject are included here for reference. All have been tried and the results are mentioned below.
('h' omitted per serverfault's rule against new users posting more than one hyperlink) [fixed by edit]
When the disaster flag or single user flag is used to attempt to gain access the following error is still generated:
LOGIN FAILED FOR USER XXXX Error 18456
Any idea what the problem is with the solutions we're trying? If it matters the machine is on a totally different domain (across the world even) and attempts to login as the the service that we set to run the SQL instance (we have that password, btw) fail as well.
Thanks in advance for your time.