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.

Can I use the administrator user of a remote (no domain or anything like that) Windows Server to log in into the SQL Server running on that same machine? That would be, using the same credentials, user and password, as I use when I connect to that server with Remote Desktop.

Is there anything special I should do for that?

I'm talking about SQL Server 2008 and Windows Server 2008

share|improve this question

2 Answers 2

If the username and password that you are logging into your local computer with, are the same as a username and password that exist on the SQL Server then yes.

If the username and/or password are different then no, you can't specify a Windows account and password when connecting using Windows Authentication.

share|improve this answer
    
Well, I don't care about using Windows Authentication or SQL Authentication (actually, I wasn't even trying with Windows Authentication), but I do care about using the same account, the same credentials, user and password, as when using remote desktop. –  J. Pablo Fernández Aug 29 '09 at 23:27
    
But Windows Authentication is exactly what you asked for. Otherwise you would have to set up an SQL username/password combo that looked the same, but would not actually be the same –  Mark Henderson Aug 29 '09 at 23:33
    
Farseeker, I've corrected my question now. I want to log in into SQL Server with my SQL Management Studio using the same credentials I use for logging into that machine with Remote Desktop. –  J. Pablo Fernández Aug 29 '09 at 23:41
1  
That would be the same Windows account using Windows Authentication. The only way to do that would be to create an account on the machine you are running SSMS on with the same username and password as the account on the other machine. Then run SSMS under that account by either logging onto your machine with this account, or by launching SSMS under this account by using the runas function of Windows. –  mrdenny Aug 29 '09 at 23:52
    
So, there's no way to connect to a SQL server using SQL Auth without having to create a SQL Auth user, but using the Windows user I already have at that machine. –  J. Pablo Fernández Aug 30 '09 at 0:09
up vote 0 down vote accepted

As far as I could find, there's no way to use the Windows credentials to log into SQL Server.

share|improve this answer

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.