SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Multiple SQL servers on same machine
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Igrok
Starting Member

USA
3 Posts

Posted - 08/27/2013 :  16:33:43  Show Profile  Reply with Quote
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

USA
37158 Posts

Posted - 08/27/2013 :  16:44:20  Show Profile  Visit tkizer's Homepage  Reply with Quote
Could you explain what you mean? What are you looking at? sp_who? Security\Logins? I'm confused...

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Igrok
Starting Member

USA
3 Posts

Posted - 08/28/2013 :  11:36:04  Show Profile  Reply with Quote
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.
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3724 Posts

Posted - 08/28/2013 :  11:50:19  Show Profile  Reply with Quote
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.
Go to Top of Page

Igrok
Starting Member

USA
3 Posts

Posted - 08/28/2013 :  12:09:54  Show Profile  Reply with Quote
Thank you James K - that was the solution - I apologize for being dumb about it - getting a resource book today!

Thanks again! <thumbs up!>
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3724 Posts

Posted - 08/28/2013 :  12:25:29  Show Profile  Reply with Quote
You are very welcome.

No need to apologize. I am not telling how I guessed that might be the problem
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000