SQL Server does not allow remote connections

[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

 

[Willem]

Just a wild guess, but are you accessing a MDF which is marked
read-only by any chance?

 

[Guest]

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

 

[cowznofsky]

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.

 

[3Dfelix]

Hi Jav,

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

thanks

 

[Kevin Jones]

There is an express management studio you can download

http://msdn.microsoft.com/vstudio/express/sql/download/

 

[Juan T. Llibre]

re:

under the default settings SQL Server does not allow remote connections

To fix that, follow the instructions in this KB :
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277




Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================