I installed the SQL Server 2005 on my PC, creat some test users and give them some permission to see the effects on jobs they can do and not, but I asked myself aquestion, I am login using windows Authontication and my name isnt found in logins list of my sql server, there are test user, local administrator, sa, NT AUTHORITY\SYSTEM and BUILTIN\Administrators and like thes, so how I make a login to my SQL Server.


Mohd A. Shalabi

__________________
Mohd A. Shalabi

You have two authentication modes when loging into SQL Server 2005. SQL Server Authentication, and Windows Authentication. If you select Windows Authentication, it uses the credentials of the person currently logged in to the computer. The other option is SQL Server Authentication, and if that is selected, you have the option of selecting (or typing) the username and password with which you want to authenticate and log in to SQL Server. The user name list comes from the list of Logins you can create in SQL Server. There are default Logins (sa, NT AUTHORITY\SYSTEM and BUILTIN\Administrators) and you can create your own, either using Windows Authentication or SQL Server authentication.

Expand the Security node, then right mouse click on the Logins node, and select New Login. The New Login dialog will appear, and you can now create a new login based on Windows or SQL authentication.

Does this help?

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

Thanks for your explanation.
In my case I use windows authentication, and because I am a local administrator on my PC, I can run SQL Server as an SQL admin, but the logical thing is a have a login name for me in the security pane in SQL Server even I use windows authentication, because when I created a windows user named test, then add to SQL Server users then login to SQL Server, this user name is listed in security\logins, but the question who add my username or where is it in security\logins?!


Mohd A. Shalabi