Use an AD group for SQL Authentication

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Use an AD group for SQL Authentication

Use an AD group for SQL Authentication

Rate Topic

Display Mode

Topic Options

Author

Message

joshd 1807

Posted Friday, December 30, 2011 8:37 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 2:09 PM
Points: 54, Visits: 247

Hi Guys,

Our Syspro system uses SQL authentication to connect the users to the database. We're migrating that server and I wanted to get away from entering everyone's username to the database for access.

What I have done is created a AD group and put users who need Syspro database access in this group. In Syspro, when you add in a new user it needs a SQL username and password for each user. I just want to have to enter in a group name for this instead of singularly entering each user and a SQL password.

Is there a way to have SQL Server 2008 use an AD account as a SQL group or is there some sort of group management option in SQL Server that I've missed?

Post #1228414

SQLRNNR

Posted Friday, December 30, 2011 8:50 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732, Visits: 12,329

SQL Server permits the use of groups no problem. The issue actually seems to be that your syspro app requires SQL Auth.

Here's an article on the authentication methods of sql server

http://blogs.msdn.com/b/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1228432

joshd 1807

Posted Friday, December 30, 2011 9:26 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 2:09 PM
Points: 54, Visits: 247

That's what I figured. I've used AD groups before and have had no issues.

WHat's wierd is that before the migration, I had this principle in place. Syspro must have clinged on to "old" settings. It also uses ISAM databases to store login information.

I'm betting that was my problem. A clean install wiped those settings away.

Looks like I'm back to the drawing board.

Thanks for the help!

Post #1228455

SteveEClarke

Posted Friday, February 15, 2013 6:36 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:22 AM
Points: 108, Visits: 292

Hi - Are you still having problems with your Syspro - SQL validation ?

Post #1420504

joshd 1807

Posted Friday, February 15, 2013 2:48 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 2:09 PM
Points: 54, Visits: 247

Steve,

I figured this problem out a while ago. Our program we were running (Syspro) has some sort of authentication glitch it seemed. AD Group Authentication was working until we had a fresh install of Syspro up and running. I just had to use normal SQL Authentication and everything worked out.

Post #1420779

SteveEClarke

Posted Sunday, February 17, 2013 12:55 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:22 AM
Points: 108, Visits: 292

Ahh right - glad you're sorted.

I too am running Syspro - version 6.1 SP1 - without any issues.... so far Smile

Regards

Post #1421003

joshd 1807

Posted Monday, February 18, 2013 8:19 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 2:09 PM
Points: 54, Visits: 247

If you run into any issues and need some help, PM me. I'd be more than happy to help

I did all of the migrations and upgrades myself to save the company some money. It was a daunting task but I'm glad I did it to see how Syspro works on a database level and on a systems level.

It sure feels good to know you can complete these tasks yourself instead of paying someone else the big bucks :)

Post #1421242

« Prev Topic | Next Topic »

Permissions