Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

2 Answers

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! –  JuanVelez Jun 11 '12 at 17:39
add comment

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! –  JuanVelez Jun 11 '12 at 17:41
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.