Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

MS SQL db not updating from MS AD


  • Please log in to reply

#1
andy_b_1502

andy_b_1502

    Member

  • Member
  • PipPip
  • 40 posts

Hi,

 

Apologies if this is the incorrect forum to post in maybe somebody can guide me to the correct place or move my post.

 

But... .

 

I have inherited a code from previous IT team. That adds users from Microsoft Active Directory into a database table created in Microsoft SQL management studio, this displays company users into our intranet.  

 

The problem is that out of 7 new users I have added only 3 have actually "made it" through to the intranet? 4 have not and I am perplexed as to what is stopping them being added through SQL studio.

 

 

Please could you help me troubleshoot this?  so far I have checked the SQL mgmt studio and found a few un-ticked boxes within the table properties, ticked what I thought what should be ticked this shows in the intranet but incomplete (so I know that MS SQL management studio is making changes), it shows the name of a user not previously added but no other fields.  

 

Checked the ticked and un-ticked boxes in SQL studio:

 

XXserver_nameXX -> security -> Logins -> XXX\xxxx  -> properties -> User mapping ->

Error message seen: "One or more databases are inaccessible and will not be displayed in list." -> OK -> Noticed that (the main table name) was NOT ticked
This is the default Company database .dbo table

Selected this tick box

 

 

Refreshed the intranet and the incompleted data was shown in the intranet.

 

 

I believe this to be a problem with the link of Active directory and SQL management studio but I am not sure which settings to change. Do you guys have any experience of this type of thing happening before?

 

Should I be checking something obvious that I'm not currently aware of?

 

 

I am willing to provide further information to resolve this issue just let me know what might help this situation #

 

 

Just on a related note I WAS able to update the db by manually selecting a unique SID but I really do not want to go down that path. Screen shots added to what it should look like and what's happening.,

 

Many thanks

 

Andy
 

Attached Thumbnails

  • LDAP issue.JPG
  • Manually added successfully.JPG

  • 0

Advertisements







Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP