Solved

SQL Server Client Network Utility

Posted on 2004-09-06
5
374 Views
Last Modified: 2012-05-05
Hello Buddies

I want to open a debate on SQL Server Client Network Utility. What are the strong points and limitions using this technique to use database alias.

Let me describe my position.. i am having 2 servers

1 Application Server (named SIRUS)
2 Database Server (named ORION)

i am running hundreds of applications on SIRUS which is using database named ORION. Now what i want to do is to merge both these servers by putting one strong machine instead of 2 to be used as application as well as database server.

Now my problem is if i name new machine as ORION.. then i have to change all the physical paths of hundreds of applications which is practically not possiblem.. and if i name this new machin as SIRUS than i have to chnage database name of my hundreds of application..which is again not possible.. now i m working on possiblity if i name my mahcin as SIRUS and the database name on this machine as ORION..

@ram has given me idea to use  SQL Server Client Network Utility to create alias of database SIRUS with the name of ORION on the machine named SIRUS..

Now i want views from experts if i m using this structure, is there any limitations in it ?? i have some 10-12 machines in my network and i can create database alias on each of the machine.. is there a way if i can do sometihng only at server to create alias to be used in the network without doing anything with workstations ??

neeraj523
0
Comment
Question by:neeraj523
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 10

Accepted Solution

by:
AaronAbend earned 500 total points
ID: 11996461
I have used this technique and it works fine - just don't forget where you are when you launch a command!  As a helpful check, I put a database on the server that has the name of the server so it is very clear which server I am working on (e.g., I would create a 1mb database called "Sirus_Server" on Sirus.

0
 
LVL 10

Expert Comment

by:AaronAbend
ID: 11996487
By the way, I was pointed to this solution by Brett (arbert). Here is the PAQ I asked...

Q_20787347.html
0
 
LVL 22

Author Comment

by:neeraj523
ID: 12003185

hmm.. nice tip... thanx aron

still i will wait for more debate on this..
i don't want to get stuck later once i upgrade my network according to this structure.. i would like to know each and every issue i could face in it..

neeraj523
0
 
LVL 22

Author Comment

by:neeraj523
ID: 12197032

Thanx TheLearnedOne for reminding to close this question.. i guess now i can;'t expect any more debate on this topic..

anyway thanx a lot @Aaron for your valuable help..

neeraj523
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question