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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or you can simply assign a different port number to two or all instances, like:
Then append the port number to the hostname in the connection string as hostname,portnumber like:
Then append the port number to the hostname in the connection string as hostname,portnumber like:
BigSqlServer,10433
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Gentlemen
looks like for me to achieve what i want, i'm going to have to implement something bigger than expected.
looks like for me to achieve what i want, i'm going to have to implement something bigger than expected.
computername is looked up and an ip address is returned. You can't have more than 1 computer with the same ip address