Understand Sql Server connectionstring for asp.net
Posted
by Eatdoku
on Stack Overflow
See other posts from Stack Overflow
or by Eatdoku
Published on 2010-05-10T03:49:23Z
Indexed on
2010/05/10
3:58 UTC
Read the original article
Hit count: 341
connectionstring
Hi,
I am trying to understand the differences between the following 2 connectionstrings. one uses servername\instancename and the other one uses the server ip address.
Can I specify port number for "serverName\instanceName". I know you can specify port number for ip address, something like '10.0.0.1,xxx'.
thanks,
Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
© Stack Overflow or respective owner