This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 80%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Hi Everyone,
I'm trying to login to SQL Server using Python pyodbc library and I have the different domain windows credentials.
How can I login to SQL server using Python for different domain credentials?
I am able to connect using cmd runas/netonly/user command.
Kind Regards,
Maddy
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @MADHUSUDAN PANWAR ,
Welcome to Microsoft Q&A! Wanted to ask if you are using Azure SQL Server? If so, I will add the appropriate tag for you.
Best regards,
Seeya
Hi Seema,
I'm trying to connect to on-prem SQL server.
Kind Regards,
Maddy
Hello everyone,
I was able to login to sql server using windows credentials with the help of pymssql library and without using runas command. You can go through its official documentation here
Incase it helps someone in the future.
Kind Regards,
Madhusudan
Great to see that you got it solved. I guess it is performing a new WIndows login under the covers.
Your question is a bit unclear. What do you mean with "different domain credentials?"
If you mean that you are logged on to windows as DOMAIN1\USER1 and you want to connect to SQL Server DOMAIN2\USER2, the best option is probably to start the Python script with RUNAS. There is no way that you can specify through ODBC (or any other client API for that matter) that you want to use a different Windows user. For this to be possible, the other user must be authenticated by Windows. SQL Server cannot do that. It can only accept the token of a user what Windows has already authenticated.
I use runas /netonly /user:domain\username ssms.exe to login through SSMS using different windows credentials.
But when trying to login through Python, then I'm using below command
import pyodbc
server = 'tcp:myserver.database.windows.net'
database = 'mydb'
username = 'myusername'
password = 'mypassword'
cnxn = pyodbc.connect('DRIVER={ODBC Driver 18 for SQL Server};SERVER='+server+';DATABASE='+database+';ENCRYPT=yes;UID='+username+';PWD='+ password)
cursor = cnxn.cursor()
But it's not letting me connect like this. If I give trusted_connection='yes' in pyodbc.connect string then it takes existing windows credentials.
Is there any other way to connect rather than running python.exe with the help of runs command?
@MADHUSUDAN PANWAR , it seems from the server name in your comment you may be using Azure SQL Database. Add the azure-sql-database tag to your question for context and visibility.
The form you have in the connection string is for SQL authentication. You cannot log in Windows authentication to SQL Server by giving the name of a Windows user and password.
If you want to log in with a different Windows user to SQL Server, you must first log on with that login to Windows. The way I know how to do this is with RUNAS. If there are other ways? That's a question for a Windows forum. (And for that question it's entirely irrelevant that you want to connect to SQL Server.)
Now, as Dan points out, you seem to be connecting to an Azure SQL Database. In that cases, there are options through Azure Active Directory, which is a different story. But there is notihng in your question that touches AAD what I can see.
Thanks for your response.
I'm not trying to connect to Azure SQL DB but on-prem SQL Server using alternate domain windows credentials.
And I highly agree that RUNAS command works but I want to pass my alternate domain windows credentials in python script.
There are two libraries to connect to on-prem sql server one is pyodc and other is pymssql. Not sure, how to pass my alternate windows credentials using those two libraries. As per your comment, the two libraries won't support passing different domain windows credentials, right?
If you want to do this in Python, you need to do the same as Runas. That is, you need to create a new process which is a new login into Windows. You can only log into SQL Server with a Windows login, if you first have logged on to Windows with that Windows user.
Which Python library you use does not matter,
Hi @Erland Sommarskog ,
I was able to achieve the same without using runas command. Please look at my answer below.
Kind Regards,
Madhusudan