SQL Server does not allow remote connections

  • Thread starter Thread starter 3Dfelix
  • Start date Start date
3

3Dfelix

Hi, someone could help me with this problem when trying to insert a record
in a SQL express database? I can view record but not edit or insert.

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)

thanks
 
In the SQL Management Studio, RightClick the SQL server instance, Choose
Properties, and under Select a Page list, click Connections. Now you should
see a checkbox labelled "Allow Remote Connections to This Server". Make sure
it is checked.

That will take care of the remote connection issue, but I have seen the same
error when the problem was elsewhere. So good luck.
Jav
 
You know, at home I just applied xp sp2 to one of my computers, and now
I cannot connect to its instance of SQLServer from another computer.

I'll have to check this. I wonder if it got turned off by the sp2
installation.
 
Hi Jav,

Thanks for your reply, but I haven't got SQL Management Studio, I'm using
SQL Server 2005 EXPRESS.

thanks
 
Back
Top