+ Post New Thread
Results 1 to 6 of 6
How do you do....it? Thread, Permitting Access to SQL Express Database in Technical; Forgive me if this sounds a stupid question! I have SQL Express set up on a Windows 7 64 bit ...
  1. #1
    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,564
    Thank Post
    3,469
    Thanked 286 Times in 215 Posts
    Blog Entries
    3
    Rep Power
    116

    Permitting Access to SQL Express Database

    Forgive me if this sounds a stupid question!

    I have SQL Express set up on a Windows 7 64 bit Workstation and want to save a Hemmings database to it for my DT teacher to access from his workstation and use. I don't want to put the database on our existing SQL on the server. Can I do this - if so how please?

  2. #2
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25
    I might be wrong, but I think one of the restrictions of SQL express over the full version(s) is that there is no network access. It was released primarily to sit underneath a website where all that needs to access it is a local IIS install - presumably to combat the increasing use of MySQL for this purpose.

  3. Thanks to limbo from:

    speckytecky (23rd May 2012)

  4. #3

    Join Date
    Apr 2006
    Posts
    390
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    45
    It is true that MSSQL Express doesn't accept remote connections by default, however there is a way of enabling it.

    First up, ensure your Windows firewall allows the relevant connection - Configure Windows Firewall for SQL Server 2008 Access

    Next, enable networking in SQL Server:
    How to: Enable Network Access in SQL Server Configuration Manager (SQL Server Express)

    After that you've got the task of configuring your application to connect to the correct server/instance.

  5. Thanks to theriver from:

    speckytecky (23rd May 2012)

  6. #4
    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,564
    Thank Post
    3,469
    Thanked 286 Times in 215 Posts
    Blog Entries
    3
    Rep Power
    116
    Thanks for the replies. Would it be possible to use this software Hemming with MySQL instead do you think?

    (
    Quote Originally Posted by limbo View Post
    I might be wrong, but I think one of wthe restrictions of SQL express over the full version(s) is that there is no network access. It was released primarily to sit underneath a website where all that needs to access it is a local IIS install - presumably to combat the increasing use of MySQL for this purpose.

  7. #5

    Join Date
    Apr 2006
    Posts
    390
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    45
    I think not - the DB create script won't work on MySQL without a rewrite, and it's unlikely that the SQL generated by the application is basic enough to be understood by both.

  8. Thanks to theriver from:

    speckytecky (24th May 2012)

  9. #6

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,593
    Thank Post
    725
    Thanked 1,685 Times in 1,500 Posts
    Rep Power
    432
    Quote Originally Posted by limbo View Post
    I might be wrong, but I think one of the restrictions of SQL express over the full version(s) is that there is no network access. It was released primarily to sit underneath a website where all that needs to access it is a local IIS install - presumably to combat the increasing use of MySQL for this purpose.
    I'm sure it is available from other applications we use it for our access control and res workspace manager and both those have client apps that access it over the network.

    Ben

  10. Thanks to plexer from:

    speckytecky (24th May 2012)

SHARE:
+ Post New Thread

Similar Threads

  1. SQL express database copy
    By nicholab in forum How do you do....it?
    Replies: 0
    Last Post: 21st October 2011, 04:46 PM
  2. Replies: 4
    Last Post: 6th January 2010, 11:59 AM
  3. No access to any database on SQL server
    By button_ripple in forum MIS Systems
    Replies: 2
    Last Post: 1st May 2009, 08:17 AM
  4. moving form access to sql server
    By RabbieBurns in forum Office Software
    Replies: 3
    Last Post: 27th August 2008, 03:20 PM
  5. Web based questionnaire to Access/SQL express dB
    By joe90bass in forum How do you do....it?
    Replies: 4
    Last Post: 23rd June 2008, 02:46 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •