REMOTE CONNECTION FOR MSDE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ahmet Aşçı - 01 Aug 2008 10:28 GMT

I TRY TO CONNECT TO MSDE BUT I GOT A FAILED

ALTHOUGHT I OPENED 1433 PORT AND I CONFIGURED FIREWALL

HOW CAN I SOLVE .

Reply to this Message

Andrea Montanari - 01 Aug 2008 11:23 GMT

hi,
Ahmet Aþçý wrote:

> I TRY TO CONNECT TO MSDE BUT I GOT A FAILED
>
> ALTHOUGHT I OPENED 1433 PORT AND I CONFIGURED FIREWALL
>
> HOW CAN I SOLVE .

what kind of exception are you reported with?
are you sure your MSDE instance is listening on tcp/ip 1433 port? please
check the setting with svrnecn.exe..

Signature

Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply

Reply to this Message

Ahmet Aşçı - 01 Aug 2008 13:54 GMT

I M SURE THAT MSDE IS LISTENING ON TCP 1433 PORT

I M USING THIRT PARTY PROGRAM TO CONFIGURE FOR MSDE

WHEN I CONNECT LOCAL MSDE DATABASE FROM OUT OF OFFICE

THE PROGRAM SAID THAT : DATABASE DOES NOT EXIST OR ACCES DEINED

TO LOGIN I AM USING USER:SA PASS NULL

Reply to this Message

Andrea Montanari - 01 Aug 2008 16:10 GMT

hi,
Ahmet Aþçý wrote:

> I M SURE THAT MSDE IS LISTENING ON TCP 1433 PORT
>
[quoted text clipped - 5 lines]
>
> TO LOGIN I AM USING USER:SA PASS NULL

do you mean that only local connections are available? (local connection to
the machine hosting MSDE, while connections coming from the lan are
refused?) if this is the case, MSDE installs by default disabling remote
connections and you have to enable them at install time, providing the
DISABLENETWORKPROTOCOLS=0 additional parameter or, later at run time, via
Server Network Protocols utility...

Signature

Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply

Reply to this Message

Hari - 26 Sep 2008 19:03 GMT

I'm having the same problem remotely connecting to a MSDE sql server.

Is windows only authentication should be changed to sql server
authentication to connect remotely?

-Hari

> hi,
> Ahmet Aþçý wrote:
[quoted text clipped - 14 lines]
> DISABLENETWORKPROTOCOLS=0 additional parameter or, later at run time, via
> Server Network Protocols utility...

Reply to this Message

Andrea Montanari - 27 Sep 2008 17:29 GMT

hi,

> I'm having the same problem remotely connecting to a MSDE sql server.
>
> Is windows only authentication should be changed to sql server
> authentication to connect remotely?

nope... remote connection is available for both authentication types..

Signature

Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply

Reply to this Message