1

Topic: MS a SQL SERVER 2012R2 for instance

Kind time.
Is available SQLServer 2012R2 + SP3 under name VMSQLServer-01, on it  by default MSSQLSERVER,  to tear in a network  and its DB to allocate on this server, but here the name instance it demands accurately certain name instance - ROLLDICE
Looking through a forum and smoking manuals on a SQL Server and did not understand, and whether it is possible for VMSQLServer-01\MSSQLSERVER to make  a type VMSQLServer-01\ROLLDICE i.e. what at reversal to a DB in instance ROLLDICE to get to a DB with the same name, but lying in instance MSSQLSERVER on the same server VMSQLServer-01
Z.Y.hop not strongly tangled, describing a problem.
... It is possible to tear new instance ROLLDICE but then all adjustments should be doubled, and yes instance MSSQLSERVER it is twisted on port distinct from standard 1433

2

Re: MS a SQL SERVER 2012R2 for instance

Through SQL Server Configuration Manager adjust  with instructions of port and appropriate adjustment TCP\IP

3

Re: MS a SQL SERVER 2012R2 for instance

wrote:

through SQL Server Configuration Manager adjust  with instructions of port and appropriate adjustment TCP\IP

It is client adjustment, i.e. it is necessary to adjust on a host-client

4

Re: MS a SQL SERVER 2012R2 for instance

TieLay;
At server setting it is possible to specify named . Probably, you "jumped" it and did not pay attention to requirements. So either add one more or delete and put anew.

5

Re: MS a SQL SERVER 2012R2 for instance

komrad wrote:

it is client adjustment, i.e. it is necessary to adjust on a host-client

well I so it is understood  that it is network  lying on somebody the server, and DB from it want to enclose on other server in existing .
Therefore not the problem to adjust  on a host .

6

Re: MS a SQL SERVER 2012R2 for instance

wrote:

it is passed...
Well I so am understood  that it is network  lying on somebody the server, and DB from it want to enclose on other server in existing .
Therefore not the problem to adjust  on a host .

I, actually, to the author specified it smile
Whether and that is not enough...

TieLay wrote:

...  to tear in a network   and its DB to allocate on this server...

7

Re: MS a SQL SERVER 2012R2 for instance

Kolosov wrote:

So either add one more or delete and put anew.

It is not necessary here then, especially on Friday))

8

Re: MS a SQL SERVER 2012R2 for instance

TieLay;
On how many understood it is possible to try:
CMD>> cliconfg
Well and Connection manager as noted above if on the server.

9

Re: MS a SQL SERVER 2012R2 for instance

There a subtlety what not to tear on the server new Instance and to old to attach  for at development new Instance it is necessary also with access rights to files of databases on NTFS level .