Re: sa User is disabled
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 07/18/05
- Previous message: Bob Barrows [MVP]: "Re: Web Applicaiton using Trusted Connections to SQL on different machine?"
- In reply to: Deepak: "sa User is disabled"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 18 Jul 2005 19:24:29 +0100
I take it this is SQL2005 - if so you can enable it by running
alter login sa enable
-- HTH Jasper Smith (SQL Server MVP) http://www.sqldbatips.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Deepak" <Deepak@discussions.microsoft.com> wrote in message news:A0530A52-BAAF-496A-9BFB-1D1861F543EB@microsoft.com... >I have installed sql server with only window authentication mode. > Later i changed it to mixed mode but while connecting to sql server using > sql server authentication, it is giving error that sa account is disabled.
- Previous message: Bob Barrows [MVP]: "Re: Web Applicaiton using Trusted Connections to SQL on different machine?"
- In reply to: Deepak: "sa User is disabled"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
