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...

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...

It was already started....

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...

Okay, so it does work with the port number. Now how do I get it to connect without the port number?

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....

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...

Could urgently use some help here, please. https://www.sqlservercentral.com/forums/topic/encrypting-sql-2012

So glad it did.

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...

• This reply was modified 4 years ago by Brandie Tarvin.

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...

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...

Well THIS is annoying.

I have an SSIS solution / project saved that is set to DontSaveSensitive. All the packages under it are saved as the same. Last week, everything was...

So here's a random thought based on your last post, Steve. If this is the longest thread in the world, how do we get it into the Guinness book of...

I find myself wondering how many people who frequent this website have gotten the dreaded bug and are unable to return for ... various reasons. I hope everyone is doing...