Avatar of Jim Metcalf
Jim Metcalf
Flag for United States of America asked on

SQL Server - 1 hostname - many sql servers?

Is there a way for me to have one sql server host name but have many sql servers using the same hostname.  I hope there is something for this.
example.

2012 sql server - hostname - server1  - has databases,  apple and orange on it
2014 sql server - hostname - server2 - has databases, one and two on it
2016 sql server - hostname - server3 - has databases , car and truck on it

i would like all the connection strings to be BigSqlServer and then the database name

ie   BigSqlServer\apple - actually forwards it to Server1\apple
ie.  BigSqlServer\truck     - actually forwards it to Server3\truck


the other thing i would hope to do is to move a database from one server to another and leave not have to worry about client connections
Microsoft SQL ServerSQLDatabases

Avatar of undefined
Last Comment
Jim Metcalf

8/22/2022 - Mon
David Johnson, CD

actually it would  be  computername\instancename\database
computername is looked up and an ip address is returned. You can't have more than 1 computer with the same ip address
ASKER CERTIFIED SOLUTION
Raja Jegan R

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Gustav Brock

Or you can simply assign a different port number to two or all instances, like:

Alternative port
Then append the port number to the hostname in the connection string as hostname,portnumber like:

BigSqlServer,10433
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Jim Metcalf

ASKER
Thanks Gentlemen
looks like for me to achieve what i want, i'm going to have to implement something bigger than expected.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck