March 13, 2019 at 10:23 am
I am trying to duplicate a user environment that has a sqlserver with the name MFSFT646\ABO. When I attempt to create a server with this name on my development server, it tells me this is an Invalid Name. I can connect to their instance by putting Brackets around the server name
Any ideas on how to create this instance
March 13, 2019 at 1:30 pm
billasutton - Wednesday, March 13, 2019 10:23 AMI am trying to duplicate a user environment that has a sqlserver with the name MFSFT646\ABO. When I attempt to create a server with this name on my development server, it tells me this is an Invalid Name. I can connect to their instance by putting Brackets around the server name
Any ideas on how to create this instance
The backslash "\" character shows that SQL Server instance to be a Named Instance (https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/database-engine-instances-sql-server?view=sql-server-2014)
You can install several independent instances of SQL Server on one server, but only one of them can be the Default instance (the one you connect to if just specifying the server name in the connection string). The rest must have instance names specified during installation.
The server Network Name is MFSFT646, and the SQL Instance Name is ABO.
Install SQL Server on your development server as a Named Instance, with ABO as the instance name. You would then connect to it with YourServerName\ABO. For example, if your development server is named DevServ01, you would connect to your Named Instance as DevServ01\ABO (you can also locally connect to .\ABO). If you do not plan to configure a static IP port for the instance and include that in all connection strings, be sure to have the SQL Browser Service running on the host, because that service will ensure that clients connecting to DevServ01\ABO are connected to that named instance. To duplicate that full SQL Server instance name in a separate domain, build the server with MFSFT646 as the server name, and install a named instance of SQL Server with ABO as the instance name.
Eddie Wuerch
MCM: SQL
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply