Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Keyword not supported: 'port'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
After changing the sql default port to 1477 port i need do any setting .
and edting the web.config Server="servername:1477"
we are enable port setting in Firewall also
but i am getting the error
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that
SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844759
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Connect(ServerInfo
After changing the sql default port to 1477 port i need do any setting .
and edting the web.config Server="servername:1477"
we are enable port setting in Firewall also
but i am getting the error
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that
SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844759
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Connect(ServerInfo
Your exeption refers to an incorrect connection string. I would try to connect from the Server Explorer tab in VS. to make sure that I had a valid connection string in this case.
s.koteshwar
0 Points
5 Posts
in Web.config connection String i need include the Port number for sql server 2005
May 29, 2009 10:15 AM|LINK
code i have return in web.config for sql server 2005
in sql server 2005 we have changed the default port to 1477
<connectionStrings><
add name="ConnectionStringSQL" connectionString="server=servername;PORT=1477;database=databasename;uid=XXX;pwd=XXXXXXX" providerName="System.Data.SqlClient" /></
connectionStrings>I am getting the error below
Error Description
Keyword not supported: 'port'.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Keyword not supported: 'port'.
Source Error:
Stack Trace:
Please any one help me . I need to include the Port number in web.config
hariram.p@li...
Contributor
3366 Points
707 Posts
Re: in Web.config connection String i need include the Port number for sql server 2005
May 29, 2009 10:49 AM|LINK
Hari
---------------------------------------------
Dont forget to click "Mark as Answer" on the post that helped you.
My Site
s.koteshwar
0 Points
5 Posts
Re: in Web.config connection String i need include the Port number for sql server 2005
May 29, 2009 02:23 PM|LINK
Hi hariram,
After changing the sql default port to 1477 port i need do any setting .
and edting the web.config Server="servername:1477"
we are enable port setting in Firewall also
but i am getting the error
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
Source Error:
Stack Trace:
eric2820
Contributor
2777 Points
1161 Posts
Re: in Web.config connection String i need include the Port number for sql server 2005
May 29, 2009 02:45 PM|LINK
Your exeption refers to an incorrect connection string. I would try to connect from the Server Explorer tab in VS. to make sure that I had a valid connection string in this case.
Eric
http://www.my-msi.net
http://www.my-msi.net/Admin
blog
If a post helps you, please mark it as Ansered, thank-you.
s.koteshwar
0 Points
5 Posts
Re: in Web.config connection String i need include the Port number for sql server 2005
May 29, 2009 03:22 PM|LINK
Hi
i am able to connect to the sql server 2005 using below code
<
add name="onnectionString" connectionString="server=servername;database=database;uid=XXX;pwd=XXXXX" providerName="System.Data.SqlClient" />when i have changed the sql default port 1433 to 1477 i am unable to connect to the sql server by below code also
<add name="onnectionString" connectionString="server=servername:1477;database=database;uid=XXX;pwd=XXXXX"
providerName="System.Data.SqlClient" />i need to know that after changing the sql port i need to do any seeting in sql server or firewall please let me know
eric2820
Contributor
2777 Points
1161 Posts
Re: in Web.config connection String i need include the Port number for sql server 2005
May 29, 2009 03:50 PM|LINK
You will need to open up port 1477 for tcp traffic on your firewall.
I would think that SQL server has already been modified to work on port 1477 by this time, but it wouldn't hurt to confirm this.
Eric
http://www.my-msi.net
http://www.my-msi.net/Admin
blog
If a post helps you, please mark it as Ansered, thank-you.
mudassarkhan
All-Star
78956 Points
13402 Posts
MVP
Re: in Web.config connection String i need include the Port number for sql server 2005
May 29, 2009 04:10 PM|LINK
refer here
http://www.connectionstrings.com/sql-server-2005
Contact me
XAos
Member
14 Points
4 Posts
Re: in Web.config connection String i need include the Port number for sql server 2005
Feb 21, 2013 01:24 PM|LINK
Port numbers in web.config are seperated by a comma, not a colon.
Try:
<add name="onnectionString" connectionString="server=servername,1477;database=database;uid=XXX;pwd=XXXXX"
providerName="System.Data.SqlClient" />