Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Server Client Network Utility

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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

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
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

636 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