LoginName #

SQLServer is the Database. GUIs show Login name. Sometimes the login name
changes to 'Login #' ... like 'Mary 2'. What might make this happen?Hi Ann
Which version of SQL Server and screen is this? Are these SQL Logins or
Windows?
Have you checked syslogins to see if the logins exist?
John
"Ann" wrote:
> SQLServer is the Database. GUIs show Login name. Sometimes the login name
> changes to 'Login #' ... like 'Mary 2'. What might make this happen?
>|||Hi
The version is the most recent though I can not quote it.
SQL Server login/authentication.
The logins exist without the ' #' to their right.
Ann
"John Bell" wrote:
> Hi Ann
> Which version of SQL Server and screen is this? Are these SQL Logins or
> Windows?
> Have you checked syslogins to see if the logins exist?
> John
> "Ann" wrote:
> > SQLServer is the Database. GUIs show Login name. Sometimes the login name
> > changes to 'Login #' ... like 'Mary 2'. What might make this happen?
> >
> >|||My reply did not seem to post so I am re posting : ).
SQL Server version most recent
SQL Logins
The logins without the ' #' exist.
"John Bell" wrote:
> Hi Ann
> Which version of SQL Server and screen is this? Are these SQL Logins or
> Windows?
> Have you checked syslogins to see if the logins exist?
> John
> "Ann" wrote:
> > SQLServer is the Database. GUIs show Login name. Sometimes the login name
> > changes to 'Login #' ... like 'Mary 2'. What might make this happen?
> >
> >|||Hi Ann
So what does SELECT @.@.VERSION return? You did not say which screen this is?
Does sp_who2 also return these logins?
John
"Ann" wrote:
> My reply did not seem to post so I am re posting : ).
> SQL Server version most recent
> SQL Logins
> The logins without the ' #' exist.
>
> "John Bell" wrote:
> > Hi Ann
> >
> > Which version of SQL Server and screen is this? Are these SQL Logins or
> > Windows?
> > Have you checked syslogins to see if the logins exist?
> >
> > John
> >
> > "Ann" wrote:
> >
> > > SQLServer is the Database. GUIs show Login name. Sometimes the login name
> > > changes to 'Login #' ... like 'Mary 2'. What might make this happen?
> > >
> > >|||I can not verify SELECT @.@.VERSION
These logins are not in any log or registered anywhere. It is a valid login
name with a number/# to the right ... the longer the user sits in the gui
configured room ... the greater the number/# gets ... increasing by 1 every
20 minutes.
Hope this helps,
Anna (Project Manager)
"John Bell" wrote:
> Hi Ann
> So what does SELECT @.@.VERSION return? You did not say which screen this is?
> Does sp_who2 also return these logins?
> John
> "Ann" wrote:
> > My reply did not seem to post so I am re posting : ).
> >
> > SQL Server version most recent
> > SQL Logins
> > The logins without the ' #' exist.
> >
> >
> > "John Bell" wrote:
> >
> > > Hi Ann
> > >
> > > Which version of SQL Server and screen is this? Are these SQL Logins or
> > > Windows?
> > > Have you checked syslogins to see if the logins exist?
> > >
> > > John
> > >
> > > "Ann" wrote:
> > >
> > > > SQLServer is the Database. GUIs show Login name. Sometimes the login name
> > > > changes to 'Login #' ... like 'Mary 2'. What might make this happen?
> > > >
> > > >|||Hi Ann
Unfortunately the information you have given does not help me to diagnose
this problem. Without basic information such as what tool you are using and
which version of SQL Server you are using I can not really progress. Normally
with either Enterprise Manager (for SQL 2000 ) or SQL Server Management
Studio (SQL 2005) the current activity screens would reflect the actual login
name without change, therefore the information you have posted does not give
me any insight in why it should be different in your case.
John
"Ann" wrote:
> I can not verify SELECT @.@.VERSION
> These logins are not in any log or registered anywhere. It is a valid login
> name with a number/# to the right ... the longer the user sits in the gui
> configured room ... the greater the number/# gets ... increasing by 1 every
> 20 minutes.
> Hope this helps,
> Anna (Project Manager)
> "John Bell" wrote:
> > Hi Ann
> >
> > So what does SELECT @.@.VERSION return? You did not say which screen this is?
> > Does sp_who2 also return these logins?
> >
> > John
> >
> > "Ann" wrote:
> >
> > > My reply did not seem to post so I am re posting : ).
> > >
> > > SQL Server version most recent
> > > SQL Logins
> > > The logins without the ' #' exist.
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi Ann
> > > >
> > > > Which version of SQL Server and screen is this? Are these SQL Logins or
> > > > Windows?
> > > > Have you checked syslogins to see if the logins exist?
> > > >
> > > > John
> > > >
> > > > "Ann" wrote:
> > > >
> > > > > SQLServer is the Database. GUIs show Login name. Sometimes the login name
> > > > > changes to 'Login #' ... like 'Mary 2'. What might make this happen?
> > > > >
> > > > >