kinggirl
asked on
SQL 2005 Question
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.
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.
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.
ASKER
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.
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.
ASKER
I only see the one service, but when I connect into sql server manager I have to change the server name. 
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?
Is that correct?
ASKER
yes, that is right.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello - I was able to run the transporter service locally on the server. Thank you for your help.
I am sorry I could not be of more help.
ASKER
you did help - you got me thinking more :) Much appeciated.
Have you made sure that you have enabled remote connections?