K
K
klabuk0v2013-11-13 16:40:29
SQL
klabuk0v, 2013-11-13 16:40:29

1c and Microsoft SQL server 2008 r2 sp1 via Shared Memory

Hello colleagues.

Help make friends 1c and Microsoft SQL server 2008 r2 sp1 via Shared Memory. The initial data is as follows: Server: Windows Server 2008 R2 1c platform 8,2,18,102 SQL Server 2008 r2 sp1

They work naturally on the same server. Made the settings as described in this article: http://selestajob.ru/article/index.php?ELEMENT_ID=111583

Server Profiler shows that the connection is only over TCP. It is impossible to completely disable TCP communication, because bases of other services are spinning on this server.

Thank you.

Answer the question

In order to leave comments, you need to log in

4 answer(s)
K
klabuk0v, 2013-11-14
@klabuk0v

In general, I asked the question myself, I will answer it myself, maybe it will be useful to someone.

Shared memory worked for me after I specified the path to the database in the format server name\instance in the infobase settings in 1s when I specified localhost, or just the Shared memory server name did not work.

PS The TCP protocol did not have to be disabled.

V
Vladislav Yaroslavlev, 2013-11-13
@vladon

The 1C server will not work on Shared Memory if a TCP connection is available. At least I didn't succeed.

Install a separate instance of the SQL server and disable TCP for it, and "set" the 1C server on this new instance.

And let the other bases spin on the main instance.

K
klabuk0v, 2013-11-13
@klabuk0v

Today I tried to disable TCP for the experiment, left only Shared Memory, 1s does not start, it gives the following error: 9512e1968269be58b7ba2485f008e60f.png

Google didn't help much, has anyone come across this?

P
ParserBD, 2016-06-01
@ParserBD

Faced, enable namespace in SQL Server Configuration Manager
01058c2acd5bf3f53aaa6f430d9091b9.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question