<div>
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.<br />
<br />
Lee
</div>


<div>
So if I understand you correctly, I should reset the sa password and then fix what ever breaks?
</div>


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


<div>
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?
</div>


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


<div>
Right now your application is working at new migrated DB Server? or not?
</div>


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


<div>
What SBS apps are there....
</div>


<div>
sharepoint related apps like the companyweb webpage
</div>


<div>
As per my under standing you can update the password in SBS app like SharePoint.<br />
<br />
<a href="http://support.microsoft.com/kb/934838" rel="ugc">http://support.microsoft.com/kb/934838</a>
</div>


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


<div>
<div class="content wysiwyg-content">
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.
</div>
</div>


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.

SQl on SBS 2008 sa login failure

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).