Login SQL 2000

From: Glenn tucker (glenn.tucker@sonoco.com)
Date: 05/30/02 

From: "Glenn tucker" <glenn.tucker@sonoco.com>
Date: Wed, 29 May 2002 21:05:34 -0700

I've recently bought Visual Studio .net. I installed SQL
Server 2000. I have no problem creating logins with my
SQL 7 servers. However, I don't seem to be able to create
logins for SQL 2000. I created an account, it failed to
login to into Query Analyzer. I tried sa and it failed.
(Error can be seen in attached document.)

Is there something that needs to be done with logins in
SQL 2000 that is different from SQL 7?

Relevant Pages

  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • End User Security Administrator for a Intranet Application
    ... you could use configure SQL ... Server to use integrated security and then manage the ... logins and groups thru your Active Directory/Domain ...
    (microsoft.public.sqlserver.security)
  • Re: VB6 apps cannot connect to SQL2000
    ... I did recreate the logins on SQL, ... verify that Enterprise Manager could connect with these logins. ... It turned out that the old server had NWLink IPX/SPX installed, ... The VB apps' connection strings were hard coded to reference the ...
    (microsoft.public.sqlserver.connect)
  • Re: Logins
    ... no databases are checked, ... On the Server Roles tab, ... That server was upgraded to SQL Server ... moved, I recreated the SQL Server logins we had added, making sure that the ...
    (microsoft.public.sqlserver.security)
  • Re: object level permissions being lost when migrating
    ... I am talking about SQL Logins, ... can go to the object and see that user X has permissions XYZ on that object, ... I then restored the databases and re-synched the users via the ...
    (microsoft.public.sqlserver.security)