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
bulletng

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


My System SpecsSystem Spec
.

03 Dec 2013   #2
HiTechCoach
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
bulletng

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
HiTechCoach
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
bulletng

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
Thread Forum
Limited Access and no adapter is in the state permissible for this op.
I am running windows 7 and just recently my internet connection is no longer working. I have tried to disable and enable the adapters. I have run virus and spyware cleaners and cleaned the computer and no luck. I Reset TCP/IP stack to installation default: netsh int ip reset reset.log then I ran...
Network & Sharing
I have broplem with Netowrk icon state connection
Hello All When you connect the cable to the computer does not change the connection status icon in the task bar http://im34.gulfup.com/lEAI0.jpg
Hardware & Devices
how to establish a ODBC connection in Windows 7 64 bit ?
Hello, I have created a ODBC connection between MS Acceess 2003 and Excel 2003 in Windows 7 32bit enviroment . The Macro ( code ) is as follows : ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ "ODBC;DSN=MS Access...
Network & Sharing
ODBC connection problem
I'm running 2005 SQL server on Windows 2008 server. I have both Windows 7 and XP ODBC connections to the server. Everything was working fine but the server was running slow so I tried a windows update. The update made my ODBC connection go flakey, but only on Windows 7. Testing the connection would...
Network & Sharing
Installing 64-bit Home Premium with both Solid State/Regular Harddrive
So here's the thing. I'm installing my actual Winodws 7 OS onto a solid state drive, but I'm installing most everything else on my computer to the regular drive. The reason for this is so that I can have windows 7 (and perhaps one or two programs) running wonderfully fast on the solid state,...
Installation & Setup
Wireless Connection can't reconnect after Hibernate state.
Hey guys, I just have been wondering this for the longest time. Ever since I've had Windows Vista (I now have Windows 7 Ultimate x86), the Wireless signal can never be re initialized after coming back from the hibernation state. I've tried playing around with the power settings for the network...
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 07:53.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App