Windows 10: network policy server logs to mssql add new columns

Hello. I have windows server 2016 and nps is configured.I want to record authorization logs in the mssql database. I found the standard variant of recording in the database, but I am missing some columns, for example, the Calling_Station_Id column, which the standard script does not create. When I try to add it manually to the database, NPS does not want to write logs to the database at all and shows the error NPS cannot log accounting information in the primary data store 10.0.0.. NPS will continue to process connection requests without logging accounting information in this data store.Err

:)

 

How do I delete C:\Users\MSSQL$ADK ?

Hi,

Have you installed any SQL programs? If you do, MSSQL$ADK is related to that program in
utilizing and handling data management for that specific program. Although this program is harmless to remove, we still suggest to ignore this since that there is no harm is being done to your computer. However,
if you want to remove this, follow these steps:

• 
  Open
  File Explorer
  and right click on
  Local Disk (C.
  
• 
  Choose
  Properties.
  
• 
  Under
  Security Tab,
  To change permissions, click Edit.
  
• 
  Choose
  Full Control.
  
• 
  Select
  Apply
  and click
  OK.
  

Try to check if you now see
MSSQL$ADK.

Let us know how it goes.

Regards.

 

Switching from mySQL to MSSQL

Hello all,
I a have a dilemma on my hands. MY application uses mySQL, and everything woks great. I planned to list mysql server as a requirement for my application, so that I didn't have to worry about licensing issues with distribution (my app is commercial, not GPL). My app uses libmysql.dll to connect to the mysql database instance, which, come to find out, must be licensed to distribute as well says Oracle.

So:
I planned to switch everything over to MSSQL express, which is totally free to distribute and use in commercial applications. I am used to mySQL server, not MSSQL. Upon installing MSSQL server, I discovered it uses local authentication (Windows username and pass)... Is there a way to set up MSSQL server to function like mySQL server? ex: requiring my connection string to use username, pass, DB name, and table name? The DB is accessed by both my app and an IIS site runnign on the same server.

Does anyone know of any good tutorials or sample walkthroughs of building a vb.net app that connects to and uses MSSQL server?

Thanks so much guys

 

Biztalk Server 2016 issue

Infra detail of Biztalk server enviornment

Multi node enviornment (one node is primary and another one is joined to that group)

MSSQL server database- BizTalk db's are distributed in two servers (MSSQL Server Instance1: BizTalkmsgboxDB & BizTalkmgmtDB, MSSQL Server Instance 2: BizTalkDTADb & SSODB).

In our enviornment BiztalkTalk server logging a error message in Event log for every 9-10Min.

Error message:

Either another TDDS is processing the same data or there is an orphaned session in
SQL server holding TDDS lock.Either another TDDS is
processing the same data or there is an orphaned session in SQL server holding TDDS lock.
SQLServer: xxxxx, Database: BizTalkDTADb.

Permissions are properly granted as per the microsoft documents and also from the blogs, but issue is still exist.

Please check and give me the suggestion.