January 29, 2012 at 10:02 am
hello guys, my problem is when i try run the first sp in my app to login the site, they throw me a error
[highlight=#ffff11]
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:
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: 26 - Error Locating Server/Instance Specified)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5050218
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity) +341
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) +129
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +270
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +195
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +232
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) +33
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +524
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +479
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +108
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
System.Data.SqlClient.SqlConnection.Open() +125
awp.conexiones.conexiones.PGL_VERIFICAR_USUARIO(String user, String password) in C:\Users\PepeW\Documents\Visual Studio 2008\Projects\awp\awp\Conexiones.vb:60
awp._Default.BtbAceptar_Click(Object sender, EventArgs e) in C:\Users\PepeW\Documents\Visual Studio 2008\Projects\awp\awp\Default.aspx.vb:13
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
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) +5563
[/highlight]
can any help me please
January 29, 2012 at 10:09 am
Is this a web based App that is throwing the error? Or are you tyring to connect using SSMS to your Hosted SQL Server.
I am going to make a big assumption that this is a web app in which case it would connect to your sql instance using Share Memory or "localhost" during development. If that is correct what probably needs to happen is you will need the sql servers fqdn (full quallified domain name) and login information.
If the above is far off can you give us a little more background information. Like if this was happening in the past or was it working, has it ever worked, and what method are you using to connect to this instance.
January 29, 2012 at 10:21 am
ya you are right, first i was trying with iss7 , all fine there, but when i up to the webhost they throw me that error, this is the page http://aspspider.info/pepew/ u can access to the page but when trying to exec the sp to log they throw the error, i up there for a test, and in 90 days will deleted there, i opened the ports 1443, then enabled the remote service sql, and put the agent server automatic and in the build account in network. but still making error.
in code:
my connectionstring is ConnectionString = "Data Source=xxxxxxxxxx\AWONG;initial catalog =awp;User ID =xx; password=xx"
thanks for ur fast reply
January 29, 2012 at 10:29 am
One thing that stuck out to me was the port. By default SQL Server operates on port 1433. IF your told to use 1443 then just disregard that last note.
January 29, 2012 at 10:34 am
ya my mistake, is port 1433,
in the xxxxxxx is the ip pc, but before was the name pc, i think that could be but no TT,
already turn off all the firewall windows to try XD, but cant too
January 29, 2012 at 10:47 am
Ok so I ran out of options. But I did some searching for you and I was able to find this article that might shine more light on the issue.
January 29, 2012 at 3:40 pm
fixed, it was the TCP/IP in configuration sql manager, the port dinamic in ipall was in another port than 1433, just change that, telnet it, and the program run the sp.
thanks a lot
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply