2
Answers

executing content of *.sql script in C# language

vitek

vitek

20y
2.7k
1
hi, I have a windows form application, which in some case needs to run a sql script so the database on users server would be built. I tried taking the content of sql script using streamreader class and then putting the text into a sqlCommand and executing. I know that I have to read it line by line, but I need to know how to put a new line in C# because it does not work when you just execute the text. do you have any suggestions? thank you, vitek
Answers (2)
2
Thiyagarajan E

Thiyagarajan E

NA 1.1k 6.8k 8y
I found the Solution:
Finf the Report web config in the below path :
C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportManager\web .config
Replace or add below line: to set admin credential for all users to access the report.

<authentication mode="Windows" /> // Authentication mode to be set to windows

<identity impersonate="true " userName="UserName" password="Password"/> // identity impersonate to be set to true and User name & Password of the SQL Server administrator should be added.