Cant manage SQLServer after office move

[coderanger]

We have just moved our Vault Server (with SQL Server 2008) to another office which is on a different domain and I cannot login to SQL Server to manage it anymore.

Have you got any suggestions as to how to resolve this?

What would the Vault SQL Server user name and password be, perhaps I can login with that and create a new account?

[lbauer]

Are you having a problem logging into Vault or logging directly into SQL Server?

What kind of error do you get?

How did you move your Vault server and SQL Server?

[coderanger]

Vault is working fine, however I cannot 'manage' the sql server instance and no backup maintenance plans are able to run.

It is a brand new rack machine with just Vault and SQL Server 2008 installed on it (bought just for Vault).

When I try and login it just says "Login failed"

I unplugged the machine, transported it 300 miles and plugged it into the new office, then joined the new domain.

Is their a Vault SQL Server login and password that I can use to login?

[lbauer]

I'm not a SQL Server expert for issues outside of Vault, but I do know that if you're using Windows authentication, Windows domain accounts in SQL Server would be from the previous domain (domain\username), and would not work on the current domain.

For instance, your current new domain account would probably not be a login for your SQL Server.

If you have mixed authentication, both Windows and SQL Server, you could login with the SA account. If you don't have mixed authentication already enabled, you probably won't be able to log in to change it.

The only Vault account that you could login as would be sgvaultuser, and that's only if you have SQL Server authentication enabled. Sgvaultuser uses the same password as Vault admin account. However sgvaultuser does not have administrative privileges.

You recall what kind of authentication you have?

[coderanger]

ah, ok, thanks

[coderanger]

I managed it thanks. This link worked:
http://msdn.microsoft.com/en-us/library/dd207004.aspx

It allowed me to go in, delete the old "OLDDOMAIN\Administrator" logins and add new "NEWDOMAIN\Admininstrator" logins. Hurrah!!

[lbauer]

Thanks for the update. That's good news. : )

Also, thanks for the link. It will be useful to other customers