Re: SQL Server Authentication, NOT Windows NT

I used SSMS to create the logins and assign database access, then the typical
Windows wizard for creating ODBC link on user pc.

The problem is that even though I set up the ODBC links to use SQL Server
Authentication because SQL Server won't accept our Windows logins (reads them
during setup but then won't create them), it seems like it is still trying to
use Windows Authentication since it is denying login for
MYDOMAIN\MyWindowsLogin instead of using MySQLlogin.




"Mary Chipman [MSFT]" wrote:

Can you connect with the same security credentials using another
client, such as SSMS? Are you using a DSN-less connection string?

--Mary

On Tue, 17 Nov 2009 23:27:01 -0800, Rondy
<Rondy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi all,

Running Windows 7 / SQL Server 2008 / Office 2007 (12) -- I set up ODBC with
SQL Authentication, specifiying a user name and password that connects just
fine when setting up ODBC and testing connection... but when I try to run the
Access database front-end, I get this message:

Connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'MYDOMAIN\MYWINDOWSLOGIN'.

But I was using SQL Authentication... whatever, right? Click OK on message,
SQL Server Login window opens, unclick Trusted Connection, input SQL
Authentication Login ID and Password, click OK... exact same message comes up
like I'm trying to connect using my Windows credentials.

How can I make it take the SQL Server creds? My SQL server is already set
to mixed authentication, FYI.

Any help would be greatly appreciated, thanks!
.

.

Relevant Pages

  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Kerberos / Authentication to SQL2K
    ... use Windows integrated security for database access. ... That SQL Server be running on the same computer as IIS. ... > authentication until I switched on impersonation either. ... > When set up on my web server however, I get the "Login failed for user ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Granting permission to a database - need help
    ... Windows authentication, and not use an application login, as then ... Links for SQL Server Books Online: ... USE Driver Access ...
    (microsoft.public.sqlserver.programming)
  • Re: ODBC worked until Server reboot defaulted to windows authentic
    ... I got the exact spelling of the windows login with the case and I rebooted ... The odbc source is set up in windows and that connects on the test. ... The SQL Server Mgmt studio connects also but only as Windows authentication. ...
    (microsoft.public.sqlserver.setup)