SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Remote Access for SQL Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

MarkJ
Starting Member

United Kingdom
2 Posts

Posted - 12/09/2012 :  05:22:13  Show Profile  Reply with Quote
I have been seaching the web, but I think I am lacking some basic knowledge \ terminology.

My background
I have worked with Access databases for a long time and have delevoped a number of quite complex database application using VBA.

The project
The project I am currently working on will need to hold a great deal more records and have quite a high level of complexity. Therefore I thought this may require me to get out of my comfort zone and get some sql server experience. The project is kind of a CRM system, the company have looked at a number but because of the nature of our business I can see the out of the box experience any of these will be poor and require a lot of tailoring and customisation.It subsequenty has struck me that we may as well start from scratch and build this sucker from the ground up.

The (first) problem
I have set up some tables and relationships inside a test environment I can use ODBC to connect an access front end to get me back to familier ground but what I have no experience of is how I can give remote users access to the data. By remote users I mean both users on the WAN and by accessing via the internet, via a web interfacce or something similar. I don't what to be spoon feed the info but if anyone could suggest a few avenues that I could investigate I would be most greatful.

Many thanks in advance

MJP

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 12/09/2012 :  11:26:44  Show Profile  Reply with Quote
If I understand you question , you can create SQL Authentication user with limited privileges so that users can connect using this credentials.
Go to Top of Page

MarkJ
Starting Member

United Kingdom
2 Posts

Posted - 12/09/2012 :  14:00:24  Show Profile  Reply with Quote
Many thanks for the Reply Sodeep

What you say may well form part of my solution - But What I'm really looking for is a steer towards what would be my best option to allow my users to get remote access from either the WAN or from over the internet. For instance can ODBC be used remotely, I've only ever used it across the LAN. Or would I be better writing a web front end? Or is there some other option?

Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 12/09/2012 :  14:24:09  Show Profile  Reply with Quote

OK. do this

Goto SQL Server Configuration,Enable SQL Server Browser
Enable Remote connection
Enable TCP/IP,change TCP Port to 1433 if not
Allow Firewall for SQL Server.
Make Sure DTC Setting is enabled
Put the correct connection string
connect with SQL Server Authentication
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000