Login to SQL Server

S

SF

Hi,

I have an ADP project (2003) that link to SQL Server 2005. The Front end
works very well except that there is no login screen. Anyone use the front
end will be given the windows login name (trusted to SQL Server). Is there a
way to provide Login form so that user can specify different login name
rather than default windows login?

SF
 
N

Norman Yuan

If your users are in a domain netwwork, using Windows Authentication to
connect to SQL Server is desired way. If there is particular need in this
application that you want user to connect to SQL Server with different
user/login from their Windows user account, you could look into
CurrentProjecct.OpenConnection()/CloseConnection() method to close existing
connection with windows authentication and open new connection with SQL
Server login (supplying username/password). Then you can build your own
login form on top of it.

However, I really do not see much point of doing that with ADP in a LAN
environment (unless you are in peer-to-peer network).
 

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

Connect to SQL Server from A2k 4
SQL Express Login Prompt From Access 2007 ADP 1
Get domain username 2
Connection Type for ODBC Link to SQL/ADP 4
SQL Server Login 1
.mdb or .adp which is best to use with SQL 2K 10
Additional SQL Link Fails for Trusted Logon 6
SQL Server Error 18456 1

Top