HelloI have created a database in MS SQL using SQLCmd then when i run my clarion program it gives me an error and tells me my login has failed. I am using sql authentication and my username and password is correct because i used also in my sqlcmd function and it creates the database. I can just not connect to it when using my clarion program.
Elna, What does your connection string look like?
This is my connection string in an ini file:
Are you running your application on the same computer where the SQL Server is running?If not, you may need to open the firewall for SQL Server.Is this SQL Server Express Edition? If so, did you enable TCP/IP protocol in the SQL Server Configuration Manager? TCP/IP is not enabled by default with Express Edition.