Post file to web api

 

Export VM to a tab delimited file

 

Fix orphaned sql users

Creating-Updating DB

  • Then open query window and execute following stored procedure

SQL 2005 Full version

Useful script

Otherwise to associate user to login try the following:

 

Install SQL instance on domain controller

Installing SQL instance is not recommended and will usually fail (when starting the service section in the wizard). If this happens you can try the following:

This usually occurs when the master.mdf or the mastlog.ldf gets corrupt . In order to solve the issue go to the following path C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL , there you will find a folder ” Template Data ” , copy the master.mdf and mastlog.ldf and replace it in C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Data folder . Thats it . Now start the MS SQL service and you are done

It will reset the sa password.

 

Default sa passwords.

SQL Server 2008/R2 Express
User:  sa
Password:   [blank password – leave field empty to connect]

SQL Server 201x Express
User:  sa
Password: Password123

SQL Server 20xx Web or Standard
User: sa
Password:   will be the same as your administrator or root user password at the time the VDS was provisioned.

 

Login via management studio and run the following to change sa password:

 

 

 

Otherwise you can you use the following link to do it properly.

How to Install Microsoft SQL on a Domain Controller

Run Visual Studio as admin (need to run this to execute ps/iis scripts within)

Rightklick devenv.exe and choose Troubleshoot compatibility. In the new window click at Troubleshoot programm, then check The programm requires additional permission.

This forces the settings to administrator rights only, without running in compatibility mode.

Otherwise with other programs you should be able to right click and hit properties. There should be a compatibility tab. If not need to enable the compatibility tab in win 10.

 

https://www.tenforums.com/tutorials/106509-add-remove-compatibility-tab-properties-page-windows.html

 

Operating system error 5(Access is denied.).

When creating backup need to set the permissions of the folder. Set the security permissions to allow ‘Authenticated Users’ to have read write permissions to the folder. Then run backup scripts again.

 

 

Get the Top 10 of each distinct column value

 

Submit Post with error catch

 

Async Calls

 

WPF DataGrid Add right click for each row