Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL 2005 Question

Posted on 2011-09-24
10
Medium Priority
?
339 Views
Last Modified: 2012-05-12
Hello - I am hoping someone can help me.  I need to connect to my BES database via BES Transporter service to migrate users to a new BES.  I receive the following error message.

 Error message

An error has ocurred when establishing a connection to the server.  When connecting to the SQL Server 2005, this failure may be caused by the fact that under the default settings of the SQL server does not allow remote connections.  I have found information online to check the surface configuration.  The strange issue is, I also have by backup exec software on this server - I do not see the properties for the sql configuration to just the main server.  I only see the configuration to the database area for the backup exec software.  I have attached screen shots.  

Any help would be greatly appreciated.

Thank you. sql database shot surface configuration area
0
Comment
Question by:kinggirl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36593823
>>this failure may be caused by the fact that under the default settings of the SQL server does not allow remote connections. <<
Have you made sure that you have enabled remote connections?
0
 

Author Comment

by:kinggirl
ID: 36595303
Hello - yes remote connections is enabled.  The weird issue is I don't see the surface configurations for the service name.  I can only see the service name for the backup exec service.  Sorry, I am very green when it comes to sql.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36595327
What is not clear to me is whether you are sharing the same server instance for your database with BackupExec.  So what you need to do is verify how many SQL Server services are actually running.  Go the the Services applet and you should find the backupexec instance, see if there are any more.
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

Author Comment

by:kinggirl
ID: 36595342
I only see the one service, but when I connect into sql server manager I have to change the server name.   Services Server
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36595413
Just to be clear, when you are sitting at the server you can successfully log on to either server instance the default (SCHOMBERG) and the named instance (SCHOMBERG\BACKUPEXEC) ?  But when you are at a workstation you cannot?

Is that correct?
0
 

Author Comment

by:kinggirl
ID: 36595563
yes, that is right.
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 2000 total points
ID: 36596298
Then there are at least 2 possible reasons (though I am sure there are more) you can only connect on the server:
1. Remote Logins are not enabled. The following query should tell you if it is enabled:
SELECT *
FROM sys.configurations
WHERE name = 'remote access'

2. You are using a protocol not supported by the SQL Server service.
0
 

Author Comment

by:kinggirl
ID: 36596713
Hello - I was able to run the transporter service locally on the server.  Thank you for your help.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36596720
I am sorry I could not be of more help.
0
 

Author Comment

by:kinggirl
ID: 36596723
you did help - you got me thinking more :)  Much appeciated.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question