|
I am doing an ASP .NET application, which is almost complete. I hosted it into IIS server and the pages are accessed from my machine. The other users in intranet can access the pages now. But when anyone is trying to login to the website, the application is throwing an error saying SQL Connection Error
The error is as follows :
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces,
error: 25 - Connection string is not valid)
The connection string is declared in Web.Config file and hope it works fine....
Can someone please sort out this issue and help me...
Thanks in advance...
SAJAN A PILLAI
ASP.NET,C#.NET Programmer
BANGALORE
"Winners don't do different things. They do things differently. ...
|
|
|
|
|
Is your SQL server on other server ? As the error says, default SQL server doesn't allow remote connection. You can enable this by going into "SQL Server Management Studio". If you have firewall running, add SQL server port to allowed list.
|
|
|
|
|
No firewalls are installed and not running on the other machine from where i am trying to access the Database.
The connection string is some thing like thing :
<add name="myconn" connectionstring="server=192.168.2.54;Initial Catalog=LG;User ID=sa;pwd=sa123" providername="System.Data.SqlClient" />
Is that the correct way of using it....
At times it throws another error saying :
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
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: Timeout expired.
The timeout period elapsed prior to completion of the operation or
the server is not responding.
Can anyone please help me...
SAJAN A PILLAI
ASP.NET,C#.NET Programmer
BANGALORE
"Winners don't do different things. They do things differently. ...
|
|
|
|
|
The timeout error message shows because it cant establish the connection and therefore just gives up after 60 seconds or so.
You need to check if remote connection to the server is allowed.
We are not a Code Charity
|
|
|
|
|
Can you specify how can check whether It allows remote connections.
SAJAN A PILLAI
ASP.NET,C#.NET Programmer
BANGALORE
"Winners don't do different things. They do things differently. ...
|
|
|
|
|
Ok- have you tried to connect from a SQL query browser to this server ?
|
|
|
|
|
Add a gridview to your form and try to bind it at design time.
If there is no error use the same connection string, That is automatically generated.
Copy and paste is a design error
|
|
|
|
|
The pages are working fine in my machine. There are Gridview and other data binded controls in the application. But when accessing from another machine in intranet, it is throwing all these errors. Please Help me
SAJAN A PILLAI
ASP.NET,C#.NET Programmer
BANGALORE
"Winners don't do different things. They do things differently. ...
|
|
|
|
|
|
I am using SQL Server 2000....
SAJAN A PILLAI
ASP.NET,C#.NET Programmer
BANGALORE
"Winners don't do different things. They do things differently. ...
|
|
|
|
|
But in your first post says, 
sajan ss wrote: When connecting to SQL Server 2005, this failure may be caused by the fact
You need to enable TCP/IP on MS SQL side.
Right click on SQL server in SQL Server enterprise manager. Tab "General".
Button "Network Configuration"
Make sure you have TCP/IP in enabled protocols.
Also make sure that if there is any firewall between Web server and SQL then
it's open. Also try to ping the SQL server from Web server. Sometimes web
server can not resolve the name of the SQL server due to the network
configuration. Fix it or use IP address.
Copy and paste is a design error
|
|
|
|
|
Thanks a lot.
SAJAN A PILLAI
ASP.NET,C#.NET Programmer
BANGALORE
"Winners don't do different things. They do things differently. ...
|
|
|
|
|
Are you able to connect?
Copy and paste is a design error
|
|
|
|
|
how create textbox dynamically and how to give a unique id to these textboxs.
my code is:
<% if (Request.Form["sacc1"]== "0" )
{ %>
<%for (int i = 1; i <= int.Parse(Request.Form["schild"]); i++)
{%>
<table style="width: 664px">
<tr>
<td colspan="2" style="height: 22px">
<span style="font-size: 10pt; font-family: Verdana"><strong>child
</strong>
<asp:RadioButton
ID="sdaughter" runat="server" Text="Daughter " Width="135px" GroupName="child" /> <asp:RadioButton
ID="sson" runat="server" Text="Son" GroupName="child" />
</span>
</td>
</tr>
<tr>
<td style="width: 268px">
<span style="font-size: 10pt; font-family: Verdana">
Name of the daughter/son:</span></td>
<td style="width: 123px">
<asp:TextBox ID="cnameofthedau" runat="server" ></asp:TextBox></td>
</tr>
<tr>
<td style="width: 268px">
<span style="font-size: 10pt; font-family: Verdana">Date of issue:</span></td>
<td style="width: 123px">
<asp:TextBox ID="cdateofissue" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 268px; height: 21px;">
<span style="font-size: 10pt; font-family: Verdana">
Place of issue:</span></td>
<td style="width: 123px; height: 21px;">
<asp:TextBox ID="cplaceofissue" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 268px">
<span style="font-size: 10pt; font-family: Verdana">
Date of expiry:</span></td>
<td style="width: 123px">
<asp:TextBox ID="cdateofexpiry" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 268px">
<span style="font-size: 10pt; font-family: Verdana">
Date of birth:</span></td>
<td style="width: 123px">
<asp:TextBox ID="cdateofbirth" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 268px">
<span style="font-size: 10pt; font-family: Verdana">
Seat preference:</span></td>
<td style="width: 123px">
<asp:TextBox ID="cseat" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 268px">
<span style="font-size: 10pt; font-family: Verdana">
Meal preference:</span></td>
<td style="width: 123px">
<asp:TextBox ID="cmeal" runat="server"></asp:TextBox></td>
</tr>
<tr>
in this code we have 8 textbox and generate another 8 textbox if user select from dropdown box 2.so now these textbox should have unique id. how can i do. plz reply soon.
|
|
|
|
|
gaurav mangal wrote:so now these textbox should have unique id. how can i do. plz reply soon.
try in this way if this work
<asp:TextBox ID='<% "cplaceofissue" + i %>' runat="server" ....
But better way to create them dynamically in code behind page.
regard
kHan
please don't forget to vote on the post that helped you.
|
|
|
|
|
Thanks Imran
for giving me the idea. but its not working.will you suggest me other code.i think it is little away from the right way.it gives it is not a valid identifier error.plz give me the idea at aspx page.how to incremwnt id .as i used it at code behind also but the id remain same.
if (!IsPostBack)
{
int k = Convert.ToInt32(s3);
for (int j = 1; j <= k; j++ )
{
for (int i = 1; i <= 4; i++)
{
TextBox TextBox1 = new TextBox();
TextBox1.ID = "stext" + i.ToString();
Panel1.Controls.Add(TextBox1);
}
}
}
in this condition id remain same .so what should i do.
in asp it works like that
|
|
|
|
|
Plz suggest me imram its very urgent .
'<% "cplaceofissue" + i %>;'
what should use in place of this.
regards
|
|
|
|
|
Pathan is right why you are not using code behind file?
Copy and paste is a design error
|
|
|
|
|
We have hosted two applications in Win 2003-IIS 6.0. We have created two websites parallel to 'Default Web site'. The domain names for both the sites are different and both the sites use forms authentication. Please help me as to how we can implement SSO between these two applications. We have the idea of implementing SSO within the same domains.
|
|
|
|
|
|
Thanks for the response.
It talks about applications in the same domain. My case the domains will be entirely different.
|
|
|
|
|
i want put a requierd field validator control in my form but not in aspx form . i want create it with programing . can anybody tell me how can i do this? and where should i write my code. in pageload() or other..
|
|
|
|
|
do you you mean a html form without "run at server"?
by the way i think checking on
onsubmit should be better
I Wish the Life Had CTRL-Z
Wizard's First Rule : People are fool,they believe what they want to believe or what they afraid to believe
www.subaitech.blogspot.com
|
|
|
|
|
sorry
<form name="form1" method="post" action="somepage" onsubmit="javascript:return my_OnSubmit();"></form>
I Wish the Life Had CTRL-Z
Wizard's First Rule : People are fool,they believe what they want to believe or what they afraid to believe
www.subaitech.blogspot.com
|
|
|
|
|
no i mean in c#.net with programing
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
