Access & ODBC connection issue on W7 Home, State 11

bulletng · 02 Dec 2013

I have two laptops at my company that have Windows 7 Home - thus cannot login to AD/Domain as a specific user. They in-turn use a local administrative account setup on those laptops. We have a database setup with linked connections to our SQL Server 2005.

Whenever we're trying to access those linked tables we get the following error message:

We can bypass this issue by manually typing in the Login/Password within this error prompt.

What's strange is that we have ODBC setup to use the SQL Server Authentication:

That SHOULD allow us to not use Windows Authentication (as you can see it's trying to use the 'Guest' account on Windows 7. I've tried making this change through both x32 and x64 versions of ODBC (located in wow64). I've searched all over the internet concerning this issue but no one seems to have anything similar. This used to work a few weeks ago and I don't know of anything we changed other than a few system updates.

The SQL Server's Security is setup to use both authentication methods:

Our SQL Server gives us an Error: 18456, Severity: 14, State: 11

A quick Google search explains that State 11 means, "Valid login but server access failure".

Any help please? The only solution I have right now is to install W7 Pro...
Thanks

HiTechCoach · 03 Dec 2013

Sound like a Windows permissions issue to see the SQL server.

You could also map a network drive using other credentials. This will authenticate the computer onto the domain.

bulletng · 06 Dec 2013

What do you suggest I do? I've attempted to map & browse the server via Explorer but it will not take any Domain Account I put in! I'm not exactly sure what to do at this point...I've checked the security permissions on the directory I'm trying to access to no avail.

HiTechCoach · 06 Dec 2013

I assume you are checking ht box "Connect using different credentials:

Since the laptop is not a member of the domain the domain is is using is the local PC. This means you must specify the domain to use to authenticate the user to log into the mapped drive.

Here is the trick to getting this top work:

When it ask for user name you will need to include the domain.

Example format:

DomainName\UserName

bulletng · 09 Dec 2013

I tried that and it still won't allow me to map the network drive. I can't even browse to that specific shared folder although I can see it. The permissions are set correctly on that share. I will try to get some screenshots soon.