1 Reply by SteveGoddard

  • SteveGoddard
  • SteveGoddard
  • Member
  • Offline
  • From: Brecon
  • Registered: 31-01-2012
  • Posts: 39

Re: Reset R6 SQL Server Connection Details

After an update to SQL Server Express 2008 R2 went horribly wrong I have had to completly reinstall SQL Server Express. :o

That has all gone fine and I have re-attached to the NBN Data Database.

I can run R6 on the server itself, but all workstations complain: "... SQL Server does not exist or access denied".

I assume I need to recreate the SQL account used by R6 or reset the account username / password in the R6 server config.

Anyone know how to do this? Is there a program I need to run to do this? Help!

Many thanks,
Steve

=====================================================
Steve Goddard - IT Officer
Biodiversity Information Service for Powys & Brecon Beacons National Park
T: 01874 610881 - E: steve[at]b-i-s.org - W: www.b-i-s.org

SteveGoddard's Website

2 Reply by SteveGoddard

  • SteveGoddard
  • SteveGoddard
  • Member
  • Offline
  • From: Brecon
  • Registered: 31-01-2012
  • Posts: 39

Re: Reset R6 SQL Server Connection Details

All fixed - thanks for your help Mike - pointed me in the right direction.

In the end it was a combination of re-creating the NBNUser account and more importantly enabling TCP/IP connections into the server via the SQL Server Configuration manager.

Steve

=====================================================
Steve Goddard - IT Officer
Biodiversity Information Service for Powys & Brecon Beacons National Park
T: 01874 610881 - E: steve[at]b-i-s.org - W: www.b-i-s.org

SteveGoddard's Website