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.
http://www.microsoft.com/en-us/download/details.aspx?id=7593
To add a new user to your SQL database
Number 3 Microsoft® SQL Server® 2008 Management Studio Express
Install using your pc name/ SQLSERVER as server name
Right Click LOGINS and select New
This is the ADD screen, use my credentials as a guide.
SQL SERVER 2008