Solved

SQL Server Client Network Utility

Posted on 2004-09-06
5
361 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
  • 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

912 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now