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.
AntoninBy 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\MSSQ
LServer\LoginMode" or
"HKLM\Software\Microsoft\Microsoft SQL Server\<Instance
Name>\MSSQLServer\LoginMode" for a named instance (detailed in
http://support.microsoft.com/defaul...b;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:eTh
C6n8FFHA.2156@.TK2MSFTNGP09.phx.gbl...
By default, MSDE is installed with Windows Authentication only. So unless you've chang
ed it to mixed mode you'll only be able to login with trusted logins (not 'sa'). To ch
ange to mixed mode you have to change a reg value, viz. "HKLM\Software\Microsoft\MSSQLS
erver\MSSQLServer\LoginMode" or "HKLM\Software\Microsoft\Microsoft SQL Server\<Instance
Name>\MSSQLServer\LoginMode" for a named instance (detailed in http://support.mic
rosoft.co...b;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