SQL Server
Microsoft's SQL Server world
-
Powershell Create of the SSISDB Catalog
So when management gets this [insert explicative] idea to strip away my MSDN enterprise access, and I need to create an SSISDB catalog on my dev server- what the hell am I to do? Well, maybe not simple… I put on my PowerShell hack through hat. Shall we? In your favorite SQL instance (we’ll just use localhost for my examples) start with making sure you have CLR ENABLED first: EXEC sp_configure 'clr enabled', 1; RECONFIGURE; GO Do this in a query window in SSMS of course. Now the PowerShell: # Load the IntegrationServices Assembly [Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Management.IntegrationServices") # Store the IntegrationServices Assembly namespace to avoid typing it every time $ISNamespace =…
-
The SQL Server Windows credentialing to work with ASP.Core and other IIS Web Sites
So somewhere in the backwaters of connecting an IIS hosted web app (a.k.a ASP Core 2.x SPA like app that uses SQL Server as it’s data host), we find the secret not so secret way to wire up a Windows Credential for Database access. Write this down: IIS AppPool\DefaultAppPool or Generically IIS AppPool\<Name My Pool> We start here in IIS with our favorite App Pool- Now this one is just for example… an ASP Core app pool, of course, would have a No Managed Code like this: Either way, the SQL Windows credential set up is the same…. In SQL server the new login looks like this: Note the IIS…
