How do I connect excel to a remote sql server
Posted on 2014-02-26
I have a server that has sql server installed - we usually run remote session on it using Remote Desktop.
it has public ip address and we do not use VPN
I need to connect my excel book to get data from a database from the sql server on that remote server.
I have firewall off, the sql server browser is running.
what do I need to do on Excel ? what syntax to use for the conection ?
the server addres is something like ( for RDC) ipaddress:45873
then the SQL server is a named instance say SQLINST ( tcp port for sql instance is something like 12354)