Because we have migrated to a new network profile, our access to our LANSA SQL database will now be denied. These instructions can also be used if inheriting someone’s LANSA install and would like to continue using their existing environment.
You need SQL Management studio to add a new login user to SQL, if not installed you can down load it from Microsoft’s Download center.
To add a new user to your SQL database
SQL SERVER 2008