SQL Connection string for asp.net

Question

I use SQL Server in an ASP.Net web application and connect database with this connection string:

<add name="SQLConnectionString" 
     connectionString="Data Source=204.93.xxx.xxx;Initial Catalog=some_Database;User ID=someUser;Password=somePassword" 
     providerName="System.Data.SqlClient"/>

Suppose our web server and SQL Server are on same machine then is it the right way of defining a connection string?

If we block SQL Server port 1433 from firewall will this connection string work as here we mention IP of the machine on which SQL Server is and SQL Server connects using port 1433

Or should we use localhost instead of IP address even then firewall block port 1433 then application might still work?

This might help databasejournal.com/features/mssql/article.php/3689846/… — CurseStacker
– CurseStacker, Commented Mar 5, 2015 at 5:52
If the SQL Server instance runs on the same machine as the web server, I'd just use . to denote "local machine". This connects as directly as possible — marc_s
– marc_s, Commented Mar 5, 2015 at 6:14

Eddie · Accepted Answer · 2015-03-05 06:00:32Z

1

If you are on two separate Machines and you're blocking the port via a firewall, then no you will not be able to communicate to the MS SQL Server Service that is listening on the Port.

If you are on one physical Machine you would not specify the IP Address. You would use the named instance or localhost.

answered Mar 5, 2015 at 6:00

Eddie

4565 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Amir Rajabi · Accepted Answer · 2015-03-05 06:06:53Z

0

You can use "." instead of ip address

answered Mar 5, 2015 at 6:06

Amir Rajabi

1

1 Comment

Tanner Over a year ago

please extend this answer to explain what the . refers to as it could be construed as unclear for users that don't know about that. some links and reference material with quotations would be useful.

Collectives™ on Stack Overflow

SQL Connection string for asp.net

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related