Tuesday

sql connection string port

If you want to connect to specific instance sometimes you have to specify port on which this instance running.
Port is specifying by comma in connection string like this(1362):


<add key="ConnectionString" value="server=sql-server1\qa,1362;database=db1;user id=u1;password=MyPassword;Trusted_Connection=no"/>

No comments:

test smtp server with powershell

Send-MailMessage -SMTPServer smtp.domain.com -To [email protected] -From [email protected] -Subject "This is a test email" -Body ...