Manual prompt needed for SQL database Authentication

R

Randy K

We have a couple of developers using MS Access with linked views to a SQL
2000 database. Traditionally we have used SQL Authentication a developer had
a Test_Writer login, a Test_Reader login, and his personal login. Now we
would like to transition over to Windows or Operating System Authentication.
However, when I create a OSA account for my developers they no longer get a
login prompt that would allow them to login with any of ther SQL
user/password.

Our developers need help on this one. I'm just the DBA. :)

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 Application for Reports Only – SQL Server Security 3
How to manage SQL Server authentication in Microsoft Access 2007 0
Authentication Issues 2
Issue creating sql authentication odbc system dsn 1
Credentials Prompt 9
MS access login issue 3
can't connect to my sql server from my access databases, help! 0
How to manage SQL Server authentication in Access2007 1

Top