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?

[Jav]

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

"3Dfelix" wrote:

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

[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.
Jav wrote:

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

"3Dfelix" wrote:

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

[3Dfelix]

Hi Jav,

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

thanks

"Jav" <Ja*@discussions.microsoft.comescribió en el mensaje
news:3A**********************************@microsof t.com...

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

"3Dfelix" wrote:

>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

[Kevin Jones]

There is an express management studio you can download

http://msdn.microsoft.com/vstudio/express/sql/download/
3Dfelix wrote:

Hi Jav,

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

thanks

"Jav" <Ja*@discussions.microsoft.comescribió en el mensaje
news:3A**********************************@microsof t.com...

>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

"3Dfelix" wrote:

>>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

[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...b;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/
===================================
"3Dfelix" <3d*****@gmail.comwrote in message news:Oj***************@TK2MSFTNGP05.phx.gbl...

Hi Jav,

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

thanks

"Jav" <Ja*@discussions.microsoft.comescribió en el mensaje
news:3A**********************************@microsof t.com...

>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

"3Dfelix" wrote:

>>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