July 2, 2008 at 7:23 pm
In our environment we have a development stream of four levels: dev desktop, dev server, test and production. We're aiming to reduce the number of changes required to projects to promote them between environments. To this end, we're trialling CNAMEs in DNS to alias our SQL Servers at each level. DWV2 is our data warehouse SQL 2005 stream.
I've created an entry in my hosts file (dev desktop level) which points DWV2 back to my IP address. I can ping DWV2 fine. I've created a linked server in SQL Server on my dev desktop to DWV2; i.e. my SQL Server. When I try and connect to my box, I get the dreaded 18452: Login failed for user '' error. I've tried using two different Windows accounts.
I have next to no control over permissions on the domain. If I was to get changes as to which machines are allowed delegation permissions, I'd have to have a very strong reason. Further, I don't understand why I'm getting these issues; if I can log in to and query my box using my Windows user, but can't query the linked server under the same account, what's going on? If it's the "double hop" issue, can someone please explain to me how this is the problem?
July 13, 2008 at 7:30 pm
Hi all,
I seem to have been able to overcome this using SQL Server aliases (see here: http://msdn.microsoft.com/en-us/library/ms190445.aspx). Will reply here if I get stuck again.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply