>Have you any systems connecting to a Microsoft SQL Server with an IP address in the connection string?
>
>If so, any problems? How is performance? Are you using encryption for the connection?
>
>I'm considering this method of database connection for remote clients running c# .NET window forms. Right now, I have no interest in ASP.NET for this application, thus the reason for this question.
>
>Thanks in advance and be well.
I would recommend AGAINST using the IP address. That ties you directly to the machine in most cases, and if it goes down you will have to scramble to reconnect your apps. Instead, I would recommend pointing it a generic DNS entry like SQLSERVER1 that you can repoint if neccessary.