<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server 2005 General Discussion
»
How To Setup Server Side Only Alias (No...
How To Setup Server Side Only Alias (No Client Config Needed) For Named Instance Only SQL Installs
Rate Topic
Display Mode
Topic Options
Author
Message
YSLGuru
YSLGuru
Posted Monday, August 27, 2012 12:18 PM
SSC Eights!
Group: General Forum Members
Last Login: 2 days ago @ 11:18 AM
Points: 848,
Visits: 1,453
How (if possible) can I setup a Server Side alias for a named instance on a server that has SQL 2005 and SQL 2008 R2 installed and install of SQL Server uses a named instance (No Default instance) and do it so that no client side alias setup/configuration is necessary?
BACKGROUND:
For a number of years we’ve been running SQL 2005 with the DB it hosts (that is used by our primary application) set to a compatibility level of SQL 2000. We now have to upgrade the DB to work with SQL server 2008 R2. The problem is that we must move the DB to the new DB server before we are ready to upgrade to SQL 29008 R2. We will need to run the DB under SQL Server 2005 in the new DB Server for 1 – 2 months. We have but 1 DB server to do this move.
To meet all the needs listed above I installed SQL 2005 and SQL 2008 R2 both on the new DB Server installing each as a named instance with no DEFAULT instance. As of current the server DBSERVER09 has a SQL 2005 instance named SS205 and a SQL 2008 R2 instance named SS2008R2.
DBSERV09\SS2005
DBSERV09\SS21008R2
THE ALIAS:
In order to simplify all of this for the user so that they need only remember a single server name I was going to setup a server alias that would point to the SQL2005 instance for now and then after we upgraded the DB to SQL 2008 R2 I would update the Server alias to point to SS2008R2. A server only alias is an alias that requires setup/configuration on the server only. This way any client on the domain a valid username & password can connect to the server thru the alias without having to do any setup/configuration on the client system.
So Far I can’t get this to work and I am testing the connection via the alias name from both the DB Server itself (I am connected into it via Remote Desktop) and a client system and neith works when specirfying the server alis name but both work when using the proper instance name.
Is this doable and if so how?
Thanks
Kindest Regards,
A Democracy works great until the day you find yourself on the sheep side of a vote between 5 wolves and 4 sheep on what’s for dinner when neither have eaten in many days. A free Republic where the rights of the few and the individual are protected is the only one in which Freedom and Prosperity for all have a chance to blossom.
Post #1350519
RBarryYoung
RBarryYoung
Posted Monday, August 27, 2012 12:33 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855,
Visits: 9,374
What facility is the "Server only Alias"? Can you point me to the doc for it?
The only way that I've heard of anything like this was through the SPN's, is that what you mean?
Thanks,
-- RBarryYoung
,
(302)375-0451
blog:
MovingSQL.com
, Twitter:
@RBarryYoung
Proactive
Performance Solutions, Inc.
"Performance is our middle name."
Post #1350528
YSLGuru
YSLGuru
Posted Monday, August 27, 2012 12:38 PM
SSC Eights!
Group: General Forum Members
Last Login: 2 days ago @ 11:18 AM
Points: 848,
Visits: 1,453
RBarryYoung (8/27/2012)
What facility is the "Server only Alias"? Can you point me to the doc for it?
The only way that I've heard of anything like this was through the SPN's, is that what you mean?
Thanks,
BY server olny alias I mean configuring an alias at the server and not at the client so that if you have 1 server and 100 clients you need configure the alias just once, at the server and then all 100 clients can use that server alias. I'm asking if that kind of thing is possible? Or do you have to configure a server alias on every client that will need to use it?
ANother way:
SQL Server\Instance:
WDSERV09\SS2005
If I want to configure it so that all 100 clients can connect to WDSERV09\SS2005 using the server alias dbserver do I need to configure the alis at all 100 clients (a client being a workstation on the domain) or can I do it at just the SQL Server?
Thanks
Kindest Regards,
A Democracy works great until the day you find yourself on the sheep side of a vote between 5 wolves and 4 sheep on what’s for dinner when neither have eaten in many days. A free Republic where the rights of the few and the individual are protected is the only one in which Freedom and Prosperity for all have a chance to blossom.
Post #1350531
spaghettidba
spaghettidba
Posted Monday, August 27, 2012 3:08 PM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Yesterday @ 6:45 AM
Points: 4,804,
Visits: 8,068
I guess something like a DNS name + reverse proxy can do that.
I'm not sure you can forward to different ports based on the "alias" name, but it's worth giving a try.
Get your two-cent-answer quickly
The Spaghetti DBA
Post #1350613
YSLGuru
YSLGuru
Posted Wednesday, September 05, 2012 10:08 AM
SSC Eights!
Group: General Forum Members
Last Login: 2 days ago @ 11:18 AM
Points: 848,
Visits: 1,453
Thanks to everyone who took tike to reply. AT this point thsi looks like a no-go in as far as doing it without imnpelemnting some kind fo work-around that may not work for all clients/scenarios.
Luckily the bulk (about %90 or more) of the users connecting to the BD do so thru an IE managed web based application which stores the Server anem & DB requiring that the user need only provide tehir login info so we don;t have to worry about tehir getting the right server name + alias. Only our outside users who come in outside this web based app will need to specify the server name. For those we can get a client side alias setup for them to use if need be,
Thanks again
Kindest Regards,
A Democracy works great until the day you find yourself on the sheep side of a vote between 5 wolves and 4 sheep on what’s for dinner when neither have eaten in many days. A free Republic where the rights of the few and the individual are protected is the only one in which Freedom and Prosperity for all have a chance to blossom.
Post #1354721
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
