Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

i have SQL server 2008 local installation and my xyzdomain/user has the access to the SQL server . Now my machine is moved to abcdomain and i am not able to access the Database server because the only user allowed on the DB is of different domain and my machine having the SQL server is now in different domain . PS: OS is Windows 7

share|improve this question
add comment

3 Answers

up vote 3 down vote accepted

Can you log on with the SA account ? If you don't know the password you can reset it: link text

This procedure cover how to add domain accounts to sql server. The key is to start SQL in single use mode to send sql statement as explained in the post: EXEC sp_addsrvrolemember 'xyzdomain\Myadminaccount', 'sysadmin';

Then you can restart SQL server in normal mode, connect through SQL Management Studio and add all needed accounts

share|improve this answer
    
Thanks it worked like a miracle :) –  paranjai Feb 3 '10 at 10:48
add comment

You have a few options here:

Connect to the SQL machine with a local admin account and assign your new domain account to the SQL server.

If your xyzdomain/user account is an admin for SQL, switch your machine back to the xyzdomain temporarily so that you can assign your new domain account to the SQL server.

Have someone else with administrative rights to the SQL server assign you access.

share|improve this answer
add comment

I would try to connect with the local Administrator account. It should have administrative permissions on that SQL Server.

Do you have a trust relationship between the xyzdomain and abcdomain?

share|improve this answer
    
no the domains dont have a trust relation ship . My account itself is the admin and i tried logging with local admin account too , it dosen't allows to log in –  paranjai Feb 2 '10 at 7:23
    
That is strange. Under which account do SQL server services run? Change them to run under an account from the new domain or a local account. Check also that Windows firewall does not prevent you from accessing that SQL Server. Can you move the computer back to the old domain, change security settings and than move it to the new domain again? –  Branko Feb 3 '10 at 6:49
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.