Showing posts with label login. Show all posts
Showing posts with label login. Show all posts

Friday, March 30, 2012

MSDE SQL Agent Wont Start

Hi,
I have installed the MSDE and use mixed mode authenticaton.
The SQL Server Agent will not start due to login failures.
Normally, I would use the Enterprise Manager Managment wizard to
correct the System Account and Connection Credentials.

Can anyone tell me how to achieve this using OSQL?

Thanksthat'll be a long and very painful road...are you sure you want to go there?|||The other way to fix the SQLAgent account is through Windows Control Panel. You need "Services", one way to get to it is: Control Panel -> Administrative Tools -> Computer Management ... Services and Applications .. Services. There you can change the Properties of MSSQLAgent .|||Originally posted by ms_sql_dba
that'll be a long and very painful road...are you sure you want to go there?

We essentially have 2 systems in place. One system is a full blown installation of SQL Server 2000 (standard edition) on a server pc running windows 2000 server. This implementation includes the enterprise manager and query analyzer etc.

The second system (due to cost concern) uses MSDE with the same database and files. We do this so we can run our control system on a windows 2000 professional OS and hence keep the costs down.

I have no problem getting the SQLAgent running on a full system because I have the enterprise manager and its wizards to configure security and credentials for it. On the MSDE win2000 pro setup I do not have the tools and hence am forced to manipulate the configuration via OSQL - I will try using the control panel and services to configure it, but I am looking for a way to send the configuration via an OSQL (T-SQL script) that sets the services security to system account (Administrator) and the database login security to the SA account.

Thanks again|||Originally posted by ClayG
The other way to fix the SQLAgent account is through Windows Control Panel. You need "Services", one way to get to it is: Control Panel -> Administrative Tools -> Computer Management ... Services and Applications .. Services. There you can change the Properties of MSSQLAgent .

If I go to Administrative tools and services under SQLSERVERAGENT and properties, I can configure the security under the LOG ON tab to Local System Account. I have done this to no avail. I believe the problem exists with the fact that I use mixed mode authentication for SQL Server 2000. Using the Management Wizard under the Connection Tab, I need to specify the log in to the SQL database instance under the SA account with its respective password.
The service properties do not provide a means of specifying the credentials for the SQL Server Instance and database connection.

Regards and Thanks|||Enterprise manager should be able to talk to an MSDE instance. Is the MSDE instance not available to you, so you need to write a script?|||Originally posted by MCrowley
Enterprise manager should be able to talk to an MSDE instance. Is the MSDE instance not available to you, so you need to write a script?

Enterprise Manager is not installed- Since we are using Windows 2000 professional for this machine - which is stand alone and a completely different project. We chose to install MSDE with our standard database loaded in. I have no tools on the machine like enterprise manager to fix the issues. I need a means of deploying the security when no tools exist.

I did a search and found the following on a google group search - to which my response was as follows:

Good Afternoon,

I found your email through google_groups where you indicated the following to a user:
SQLServerAgent needs to be able to connect to SQL Server upon starting. See any errors in the sqlagent.out file. When you look in the Logins folder in Enterprise Manager, the BUILTIN\Administrators group must be granted access to the server. If the group has been removed or denied access, SQLServerAgent won't start
Sade Fashokun
SQL Server Support

My question if you don't mind answering it is as follows:

I am using MSDE on a windows 2000 professional OS installation with a default instance. SQL Server Agent will not start with the following error in the log:
Login Failed for User 'SCADA\Administrator' --

I am using mixed mode authentication and normally I would use the management wizard in Enterprise Manager under the Connection Tab to specify the SQL Agent Login
as the SA account and respective password. I do not want the Agent to Attempt a login through the windows Adminstrator account but instead through the SA or
other Database Security account.

Can you tell me how to change the Agent using OSQL etc. as I do not have the enterprise manager with MSDE -- to force it to use the SA account for the Sql Server Instance instead of the Window System Account the same as I would using the Management Wizard.|||You stated you have a full-blown installation of SQL Server (including tools). Just register your MSDE instance in the Enterprise Manager on that system. All you need is a network connection between the two boxes.|||Originally posted by MCrowley
You stated you have a full-blown installation of SQL Server (including tools). Just register your MSDE instance in the Enterprise Manager on that system. All you need is a network connection between the two boxes.

Okay, I understand that, I will try it out.
However, assume that I do not have such a system.
Is there a way to accomplish it without making such a connection
altering the login information for the agent via osql.

Monday, March 19, 2012

MSDE login problem - Windows

I'm confused.
OS = Win XP Pro
I installed MSDE2000A on a new laptop using mixed security - Windows and
SQL. Everything went fine. At the time my everyday Windows user account wa
s
set up as a Windows (not SQL) administrator, so that I could get some other
software installed, too.
I subsequently changed my Windows user account to be a power user and NOT a
Windows administrator and now I cannot connect to MSDE with that Windows
account. If I switch the account back to Windows adminstrator all is well
with MSDE.
How can I coax MSDE to recognize this user account when it is no longer a
Windows administrator?Add your windows account to the Logins for MSDE. You are
getting in due to the default behavior of SQL Server adding
BUILTIN\Administrators as a login. That would include all
logins that are members of the local admins group.
You can add your login using sp_grantlogin. You can find
more information in books online.
-Sue
On Mon, 9 Jan 2006 08:07:04 -0800, "Duke Carey"
<DukeCarey@.discussions.microsoft.com> wrote:

>I'm confused.
>OS = Win XP Pro
>I installed MSDE2000A on a new laptop using mixed security - Windows and
>SQL. Everything went fine. At the time my everyday Windows user account w
as
>set up as a Windows (not SQL) administrator, so that I could get some other
>software installed, too.
>I subsequently changed my Windows user account to be a power user and NOT a
>Windows administrator and now I cannot connect to MSDE with that Windows
>account. If I switch the account back to Windows adminstrator all is well
>with MSDE.
>How can I coax MSDE to recognize this user account when it is no longer a
>Windows administrator?
>|||Sue -
Thanks for the guidance, but it looks like sp_grantlogin requires me to use
a domain name. The laptop is not part of a domain. Is there a workaround
for that?
"Sue Hoegemeier" wrote:

> Add your windows account to the Logins for MSDE. You are
> getting in due to the default behavior of SQL Server adding
> BUILTIN\Administrators as a login. That would include all
> logins that are members of the local admins group.
> You can add your login using sp_grantlogin. You can find
> more information in books online.
> -Sue
> On Mon, 9 Jan 2006 08:07:04 -0800, "Duke Carey"
> <DukeCarey@.discussions.microsoft.com> wrote:
>
>|||If you are logging into the laptop using a local account,
you would use:
MachineName\LoginName
-Sue
On Mon, 9 Jan 2006 16:29:02 -0800, "Duke Carey"
<DukeCarey@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue -
>Thanks for the guidance, but it looks like sp_grantlogin requires me to use
>a domain name. The laptop is not part of a domain. Is there a workaround
>for that?
>"Sue Hoegemeier" wrote:
>|||Sue -
I logged in to the laptop as Administrator and was automatically logged in
to MSDE. Within MSDE I then ran EXEC sp_grantlogin 'pc_name\duke' and it ra
n
successfully.
However, after logging in as Duke *without Windows administrator rights* I
was still unable to login to MSDE.
I have to be so dense, but what am I missing?
Duke
"Sue Hoegemeier" wrote:

> If you are logging into the laptop using a local account,
> you would use:
> MachineName\LoginName
> -Sue
> On Mon, 9 Jan 2006 16:29:02 -0800, "Duke Carey"
> <DukeCarey@.discussions.microsoft.com> wrote:
>
>|||If the login is there, you should be able to at least
connect.
So when you log in as Duke and try to log in to MSDE, what
is the exact error message - all the details?
-Sue
On Thu, 19 Jan 2006 08:24:04 -0800, "Duke Carey"
<DukeCarey@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue -
>I logged in to the laptop as Administrator and was automatically logged in
>to MSDE. Within MSDE I then ran EXEC sp_grantlogin 'pc_name\duke' and it r
an
>successfully.
>However, after logging in as Duke *without Windows administrator rights* I
>was still unable to login to MSDE.
>I have to be so dense, but what am I missing?
>Duke
>"Sue Hoegemeier" wrote:
>|||Sue -
There are no error messages as such
What is happening is that the SQL Service Mgr in the systray shows an empty
circle. When I open it I have to type in the pc name and select SQL Server
as the service. It then shows that it is already running. When I go into
MSDE Manager (Vale Software's management tool), it shows me logged in as
guest. It also shows the database owner (there's only one user database so
far) as hp_notebook\duke and says that I do not have permisssion to access
that database
If I grant my Windows login Windows Administrator status, MSDE starts fine
and I log in to the MSDE as myself
I don't know enough to provide you more helpful information
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:1q00t11aka3drrkih9ev7rofpbidk5c6dr@.
4ax.com...
> If the login is there, you should be able to at least
> connect.
> So when you log in as Duke and try to log in to MSDE, what
> is the exact error message - all the details?
> -Sue
>|||Okay...so you get on the server but can't do anything in
that database or can't access the database.
Add your Duke login as a user in the database using
sp_grantdbaccess.
If you need that login to be able to do anything and
everything on the MSDE instance, you can add that login to
the sysadmins server role using:
EXEC sp_addsrvrolemember 'pc_name\duke', 'sysadmin'
-Sue
On Thu, 19 Jan 2006 19:02:51 -0500, "Duke Carey"
<dukecarey@.hotmail.com> wrote:

> When I go into
>MSDE Manager (Vale Software's management tool), it shows me logged in as
>guest. It also shows the database owner (there's only one user database so
>far) as hp_notebook\duke and says that I do not have permisssion to access
>that database|||Sue -
Thanks for sticking with me. It appears that things are working correctly
now.
EXEC sp_addsrvrolemember 'pc_name\duke', 'sysadmin' seems to have done the
trick.
"Sue Hoegemeier" wrote:

> Okay...so you get on the server but can't do anything in
> that database or can't access the database.
> Add your Duke login as a user in the database using
> sp_grantdbaccess.
> If you need that login to be able to do anything and
> everything on the MSDE instance, you can add that login to
> the sysadmins server role using:
> EXEC sp_addsrvrolemember 'pc_name\duke', 'sysadmin'
> -Sue
> On Thu, 19 Jan 2006 19:02:51 -0500, "Duke Carey"
> <dukecarey@.hotmail.com> wrote:
>
>|||Good to hear it's all working now - thanks for posting back!
-Sue
On Mon, 23 Jan 2006 06:31:04 -0800, "Duke Carey"
<DukeCarey@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue -
>Thanks for sticking with me. It appears that things are working correctly
>now.
>EXEC sp_addsrvrolemember 'pc_name\duke', 'sysadmin' seems to have done the
>trick.
>
>"Sue Hoegemeier" wrote:
>

MSDE login problem

After installing MSDE 2000 in mixed mode local access worked fine.
Accessing through network with enterprice manager at first didn't work.
Fixed by activating network protocols "TCP/IP" and "Named pipes" in database properties.
But only the first time. After that login by SQL user and password is denied after restart local MSDE machine.

Anyone know why?

thanks in advanceAfter that login by SQL user and password is denied after restart local MSDE machine

With this I mean access from other machines on the network. Local login is working ok.|||Solution found!

Install MSDE again with DISABLENETWORKPROTOCOLS=0.
Changing it afterwards with SQL Server enterprice manager doesn't work.

just for those who are having the same problem

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

MSDE login problem

Hi all,

I have bought Visual C# .NET 2003 Standard and downloaded the MSDE to use
with it.

I did install it with it's default options and now i'd like to administer it
with Web Data Administrator but it keeps telling me that i should enable SQL
Server Authentication.

So i tried debugging the question creating an .udl file and trying to test
various authentication methods:
- Integrated Windows authentication works fine
- SQL Server authentication (when i try logging in using user 'sa' with the
password i've set keeps telling me that user 'sa' is not associated with a
trusted SQL Server connection.

How do i solve this puzzle? Tried googling (and reading some faqs) but
didn't come up with anything useful.

Unfortunately the Web Data Administrator doesn't allow using integrated NT
authentication. :-(

Thank You,
LorenzoCheck out MSKB 321698:

https://mvp.support.microsoft.com/d...kb;en-us;321698

--
Hope this helps.

Dan Guzman
SQL Server MVP

--------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index...epartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--------

"Lorenzo Bolognini" <lorenzo@.mysurname.net> wrote in message
news:jNaYa.42647$cl3.1359277@.news2.tin.it...
> Hi all,
> I have bought Visual C# .NET 2003 Standard and downloaded the MSDE to
use
> with it.
> I did install it with it's default options and now i'd like to
administer it
> with Web Data Administrator but it keeps telling me that i should
enable SQL
> Server Authentication.
> So i tried debugging the question creating an .udl file and trying to
test
> various authentication methods:
> - Integrated Windows authentication works fine
> - SQL Server authentication (when i try logging in using user 'sa'
with the
> password i've set keeps telling me that user 'sa' is not associated
with a
> trusted SQL Server connection.
> How do i solve this puzzle? Tried googling (and reading some faqs) but
> didn't come up with anything useful.
> Unfortunately the Web Data Administrator doesn't allow using
integrated NT
> authentication. :-(
> Thank You,
> Lorenzo|||"Dan Guzman" <danguzman@.nospam-earthlink.net> ha scritto nel messaggio
news:p_hYa.241$BC2.47@.newsread2.news.atl.earthlink .net...
> Check out MSKB 321698:

Thank you very much Dan.

Lorenzo

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

MSDE Login Problem

Hi All;
MSDE has so many complication to install and to use. So, I am facing one
problem right now. It is very frustrating right now. I created one VB.NET
application and used MSDE SP3. I am trying to install on Windows 2000
professional. There is a problem setting the SA password. To install MSDE I
am passing following parameter into
[Options]
INSTANCENAME= <instance name>
DISABLENETWORKPROTOCOLS=1
SAPWD= <password>
First thing, MSDE ignore SECURITYMODE = SQL at the time of installation and
installs in Windows Authentication. I can connect to MSDE in windows
authentication if I am using that connection string to connect to MSDE
Connection String = "(local)\<instance name> ;persist security info=True;
initial catalog= <database name> ;Trusted_Connection=True"
It is working fine if the Windows user is Administrator, if the user is a
domain user and not have Admin rights then it fails to connect.
I changed to MSDE login mode to SQL mode using RegEdit and change the Key to
Login mode = 2 which changes the mode to SQL Authentication. I reset the
service as well. Now, I am using that connection string to connect:
Connection String = "data source=(local)\<instance name>;initial
catalog=<database name> ; user id=sa ; password= <sa password which set at
the time of installation> " />
Now, it is failed to connect using sa login. It always says "Login failed
for user 'sa' "
I tried to connect to the MSDE using
osql -U sa -S <instance name>
then provide Password:
it is not connected that way as well.
I am stuck here, I want to install application at client side which is a
domain network and all the users can't be administrator to use the
application. The summary is I need to connect using SQL Authentication but it
is not setting the SA password properly which causes failing to connect. Is
there any suggestion and solution.
Thanks for your help in advance.
Essa, M. Mughal
Software Developer
Toronto, Canada
hi Essa,
Essa wrote:
> First thing, MSDE ignore SECURITYMODE = SQL at the time of
> installation and installs in Windows Authentication. I can connect to
> MSDE in windows authentication if I am using that connection string
> to connect to MSDE
I was unable to reproduce the problem... providing the SECURITYMODE=SQL
always set the MSDE instance to accept mixed authenticated connections..

> Connection String = "(local)\<instance name> ;persist security
> info=True; initial catalog= <database name> ;Trusted_Connection=True"
> It is working fine if the Windows user is Administrator, if the user
> is a domain user and not have Admin rights then it fails to connect.
and this is normal, as MSDE, at installation time, register local
administrators in the BUILTIN\Administrators WinNT group logins, but other
accounts (power users, limited users, .. ) have to be manually granted
authentication rights via a WinNT login or WinNT group login...

> I changed to MSDE login mode to SQL mode using RegEdit and change the
> Key to Login mode = 2 which changes the mode to SQL Authentication. I
> reset the service as well. Now, I am using that connection string to
> connect:
> Connection String = "data source=(local)\<instance name>;initial
> catalog=<database name> ; user id=sa ; password= <sa password which
> set at the time of installation> " />
> Now, it is failed to connect using sa login. It always says "Login
> failed for user 'sa' "
>
if the remaining part of the error is " ... not associated with a trusted
connection" then the server did not (still) accept the registry change, and
you have to stop and re-start it..
http://support.microsoft.com/default...;EN-US;q285097
else the provided password does not match the registered one... please
verify it is correct...
you can modify it accessing MSDE via a local windows admin in integrated
security mode and executing the
EXEC sp_password @.new = 'your_new_pwd_for_SA' , @.loginame = 'sa'
http://support.microsoft.com/default...;EN-US;q325003

> I am stuck here, I want to install application at client side which
> is a domain network and all the users can't be administrator to use
> the application. The summary is I need to connect using SQL
> Authentication but it is not setting the SA password properly which
> causes failing to connect. Is there any suggestion and solution.
in all my experiences,
C:\...\setup.exe SAPWD=your_pwd DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL
INSTANCENAME=YourInstanceName /L*v "c:\msdeLog.txt"
command line alwyas installed a named instance, with mixed mode
authentication, enabled network protocols, logging the installation process
to file
your setting of DISABLENETWORKPROTOCOLS=1 disables network protocols and no
remote connection will be granted (but this is another story)...
apart from this, but this is another entire story, you should not connect to
SQL Server with administrative privileges (sa login) if you really do not
need to... you should use normal privileged logins and database users, as
administrative permissions are not tailored for standard DML access, and
each user should log in with his/her own login, trusted or standard SQL
server authenticated...
please have an additional look at
http://www.sql-server-performance.co...l_security.asp
http://www.microsoft.com/technet/pro.../sp3sec03.mspx
or, at least, an application role,
http://www.databasejournal.com/featu...le.php/3363521 ...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

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--

MSDE Login

Hi All,

I've been using NT authentication to access my MSDE without any problem, but when I try to login using an account with SQL Server username and password it returns

"Login failed for user 'testuser'. Reason: Not associated with a trusted SQL Server Connection."

I tried with Visual Studio, Query Analyzer and ODBC, they all return the same error.

Is this a limitation of MSDE or are there configurations that I'm not aware of?

Thanks!

WillIndeed, you should make sure MSDE is installed the right way to allow it to use SQL authentication as well. Just take a look at theMSDE website to find out more about how to configure and install it in the right way. The limitations are listed on this website as well...|||Maybe the next URL can be of interest as well:
http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1.

It describes how to setup MSDE in mixed mode (both Windows and SQL authentication).|||The only thing that was left out in the above link is that the username is sa. It took me a while to figure that one out :-)

Is there a way to add other users?

Wednesday, March 7, 2012

MSDE installation - login failed

Hello,
I am installing MSDE 2000 on a Windows 98 machine. After
installation, the SQL server is running, but when I try to
run my program against the SQL server, I get the following
message "Login failed for user "null" note associated with
a trusted SQL Server connection"
I'm running setup in the command line mode, what am I
missing in the command line?
Thank you,
Randers
Hi,
By default, the MSDE was install with integrated Security. Thats the reason
you are getting this error.
Windows 98 will not support Windows authentication. So use SQL server
authentication to connect to MSDE.
Thanks
hari
SQL Server MVP
"randers" <rmonroe@.aulcorp.com> wrote in message
news:0de101c54533$d9b7d7c0$a501280a@.phx.gbl...
> Hello,
> I am installing MSDE 2000 on a Windows 98 machine. After
> installation, the SQL server is running, but when I try to
> run my program against the SQL server, I get the following
> message "Login failed for user "null" note associated with
> a trusted SQL Server connection"
> I'm running setup in the command line mode, what am I
> missing in the command line?
> Thank you,
> Randers

Monday, February 20, 2012

MSDE from Hoster installed

Hello
my DEd win 2003 server, uses MSDE
all is ok, the server run, and can create from script Db
but if i want login or create connection MSDE say wrong pass
i never change the pass or other
i have the server complet reinstalled from hoster image
what i doing wrong ?
hi,
MS News wrote:
> Hello
> my DEd win 2003 server, uses MSDE
> all is ok, the server run, and can create from script Db
> but if i want login or create connection MSDE say wrong pass
> i never change the pass or other
> i have the server complet reinstalled from hoster image
> what i doing wrong ?
assuming you are trying to connect using the standard SQL Server
authentication with the "sa" login and you can't remember it's pasword, you
can login using integrated security (the Windows authentication) using a
local admin member and set the "sa" password to whatever you want via the
system stored procedure sp_password,
http://msdn.microsoft.com/library/de...a-pz_5x44.asp,
in the form
EXEC sp_password @.new = 'whatever', @.loginame = 'sa'
as all local admins members are automatically members of the
BUILTIN\Administrators login group in MSDE too, with sysadmins privileges...
connect via oSql.exe providing the -E parameter to specify integrated
security..
c:\..\>osql.exe -E -S(local)\InstanceName
1>EXEC sp_password @.new = 'whatever', @.loginame = 'sa'
2>GO
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hey thats realy works !
thanks!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> schrieb im Newsbeitrag
news:3s11vbFlebp5U1@.individual.net...
> hi,
> MS News wrote:
> assuming you are trying to connect using the standard SQL Server
> authentication with the "sa" login and you can't remember it's pasword,
> you can login using integrated security (the Windows authentication) using
> a local admin member and set the "sa" password to whatever you want via
> the system stored procedure sp_password,
> http://msdn.microsoft.com/library/de...a-pz_5x44.asp,
> in the form
> EXEC sp_password @.new = 'whatever', @.loginame = 'sa'
> as all local admins members are automatically members of the
> BUILTIN\Administrators login group in MSDE too, with sysadmins
> privileges...
> connect via oSql.exe providing the -E parameter to specify integrated
> security..
> c:\..\>osql.exe -E -S(local)\InstanceName
> 1>EXEC sp_password @.new = 'whatever', @.loginame = 'sa'
> 2>GO
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>