Monday, March 19, 2012

msde login problem

I installed MSDE in my computer. When I try to connect to a database from a
program I get an error message:
Code = 80004005
Code meaning = Unspecified error
Source = Microsoft OLE DB Provider for SQL Server
Description = Login failed for user 'sa'. Reason: Not associated with
a trusted SQL Server connection.
Please help.
Antonin
By default, MSDE is installed with Windows Authentication only. So
unless you've changed it to mixed mode you'll only be able to login with
trusted logins (not 'sa'). To change to mixed mode you have to change a
reg value, viz.
"HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\L oginMode" or
"HKLM\Software\Microsoft\Microsoft SQL Server\<Instance
Name>\MSSQLServer\LoginMode" for a named instance (detailed in
http://support.microsoft.com/default...;EN-US;Q325022). The
values for the reg key are:
1 - Windows only mode
2 - Mixed mode (Windows & SQL authentication)
Cheers,
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Antonin Koudelka wrote:

>I installed MSDE in my computer. When I try to connect to a database from a
>program I get an error message:
> Code = 80004005
> Code meaning = Unspecified error
> Source = Microsoft OLE DB Provider for SQL Server
> Description = Login failed for user 'sa'. Reason: Not associated with
>a trusted SQL Server connection.
>Please help.
>Antonin
>
>
|||Thanks Mike,
It works now.
Antonin
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:eThC6n8FFHA.2156@.TK2MSFTNGP09.phx.gbl...
By default, MSDE is installed with Windows Authentication only. So unless you've changed it to mixed mode you'll only be able to login with trusted logins (not 'sa'). To change to mixed mode you have to change a reg value, viz. "HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\L oginMode" or "HKLM\Software\Microsoft\Microsoft SQL Server\<Instance Name>\MSSQLServer\LoginMode" for a named instance (detailed in http://support.microsoft.com/default...;EN-US;Q325022). The values for the reg key are:
1 - Windows only mode
2 - Mixed mode (Windows & SQL authentication)
Cheers,
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Antonin Koudelka wrote:
I installed MSDE in my computer. When I try to connect to a database from a
program I get an error message:
Code = 80004005
Code meaning = Unspecified error
Source = Microsoft OLE DB Provider for SQL Server
Description = Login failed for user 'sa'. Reason: Not associated with
a trusted SQL Server connection.
Please help.
Antonin

No comments:

Post a Comment