Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lextreme12345
Starting Member
3 Posts |
 Posted - 2013-07-11 : 01:00:19
|
| Hi AllI am new to this forum requesting for some assistance.I look after IT for few Companies. 1 of my Clients, they installed a payroll software from a individual few years ago when I wasnt present with them.The individual designed his own software and uses MYSQL 2005 who also provides support to his clients. Recently, he just departed from the country with no one to continue his work. My client are in problem.MYSQL Server 2005 is installed on a Server and the Payroll software is installed on client PC.Just today, somehow, the Application started to pop up error with something like "invalid password for 'sa'". We can log into the MYSQL with 'sa' as username and a password but it seems we cannot enter into the application. We tried other user names but still it shows same error. Unfortunately, this application was installed and used in only 1 PC. We can create another database in the Main DB and log in but cannot open old.Is there anyway to get around this.ThanksEP |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-11 : 01:06:38
|
| looks like password expired for it. Do you've any admin accounts of the box in which sql was installed. If buitin administrator group is not removed from sql server you should be able to login using one of the accounts into sql management studio and it will have sysadmin access too.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
Lextreme12345
Starting Member
3 Posts |
Posted - 2013-07-11 : 01:58:15
|
quote:
Originally posted by visakh16
looks like password expired for it. Do you've any admin accounts of the box in which sql was installed. If buitin administrator group is not removed from sql server you should be able to login using one of the accounts into sql management studio and it will have sysadmin access too.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Hi,I can log into the sql management studio using the 'sa' account and also have created a new account but I am unable to log into the application using same.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-11 : 02:04:53
|
quote:
Originally posted by Lextreme12345
quote:
Originally posted by visakh16
looks like password expired for it. Do you've any admin accounts of the box in which sql was installed. If buitin administrator group is not removed from sql server you should be able to login using one of the accounts into sql management studio and it will have sysadmin access too.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Hi,I can log into the sql management studio using the 'sa' account and also have created a new account but I am unable to log into the application using same.Thanks
check configuration file and see if its not having an expired password.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-07-11 : 03:29:43
|
SA account doesn't expire. It's either available or not.I am little worried since you write MYSQL. Are you using Oracle MySQL, or Microsoft SQL Server?If you are using SQL Server, please check to see if the default database hasn't changed, and that the default database is present.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Lextreme12345
Starting Member
3 Posts |
Posted - 2013-07-11 : 04:38:12
|
quote:
Originally posted by SwePeso
SA account doesn't expire. It's either available or not.I am little worried since you write MYSQL. Are you using Oracle MySQL, or Microsoft SQL Server?If you are using SQL Server, please check to see if the default database hasn't changed, and that the default database is present.
N 56°04'39.26"E 12°55'05.63"
Hi.Sorry but it is Microsoft SQL Server 2005.I can log into the sql management studio using the 'sa' account and also have created a new account but I am unable to log into the application using same.The DB is there and I am able to create another DB in main DB and successfully log in but I still cannot open old DB. Giving 'sa' account error.Thanks |
|
|
|
Vikashvicky
Starting Member
2 Posts |
Posted - 2013-08-10 : 01:30:42
|
| Microsoft MCTS SQL Server 2005 Boot Camp:he MCTS: SQL Server 2005 certification course has been specifically designed to teach candidates how to implement and maintain information systems that incorporate Microsoft’s SQL Server 2005.A certified MCTS: SQL Server 2005 professional has in-depth knowledge of SQL Server 2005, and knows how to use Transact-SQL language. Microsoft MCTS SQL Server 2005 Boot Camp, MCTS SQL Server 2005 Training Course, Microsoft MCTS SQL Server 2005 Training and lot more professional boot camps courses at 70% the prices in US or UK at Gurgaon based center in India. We provide world class training facilities by highly qualified and vendor certified faculty. Contact us for more offers and details.Best Regards,Vikash Kumar |
|
|
|
|
|
|
|
|
SQL Server 2005