Username and Password Pop-Up

[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

 

[MichaelRay via AccessMonster.com]

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.

 

[MichaelRay via AccessMonster.com]

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.

 

[mroks via AccessMonster.com]

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,

[quoted text clipped - 8 lines]

Regards,
edgar

 

[hai]

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