Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My SQL Server 2008 is located on a remote computer so I am trying to create an ODBC connection using SQL Server Authentication.

My problem is that the way i normally connect to my SQL Server is by doing a remote desktop connection and then I just connect using windows authentication so I don't know what my SQL Server Username and Password are.

Is there anyway I can find out what my Sql Server Authentication username is so I can maybe reset my password?

All I am trying to do is to create an ODBC connection usnig SQL Server Authentication since I can't use Windows Authentication since the SQL Server is on a remote Windows Server computer (or can I?)

share|improve this question
up vote 1 down vote accepted

You can ask the Database Administrator for the environment what your SQL Server Login details are for using SQL Server Authentication.

Alternatively, you could connect to the SQL Server Instance via RDP and Windows Authentication and then create a new SQL Server Login for you to use remotely.

To confirm, you cannot use Windows authentication remotely (from outside of the domain the instance resides in) unless you are connecting from a domain with a trust relationship defined.

share|improve this answer
Awsome. Thanks! – PokerPlayer23 Jun 11 '12 at 17:39

if your windows user has sysadmin privilege> login to your server as you do and after you login to your sql server using SSMS, go to security>logins>sa double click on sa and reset your password

Reset SA password

share|improve this answer
Perfect! thank you! – PokerPlayer23 Jun 11 '12 at 17:41

Your Answer


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.