SteveoAtilla
Well-known member
Hello!
I am developing and maintaining a large .NET 2.0 application for a customer, and we are migrating the application to their data center.
It has been working very well on the SQL Server 2005 installation, but it is being moved to the corporate data center, and they do not use the standard SQL port (1433) due to a previous virus attack.
How do I specify the actual SQL port used for connections in an ASP connection string? I tried putting "port=" in the connection string, but I was told that the keyword was not supported. Here is the connection string in the web.config file:
This is what generates the error.
Any ideas?
Thanks.
Steve
I am developing and maintaining a large .NET 2.0 application for a customer, and we are migrating the application to their data center.
It has been working very well on the SQL Server 2005 installation, but it is being moved to the corporate data center, and they do not use the standard SQL port (1433) due to a previous virus attack.
How do I specify the actual SQL port used for connections in an ASP connection string? I tried putting "port=" in the connection string, but I was told that the keyword was not supported. Here is the connection string in the web.config file:
Code:
<add name="CustConnectionString" connectionString="Data Source=custSQLServer; Port=1433; Initial Catalog=custDatabase; Persist Security Info=True; User ID=dbuser; Password=p@ssw0rd" providerName="System.Data.SqlClient" />This is what generates the error.
Any ideas?
Thanks.
Steve
