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 |
|
Igrok
Starting Member
3 Posts |
 Posted - 2013-08-27 : 16:33:43
|
| I have inherited a server that has both SQL server 2005 express edition and SQL server 2008 standard edition installed, and databases being used in both. I can see all the active domain users on the 2008 SQL, but not on the 2005 Express edition. Is this normal? If so, how do I get access to a domain user to the 2005 express edition? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Igrok
Starting Member
3 Posts |
Posted - 2013-08-28 : 11:36:04
|
| Sorry, I am using SSMS to view the users who have access to the DBs. when I go to the security section to add users, I can't see everyone listed in the domain, only a handful of domain users and I can't tell what is different about those users as opposed to everyone else in the domain - they are all set up the same in AD. |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-08-28 : 11:50:19
|
quote:
Originally posted by Igrok
Sorry, I am using SSMS to view the users who have access to the DBs. when I go to the security section to add users, I can't see everyone listed in the domain, only a handful of domain users and I can't tell what is different about those users as opposed to everyone else in the domain - they are all set up the same in AD.
You should be going to the security section under the Server node of SSMS and adding LOGINS rather than going to the security section under a database and adding USERS. Once you add the login, you can give them access to the database in that same dialog, or you can go to the security under the database and add them. |
|
|
|
Igrok
Starting Member
3 Posts |
Posted - 2013-08-28 : 12:09:54
|
| Thank you James K - that was the solution - I apologize for being dumb about it - getting a resource book today!Thanks again! <thumbs up!> |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-08-28 : 12:25:29
|
You are very welcome. No need to apologize. I am not telling how I guessed that might be the problem  |
|
|
|
|
|
|
Multiple SQL servers on same machine