Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Problem with logon ID's

Author  Topic 

dowens
Yak Posting Veteran

82 Posts

Posted - 2005-11-03 : 18:07:31
SQL2000

I'm looking under Security Logons.
I see all logons created and their network address if they are logged on. The newwork address is showing the same address for different logons. PC's are not setup to allow users to do this.

I getting deadlocked locks on a windows application reading and writing to the server. Could the newwork address be causing this?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-11-03 : 18:15:08
No. The two issues are not related. Check SQL Server Books Online for how to troubleshoot deadlocks.

Tara Kizer
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-11-03 : 21:53:02
quote:

The newwork address is showing the same address for different logons. PC's are not setup to allow users to do this.



What in the world does this mean? What do you mean that PC's are not setup to allow users to do this? Where is it showing this network address? What is the query and field name you're using for this information?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -