Can someone tell me how to create a datasource to ...
# sqlj
John Wilson
05/17/2023, 6:46 PMCan someone tell me how to create a datasource to connect to an MSSQL instance that is not the default?
dbaseServer\DEMOJohn Wilson
05/17/2023, 6:58 PMPunch line: You must set up the instance on a different port.
t
Tim
05/17/2023, 6:59 PMI figured out how to do this with Adobe Coldfusion a few years ago, but it was so annoying that the next time I set up a server, i made sure to use the default name so I didn't have to go through it again.
j
John Wilson
05/17/2023, 7:00 PMyeah I hear that. Using sql config manager, change the TCP port to something other than 1433 and connect to that
t
Tim
05/17/2023, 7:00 PMI'm trying to think back, and I think I changed the sql server settings so that it alwasys used the same port.... and then configured coldfusion to that.
2 Views