IT Community - Software Programming, Web Development and Technical Support

Where are SQL server users names and passwords are stored in sql server?

This is a discussion on Where are SQL server users names and passwords are stored in sql server? within the Database Support forums, part of the Web Development category; Where are SQL server users names and passwords are stored in sql server?...


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 07-19-2007, 12:09 AM
H2o H2o is offline
D-Web Analyst
 
Join Date: Jul 2007
Posts: 246
H2o is on a distinguished road
Question Where are SQL server users names and passwords are stored in sql server?

Where are SQL server users names and passwords are stored in sql server?
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 07-19-2007, 12:34 AM
Murali Murali is offline
D-Web Master
 
Join Date: Feb 2007
Location: India-Chennai.
Posts: 386
Murali is on a distinguished road
Send a message via AIM to Murali
Default Re: Where are SQL server users names and passwords are stored in sql server?

Hi,

The SQL Server User names and Passwords are stored in Master DB in the sysxlogins table.
__________________
-Murali..
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 07-19-2007, 01:15 AM
oxygen oxygen is offline
D-Web Architect
 
Join Date: Jun 2007
Posts: 633
oxygen is on a distinguished road
Default Re: Where are SQL server users names and passwords are stored in sql server?

They get stored in master db in the sysxlogins table.
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Some Performance tuning tips about SQL Server Stored Procedures vadivelanshanmugam Database Support 0 02-04-2008 06:12 AM
SQL Server Undocumented Stored Procedures a.deeban Database Support 2 12-23-2007 11:20 PM
SQL Server Undocumented Stored Procedures a.deeban Database Support 3 09-04-2007 03:31 AM
What is the Query to display all tables and Database names in server use sql? kingmaker Database Support 2 07-23-2007 10:57 PM
How to Send Mail Using Stored Procedure in MS SQL SERVER 200x?? Gopisoft Database Support 1 07-17-2007 09:43 AM


All times are GMT -7. The time now is 04:18 AM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.

SEO by vBSEO 3.0.0