SQl on SBS 2008 sa login failure

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

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

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?

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

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

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.

Thanks