Is it possible to open a SQL Server connection using domain credentials that
are not your own? In ODBC dialog, you have the option for Windows
Authentication (your own domain account - this works, but not what I want)
or SQL Authentication.
In SQL Server, I have a login created as a domain account and it shows
correctly in SSMS as domain\username.
When trying to create an ODBC connection using domain\username, I get "Login
failed for domain\username".
If I create a SQL login as just username, it works. But, I really want to
have a domain account login.
Is there a way to make this work short of having to login as the domain
account I am trying to configure?
Re: Cant Connect ... Then it's likely the authentication settings on the IIS side ... Try adding the IUSR account as a login in SQL Server... > Cn.open CnStr... (microsoft.public.sqlserver.connect)
Re:changing sa password / login ...authentication and it worked. ... >I think you might have made changes to SQL Server... >Authentication" can not recognize SA login which is SQL ...>configuration to use mixed authentication. ... (microsoft.public.sqlserver.security)
Re: Security question .. ... > If you use NT authentication, a user's permissions to a database are ... Your assertion that a user's permissions are independent of the application ... Even using Access and "exploring" will require an ODBC login to SQL Server.... (microsoft.public.sqlserver.server)
Re:changing sa password / login ... I think you might have made changes to SQL Server... to make was using Mixed Authentication which will ... Authentication" can not recognize SA login which is SQL ...configuration to use mixed authentication. ... (microsoft.public.sqlserver.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)
