Viewing 15 posts - 181 through 195 (of 9,725 total)
Just verified the DCOM permissions add doesn't allow me to connect to SSIS via SSMS with my non-administrator account.
November 8, 2021 at 1:00 pm
No go with /FILE.
Executed as user: <ServiceAccount>. Microsoft (R) SQL Server Execute Package Utility Version 15.0.4102.2 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. The File option cannot be...
November 8, 2021 at 11:48 am
I'm using drive letters because we're using a folder on the local-to-the-server SAN, not a NAS. The last time we tried using a NAS share, things kept breaking every time...
November 8, 2021 at 11:46 am
We're using both DNS aliases and SQL aliases. We have too much code connection strings using just the instance names, so I was trying to make this migration easy by...
October 29, 2021 at 3:34 pm
Well, some instances may not use port 1433 !
You'll actually need to double check that the instance you are trying to address is actually the one listening at that...
October 29, 2021 at 1:29 pm
> Okay, so it does work with the port number. Now how do I get it to connect without the port number?
Start the SQL Browser service.
It was already started....
October 28, 2021 at 5:21 pm
Nevermind. Apparently 50 restarts of the service and recreating the aliases a dozen times will finally get it to work. And must use port 1433 to get the alias to...
October 28, 2021 at 3:28 pm
Okay, so it does work with the port number. Now how do I get it to connect without the port number?
October 28, 2021 at 3:25 pm
Having lots of fun at the office. All the old guard has retired and we have several new people coming in who don't know the environment and business rules yet....
October 28, 2021 at 2:41 pm
It took me a while to realize the person in question was conflating KMS with TDE. Because I pushed back on using TDE on our specific SQL 2012 environment, they...
October 22, 2021 at 5:07 pm
Could urgently use some help here, please. https://www.sqlservercentral.com/forums/topic/encrypting-sql-2012
October 22, 2021 at 8:39 am
Thanks!
This helped me 13 years after you posted it!
So glad it did.
October 5, 2021 at 7:47 pm
Completely missing the point, Phil.
It's not discrimination. You are not being forbidden from attending these conferences. You are not incapable of getting jobs or networking because of your gender or...
September 9, 2021 at 10:54 am
Can someone tell me why this isn't horribly racially prejudiced?
https://www.eventbrite.com/e/black-is-tech-conference-2021-tickets-149570987851
Can I open a "White Is Tech" conference without any ramifications? I never would, though. THAT would be racist.
Can...
September 9, 2021 at 8:36 am
Oh, FOR HEAVEN'S SAKE!
It was executing the query under the context of msdb, not the original database, so the query needs to have the MyDB prepended to the dbo.MyTable.
<headdesk>
I used...
September 7, 2021 at 6:00 pm
Viewing 15 posts - 181 through 195 (of 9,725 total)