index > Installing and Registering Visual Studio Express Editions > how to add new users with SQL Server Management Studio Express CT...

how to add new users with SQL Server Management Studio Express CT...

hi, someone maybe can help me how to add new users, that they could connect to my MSSQL 2005 server, i trided myself, but i didn't make it.. thanks


Radvis
Radvis
This probably should have been posted somewhere else being that this is the Installing and Registering forum but here is how to add a new user for SQL 2005:

1) Connect via Management Studio
2) Expand Security
3) Right click Logins and select New Login

From there you can configure that new user. Remember to set the authentication mode for the server. It's set to windows authentication by default.
BobbyPeru
but how to set that authentication mode for the server?


Radvis
Radvis
You can set the authentication mode by right clicking the server name and select properties. Then select security in the left side. You can then choose either windows or SQL Sever and Windows authentication.

You mentioned people will be remotely connecting.... by default, SQL Server Express does not allow remote connections so that will have to be set as well by using the Surface Area Configuration tool. Set it to allow local and remote connections and the protocols you want it to use.

HTH
BobbyPeru
reply 4

You can use google to search for other answers

 

More Articles

• Registering Visual C++ Express Ed
• VC++ Express Beta 2 : On other computer..
• Error adding web reference
• ADO.NET DATASET
• Visual Web Developer and Sub Folder Applications
• Cannot use some keys when open external programs ...
• Error in Downloading VBe
• Debug problem - Source code/original difference...
• Unable to download ISO image of VWD
• SQL EXPRESS Uninstall
Bookmark and Share
Welcome to Bokebb   New Update  
 

New Articles

• 2nd upgrading question
• Visual Basic Express edition 2005 freeze
• Visual Studio version recommendation
• Limitation of VB 2005 Express?
• No projects
• Merge Visual express setups
• Link to "Registration Benefit Porta
• Why VB.NET and VB2005 ignore ini files f
• Why can't I install .net framework2.0???
• DataGrid
• Bug report: Debugging Flag not always set
• Can´t register or create new User i
• Import Existing Pages
• Moved My Documents Problem
• Activation

Hot Articles

• Installation Error
• Does .NET Express Edition Support Sqlser
• free for using?
• HELP! SQL Server Beta Notification Servi
• Can't start visual C++ Express
• Unable to insert or update into SQL2005E
• visual express C # installation will not
• VB.NET express really different from VB.
• Default Browser
• Uninstalling Pre-RTM Visual Studio Expre
• Accessing variables from other apps.
• Can I Move The Program Files?
• VB 2005 Express + Crystal Report
• Running an Application from my Applicati
• Can't remove .NET Framework 2.0 Beta 1

Recommend Articles

• PROJECT FILE
• Can I use SQL Server 2000 with VBExpress
• Installing Plugin
• No Debug?
• Service Pack packaging for SQL Server 20
• Can't install VB Express from a CD
• Problem Encountered While Installing Set
• VWD and other browsers
• Cant read from a database with vb 2005
• Can't start visual C++ Express
• damaged file
• Adding a data source
• Registration Questions
• How to add row in code to bound datagrid
• Error while installing