Re: Failed to set proper user name ('domain\username') for the connection

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 02/06/05


Date: Sun, 6 Feb 2005 18:19:15 -0000

Hi

Have you got the same db_id for the database(s) on the production and
development servers? You may want to restore master! Alternatively try to
save the trace as a SQL File and then run that, you should not get this
problem and it will be easier to debug any problems that you do get.

John

"ChrisR" <ChrisR@noEmail.com> wrote in message
news:%23qqMGq7CFHA.4052@TK2MSFTNGP15.phx.gbl...
> Im runnning a Trace from Production against a Development box and getting
> this error message:
>
> Failed to set proper user name ('domain\username') for the connection
>
> . I have removed the db_id from the Trace table. Also, all the Logins/
> Users
> are set to the proper default DB. So Im really confused as to why I would
> be
> getting this? Any ideas?
>
>
>
> TIA, ChrisR
>
>



Relevant Pages

  • Re: right way to perfromance tune?
    ... >>I captured a trace from a production box. ... >>Indexes, Stats, etc. so now I want to replay. ... >Joshua Stern ...
    (microsoft.public.sqlserver.server)
  • Re: right way to perfromance tune?
    ... >I captured a trace from a production box. ... >Indexes, Stats, etc. so now I want to replay. ... CPU and duration will not be comparable. ...
    (microsoft.public.sqlserver.server)
  • right way to perfromance tune?
    ... I captured a trace from a production box. ... Indexes, Stats, etc. so now I want to replay. ... lowering Duration and CPU at this point. ...
    (microsoft.public.sqlserver.server)