.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

Accessing an instance of SQL using a seperate network

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
 
Hi everyone. I'll go through my configuration and then my problem.  Thanks in advance for any help. Host 1: OS:  Windows 2008 R2 Network: NIC 1 Production Network- 10.0.1.100 - VLAN 5 (Network Connectivity tested and verified) NIC 2 Data Network - 10.0.150.10 - VLAN 10 (Network connectivity tested and verified) SQL: SQL 2008 SP1 Instance 1:  Default MSSQLSERVER TCP Config: Enabled: Yes, Listen All: No IP1: Active, Enabled, 10.0.150.10, TCP Dynamic Ports blank, TCP Port 1433 IP2: Active, Enabled, 10.0.1.100, Dynamic Ports blank, TCP Port 1433 IP3: Active, Not Enabled, 127.0.0.1, Dynamic Ports blank, TCP Port 1433 Instance 2:  VMM Instace 2 TCP Config: Enabled: Yes, Listen All: No IP1:  Active, Enabled, 10.0.150.10, TCP Dynamic Ports: 50347, TCP Port Blank IP2:  Active, Not Enabled, 10.0.1.100, Dynamic Ports: 0, TCP Port Blank IP3:  Active, Not Enabled, 127.0.0.1, Dynamic Ports: 0, TCP Port Blank Host 2: OS: Windows 2008 R2 Network: NIC 1 Production Network- 10.0.1.200 VLAN 5 (Network Connectivity tested and verified) NIC 2 Data Network - 10.0.150.11 - VLAN 10 (Network connectivity tested and verified) My Problem I am trying to install Microsoft Virtual Machine Manager on Host 2 which I want to use the NIC 2 to connect to instance 2, VMM.  Every time I try to install the VMM software I cannot connect to the VMM instance.  I'm not


View Complete Post


More Related Resource Links

OLE DB Error: Network-Related or Instance-Specific while Deploying SSAS 2008 Cube

  
Hi, I encountered the below listed error while attempting to deploy SSAS 2008 DB: Error 1 OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [5]. ; 08001.  0 0  I am running a standalone MSSQL 2008 named instance on Windows Server 2008 R2. Here are the steps I have taken but yet the issue is not resolve: 1) Enable Remote connections on the server 2) Enable TCP\IP 3) SQL Browser is Running 4) Set Firewall Inbound Exceptions for SQL Browser, Default Port 1433, UDP Port 1434 5) Using Management Studio I can successfully connect to the MSSQL named instance from the app server 6) I can ping I MSSQL box from the app server 7) Read and implemented all steps in the MSDN post below: http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx Thanks for your help.

A network-related or instance-specific error occurred while establishing a connection to SQL Server.

  
I know what the problem is. I am just not sure how to fix it. I get the error below when I have this: < roleManager enabled="true" />  It works fine when I set rolemanager = false but I need to use membership roles.   my connection strings are:  <connectionStrings> <add name="ConnMSSQLASP" connectionString="Data Source=MISFS;Initial Catalog=ASPNetDB;User Id=----;Password=-----;" providerName="System.Data.SqlClient"/> <add name="DisasterRecoveryConnectionString" connectionString="Data Source=MISFS;Initial Catalog=ASPNetDB;User Id=----;Password=----" providerName="System.Data.SqlClient"/> </connectionStrings>    Can someone help me with this? ERROR Below: 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. SQLExpress database file auto-creation error: The connection string s

network - related or instance-specific error occurred while establishing a connection to sql server

  
A co worker tried installing sql2008 express on his home laptop and had a problem, i downloaded the install and installed again (didnt remove orig install ( prob should have))  now when i try to connect using Server type : Database Engine  Server name : . or .\SqlExpress with window auth i get the message:Cannot connect to ..Additional Info : A network - related or instance-specific error occurred while establishing a connection to sql server

A network-related or instance-specific error occurred while establishing a connection to SQL Server

  
I got this error when i try to connect to sql server10.0  from c# 2008 express. any idea.Pedro

network-related or instance-specific error occurred while establishing a connection to SQL Server

  
I have two database one on sql server 2000 and other on 2005. When i am connecting my application through web serviceit gives exception:"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)"with sql server 2000 no such problem occurs. I have cheked the firewall and web.config connection string also.

A network-related or instance-specific error occurred while establishing a connection to SQL Server

  

I just opened the project. Yesterday everything worked fine. It does not work any link database.
Today I open the project and displays:

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:

A network-related or instance-specific error occurred while establishing a connection to SQL Server

  

Hi,

I've created a small website with a simple sqlite database using vwd 2010 .net 4. In dev and test envionments everything works fine, however when i promote to my hosting provider i receive the following 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: 26 - Error Locating Server/Instance Specified)

I've been configuring the connection strings (autogenerated from entity framework and attached db) but unable to get it working on the hosting provider, I'm assuming it's related to permissions but not entirely sure how to resolve - here's the web.config as it stands:

<add name

A network-related or instance-specific error occurred while establishing a connection to SQL Server.

  

Well, there are many post about this issues but mine is a bit different that I have this problem on my hosting which I can't configure their MS SQL Server. The only thing I can access is Plesk control panel. I have uploaded my mdf file in httpdocs/App_Data, while I establishing the connection it say..

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)

Damn this (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

  

 

Well my problem is this error message Message="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)"

 

but :

 

-can't connect to SqlServer Express 2005 on my network server from my application while ITS RUNNING. What I mean is that when I use Server Explorer Window on VS2008 every thing is fine (I can even insert and modify data from server explorer), in fact, when I use Datatables and I choose to preview data through TableAdapters (Design Time) I get data, and also can run the queries from there directly to the data base, but when I'm debbugin the application I get this error.

 

-when I run Sql Server Management Studio, its also fine, even though I can't see the Sql instance on the server (or any of my partners machine) when I try to browse them. But if I type the server path (servername\instancename) everything is OK.

 

-I know the problem is not the connection string 'cause mya partners nd I use the sa

Accessing Sharepoint 2010 root throught network drive

  

When I try to go to \\sp_domain\ I am presented with 2 network shares which I can't open afe15108-b347-4a9d-ba3a-1426636526d4-query-1  and afe15108-b347-4a9d-ba3a-1426636526d4-query-2.

If I navigate to \\sp_domain\site I get a list of libraries and sub sites as one would expect.

Does any one have any thoughts as to why I am unable to see list of sites and libraries at the root level?


a network-related or instance-specific error occurred while establishing a connection to sql server

  
I installed a new installation of SQL 2008R2 server on Windows 2008R2 server. First I can not connect to it with SQL management Studio 2005 so I wanted to install 2008R2 and I can not install it and that first. I used a PC with SQL management Studio 2008R2 but I can not connect to the database and I receive the following 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. Verfiy the instance name is correct and that SQL server is configured to allow remote connection. error 40 - could not open a connection to SQL server Microsoft SQL server, error 2

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

  

Hi

I am receiving an intermittent error as described in the thread title. I have checked several other threads and the commons solutions seem to be...

check the SQL browser service is running

check the spelling of the instance name

check that the correct UDP port is open on the firewall

All of the above are ok in my case but where my case differs is that the error is intermittent - restarting the server solves the problem but sooner or later, it reocurrs. This specificaly relates to an asp.net application - even when I start getting the error, the web app runs fine over the network but running it in debug or testing / creating connection strings gives error 26. I am all out of ideas with this and it's really not convenient to shut down the server in the middle of a working day. I intended to include the full error text at the end of this question but in the time it has taken me to type this, it has started working again (what the ____!!??!). I am running SQL Server 2008 Express with Visual Studio 2010. Any help would be greatly appreciated.

Regards

Steve

 Update: full error text below...

Server Error in '/' Application.
----------------------------------------------------------

Problem Accessing a Web Service Outside of Local Network

  

I've created a simple web service and tested it on my local machine and it worked perfectly. Another machine in the same local network tested using the web service and it worked fine as well. However, when I try to access the web service from outside of our local network, it returns a HTTP status 400: Bad Request error message. Any clues as to what might be causing this behavior?

It's my understanding that port 80 is for web services and that is not being blocked by a firewall or anything, so that is not the issue. Any help would be appreciated.


A network-related or instance-specific error occurred while establishing a connection to SQL Server.

  

I have looked all over and tried every suggestion to resolve this issue but it persists:

I am trying to connect to an sql server on a windows 7 machine from an asp.net application.  When I am in Visual Studio I can use the connection in sqldatasource controls and everything is fine when I test the queries.  However, when I attempt to run the application I get the error.

I've tried:

1) Turning on named pipes on the database server and restarting the server.

2) Stopping all firewalls on the server.

3) Making sure that the server is configured to allow remote connections.

My connectionstring is:

Data Source=MYSERVERNAME\mssqlserver;Initial Catalog=NEMO;User ID=sa;Password=password

I have tried using portqryv2 to see whats happening on the UDP port that sql server uses as suggested in another post but gets a syntax error from the utility.

I am baffled by this one and would greatly appreciate some help.

Thanks.


How can I hide the SQL instance from appearing in Enterprise Manager > connect > Network servers lis

  

I can find all sql instances in the network in Enterprise Manager > connect > Network servers list.

How can I hide my instances to appear in the list or in the network?


Sara

Prompted for network credentials via internet while accessing SSRS reports in SharePoint integrated

  
Hi

We have developed a SharePoint- FBA site and published it through ISA.  The site, among many features, displays SSRS reports through Performance Point Monitoring dashboards.  SSRS is using windows integrated authentication (Kerberos).  Through intranet, the reports are getting displayed without any issue, but, through internet, its getting prompted when we try to access the reports for the first time after logging into the site using FBA credentials.  When we enter valid domain credentials after being prompted, it starts displaying reports without any issues and never prompts again for that FBA session.

We have been trying to eliminate the prompt through internet, but couldn't do so. 

Has anyone experienced the same before?

Any help is appreciated.


A network-related or instance-specific error occurred while establishing a SQL connection

  
Hi
I am configuring SharePoint form Based Authentication for my clients internet site where users can authenticate through the sql DB. I am running windows server 2008, SharePOint 2007, WSS 3.0, SQL 2008 and Visual Studio 2005. I had followed this article to configure FBA on the server : http://www.andrewconnell.com/blog/articles/HowToConfigPublishingSiteWithDualAuthProvidersAndAnonAccess.aspx , 

all is well till the time i sign in on the internet site, it throughs an error msg for which I have benn trying very hard to sole it still no luck. the error msg im getting is:

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)   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.Td
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend