Hi,
I am currently working on a VBA project that links to a SQL Server 7.0
database using a connection string. When I use a SQL user account in the
connection string, everything works fine. However, when I use a SQL user
account with NT authentication , the login attempt fails every time. I have
checked all the individual settings for each user and they are exactly the
same except that 1 is a SQL verifued user and the other is an NT verified
user.
Any assistance would be appreciated,
Thanks in advance,
Paul
I am currently working on a VBA project that links to a SQL Server 7.0
database using a connection string. When I use a SQL user account in the
connection string, everything works fine. However, when I use a SQL user
account with NT authentication , the login attempt fails every time. I have
checked all the individual settings for each user and they are exactly the
same except that 1 is a SQL verifued user and the other is an NT verified
user.
Any assistance would be appreciated,
Thanks in advance,
Paul