Select Categories Below
Status: Closed Points: 75 Time: 15:55 - Aug 03, 2006
Anpanman
In the enterprise manager for ms sql server 2000 I'm trying to configure access with two different users on the same server. Each user has access to a different database. The first was no problem, but when I try to add a new server (which is the same as an existing one) with the other user login, I get the error message "A server with this name already exists". How do I get around this problem?
Categories:
Add Categories
When adding more than one category, separate them with commas.
Advertisement
Date:: Aug 03, 2006
Time:: 16:56
Ok, I found out how to do it myself. I had to use the "Client Network Utility" application coming with the sql server installation. (Look in START/All Programs/MS SQL Server/) There I clicked on the Alias tab then the Add-button and wrote the alias i wanted to appear in my server list in the enterprise manager. I chose TPC/IP as network library and gave the correct server name (plus the specific port, since it wasn't the default one). Then I closed Client Network Utility and went back to the enterprise manager and when registering a new server i used the alias instead of the real server name. Now it's working perfectly.
rcastagna
Time:: 23:10
Too bad you can't award yourself the points! :) This is a great way to restrict access to the server. I'm glad you found the answer. Ric
Date:: Aug 08, 2006
Time:: 16:39
Well, I can actually give myself the points back. But they don't help in my ranking... :)
Question Answered
This question has been closed, and points have been rewarded to the following experts:
You're welcome however to comment or give additional information or if you wish, you have the ability to write a Tutorial in the Tutorial Area.
Answer this Question
New User
Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address
Registered User
Username:
Password:
Forgot Your Password?
Enter your email address below and we will resend your login information to you.
Login Information Sent
Questions
change owner of objects in ms sql server
how to export a database from ms sql server to access?
How do I restore a database on sql server through the command prompt?
sql server 2000: Generate insert scripts for data?
How do I connect to an ms access database with NHibernate?
You have 100 characters to use
Rank
Expert
Points
1.
10
2.
3.
4.
5
Register today to share your knowledge with the community and be recognized and rewarded for your contributions.
Register Here
"Psst, Quomon is a great site. Pass it on." Tell a Friend | Link To Us | Save to Delicious | Digg it
Language Options
English:
Español:
Sponsors
Questions and Answers Software Real Estate Postcards Marketing Fulfillment