sounds like a permissions problem to me. Is you network a domain or workgroup?
On Wed, Dec 24, 2008 at 1:26 AM, syed tameem <[email protected]> wrote: > it is an windows application it is working in one of the clients same > connection string, and in another system the Microsoft Sql Server is not at > all opening, we have restarted the services, but of no use, Please can > anybody tell me wat the problem is. > > Thanks > > On Wed, Dec 24, 2008 at 12:53 AM, The_Fruitman <[email protected]> > wrote: >> >> As the error message states: The server was not found or was not >> accessible. >> >> Check your connection string data source property. >> >> www.connectionstrings.com >> >> Verify that you are not blocked by a firewall. >> >> >> >> On Dec 23, 8:26 am, "hirendra singh" <[email protected]> wrote: >> > * hi >> > >> > SqlConnection con = new SqlConnection(cStr); >> > >> > con.Open(); >> > >> > code give an error any on give bast solution this code >> > its working fine in local mssql. >> > >> > its not working online working in server mssql. >> > please let me knw wer i'm wrong >> > here is my code >> > >> > Hirendra pratap singh >> > >> > Niit student >> > >> > thanks >> > 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: Named Pipes Provider, error: 40 >> > - >> > Could not open a connection to SQL Server) >> > >> > 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: Named Pipes Provider, error: 40 - Could not open >> > a >> > connection to SQL Server) >> > >> > Source Error: >> > >> > Line 33: >> > Line 34: con.ConnectionString = conn;Line 35: >> > con.Open();Line 36: int i; >> > Line 37: i = 0; >> > >> > using System; >> > >> > using System.Data; >> > >> > using System.Configuration; >> > >> > using System.Collections; >> > >> > using System.Web; >> > >> > using System.Web.Security; >> > >> > using System.Web.UI; >> > >> > using System.Web.UI.WebControls; >> > >> > using System.Web.UI.WebControls.WebParts; >> > >> > using System.Web.UI.HtmlControls; >> > >> > using System.Net.Mail; >> > >> > using System.Data.SqlClient; >> > >> > public partial class Signup : System.Web.UI.Page >> > >> > { >> > >> > SqlConnection con = new SqlConnection(); >> > >> > string conn = ConfigurationManager.ConnectionStrings["appConnection" >> > ].ConnectionString; >> > >> > protected void Page_Load(object sender, EventArgs e) >> > >> > { >> > >> > -----some code here >> > >> > } >> > >> > protected void Button3_Click1(object sender, EventArgs e) >> > >> > { >> > >> > con.ConnectionString = conn; >> > >> > con.Open(); >> > >> > int i; >> > >> > i = 0; >> > >> > SqlCommand cmd2 = new SqlCommand("select [username] from userinfo2 >> > where" + >> > "(([usernam...@username))", con); >> > >> > cmd2.Parameters.Add("@username", SqlDbType.VarChar, 50); >> > >> > cmd2.Parameters["@username"].Value = txtusername.Text; >> > >> > SqlDataReader dr; >> > >> > dr = cmd2.ExecuteReader(CommandBehavior.CloseConnection); >> > >> > while (dr.Read()) >> > >> > { >> > >> > i = 1; >> > >> > } >> > >> > if (i == 1) >> > >> > { >> > >> > LblUN.Visible = true; >> > >> > LblUN.Text = txtusername.Text + " is not available"; >> > >> > } >> > >> > else if (txtusername.Text == "") >> > >> > { >> > >> > LblUN.Visible = true; >> > >> > LblUN.Text = "Please enter the value"; >> > >> > } >> > >> > else >> > >> > { >> > >> > LblUN.Visible = true; >> > >> > LblUN.Text = txtusername.Text+" is available"; >> > >> > } >> > >> > dr.Close(); >> > >> > con.Close(); >> > >> > } >> > >> > * ** *+++++++++++++++++++++++++++* >> > >> > <?xml version="1.0"?> >> > >> > <configuration> >> > >> > <configSections> >> > >> > <sectionGroup name="system.web.extensions" >> > type="System.Web.Configuration.SystemWebExtensionsSectionGroup, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35"> >> > >> > <sectionGroup name="scripting" >> > type="System.Web.Configuration.ScriptingSectionGroup, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35"> >> > >> > <section name="scriptResourceHandler" >> > type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35" requirePermission="false" >> > allowDefinition=" >> > MachineToApplication" /> >> > >> > <sectionGroup name="webServices" >> > type="System.Web.Configuration.ScriptingWebServicesSectionGroup, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35"> >> > >> > <section name="jsonSerialization" >> > type="System.Web.Configuration.ScriptingJsonSerializationSection, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35" requirePermission="false" >> > allowDefinition=" >> > Everywhere" /> >> > >> > <section name="profileService" >> > type="System.Web.Configuration.ScriptingProfileServiceSection, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35" requirePermission="false" >> > allowDefinition=" >> > MachineToApplication" /> >> > >> > <section name="authenticationService" >> > type="System.Web.Configuration.ScriptingAuthenticationServiceSection, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35" requirePermission="false" >> > allowDefinition=" >> > MachineToApplication" /> >> > >> > </sectionGroup> >> > >> > </sectionGroup> >> > >> > </sectionGroup> >> > >> > </configSections> >> > >> > <system.web> >> > >> > <customErrors mode="Off" defaultRedirect="404.aspx" /> >> > >> > <!-- >> > >> > Set compilation debug="true" to insert debugging >> > >> > symbols into the compiled page. Because this >> > >> > affects performance, set this value to true only >> > >> > during development. >> > >> > --> >> > >> > <httpHandlers> >> > >> > <remove verb="*" path="*.asmx" /> >> > >> > <add verb="*" path="*.asmx" validate="false" >> > type="System.Web.Script.Services.ScriptHandlerFactory, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35" /> >> > >> > <add verb="*" path="*_AppService.axd" validate="false" >> > type="System.Web.Script.Services.ScriptHandlerFactory, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35" /> >> > >> > <add verb="GET,HEAD" path="ScriptResource.axd" >> > type="System.Web.Handlers.ScriptResourceHandler, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35" validate="false" /> >> > >> > <add verb="GET" path="ImageVerifier.axd" >> > type="NatsNet.Web.UI.Controls.ImageVerifier, >> > NatsNet.Web.UI.Controls" /> >> > >> > </httpHandlers> >> > >> > <httpModules> >> > >> > <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35" /> >> > >> > </httpModules> >> > >> > <compilation defaultLanguage="c#" debug="true" /> >> > >> > <globalization culture="en-US" uiCulture="en-US" /> >> > >> > </system.web> >> > >> > <system.web.extensions> >> > >> > <scripting> >> > >> > <webServices> >> > >> > <!-- Uncomment this line to customize maxJsonLength and add a custom >> > converter --> >> > >> > <!-- >> > >> > <jsonSerialization maxJsonLength="500"> >> > >> > <converters> >> > >> > <add name="ConvertMe" type="Acme.SubAcme.ConvertMeTypeConverter"/> >> > >> > </converters> >> > >> > </jsonSerialization> >> > >> > --> >> > >> > <!-- Uncomment this line to enable the authentication service. Include >> > requireSSL="true" if appropriate. --> >> > >> > <!-- >> > >> > <authenticationService enabled="true" requireSSL = "true|false"/> >> > >> > --> >> > >> > <!-- Uncomment these lines to enable the profile service. To allow >> > profile >> > properties to be retrieved >> > >> > and modified in ASP.NET AJAX applications, you need to add each property >> > name to the readAccessProperties and >> > >> > writeAccessProperties attributes. --> >> > >> > <!-- >> > >> > <profileService enabled="true" >> > >> > readAccessProperties="propertyname1,propertyname2" >> > >> > writeAccessProperties="propertyname1,propertyname2" /> >> > >> > --> >> > >> > </webServices> >> > >> > <!-- >> > >> > <scriptResourceHandler enableCompression="true" enableCaching="true" /> >> > >> > --> >> > >> > </scripting> >> > >> > </system.web.extensions> >> > >> > <system.webServer> >> > >> > <validation validateIntegratedModeConfiguration="false" /> >> > >> > <modules> >> > >> > <add name="ScriptModule" preCondition="integratedMode" >> > type="System.Web.Handlers.ScriptModule, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35" /> >> > >> > </modules> >> > >> > <handlers> >> > >> > <remove name="WebServiceHandlerFactory-Integrated" /> >> > >> > <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition=" >> > integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35" /> >> > >> > <add name="ScriptHandlerFactoryAppServices" verb="*" >> > path="*_AppService.axd" >> > preCondition="integratedMode" >> > type="System.Web.Script.Services.ScriptHandlerFactory, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35" /> >> > >> > <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" >> > path="ScriptResource.axd" >> > type="System.Web.Handlers.ScriptResourceHandler, >> > System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, >> > PublicKeyToken=31bf3856ad364e35" /> >> > >> > </handlers> >> > >> > </system.webServer> >> > >> > <connectionStrings> >> > >> > <add name="appConnection" connectionString="data source=.;initial >> > catalog=manager_vdnextw; User id=vdnextw; Password=123456" >> > providerName=" >> > System.Data.SqlClient"/> >> > >> > <remove name="LocalMySqlServer" /> >> > >> > </connectionStrings> >> > >> > </configuration> >> > *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: Named Pipes Provider, error: 40 >> > - >> > Could not open a connection to SQL Server)* *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: Named Pipes Provider, error: 40 - Could not open >> > a >> > connection to SQL Server) >> > >> > * 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: Named Pipes Provider, error: 40 >> > - >> > Could not open a connection to SQL Server) 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: Named Pipes Provider, error: 40 - Could not open >> > a >> > connection to SQL Server) >> > >> > Source Error: >> > >> > Line 33: >> > Line 34: con.ConnectionString = conn;Line 35: >> > con.Open();Line 36: int i; >> > Line 37: i = 0; >> > >> > Source File: c:\inetpub\vhosts\vdnext.com\httpdocs\Signup.aspx.cs >> > Line: 35 >> > >> > 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: Named Pipes Provider, error: 40 - Could not >> > open a connection to SQL Server)] >> > System.Data.SqlClient.SqlInternalConnection.OnError(SqlException >> > exception, Boolean breakConnection) +4844759 >> > >> > >> > 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) +4858065 >> > >> > 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) +342 >> > >> > >> > 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) +185 >> > >> > >> > 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 >> > Signup.Button3_Click1(Object sender, EventArgs e) in >> > c:\inetpub\vhosts\vdnext.com\httpdocs\Signup.aspx.cs:35 >> > System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111 >> > System.Web.UI.WebControls.Button.RaisePostBackEvent(String >> > eventArgument) +110 >> > >> > >> > System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String >> > eventArgument) +10 >> > System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler >> > sourceControl, String eventArgument) +13 >> > System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) >> > +36 >> > System.Web.UI.Page.ProcessRequestMain(Boolean >> > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) >> > +1565 >> > >> > ------------------------------ >> > Version Information: Microsoft .NET Framework Version:2.0.50727.3053; >> > ASP.NET Version:2.0.50727.3053 * >> > >> > -- >> > A Door knocks twice. insider asks--who is there... ans was : its >> > OPPOTUNITY" >> > insider tels ,you are wrong becouse oppotunity never knocks twice >> > रात यों कहने लगा मुझसे गगन का चाँद, >> > आदमी भी क्या अनोखा जीव होता है! >> > ,उलझनें अपनी बनाकर आप ही फँसता >> > और फिर बेचैन हो जगता, न सोता है। >
