How to configure SQL to AM

mfcelleri

Hi guys, can you explain me how to configure AM to connect SQL Server Express 2017?

What can I do to do this?. I'm new with AM.

Vasyl

While installing Express you have to enable Sql browser..
Next open sql configurations tool and enable Memory Pipes and TCP protocols...
Restart SQL Server, browser

Goto Accumark utility, SQL Support and configure connection 

Sandro Palumbo

Suppose that you already have an SQL Instance, in Accumark Explorer->Option->Configuration->SQL Support put the below information, and before to press Ok. BE SURE TO PRESS TEST BUTTON. If test is OK, when you re-open Accumark Explorer, you'll found a new disk called 0: 

mfcelleri

Thanks Vasyl and Sandro; for your answers.

I did that, test the conection and all is right; but when I tried to create a storage area ; and receive this error Creatin Accumark Tables <server_name\instance/xxxx// AccumarkTypes AccumarkData Version>

Microsoft SQL Server Error 5105 accesing <server_name\instance/xxxx/AccumarkTypes and AccumarkData>

In the SQL Server we need to create a database or AM create one automatically?

Thanks and regards.

Vasyl

What version of Accumark are you using?

Look like your account hasn't privileges for database creation.

Use Sql management studio to configure user role

mfcelleri

Accumark Version 12.

I use the sa user to connect from AM.

How to configure the user role in SQL management

Vasyl

Check this topic.
There is SQLvsAM compatible sheet 
https://gerbertechnology.vanillacommunity.com/discussion/comment/2581/#Comment_2581

mfcelleri

And how to do with an update version of AM and SQL Express?

Are the same steps?, in SQL Server Express 2017 the MSDE still exists?