SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Server 2005
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Lextreme12345
Starting Member

Fiji
3 Posts

Posted - 07/11/2013 :  01:00:19  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 07/11/2013 :  01:06:38  Show Profile  Reply with Quote
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

Fiji
3 Posts

Posted - 07/11/2013 :  01:58:15  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 07/11/2013 :  02:04:53  Show Profile  Reply with Quote
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

Sweden
29908 Posts

Posted - 07/11/2013 :  03:29:43  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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

Fiji
3 Posts

Posted - 07/11/2013 :  04:38:12  Show Profile  Reply with Quote
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

India
2 Posts

Posted - 08/10/2013 :  01:30:42  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000