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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Server 2005

Author  Topic 

Lextreme12345
Starting Member

3 Posts

Posted - 2013-07-11 : 01:00:19
Hi All

I 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.

Thanks
EP

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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

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 MVP
http://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
Go to Top of Page

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 MVP
http://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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

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"
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -