[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 620
  • Last Modified:

Connection to SQL Database on SBS 2008 server

I am trying to setup a MSDE 2005 database for a blackberry server install.  I have installed the MSDE 2005 database  - BLACKBERRY -  and have enabled both named pipes and tcp/ip.   I enabled TCP/IP on local IPV4 - 192.168.90.2.  I cannot connect to the database either locally on the host via port 1433 or from a remote client - i have checked that remote clients are enabled.  I have also explicitly added 1433 to the firewall allowed ports.   I have also tested with the firewall turned off but cannot connect.   Any help is appreciated.
0
egrotjahn
Asked:
egrotjahn
1 Solution
 
elimesikaCommented:
HI

Are you using user/password or Windows Authentication to conenct ?
Can you attach the exact error ?
0
 
egrotjahnAuthor Commented:
I abandoned using 2005 MSDE and used another server wth SQL on it.   MSDE doesn't allow remote connections -  i tried to enable them but didn't get anywhere.   Unfortunately i was under a time crunch so didn't have enough time to troubleshoot.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now