I’m a developer at heart, so I’m constantly keeping up with the latest technologies. currently I’m developing ‘Time and Bill’, an ASP.NET Core Web Application. The application is based on Microsoft .NET Core 5.0 (5.03 to be exact). Well, developing the application is one thing, the other thing is to publish the application on an…
Several Windows Server reported this Solution was connecting to SUSDB using Servername: np:\.\pipe\MICROSOFT##WID\tsql\queryStart SQL Server Management Studio elevated or get a Login failed for user Then query for the current value of MaxXMLPerRequest in table tbConfigurationC USE SUSDB GO SELECT MaxXMLPerRequest from tbConfigurationC Then update the value: UPDATE tbConfigurationC SET MaxXMLPerRequest = 0 And check…
SQL Server Management Studio installed, tried to connect to a SUS WID using Servername: np:\\.\pipe\MICROSOFT##WID\tsql\query Resulted in: =================================== Cannot connect to np:\\.\pipe\MICROSOFT##WID\tsql\query. =================================== Login failed for user ‘REMOVED\admin.solvia’. (.Net SqlClient Data Provider) —————————— For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476 —————————— Server Name: np:\\.\pipe\MICROSOFT##WID\tsql\query Error Number: 18456 Severity: 14 State: 1 Line Number: 65536 —————————— Program Location: at…
I often use Visual Studio and LocalDB in combination with Entity Framework 6+ for Prototyping or to make a quick sample. I also publish them sometimes to my Github Page Sample Code for this post can be found here: https://github.com/itsChris/Sample-EF-RelationsApp In the following steps we’ll: Create a .NET Framework 4.5 Console App -> not .NET…
Previous post How to get your developer workstation Microsoft SQL Server Express LocalDB-ready In our last blog post we learned how we: install a Microsoft SQL Server LocalDB using Visual Studio InstallerInstall Chocolateyuse Chocolatey to install the Microsoft SQL Server Management Studio (SSMS) Now we need to configure LocalDB in order to use it. To…