?
Solved

SQL Server Client Network Utility

Posted on 2004-09-06
5
Medium Priority
?
384 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 2000 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

762 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