SQl on SBS 2008 sa login failure

darracsgr
darracsgr used Ask the Experts™
on
I migratedfrom a sbs 2003 to sbs 2008 server. I noticed immediatly that the sql sa user account was failing to login. How do I correct this. I do not know if it make any differance, but a third party software that uses SQl is also installed on the server.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Logins don't export. This is the problem with allowing external applications to rely on the sa account in SQL Server for logging in. You'll have to either change the sa password and thus break the existing application on the 2008 server and then change the applications password to match the new one, or update the old application that connect using the old sa password so it uses the new sa password. Better yet, create 2 new logins on the SQL Server so that the applications that rely on the sa account are altered to use their new respective accounts.

Lee

Author

Commented:
So if I understand you correctly, I should reset the sa password and then fix what ever breaks?
Mate One quick question what Authentication method you are using?? if you are using Mixed mode then logon to SQL using SSMS and rest the password as old one, so you dont have to change the password in your application config..
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
it is in mixed mode, I do not know the old one. the 3rd party software do appear to have thier own accounts. I have been doing some research and supect a null password. if this is the case, what problems can occur if i change the password?
In general yes, if you have to change the sa password, you will need to fix what breaks. If you can get it to use Windows authentication, you could try that. Ideally though you create separate SQL accounts and allow each app to connet using a different account. Scripting out logins can be done so you can move them from one server to another but you don't want to be exporting the sa account to another machine.
Right now your application is working at new migrated DB Server? or not?

Author

Commented:
the 3rd party db's are working fine, the SBS apps that rely on sql do not. the 3rd paty apps do have thier own accounts. When I researched the SBS issues I found that a SQL sa null password can cause these issues. SQL is not my area and I am tring to understand what will happen if I reset the password. your help is musch appriciated.
What SBS apps are there....

Author

Commented:
sharepoint related apps like the companyweb webpage
As per my under standing you can update the password in SBS app like SharePoint.

http://support.microsoft.com/kb/934838

Author

Commented:
if it were just sharepoint on a standard server I would agree with you, however sbs is a product unto itself and normal rules do no always apply. I have been told to reset the sa password - I am just tring to understand any potential problems if I do. i do appriciate your help.
If you reset the SA password nothing will happen only your sharepoint application start throwing error of DB , my suggestion reset the password and chang it to in Sharepoint application.

Author

Commented:
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial