asked on

Local Server, Change in Integrated Security settings falis login

I'm sure this is answered in here somwhere, I just can't seem to put it all together to find the answer.

I have a local SQL Server on a notebook PC that generally is connected to a domain at work. Friday, I changed my domain password, Local server running fine.

Today, I am trying to work from home, try to start the local SQL Server and it says "access denied or server does not exist".

My login account is not readily viewable from the Users profiles; But I believe the issue is in that the server was "created" using the old security context and now I have a new one. Where do I change this? I have tried removing and re-registering the server, but this does not work. There was also no other account setup when the local SQL Server was created, so using Sql Server login doesn't appear to be an option either.

Is there a registry key somewhere I can reset the password in?

Thanks.

SOLUTION

TimCottee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

jayrod

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

thefunnydad

ASKER

your answers were 1 minute a part and both very close to the same. I was able to get it worked out using your suggestions(s), so I split the points evenly.

Thanks for the quick response; saved me a LOT of headache today.

regards