Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.



Windows 7: Access & ODBC connection issue on W7 Home, State 11

02 Dec 2013   #1

Windows 7 Pro x64
 
 
Access & ODBC connection issue on W7 Home, State 11

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 Windows 7 Pro...
Thanks

My System SpecsSystem Spec
.

03 Dec 2013   #2
Microsoft MVP

Windows 7 Ultimate x64
 
 

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.
My System SpecsSystem Spec
06 Dec 2013   #3

Windows 7 Pro x64
 
 

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.
My System SpecsSystem Spec
.


06 Dec 2013   #4
Microsoft MVP

Windows 7 Ultimate x64
 
 

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
My System SpecsSystem Spec
09 Dec 2013   #5

Windows 7 Pro x64
 
 

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.
My System SpecsSystem Spec
Reply

 Access & ODBC connection issue on W7 Home, State 11





Thread Tools



Similar help and support threads for2: Access & ODBC connection issue on W7 Home, State 11
Thread Forum
odbc connection win7 pro to unix Network & Sharing
how to establish a ODBC connection in Windows 7 64 bit ? Network & Sharing
ODBC connection problem Network & Sharing
Wireless Connection can't reconnect after Hibernate state. Network & Sharing
ODBC Issue Network & Sharing

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 12:10 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33