1

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

Pablo
  • 7,249
  • 25
  • 68
  • 83

2 Answers2

1

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.

mrdenny
  • 27,074
  • 4
  • 40
  • 68
  • 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. – Pablo 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. – Pablo 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. – Pablo Aug 30 '09 at 00:09
  • No there not. Windows accounts and SQL Accounts are completely separate. – mrdenny Aug 30 '09 at 00:53
0

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

Pablo
  • 7,249
  • 25
  • 68
  • 83