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

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

Setting up SQL Server

I am looking at setting up an SQL Server in my office, and am after some advice on how to configure it to get the best results. I have a SBS2003 with a static IP, and am looking at setting up SQL Server Express on another machine in the network probably running XP and use Access 2007 as a front end.

I would like to able to access the sql server from multiple sites, is this possible ? What is the best way ? ie setting up ports etc.

Currently I'm trying to get a plan together, to see if I can make this work, so any help would be appreciated
0
GregMcL
Asked:
GregMcL
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
>I would like to able to access the sql server from multiple sites, is this possible ?
Yes , thats what a server meant to do
by default it uses the ports 1433 and 1434
you dont really need any special configuration, install the server on one of those machines, connect with your application (you have to change the connection string )
0
 
Marten RuneCommented:
SQL Express, is not configured for network access by default.

You need:
Set SQLEXPRESS to allow remote connections through TCP (disabled by default)
Start (set automatic) "SQL Server Browser" service (not enabled by default)
Allow port 1433, 1434 if you use firewalls
Install (or alter afterwords) security for Mixed mode on SQL Server (default is not mixed mode)

//Marten
0
 
GregMcLAuthor Commented:
Lots of reading still to go
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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