Authenticating SBR users from SQL DB

 

 

SQL

 

Perquisites (for a VM machine)

1.Microsoft Framework 2.0+

clip_image001[4]

 

2.windows Installer 3.1

clip_image002[4]

 

3.Microsoft SQL Server 2005 (install it before SQL Management Studio)

clip_image003[4]

(regular installation, and choose to authenticate using windows authentication)

 

4.SQL Server Management Studio Express

clip_image004[4]

 

 

1.Start Management Studio Express

 

clip_image005[4]

 

2.Connect to the server that SQL 2005 express installed on it (in our case it’s the same server)

clip_image006[4]

 

clip_image007[4]

 

3.create a new database

clip_image008[4]

 

 

4.give it a name and hit Enter

clip_image009[4]

 

5.right click on Tables and choose New Table

clip_image010[4]

 

6.choose the Columns Name (make it something easy to remember and also it’s better to make it without any spaces) 

clip_image011[4]

 

7.Hit CTRL+S to save this table and give it a name

clip_image012[4]

 

8.right click on the table name and choose Open Table

clip_image013[4]

 

9.enter your data (username and passwords)

clip_image014[4]

 

10.Now create an ODBC (Open DataBase Connectivity) on server that host SBR (in our case they all host on the same server)

clip_image015[4]

 

*choose System DSN tab and click Add

clip_image016[4]

 

*choose SQL Server and click Finish

clip_image017[4]

 

clip_image018[4]

 

*click Enter on the name of server then click Test Data Source

clip_image019[4]

 

clip_image020[4]

Now on SBR files, edit Sqlauth.aut

 

[Bootstrap]

Enable=1

LibraryName=sqlauth.dll

InitializationString=SQL_Auth //any name that listed in Authentication order

 

[Settings]

Connect=DSN=CONN2;UID=basim;PWD=basim123 //username and password of the SQL server (windows authentication)

SQL=SELECT SQL_PASSWORD FROM SQL_TABLE WHERE SQL_USER= %name

 

ParameterMarker=?

MaxConcurrent=1

ConcurrentTimeout=30

ConnectTimeout=25

QueryTimeout=25

WaitReconnect=2

MaxWaitReconnect=360

PasswordFormat = 0

DefaultResults = 0

ShutdownTimeout = 1

;ErrorMap=<mssql.ini|mysql.ini|oracle.ini>

LogLevel=0

 

[Server]

s1=1

;s2=2

 

 

[Server/s1]

Connect=DSN=CONN2;UID=basim;PWD=basim123

 

;[Server/s2]

;Connect=DSN=<dsn_name_here>;UID=<username_for_dB>;PWD=<password_for_dB>

 

[Results]

Password=1

Profile=2/48

;Alias=2/48

 

[Failure]

;Accept=0

;Profile=xyz

;FullName=Remote User

 

 

 

*note that SQL connection is established

clip_image021[4]

 

 

*in Order of Methods make SQL_Auth (the initialization string that you edit in Sqlaut.aut) on the top of other methods

clip_image022[5]

 

Troubleshooting

1.if it’s not working with you, ensure that there’s   no space characters after usernames in sql database.

 

Advertisements

2 thoughts on “Authenticating SBR users from SQL DB

Share you opinion to benefit others :)

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s