Re: Error connecting

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 07/27/04 

Date: Tue, 27 Jul 2004 13:15:26 -0600

LLF,
You can use Enterprise Manager if you wish. Enterprise
Manager is really just executing T-SQL commands for you so
you can manage these through Query Analyzer or any other
tool that can connect to and execute queries on SQL Server.
Passwords are changed using sp_password.
You can add logins using sp_grantlogin for Windows logins or
sp_addlogin for SQL logins.
You can add users to a database using sp_grantdbaccess.
You can find all of these system stored procedures
documented in SQL Server Books Online.

-Sue

On Tue, 27 Jul 2004 10:01:37 -0700, LLF
<LLF@discussions.microsoft.com> wrote:

>Hello, Steve,
>
>How can I manage SQL Server's users, for example, how to change the 'sa' password?
>Is it can only be done by using 'Enterprise Manager'?
>
>LLF

Relevant Pages

  • Re: Error connecting
    ... "Sue Hoegemeier" wrote:> LLF, ... Enterprise> Manager is really just executing T-SQL commands for you so> you can manage these through Query Analyzer or any other> tool that can connect to and execute queries on SQL Server. ... > You can add logins using sp_grantlogin for Windows logins or> sp_addlogin for SQL logins. ... >>Is it can only be done by using 'Enterprise Manager'? ...
    (microsoft.public.sqlserver.connect)
  • Login failed for user sa. Reason: Not associated with a trusted SQL Server Server Connection.
    ... I have set the security settings inside Enterprise Manager to allow logins ... for both SQL Server and Windows. ...
    (microsoft.public.sqlserver.connect)
  • invalid value specified for STOPAT parameter
    ... I too had problems when trying to perform a Point in Time restore ... Enterprise Manager, I receive a error message "Invalid value specified ... "YDM" by SQL Server where as the value supplied by the SQL Server ... Select "British English", then hit OK. ...
    (microsoft.public.sqlserver.server)
  • RE: Upgrading to SQL 2005 ENT
    ... I left the reporting services off. ... It gives a good step by step how to on upgrading to SQL Server 2005. ... some SQL Server features will not be available for installation. ... It has the same version from the Enterprise Manager. ...
    (microsoft.public.sqlserver.server)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)