UID in linked table (1 Viewer)

[Davef28]

I have an ODBC that l inherited. It is used to link to SQL tables. When the users use the app they get straight in. We have now replaced our server. I changed the ODBC to look at the new server and re-linked all the tables. However it is now asking for a password when the users first go in, whereas it did not in the past. Any ideas plse ?

 

[WayneRyan]

Dave,

One of the options (maybe the 3rd panel or so) is for the type of
database connection. It specifies whether to use a username/password
or use a Trusted_Connection.

Try the Trusted_Connection.

Wayne

 

[WayneRyan]

Dave,

Their verbage is "Windows NT Authentication".

Wayne

 

[Davef28]

Tried that

The NT userids do not have the authority and we don't want them to.