Monday, March 12, 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.
AntoninThis is a multi-part message in MIME format.
--010506050301020900000107
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
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\LoginMode" or
"HKLM\Software\Microsoft\Microsoft SQL Server\<Instance
Name>\MSSQLServer\LoginMode" for a named instance (detailed in
http://support.microsoft.com/default.aspx?scid=kb;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
>
>
--010506050301020900000107
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>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\LoginMode" or
"HKLM\Software\Microsoft\Microsoft SQL Server\<Instance
Name>\MSSQLServer\LoginMode" for a named instance (detailed in
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q325022</a>). ">http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q325022">http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q325022</a>). The
values for the reg key are:<br>
1 - Windows only mode<br>
2 - Mixed mode (Windows & SQL authentication)<br>
<br>
Cheers,<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Antonin Koudelka wrote:
<blockquote cite="mid%23uTSP87FFHA.3888@.TK2MSFTNGP12.phx.gbl"
type="cite">
<pre wrap="">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
</pre>
</blockquote>
</body>
</html>
--010506050301020900000107--|||This is a multi-part message in MIME format.
--=_NextPart_000_0009_01C5182A.2893B8F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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\LoginMode" or ="HKLM\Software\Microsoft\Microsoft SQL Server\<Instance =Name>\MSSQLServer\LoginMode" for a named instance (detailed in =http://support.microsoft.com/default.aspx?scid=3Dkb;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=20
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 =3D 80004005
Code meaning =3D Unspecified error
Source =3D Microsoft OLE DB Provider for SQL Server
Description =3D Login failed for user 'sa'. Reason: Not associated =with
a trusted SQL Server connection.
Please help.
Antonin
--=_NextPart_000_0009_01C5182A.2893B8F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Thanks Mike,
It works now.
Antonin
"Mike Hodgson" 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\LoginMode" or "HKLM\Software\Microsoft\Microsoft SQL Server\\MSSQLServer\LoginMode" for a named instance (detailed in http://support.microsoft.com/default.aspx?scid=3Dkb;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 jaquesT +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907E mailto:mike.hodgson@.mal=lesons.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 =3D 80004005
Code meaning =3D Unspecified error
Source =3D Microsoft OLE DB Provider for SQL Server
Description =3D Login failed for user 'sa'. Reason: Not associated =with
a trusted SQL Server connection.
Please help.
Antonin


--=_NextPart_000_0009_01C5182A.2893B8F0--

No comments:

Post a Comment