I have a coworker in the UK using a MacBook and Oracle SQL Developer to connect to one of our SQL instances. He's having problems connecting and we think it's possibly down to a login issue, but we can't seem to figure out what the issue is.
Here's the scrubbed info:
Server name is XKY-1234 with named instance SQLDevInst. His login is part of a Windows Active Directory security group called SQLDevGrp1. So using the below image I got off of Google, I told him to enter his windows username and password at the top, then put XKY-1234;instnce=SQLDevInst in the hostname and the port in the port, then the database name in "Retrieve Database".
He can connect to the instance name. He says that's good. But he's getting the error:
Status: Failure -Test failed: Login failed for user 'user8'.
He's tested the username part several different ways. Just using "user8" or "domain\user8" or even "domain/user8." Same error. If he deliberately typos the hostname, he gets an error complaining it can't find the host. So we're pretty sure this is related to either the group login or his personal login.
The security group has access to the instance and database name in question. db_owner, in fact. I've also verified his login is a member of the security group.
He's able to connect to another MS SQL Server instance for another team, but it looks like he might be using a SQL login rather than windows authentication. And if he clicks Windows Authentication, it asks for a windows domain. Entering the domain didn't work either.
Where do I go from here? Any thoughts on what could be causing the connection problem?
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.