Re: SQL and Local user authentication
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/07/03
- Next message: J: "Phantom User or Role"
- Previous message: Bill R.: "Re: Cannot add new NT login"
- In reply to: MyaTix: "SQL and Local user authentication"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 7 Aug 2003 08:58:29 -0400
A local account is just that, local to that machine. Sql server can not
authenticate an account that is not a domain account. If you don't want to
give it a domain account then you can use SQL Logins instead.
-- Andrew J. Kelly SQL Server MVP "MyaTix" <bloggs@hotmail.com> wrote in message news:036201c35cd5$d4071810$a001280a@phx.gbl... > Hi, > > Can someone please tell me how I do the following... > > I am trying to create an odbc connection from a iis member > server to a sql server but I'm having problems with > authentification. The server is on the domain but I want > to use a local account as the authentication account to > create the odbc connection between the sql server and the > iis. How do I do this??? > > I have tried adding the local account to the database but > I can only seem to be able to add domain accounts to the > sql server, is there a way to do this and if so how? > > Thanks!
- Next message: J: "Phantom User or Role"
- Previous message: Bill R.: "Re: Cannot add new NT login"
- In reply to: MyaTix: "SQL and Local user authentication"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
