Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IP Address in Connection String
Message
From
23/01/2008 08:31:55
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
01284329
Message ID:
01284404
Views:
8
>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.
Very fitting: http://xkcd.com/386/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform