I'm trying to connect via SQL Server Powershell Cmdlet (read not ADO.NET) using SQL-based Authentication, not Windows Integrated security.
Anyone know the format to use for this?
- Server: foo
- Instance: DEFAULT
- UserID: homer
- Password: simponsrock
I can get to this SQL-cmdlet path using SQL Server Management Studio.
When doing it that way, the path is:
The problem is that I cannot
set-location to this path via PowerShell