Skip to content
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

Connecting using "Domain" credentials when running in a workgroup #388

Closed
sarus opened this issue May 23, 2016 · 1 comment
Closed

Connecting using "Domain" credentials when running in a workgroup #388

sarus opened this issue May 23, 2016 · 1 comment

Comments

@sarus
Copy link

sarus commented May 23, 2016

I can connect to our SQL Server fine with SQL Server Authentication however when I attempt to use windows authentication by setting the domain config value to my workgroup I get the error:

SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed.

and

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. 

I'm not currently part of a domain (this is a home computer) and it's just part of a Workgroup (WORKGROUP). When using SQL Server Management Studio I can connect to the database using Windows Authentication but have not been able to do so with Tedious.

Should this be working or do I have to have an actual domain setup for Windows Authentication to work?

My config looks like this:

        this.connection = new Connection({
            userName: "WORK-DESKTOP\\Sarus",
            password: "mypassword",
            server: "WORK-DESKTOP",
            domain: "WORKGROUP",
            options:{
                port: 1433,
                database: "mydb",
                encrypt: true
            }
        });

This looks like it might be related to #246 as I am also running SQL Server 2014

@sarus
Copy link
Author

sarus commented May 23, 2016

Changing username from WORK-DESKTOP\\Sarus to just Sarus appears to have fixed the issue.

Thanks!

@sarus sarus closed this as completed May 23, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant