Locked Out of Local Instance

I have a company owned laptop that has SQL Server 2005 loaded. I am running
Windows XP Pro, SP2. SQL was loaded for me by a non-DBA, standard computer
support tech. I did not set it up.

I have been in and out of that instance for a year and a half as I learn and
develop my SQL skills.

This week I deleted an old database that I no longer use. I now no longer
have any access to my own local instance. I had been using the Windows
Authentication mode and never set up a separate personal log in. As a test,
using an Access front end, I was able to upsize a database into the instance,
but still cannot access it. I do not have the SA password. The tech who
performed the install doesn't even remember setting one up. Here is the
error message I get.


TITLE: Connect to Server
Cannot connect to (laptop name/number).
ADDITIONAL INFORMATION:
Login failed for user 'domain\user name'. The user is not associated with a
trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)


I have tried a suggestion to go through the command prompt. That did not
work. I tried a method of setting up in single user mode, but that did not
help, primarily because I do not have the SA password.

Any suggestions before I have computer support do a complete new install?
.

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • c++ application causes an error
    ... The program was written to connect to a microsoft SQL server 7.0 database ... either my windows 95 or windows 98 box, I get the following error message: ... Is there some way to fix this error message with a patch or update of the ...
    (microsoft.public.vc.database)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
    (microsoft.public.windowsupdate)