I TRY TO CONNECT TO MSDE BUT I GOT A FAILED ALTHOUGHT I OPENED 1433 PORT AND I CONFIGURED FIREWALL HOW CAN I SOLVE .
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.. -- 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
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
hi, Ahmet Aþçý wrote: > 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 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... -- 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
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 "Andrea Montanari" wrote: > hi, > Ahmet Aþçý wrote: > > 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 > > 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... > -- > 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 > > >
hi, Hari wrote: > 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.. -- 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
