dbTalk Databases Forums  

Can't connect remotely to SQL Server Express

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss Can't connect remotely to SQL Server Express in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roger Withnell
 
Posts: n/a

Default Can't connect remotely to SQL Server Express - 08-06-2008 , 07:03 PM






I have installed SQL Server Express on a Windows 2003 platform.

I have set the Windows firewall to allow sqlservr.exe and sqlbrowser.exe and
udp port 1434. SQL browser is running.

I have enable tcp/ip protocol. The SQL Server 2005 Surface Area
Configuration is set to local and remote connections using tcp/ip only.

The Server Properties are set to Server authentication Mixed mode.

I have set up two users in mixed mode. I can connect locally through
Management Studio Express with both these users.

But if I try to connect remotely, I get the error "... under the default
settings SQL Server does not allow remote connections (provider; named pipes
provider, error: 40 - could not open a connection to SQL server)(Microsoft
SQL Server, Error: 53).

Any help much appreciated.

Reply With Quote
  #2  
Old   
Roger Withnell
 
Posts: n/a

Default Re: Can't connect remotely to SQL Server Express - 08-08-2008 , 01:18 PM






Thanks for your help, but I don't understand what you mean.

Could you elaborate, please?

Many thanks.

Roger

"Ekrem Önsoy" wrote:

Quote:
I suggest you to use a static port instead of a dynamic one.

--
Ekrem Önsoy




"Roger Withnell" <RogerWithnell (AT) discussions (DOT) microsoft.com> wrote in message
news:C129F916-32C0-4439-9B1C-D98D8593BCD6 (AT) microsoft (DOT) com...
I have installed SQL Server Express on a Windows 2003 platform.

I have set the Windows firewall to allow sqlservr.exe and sqlbrowser.exe
and
udp port 1434. SQL browser is running.

I have enable tcp/ip protocol. The SQL Server 2005 Surface Area
Configuration is set to local and remote connections using tcp/ip only.

The Server Properties are set to Server authentication Mixed mode.

I have set up two users in mixed mode. I can connect locally through
Management Studio Express with both these users.

But if I try to connect remotely, I get the error "... under the default
settings SQL Server does not allow remote connections (provider; named
pipes
provider, error: 40 - could not open a connection to SQL server)(Microsoft
SQL Server, Error: 53).

Any help much appreciated.



Reply With Quote
  #3  
Old   
Roger Withnell
 
Posts: n/a

Default Re: Can't connect remotely to SQL Server Express - 08-08-2008 , 01:18 PM



Thanks for your help, but I don't understand what you mean.

Could you elaborate, please?

Many thanks.

Roger

"Ekrem Önsoy" wrote:

Quote:
I suggest you to use a static port instead of a dynamic one.

--
Ekrem Önsoy




"Roger Withnell" <RogerWithnell (AT) discussions (DOT) microsoft.com> wrote in message
news:C129F916-32C0-4439-9B1C-D98D8593BCD6 (AT) microsoft (DOT) com...
I have installed SQL Server Express on a Windows 2003 platform.

I have set the Windows firewall to allow sqlservr.exe and sqlbrowser.exe
and
udp port 1434. SQL browser is running.

I have enable tcp/ip protocol. The SQL Server 2005 Surface Area
Configuration is set to local and remote connections using tcp/ip only.

The Server Properties are set to Server authentication Mixed mode.

I have set up two users in mixed mode. I can connect locally through
Management Studio Express with both these users.

But if I try to connect remotely, I get the error "... under the default
settings SQL Server does not allow remote connections (provider; named
pipes
provider, error: 40 - could not open a connection to SQL server)(Microsoft
SQL Server, Error: 53).

Any help much appreciated.



Reply With Quote
  #4  
Old   
Roger Withnell
 
Posts: n/a

Default Re: Can't connect remotely to SQL Server Express - 08-08-2008 , 01:18 PM



Thanks for your help, but I don't understand what you mean.

Could you elaborate, please?

Many thanks.

Roger

"Ekrem Önsoy" wrote:

Quote:
I suggest you to use a static port instead of a dynamic one.

--
Ekrem Önsoy




"Roger Withnell" <RogerWithnell (AT) discussions (DOT) microsoft.com> wrote in message
news:C129F916-32C0-4439-9B1C-D98D8593BCD6 (AT) microsoft (DOT) com...
I have installed SQL Server Express on a Windows 2003 platform.

I have set the Windows firewall to allow sqlservr.exe and sqlbrowser.exe
and
udp port 1434. SQL browser is running.

I have enable tcp/ip protocol. The SQL Server 2005 Surface Area
Configuration is set to local and remote connections using tcp/ip only.

The Server Properties are set to Server authentication Mixed mode.

I have set up two users in mixed mode. I can connect locally through
Management Studio Express with both these users.

But if I try to connect remotely, I get the error "... under the default
settings SQL Server does not allow remote connections (provider; named
pipes
provider, error: 40 - could not open a connection to SQL server)(Microsoft
SQL Server, Error: 53).

Any help much appreciated.



Reply With Quote
  #5  
Old   
Roger Withnell
 
Posts: n/a

Default Re: Can't connect remotely to SQL Server Express - 08-08-2008 , 01:18 PM



Thanks for your help, but I don't understand what you mean.

Could you elaborate, please?

Many thanks.

Roger

"Ekrem Önsoy" wrote:

Quote:
I suggest you to use a static port instead of a dynamic one.

--
Ekrem Önsoy




"Roger Withnell" <RogerWithnell (AT) discussions (DOT) microsoft.com> wrote in message
news:C129F916-32C0-4439-9B1C-D98D8593BCD6 (AT) microsoft (DOT) com...
I have installed SQL Server Express on a Windows 2003 platform.

I have set the Windows firewall to allow sqlservr.exe and sqlbrowser.exe
and
udp port 1434. SQL browser is running.

I have enable tcp/ip protocol. The SQL Server 2005 Surface Area
Configuration is set to local and remote connections using tcp/ip only.

The Server Properties are set to Server authentication Mixed mode.

I have set up two users in mixed mode. I can connect locally through
Management Studio Express with both these users.

But if I try to connect remotely, I get the error "... under the default
settings SQL Server does not allow remote connections (provider; named
pipes
provider, error: 40 - could not open a connection to SQL server)(Microsoft
SQL Server, Error: 53).

Any help much appreciated.



Reply With Quote
  #6  
Old   
Roger Withnell
 
Posts: n/a

Default Re: Can't connect remotely to SQL Server Express - 08-08-2008 , 01:18 PM



Thanks for your help, but I don't understand what you mean.

Could you elaborate, please?

Many thanks.

Roger

"Ekrem Önsoy" wrote:

Quote:
I suggest you to use a static port instead of a dynamic one.

--
Ekrem Önsoy




"Roger Withnell" <RogerWithnell (AT) discussions (DOT) microsoft.com> wrote in message
news:C129F916-32C0-4439-9B1C-D98D8593BCD6 (AT) microsoft (DOT) com...
I have installed SQL Server Express on a Windows 2003 platform.

I have set the Windows firewall to allow sqlservr.exe and sqlbrowser.exe
and
udp port 1434. SQL browser is running.

I have enable tcp/ip protocol. The SQL Server 2005 Surface Area
Configuration is set to local and remote connections using tcp/ip only.

The Server Properties are set to Server authentication Mixed mode.

I have set up two users in mixed mode. I can connect locally through
Management Studio Express with both these users.

But if I try to connect remotely, I get the error "... under the default
settings SQL Server does not allow remote connections (provider; named
pipes
provider, error: 40 - could not open a connection to SQL server)(Microsoft
SQL Server, Error: 53).

Any help much appreciated.



Reply With Quote
  #7  
Old   
Roger Withnell
 
Posts: n/a

Default Re: Can't connect remotely to SQL Server Express - 08-08-2008 , 01:18 PM



Thanks for your help, but I don't understand what you mean.

Could you elaborate, please?

Many thanks.

Roger

"Ekrem Önsoy" wrote:

Quote:
I suggest you to use a static port instead of a dynamic one.

--
Ekrem Önsoy




"Roger Withnell" <RogerWithnell (AT) discussions (DOT) microsoft.com> wrote in message
news:C129F916-32C0-4439-9B1C-D98D8593BCD6 (AT) microsoft (DOT) com...
I have installed SQL Server Express on a Windows 2003 platform.

I have set the Windows firewall to allow sqlservr.exe and sqlbrowser.exe
and
udp port 1434. SQL browser is running.

I have enable tcp/ip protocol. The SQL Server 2005 Surface Area
Configuration is set to local and remote connections using tcp/ip only.

The Server Properties are set to Server authentication Mixed mode.

I have set up two users in mixed mode. I can connect locally through
Management Studio Express with both these users.

But if I try to connect remotely, I get the error "... under the default
settings SQL Server does not allow remote connections (provider; named
pipes
provider, error: 40 - could not open a connection to SQL server)(Microsoft
SQL Server, Error: 53).

Any help much appreciated.



Reply With Quote
  #8  
Old   
Roger Withnell
 
Posts: n/a

Default Re: Can't connect remotely to SQL Server Express - 08-08-2008 , 01:18 PM



Thanks for your help, but I don't understand what you mean.

Could you elaborate, please?

Many thanks.

Roger

"Ekrem Önsoy" wrote:

Quote:
I suggest you to use a static port instead of a dynamic one.

--
Ekrem Önsoy




"Roger Withnell" <RogerWithnell (AT) discussions (DOT) microsoft.com> wrote in message
news:C129F916-32C0-4439-9B1C-D98D8593BCD6 (AT) microsoft (DOT) com...
I have installed SQL Server Express on a Windows 2003 platform.

I have set the Windows firewall to allow sqlservr.exe and sqlbrowser.exe
and
udp port 1434. SQL browser is running.

I have enable tcp/ip protocol. The SQL Server 2005 Surface Area
Configuration is set to local and remote connections using tcp/ip only.

The Server Properties are set to Server authentication Mixed mode.

I have set up two users in mixed mode. I can connect locally through
Management Studio Express with both these users.

But if I try to connect remotely, I get the error "... under the default
settings SQL Server does not allow remote connections (provider; named
pipes
provider, error: 40 - could not open a connection to SQL server)(Microsoft
SQL Server, Error: 53).

Any help much appreciated.



Reply With Quote
  #9  
Old   
Roger Withnell
 
Posts: n/a

Default Re: Can't connect remotely to SQL Server Express - 08-08-2008 , 01:18 PM



Thanks for your help, but I don't understand what you mean.

Could you elaborate, please?

Many thanks.

Roger

"Ekrem Önsoy" wrote:

Quote:
I suggest you to use a static port instead of a dynamic one.

--
Ekrem Önsoy




"Roger Withnell" <RogerWithnell (AT) discussions (DOT) microsoft.com> wrote in message
news:C129F916-32C0-4439-9B1C-D98D8593BCD6 (AT) microsoft (DOT) com...
I have installed SQL Server Express on a Windows 2003 platform.

I have set the Windows firewall to allow sqlservr.exe and sqlbrowser.exe
and
udp port 1434. SQL browser is running.

I have enable tcp/ip protocol. The SQL Server 2005 Surface Area
Configuration is set to local and remote connections using tcp/ip only.

The Server Properties are set to Server authentication Mixed mode.

I have set up two users in mixed mode. I can connect locally through
Management Studio Express with both these users.

But if I try to connect remotely, I get the error "... under the default
settings SQL Server does not allow remote connections (provider; named
pipes
provider, error: 40 - could not open a connection to SQL server)(Microsoft
SQL Server, Error: 53).

Any help much appreciated.



Reply With Quote
  #10  
Old   
Roger Withnell
 
Posts: n/a

Default Re: Can't connect remotely to SQL Server Express - 08-08-2008 , 01:18 PM



Thanks for your help, but I don't understand what you mean.

Could you elaborate, please?

Many thanks.

Roger

"Ekrem Önsoy" wrote:

Quote:
I suggest you to use a static port instead of a dynamic one.

--
Ekrem Önsoy




"Roger Withnell" <RogerWithnell (AT) discussions (DOT) microsoft.com> wrote in message
news:C129F916-32C0-4439-9B1C-D98D8593BCD6 (AT) microsoft (DOT) com...
I have installed SQL Server Express on a Windows 2003 platform.

I have set the Windows firewall to allow sqlservr.exe and sqlbrowser.exe
and
udp port 1434. SQL browser is running.

I have enable tcp/ip protocol. The SQL Server 2005 Surface Area
Configuration is set to local and remote connections using tcp/ip only.

The Server Properties are set to Server authentication Mixed mode.

I have set up two users in mixed mode. I can connect locally through
Management Studio Express with both these users.

But if I try to connect remotely, I get the error "... under the default
settings SQL Server does not allow remote connections (provider; named
pipes
provider, error: 40 - could not open a connection to SQL server)(Microsoft
SQL Server, Error: 53).

Any help much appreciated.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.