September 14, 2011 at 9:51 am
I've been struggling to create an alias for an instance of my server, but finally managed it. However, it has raised a question:
64 bit Windows 7, 64 bit SQL Server 2008R2 - why can I only get the alias working if I create it in Configuration Manager under the SQL Native Client 10.0 Configuration (32 bit)?
September 14, 2011 at 6:29 pm
What tool are you using to connect to the SQL Server by using that alias ?
If you are using SSMS 2008\R2, since its a 32-bit application, it works only with 32-bit native client alias.
Thank You,
Best Regards,
SQLBuddy
September 15, 2011 at 1:56 am
Thanks for the reply. Now that I know that, I've worked out what to search for: http://msdn.microsoft.com/en-us/library/cc835497.aspx and http://stackoverflow.com/questions/1128597/is-there-a-64-bit-version-of-ssms-and-bids-with-sql-server-2008-64-bit.
Thanks for your time.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply