There is going to be a number of changes in the error messages that are put out by Windows as different alements are changed .

What I've done is  uninstall from...

Thanks for your reply. The Browser Service is running on the SQL 2022 box. The cliconfg doesn't expand to provide a better view. The Server name was updated to fqdn...

• This reply was modified 2 months, 3 weeks ago by  MothInTheMachine. Reason: added note about the error being returned

I made the changes you recommended. and get the same problem. I'm using a TCP/IP alias but do have named pipes enabled. The Registry entries on my client are both...

SQL Server Configuration Manager is where Aliases have been defined, which would be on the server where SQL is installed. The use of Aliases is recommended for SharePoint which is...

• This reply was modified 2 months, 4 weeks ago by  MothInTheMachine. Reason: edited for clarity

I've created the alias on all SharePoint Servers as well as on my laptop using clconfg in sys32 and syswow64. THe SQL Server 2022 is installed on an Azure Virtual...

• This reply was modified 2 months, 4 weeks ago by  MothInTheMachine.

It's been a looooong time since I've had to ask for sql help...lol. I've added an attachement with some sample data. Sorry about that and thank you for taking a...

You're right. I added the YEAR part mid post. The Start Time is a DateTime field.

StartTimeCount StartedDay of Week
12/14/2021 16:1030Tue
12/14/2021 15:4016Tue
12/14/2021 15:301Tue
12/14/2021 15:104Tue

Thanks, but it can't be the SA account. It needs to be a specific service account.

All good information, and appreciated but still don't know what these digits represent.

paging @gilamonster

Looks like I found a way to do this.

Declare @dataFiles Table (databaseName Varchar(256))
Declare @SQL Nvarchar(Max), @databaseName Varchar(256)
Set @SQL = '';
Insert  @dataFiles
select ...

That did it. Thanks David!

Hi Lowell. Thanks for your reply. My hunch is there is no automagic encryption that SQL and Oracle share. One solution I had considered was like your. A SSIS dumps...

Lots of looks on this one. Is this really so rare a scenario? A windows based SQL 2012 server wanting to run a SSIS job to pull data from a...