Friday, February 24, 2012

64 bit Server Aliases SQL 2005

Does anyone know how to create SQL Server aliases for Itanium servers?

Alternatively does anyone know how to use SMO to create a SQLAliasCollection for a specific server? I can't seem to find how to get that collection.

I've added aliases that work for 32 bit applications but they don't seem to be used for 64 bit applications.

Please check my blog for alias. http://blogs.msdn.com/sql_protocols/archive/2007/01/07/connection-alias.aspx

You need to use 64-bit cliconfg.exe or SQL Server Connection Manager to create the alias.

|||

Thanks. It turns out alias are working fine for 64 bit and we need to add the 32 bit. The problem turned out to be that I can't connect from an Itanium Back to the itanium using a different name. When we do, NT credentials are getting blocked. We can connect to other machines using aliases, just not back to the same machine. We're investigating how to get around that at the moment :)

No comments:

Post a Comment