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: 305

Filed under:

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

Related posts about connectionstring