Creating Database Projects with SQL Anywhere Studio, Part 2 - Integrated Login
(Page 2 of 5 )
Logging into a server, for example, an SQL 2000 Server, requires authentication. There are two kinds of authentication: Windows authentication (trusted connection) and SQL Server authentication(from non-trusted clients). Similarly in Adaptive Server Anywhere, there is what is called an Integrated login; that is, the login that is mapped to the user profile of an existing user (who may fullfil a specific role).
In order to create an Integrated login, right click on the "Integrated Login" node in the left frame of Sybase Central. If there are existing integrated logins, they will be seen on the list. A new one can be created by right clicking in an empty area in the list view, and picking up "new." This wakes up the Integrated Login Wizard, as shown in the next picture.
In order for the ASPNET application to access the database, this application should have an integrated login. This is made possible by choosing for ASPNET to have an integrated login as shown in the next picture. Further, it has been allowed to assume the DBA role. In production environments, a lot more care is necessary when making these choices.
Clicking on the NEXT button in the above picture takes you to the final dialogue, which is, what kind of login do you wish to confer upon this user? In this case, mixed login mode has been chosen. When the FINISH button is clicked, one should see the ASPNET user in the Integrated login list view, as shown in the following picture. Integrated login will help with logging in once for both the application and the data base.
Next: Importing ASA data into an Excel worksheet >>
More Database Articles
More By Jayaram Krishnaswamy
/ 11 
