Azure SQL Database
An Azure relational database service.
5,134 questions
Login failed for user
![](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(233.6, 8%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rishabh Kumar
1
Reputation point
I am running the script as mentioned below via batch file and I am getting error.
Script:
sqlcmd -S servername.company.edu -U first.last@mathieu.company .edu -P password
-G -s "|" -i "c:\Users\fl1\Desktop\Test.sql" -o "c:\Users\fl1\Desktop\output.txt"
Error:
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user ''
Can someone advise what could be the issues here? Since I have tried the double quotes, single quotes, and no quotes around username and password but none worked.
{count} votes
-
![](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(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma 17,571 Reputation points2021-03-10T03:35:06.217+00:00 Hi @Rishabh Kumar , welcome to Microsoft Q&A forum.
***(-G )***is used for Azure Active Directory Authentication. Could you please confirm if you set the user(first.last@mathieu.company .edu) as the Active Directory Admin for the Azure SQL Server?
Also can you please try running the same from command window once and see if you are getting the similar error?
After I set up the Azure Admin I was able to run the command successfully.
Sign in to comment