-
Notifications
You must be signed in to change notification settings - Fork 467
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Fail : connection with mssql server which run in remote windows server using windows authentication mode #338
Comments
You still need to set the username+password, it won't actually use the windows credentials for the run-time user. You may need to set |
@tracker1 Thanks for your reply,
Error Details are Below.
And sql server Event Viewer showing
But SQL sever can logged using SCL\sccmadmin in windows authentication mode |
I found the solution just used like below code.
|
If you need to use windows integrated security without providing username and password you should use the driver "msnodesqlv8" as mentioned here : But in order to use this driver you will need to have the SQL Server Native client installed in your machine, else you are going to receive this error message : Instructions bellow : Installation instructions can be found under : https://www.microsoft.com/en-us/download/details.aspx?id=29065 the section : "MICROSOFT SQL SERVER CONNECTIVITY FEATURE PACK COMPONENTS" To check if the client was properly installed follow the steps bellow :
|
Thank you posting this guide, I'm closing this as it seems to be resolved. |
Thanks @mafais your solution worked for me as well. |
@JedatKinports Would it be possible to share a sample config? I'm struggling with my sample
|
@JedatKinports I think got it... {
"host": "dbHost",
"database": "dbName",
"driver": "msnodesqlv8",
"connectionString": "Driver={SQL Server Native Client 11.0};Server=dbHost;Database=dbName;Trusted_Connection=yes;",
"dialectOptions": {
"trustedConections": true
}
} Seems like patriksimek shared a proper configuration without a {
"driver": "msnodesqlv8",
"server": "db3dev",
"database": "EForms",
"options": {
"trustedConnection": true,
"useUTC": true
}
} |
what if you are on a linux server. msnodesqlv8 does not work. any other integration options? Azure has a token |
My case is I need "trustedConnection": false; then use username passwords; msnodejsv8 can do that? I just tested and don't know the syntax. Thanks |
Im try to make connection with mssql server which run in remote windows server using windows authentication mode.
But it give me connection fail error.
How to make the windows authentication for remote sql server ?
The text was updated successfully, but these errors were encountered: