Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> Transact-SQL

logins and users

Hello,

How can I login in one databse from Sql Management Studio? Do I need one login for each user?

How does it work?

thanks,

[151 byte] By [AlessandroCamargo] at [2007-12-24]
«« Streaming directly from mic to speakers using DirectSound
»» "Tahoma" font problem
# 1

Using the management studio you should be able to log on with a trusted connection. You will need to get the Database owner or admin to assign the permissions to each user that will need to connect... or you could create a network group in the AD and assign permissions to the user group in the databases that the users need to connect to.

GlennWilson at 2007-10-8 > top of Msdn Tech,SQL Server,Transact-SQL...
# 2
yes, but how can I assign permission to this users. I mean trusted connection
AlessandroCamargo at 2007-10-8 > top of Msdn Tech,SQL Server,Transact-SQL...
# 3

Hi,

no you don′t need to. Trusted Connections / Windows Authentication is based on Windows security. Therefore you can also create a principal using a Windows group of your Windows domain or local server.


HTH, Jens K. Suessmeyer.


http://www.sqlserver2005.de

JensK.Suessmeyer at 2007-10-8 > top of Msdn Tech,SQL Server,Transact-SQL...
SQL Server
Transact-SQL

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified