Re: ODBC, alias an SQL Server Login error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 17:35:20 +0100

Seems you have orphaned users. Read about sp_change_users_login. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Dave" <dave@groupfive.net> wrote in message
news:993ef28c.0403120830.60b5fd40@posting.google.com...
> The message that I got was:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server Login]
>
> is aliased or mapped to a user in one or more databases.  Drop the
> user or alias before dropping the login.
>
>
>
>
> I am trying to create all new accounts for a new database.  Is this
> referring to the SA account?  If anyone could assist me with this I
> would appreciate it very much.
>
> Thanks.

Relevant Pages

  • Re: db_owner
    ... Is there a way to disable all of the 'guest' accounts in all of the system ... and user databases since I noticed this Microsoft article recommends not to ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Error in Index Reorg in Maintenance Task
    ... Tibor Karaszi, SQL Server MVP ... Turned Allow Page Lock off and tried re-org. ... I have created a maintenance plan which performs the following (in order, on all databases): ... Our system is running Windows 2003 Cluster w/ SQL 2005 Std Cluster. ...
    (microsoft.public.sqlserver.server)
  • Re: Tracing
    ... Would it make sense to add InsertedBy, InsertDate, UpdatedBy, UpdateDate, ... DeleteDate columns at the end of each table in my databases and ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Cannot connect to POP3 server?
    ... You're welcome, Dave. ... with 3 accounts. ... using Outlook Express 6. ... You probably installed the email scanner plugin via AVG. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Integrated security - why not?
    ... For some time now i have been using integrated security at all levels ... The application itself hooks up to multiple databases ... IIS will only allow access to valid accounts and the aspnet ... testing server with no problems at all. ...
    (microsoft.public.dotnet.framework.aspnet.security)