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.