?
Solved

sql server 2012 - ALIAS

Posted on 2013-11-30
2
Medium Priority
?
500 Views
Last Modified: 2013-12-08
Hi experts,

MKTG instance I have a sql server 2012
I created two aliases: PWDev64 and PWDev32
Achievement connect using the managment studio PWDev32

But I can not connect using the alias PWDev64
0
Comment
Question by:enrique_aeo
[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 Comments
 
LVL 7

Assisted Solution

by:XGIS
XGIS earned 500 total points
ID: 39687985
Please advise what server you are trying to connect to, is it
2012 or earlier.

Linked Server SQL 2012 to SQL 2008

else here is a link 2012 example to check and compare versus your existing implementation method
0
 
LVL 11

Accepted Solution

by:
John_Vidmar earned 500 total points
ID: 39690308
I only have 32-bit servers, so for me to create an alias, I run cliconfg from the run dialogue, which uses my path environment variable.  My alias is using 32-bit DLL called dbnetlib, how did you create the alias for 64-bit?  You would need to ensure you are invoking the 64-bit version of cliconfg.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

771 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