1 Topic by SteveHannah

  • SteveHannah
  • Veteran
  • Offline
  • From: Midlothian
  • Registered: 02-09-2010
  • Posts: 84

Topic: SQL Server doesn't exist?

I've just moved our Recorder database to our new computer, and it's up and running and the local workstation install is ok, but if any other terminal in the office tries to access the database I get the message

EOleException: [DBNETLIB][ConnectionOpen (Connect().] SQL Server does not exist or access denied.

It looks like a permissions error but I can't for the life of me work out what exactly.  Anyone able to advise?

-----------------------------------------------------------------------
Steve Hannah - GIS and Data Infrastructure Officer
The Wildlife Information Centre

SteveHannah's Website

2 Reply by SteveHannah

  • SteveHannah
  • Veteran
  • Offline
  • From: Midlothian
  • Registered: 02-09-2010
  • Posts: 84

Re: SQL Server doesn't exist?

Update to this.  I'm getting a different error on the 64-bit machine to the 32-bit machine.  This message reads:

EOleException cannot open database NBNData requested by login.  The login failed.

-----------------------------------------------------------------------
Steve Hannah - GIS and Data Infrastructure Officer
The Wildlife Information Centre

SteveHannah's Website

3 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: SQL Server doesn't exist?

HI Steve
Unfortunately this is a pretty generic problem just meaning that the server could not be contacted, and there are quite a few potential solutions. Microsoft have a page about them here. I would suggest looking at the ones relating to the protocols that SQL Server is trying to communicate on as I've recently seen a similar issue that was solved by correcting a protocol setting.

Best wishes
John

John van Breda
Biodiverse IT

johnvanbreda's Website

4 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: SQL Server doesn't exist?

On a customer site in January a problem like this was traced to remote connections not being allowed. If this is the problem, it can be corrected using Start – All Programs – Microsoft SQL Server 2005 – Configuration Tools – SQL Server Surface Area Configuration then select ‘Surface Area Configuration for Services and Connections’, or the equivalent on your system. In the dialogue box that opens select ‘Remote Connections’ and change the protocols on which SQL Server listens for incoming client connections to use TCP/IP and/or named pipes.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

5 Reply by DavidChun

  • DavidChun
  • Veteran
  • Offline
  • Registered: 13-08-2010
  • Posts: 58

Re: SQL Server doesn't exist?

Hi

I had thsi problem and did finally resolve it. Unfortunately had to try so many things not sure which one/combination finally did the trick. The following site may help.

http://social.technet.microsoft.com/wik … ngine.aspx