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
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
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.