Skip to main content

MS SQL Server, Can not connect to computer

Beginner
Posts: 4
Comments: 9

Hello,
I have a problem to make Acronis for MS SQL Server.
First, I have a computer with MS SQL Agent installed.
Second, I have an other computer wih MS SQL Console management installed.

On the second computer, I can "add server" the first computer but when I try to connect it, the message "Processing, please wait..." appear and nothing happen.

I tried to install the MS SQL Console management on the first computer and connect to himself but the same message appears and never disappears (after 24h I decided to kill the process to close Acronis)

Do you know where this problem comes from ? Any idea ?

Best regards

Beginner
Posts: 4
Comments: 9

Top

up?

Forum Star
Posts: 88
Comments: 4769

Top

Hello Alex LÊ,

Thank you very much for your post. I apologize for the delay, but I will definitely help you with this issue.

From your description of the problem, it looks like the Acronis agent does not have enough privileges to allow the connection.

I recommend using the following solution from our Knowledge Base article - Acronis Recovery for MS SQL Server Management Console Hangs When Connecting to Acronis Agent.

I would really appreciate if you could let me know if this worked or not, so that I can continue assisting you.

Beginner
Posts: 4
Comments: 9

Top

Thank you for your reply.

This solution works perfectly but I met an other problem, the same kind of problem.

After connecting to the server (thanks to Anton), when I click on "Back up" to create a backup, I have the message :

"It appears that there are no databases on given server or your current user has no enought rights to view them"

There are databases on this server and the user is the administrator of the domain. Maybe Administrator does not have enought rights to view databases. In this case, what should I do ?

Forum Star
Posts: 88
Comments: 4769

Top

Hello Alex LÊ,

Thank you very much for your question, I will definitely assist you with it.

If you can please clarify, at what step in the backup wizard do you get this error message?

Which version of SQL are you using?

I would like to make the following suggestion, from my experience, this issue could be occurring because of incorrect credentials.

As a reference, please use page 39 from our user guide, and kindly make sure that in the backup creation wizard, at the database selection screen you  click on Change next to (Task inherited authentication) and provide your database credentials.

Let me know if you have any other questions.

Thank you.

Beginner
Posts: 4
Comments: 9

Top

The message appears when I click on "Back up" just after connecting the server (so page 32 of the guide).

So I can not follow the 39th page's instructions.

Best regards

Forum Star
Posts: 88
Comments: 4769

Top

Hello Alex LÊ,

Thank you for getting back to me.

I am sorry for the inconvenience but at the moment it is not clear why this issue is occurring. Can you please clarify the following for me.

1. Which SQL version are you using?

2. If you are using a domain administrator account, please check that in your SQL database setting that domain admin has the correct privileges.

Please try using another account.

3. Which authentication mode are you using, mixed or native?

Thank you.

Beginner
Posts: 4
Comments: 9

Top

1. I am using Microsoft SQL Server 2005
2. This is the domain administrator account but have all privileges on the databases
3. I am using Native authentification

In the configuration I can see "Protocol for Acronis" and only "Shared Memory" is enabled. "Named Pipes", "TCP/IP" and "VIA" are disabled.

ps: I also tried with others accounts

Forum Star
Posts: 88
Comments: 4769

Top

Hello Alex LÊ,

Thank you for replying. If I can clarify one more thing please.

Can you please provide me with screenshots of the logins that you use when connecting through the SQL Management Studio?

They can involve sensitive information, you can send me a PM with the screenshots attached.

Thank you.

Beginner
Posts: 4
Comments: 9

Top

Screenshot sended

Forum Star
Posts: 88
Comments: 4769

Top

Hello Alex LÊ,

Thank you for getting back to me.

I am afraid at the moment it is not clear why this issue is occurring.

Can you please submit a support request and explain about this issue in detail. You can also include a link to this forum thread and ask to get this case escalated to our Expert team.

Please include the following logs when you are submitting the support request:

1. AcronisInfo.

2. Screenshots of your SQL Server 2005 user settings.

3. The following folders:

Acronis Recovery for MS SQL Server Management Console logs from the machine where it is installed:

    C:\Documents and Settings\All Users\Application Data\Acronis\DatabaseBackup\Logs

Acronis Recovery for MS SQL Server Agent logs from the machine where it is installed:

    C:\Documents and Settings\All Users\Application Data\Acronis\FomatikAgent\Logs

MS SQL Server native logs from the machine where Acronis Recovery for MS SQL Server Agent is installed:

    C:\Program Files\Microsoft SQL Server\MSSQL\LOG

Task Service logs from the machine where Acronis Recovery for MS SQL Server Agent is installed:

    C:\Documents and Settings\All Users\Application Data\Acronis\TasksService\Logs

4. Check whether a database can be backed up successfully by means of MS SQL native utilities.

Please let me know if you have additional questions.

Thank you.

Beginner
Posts: 2
Comments: 1

Top

Hi Anton,

I had tried the method: (http://kb.acronis.com/content/3063) and please refer to file attachment.

But it still display the message shows as "Processing, please wait..." and nothing happen at all.

Any idea about this issue?

Thanks.

Regards,
Liew

Attachment Size
61661-94822.txt 3.11 KB