Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
barbikochis
Starting Member
2 Posts |
 Posted - 2008-04-17 : 17:42:18
|
| In 2005 the security login will not allow me to add a user, database role, application role or schema manually. If I use a Transact-SQL in Query Editor to create a Login with a password, it said it was successful yet The T-SQL added my login as an application role is this correct? and why can I not add manually? is there another function that must be performed first?I am very new to the environment but know 2000 very well and miss it being so user friendly. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-17 : 17:49:54
|
| How are you adding the login?Can you post the code.It's odd because create login is used to add a login and create application role to add an application role.>> know 2000 very well and miss it being so user friendly.It's just because you're familiar with it. You'll find it difficult to move back after using v2005 for a while.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
barbikochis
Starting Member
2 Posts |
Posted - 2008-04-17 : 17:59:42
|
| OK I am going to query editor and CREATE LOGIN <login name> WITH PASSWORD = '<password>' : GOI was trying to right click on securities which gives me 4 options user, db role, app role, schema. I don't mind the options the server will not allow any that I click on manually. I check the other logins and mine is set up exactly like theirs so that makes me wonder why the others are added and mine is not. Also when I go to online books I am doing exactly what it tells me to do. Could it be a permissions issue perhaps since I am not the TOP DBA here?In 2000 there was just a setup period... |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-17 : 18:36:47
|
| You are looking in a database but creating a login which is a server object.Minimise the databases and you should see security just below it - double click on it and you shuold see logins and server roles. Your created login should be under logins.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Creating an SQL Server 2005 Login