Username and Password Pop-Up

  • Thread starter Thread starter mroks via AccessMonster.com
  • Start date Start date
M

mroks via AccessMonster.com

Hi Guys,

Could you please help me on my problem?

im using ODBC connection on SQL server as backend and MS Access as frontend,
however whenever i tried to connect on on ms access, it always pop the
Microsoft SQL Server Login and i had always login my username and password
just to connect on SQL Database, is there any way to remove that error. so
the user could use it normally.

Regards,
edgar
 
When you set up the ODBC connection, if you specify "With Windows NT
authentication using teh network login ID", it will use the built-in
authentication based on the user's credentials, assuming your SQL server
instance is set up to allow that type of authentication.
 
When you set up the ODBC connection, if you specify "With Windows NT
authentication using the network login ID", it will use the built-in
authentication based on the user's credentials, assuming your SQL server
instance is set up to allow that type of authentication.
 
Michael,

Is there other way to resolve my problem?

thanks,
edgar
When you set up the ODBC connection, if you specify "With Windows NT
authentication using the network login ID", it will use the built-in
authentication based on the user's credentials, assuming your SQL server
instance is set up to allow that type of authentication.
Hi Guys,
Click to expand...
[quoted text clipped - 8 lines]
Regards,
edgar
Click to expand...
Click to expand...
 
mroks via AccessMonster.com said:
Hi Guys,

Could you please help me on my problem?

im using ODBC connection on SQL server as backend and MS Access as
frontend,
however whenever i tried to connect on on ms access, it always pop the
Microsoft SQL Server Login and i had always login my username and password
just to connect on SQL Database, is there any way to remove that error. so
the user could use it normally.

Regards,
edgar
Click to expand...
 
Back
Top