Post reply

Use an AD group for SQL Authentication

  • December 30, 2011 at 8:37 am

    #254122

    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?

  • December 30, 2011 at 8:50 am

    #1427012

    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, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 30, 2011 at 9:26 am

    #1427035

    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!

  • February 15, 2013 at 6:36 am

    #1588287

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

    ________________________________________________________________________________________________
    Regards
    Steve
    SQL 2008 DBA/DBD - MCTS/MCITP

    Please don't trust me, test the solutions I give you before using them.

  • February 15, 2013 at 2:48 pm

    #1588516

    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.

  • February 17, 2013 at 12:55 pm

    #1588688

    Ahh right - glad you're sorted.

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

    Regards

    ________________________________________________________________________________________________
    Regards
    Steve
    SQL 2008 DBA/DBD - MCTS/MCITP

    Please don't trust me, test the solutions I give you before using them.

  • February 18, 2013 at 8:19 am

    #1588873

    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 🙂

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply