Thank you. Working fine.

Thank you for the response and explanation. I have added the account back the errors are not coming again. I think it it worked.

Yes, it is express and working fine.

Found the solution here http://www.batenict.nl/2020/04/03/token-based-server-access-validation-failed-with-an-infrastructure-error-login-lacks-connect-sql-permission/

Thank you. I have fixed it by changing IIS application pool identity.

• This reply was modified 1 year, 11 months ago by  Saran.

Thanks everyone. I will speak to the team and see what we can do.

When it comes to validating users’ input, dynamic SQL or not, I like to use the belt and braces method of validating the input by running it through the...

Thanks Johan.

Can you share some example of parameterized stored proc.

Ex: something like this.

Create sp_name (@u_id int,@pass varchar(100))

as

begin

declare @l_u_id int

declare @l_pass varchar(100)

code here

end

2. If I remove reader, how he login used...

• This reply was modified 2 years ago by  Saran.

Thanks Steve. I am working on to the server provider to have open ports to the server. Once I get list will disable unused ports.

Yes, that is correct. For lot...

Thank you confirming Durai, that's what I read after I posted.

Thank you Jeffrey Williams. Then we will run in the same account, but not sure what us the password for that default account.

Can we reset the password. I am further...

Double check your configuration settings for the network. You could have something else open and available. Ideally, we do not expose SQL Servers on the Internet in any way,...

Got it.

select 'LOAD DATA INFILE ''db/'+name+'.txt'' INTO TABLE '+name+'('+STRING_AGG(COLUMN_NAME,',')+');'

from tbl_column_length C left join sysobjects  S on C.TABLE_NAME=S.name
where type='u' 
and length <100
and name in('table1')
group by name

Thank you @sean Pearce.

I am doing same for other load but getting an error.

-- Needed Result

LOAD DATA INFILE 'db/table1.txt' INTO TABLE table1 (id,name,Dept)

select 'LOAD DATA...