473,327 Members | 1,967 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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

Hello,

I have a problem trying to connect a remote sql server. The error:
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: 26 - Error Locating Server/Instance Specified)

DEVSQL computer name
RealitySolutions instance name

Using a windows application on a LAN.

my connection string is:
connectionString="server=DEVSQL\REALITYSOLUTIONS; database=ServiceMaster; Integrated Security=True

This is what I have done:
Enabled TCP/IP and named pipes and share memory protocals on my instance in configuratoin management.
surface area configuration I have enabled enabled remote connection using TCP and Named pipes.

I still get the above error message.

Any help will be most grateful, and I think i have tried everything.

Thanks

Steve
Oct 9 '06 #1
1 16414
try adding port no. 1433 after ur instance...i.e.
it should look like...

"data source=server_name\instance,1433"
hope this will work...
thanks
Aug 19 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Duncan Winn | last post by:
I have written an Ole Db provider. It seems to be registered in the Operating system to a degree, but not fully, i.e. I can access it from a client that I have written. But it does not appear in...
2
by: John | last post by:
Hi I was working fine with create user wizard and the default membership provider. I have now customised the membership provider as per attached web.config. The create user wizard picks up the...
0
by: Bruno Alexandre | last post by:
Hi Guys, My Hosting company does not support SQL2005 so I need to use Access MDB File or SQL2000, and I'm having problems set this up under web.config I'm using:...
5
by: Vishal Gupta | last post by:
Hi This is Vishal this side.I have been trying to create a new sample website using the new Membership Provider Class. Now when I try to a create a new website and then hit on the Website...
3
by: Carlos | last post by:
Hi all, I am trying to figure out how to deal with the membership provider. I used the aspnet_regsql to create the aspnetdb database in my sqlserver2005 instance of my server. I noticed that the...
0
by: snowman | last post by:
I have vb and sql server express 2005 installed locally. I cannot add a data connection in vb express. I keep getting the error "An error has occured while establishing......26 - Error Locating...
3
by: Ted | last post by:
In WSAT, I get the following error when trying to set up my provider: Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site...
1
by: Andrew | last post by:
Hello Everyone I am receiving an error in an application I am working on. The application when its done will be a Dungeons and Dragons Network game. I am having problems with the Networked...
2
by: misogsk | last post by:
Hi All, i'm using Sql Server 2005 Standard, IIS 6.0 an Windows 2003 Server. I deployed my project on IIS (Default web site) everything goes well, but i created new web site on IIS called MCSite and...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.