[dba-SQLServer] Logins on workstation

Are you talking about a DTS data transfer for your backup?  From memory
there's an option to 'transfer logins' or something similar, so maybe
this was what grabbed them?? 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Steve
Erbach
Sent: Monday, 14 February 2005 1:52 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Logins on workstation

Billy and Jim,

I have the answer. I've been working on an ASP.NET application that uses
a SQL Server backend. The SQL Server database is hosted on a shared SQL
Server by CrystalTech. There are 401 databases on this particular SQL
Server. On Jan. 17th I backed up my client's database to my local
server. For some reason my backup brought in all the various syslogins
for all the rest of the databases on that CrystalTech server. None of
them can get at the data on my own server, of course; I just somehow
copied the login definitions for all 450+ users of that CrystalTech
server. Beats the tar out of me.

Steve Erbach
Neenah, WI


On Sun, 13 Feb 2005 19:09:31 +0000, Billy Pang <tuxedo_man at hotmail.com>
wrote:
> Not sure how those logins got there in first place.  first thing I'd 
> check is syslogins table to see when they were created.  (ie. SELECT 
> crdate,* FROM master.dbo.SYSLOGINS).  maybe that provides some 
> insight.  what is an example of the bogus logins that are created? do 
> they follow some sort of naming convention? maybe it was created
during some sort of app install.
> 
> HTH
> 
> Billy
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



IMPORTANT - PLEASE READ *** This email any any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not.