![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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. |
#3
| |||
| |||
|
|
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. |
#4
| |||
| |||
|
|
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. |
#5
| |||
| |||
|
|
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. |
#6
| |||
| |||
|
|
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. |
#7
| |||
| |||
|
|
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. |
#8
| |||
| |||
|
|
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. |
#9
| |||
| |||
|
|
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. |
#10
| |||
| |||
|
|
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. |
![]() |
| Thread Tools | |
| Display Modes | |
| |