I upgraded my existing sql 7 database system to sql 2005 and it seems that everything is fine. But when i tried to connect using the existing program we used in sql 7 i experienced some log-in failure(i use sa user). The strange thing is that when i change
the password to numeric i can successfully log-in to database, but setting the password to character that's the time i experienced log-in failure. It seems that there is a problem with the datatype configuration. By the way i already set the security to mixed
mode. Some help much appreciated. Thank you.
View Complete Post