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 |
|
Rocko
Starting Member
26 Posts |
 Posted - 2006-12-14 : 21:49:03
|
| Hi Friends,I’m using Microsoft SQL 2000. I was trying to create user account under Enterprise Manager/Security/Logins (SQL Server Authentication) However I’m getting the following error message when trying to set a database for that user:The login 'admin' has not been granted access to their default database: 'PTD' and therefore will not be able to gain access to the default database. Continue?In the database PTD I have several users (PTD/Users) which won’t be able to connect to the SQL server because I think they are not under Security/Logins. Is there a way I can grant access for those users or just add them to Security/Logins?Thanks in advance for your help!Rocko |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-15 : 00:38:41
|
| Logins and users are two completely different things. You login to the server with a login and you use a database as a user. Each login needs a user in a database in order to be able to use that database and you need to grant permissions to that user or make the user a member of one or more roles in order for the user to be able to do anything in the database.In EM go to the properties of a login and on the Database Access tab you can create a user for the login in each database OR go to Users in a database and you can add a user for a login in that database. |
 |
|
|
Rocko
Starting Member
26 Posts |
Posted - 2006-12-15 : 11:48:27
|
| Hi again,Yes, I was trying to move logins from one SQL server to another. That is because when I backup/restore database it’s not getting the logins, only the database users.Regarding your recommendations I don’t see properties under EP/Security/Logins. And also if I go to User in the database I don’t see option to add a user for a login in the database. Maybe I’m missing something, not sure.Instead I tried with EP > Data Transformation Services. I went to DTS > Local Packages > New Package > Task (on the top) > Transfer Login Task > then defined my source. However on the destination server menu I wasn’t able to select my local instance. It says:Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network.Do you have any idea where to add those rights? Thanks in advance for you help!Rocko |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-15 : 15:59:49
|
| In Enterprise Manager, go to Logins under Security and right click on a login then select Properties to see the properties for a login.To change the service account for SQL Server, right click on your server and select Properties and go to the Security tab. Look up service accounts in Books Online before you do this though because there are various security requirements for the account you run the service under. |
|
|
|
|
|
|
Granted access to default database