|
Server Error in '/' Application.
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: 26 - Error Locating Server/Instance Specified)
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: 26 - Error Locating Server/Instance Specified)
Source Error:
Line 1423: this.Adapter.SelectCommand = this.CommandCollection[0];
Line 1424: DataSet1.PositionlistDataTable dataTable = new DataSet1.PositionlistDataTable();
Line 1425: this.Adapter.Fill(dataTable);
Line 1426: return dataTable;
Line 1427: }
Source File: c:\windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\cb8fe185\bde2cb14\App_Code.vkqy43db.0.cs Line: 1425
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: 26 - Error Locating Server/Instance Specified)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846887
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +4860189
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +376
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +4861315
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +31
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +112
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +115
DataSet1TableAdapters.PositionlistTableAdapter.Getposition() in c:\windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\cb8fe185\bde2cb14\App_Code.vkqy43db.0.cs:1425
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +71
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +350
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +488
System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1247
System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +95
System.Web.UI.WebControls.ListControl.PerformSelect() +34
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.BaseDataBoundControl.OnPreRender(EventArgs e) +22
System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +18
System.Web.UI.Control.PreRenderRecursiveInternal() +80
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842
Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082
|
|
|
|
|
It seems that your application is not able to connect with the SQL server database from within your application.
Check the SQL server connection string in your web.config.
|
|
|
|
|
<add name="ConnectionString" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|database.mdf;User Instance=true"/>
That's it. I don't know how else to go about doing this. I have MS SQL database support on my hosting, I just don't know how to get it all working. Right now the database is just in the app_data folder.
|
|
|
|
|
Is your SQL Server database in the App_Data folder of the web application.
You are using Windows Authentication to connect with SQL Server dataqbase.
The ASP.NET application will run under Network Service account in the server. Therefore you need to provide access to the Network Service account to your database.
|
|
|
|
|
I'm completely confused. I'm new at this whole thing, what do I need to do, in detail, to get it to work?
Basically I am running on a server that I do not own, I just host there. It has Plesk control panel on it, and it allows me to create MS SQL databases and such. No idea.
|
|
|
|
|
If the server allows you to create SQL Server database,
Which connection details are you using?
The same connection details should be put your web.config file.
|
|
|
|
|
I don't have any connection details, I have a Plesk control panel, that allows me to create either an MS SQL database, or a MySQL database, all I know is that you create a database, in my case it would be erik_database, and a username, in my case I created it to be simply aspadmin, and that's it.
|
|
|
|
|
I assume that you have used SQL Server database in your application.
How do you create SQL server database in the server. Using SQL Management Studio?. if so, then you can see the server name, database name and also you need to enter password.
Assume that erik_database is name of the SQL database and aspadmin is the user name, 'YourServerName' is the server name, 'YourPassword' is the password to be used connect with database, then connection string in your web.config should be as below
<add name="connectionString" connectionString="Database=erik_database;server=YourServerName;Uid=aspadmin;pwd=YourPassowrd" providerName="System.Data.SqlClient"/>
modified on Sunday, May 31, 2009 11:04 AM
|
|
|
|
|
What is the common port for a MS SQL server?
|
|
|
|
|
|
I got my apps to connect, but now it's strange because every time I go to my site a username and password dialog shows up, and I can't even login. Odd.
|
|
|
|
|
Hello,
I'm working on a simple ASP .NET health checker and I've run into a few obstacles.
1) I need to be able to get the full non-paged memory usage from a remote machine (on same network). I've tried using System.Diganostics.Process.NonpagedSystemMemorySize64 however I've come to realize that the kernel's nonpaged usage is going to be missing from that total. Here is a quick sample of what I was doing:
Process[] myprocess = Process.GetProcesses("computername");
foreach (Process p in myprocess)
{
nonpaged += p.NonpagedSystemMemorySize64
}
2) I can overcome that locally by using System.Diagnostics.PerformanceCounter however you can only access the API for that class locally. Is there another class that would suit my needs?
Any help would be appreciated.
|
|
|
|
|
can anyone tell me when to use state server outprocess session and sql server out process session? and also give me some real time scenarios for both of them?
rajesh sunakri
|
|
|
|
|
State server session and SQL Serevr session are useful when you deploy your application in web Garden or Web Farm environment.
Web garden is a scenario in which a single server machine has multiple aspnet worker processes running simultaneously. The server should have multiple processor.
Web Farm is a method of hosting a web site in a cluster of servers. The web request to the web application will be handled by multiple servers.
StateServer is faster than SqlServer session. But SQL Server is more reliable and used for mission critical applications.
Check this link[^]
|
|
|
|
|
Hi Guys,
I have a web page with many controls in ASP.NET and I am showing records to these controls from database.
Now what I am trying to do is I want to create same page with same controls but this new page should be open as a tab page.
Could you please provide me any link or source code which can help me out?
(I am trying to create a TAB page with same controls)
Thanks,
|
|
|
|
|
u can use ajax or some javascript framework like jquery.
if u need more info tell me!
|
|
|
|
|
Use Ajax Tab control.
Look into this[^]
|
|
|
|
|
In my web application I have a webservice. I'm using this webservice inside this web application. The mode of customError (in web.config) is set to "On". This prevent from me to get detailed exception in client (javascript). My webmethod defined as scriptmethod too. If I turn customError off I start getting the detailed exception. I need to keep stay with customError set to "On", but get detailed exception from webservice instead of general exception with this message: "There was an error processing the request".
Thanks.
|
|
|
|
|
Anyone have an answer for this, I have the same issue.
With customError set to On or RemoteOnly:
When the webservice method throws an error with a detailed error message, then on the error return to javascript, results.get_message() shows the generic message "There was an error processing the request", not the detailed error message.
With customError set to Off:
When the webservice method throws an error with a detailed error message, then on the error return to javascript, results.get_message()shows the detailed error message.
I want the customError to be set to RemoteOnly, but I also want get_message() to have the detailed error message, not the generic one.
Any thoughts, fixes, workarounds would be greatly appreciated.
|
|
|
|
|
Create a new folder and move there your asmx file (the asmx.cs/asmx.vb will stay in app_code folder). Add a new web.config to your new folder by "Add new item... -> Web Configuration file". Your new web.config will be almost empty. Add a "customError" element as you did it in your main web.config and set it to Off.
That's all.
|
|
|
|
|
perfect. thanks for replying!
|
|
|
|
|
hi:
how can i change the default path (aspnet_client/system_web/2_0_50727....)
for the images and css in the toolbar inside the CrystalReportViewr.
what i want, is to put all those files inside my application.
thank you
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
|
thank you
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
Hi, I am trying to make a spreadsheet in asp.net wherein, the user can enter some data and I display results for one of my methods( say Average, Standard deviation etc,). Can anybody please guide me how I read data from spreadsheet at runtime & then pass these data as parameter to my methods.
e.g
public static double Sum( double [] data)
{
double sum =0.0;
for(int i=0;i
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
