However, the full name of a named instance is ComputerName\InstanceName, for example AX-NAV\NAV and only with this string we can connect to a named instance.īut if we go to Services we will find the named MsSql instance as SQL Server (InstanceName), for example SQL Server (NAV).ĬRITICAL: A named instance by default listens to a dynamic port that it chooses when the named instance starts. If we choose named instance during installation, then the installation forces us to give a name to the MsSql server instance. In all cases, we can use the IP Address of the machine hosting MsSql server instead of the name of the default instance.ĭata Source=10.3.3.4 User ID=sa Password=psw Initial Catalog=NAVDB ĭata Source=10.3.3.4,50000 User ID=sa Password=psw Initial Catalog=NAVDB A2. The same Domain,Portal scheme is used to connect from the MsSql Server Management Studio. Then the connection string becomesĭata Source= AX-NAV,50000 User ID=sa Password=psw Initial Catalog=NAVDB Instead of the default port 1433 we may use any other available port, say port 50000. Net connection stringĭata Source=AX-NAV User ID=sa Password=psw Initial Catalog=NAVDB We’ll see how.Ī client application is connected to the default instance by using either the default instance name or the IP Address of the hosting machine. We may set that port to any other available port. If, for example, machine name is AX-NAV, then the default instance will be called AX-NAV too.īut if we go to Services we will find the MsSql default instance as SQL Server (MSSQLSERVER).īy default, the default instance listens to port 1433. The MsSql server instance gets the name of the machine. If we choose default instance the installation does not allow us to give a name to the MsSql server instance. When installing MsSql server, the installer gives us two options:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |