Connectivity problem after SP4 !!

[Jackcipk]

I am in the process of updating my SQL 7 with sp4, which runs on NT4 sp6. I have users running FoxPro as FrontEnd program connected with SQL server. We use Windows NT Authentication for SQL Server.

After sp4 is installed, we have following error when users try to run the FoxPro program to connect the server.

Connectivity Error: [Microsoft][ODBC SQL Server][SQL Server]Login failed for user 'domainname/username'.

It seems to be the driver problem, but when I logon from user's desk with any account with administrator right, the ODBC connection is okay, program is running.

By the way, the SQL driver on server (after sp4) is 3.70.1063; driver on user machine (most Window98) is 3.70.0623.

Did anyone have same problem when you installed the sp4? Any easy solution ?

Thanks in advance,

Jack


It's not about whether you can do it or not, it's about HOW
OK, Let's Do It !!!
jliu@Cipk.com

 

[Jackcipk]

Never mind... I figured it out, The security setting was messed up during the installation. It's not about whether you can do it or not, it's about HOW
OK, Let's Do It !!!
jliu@Cipk.com