- Sql native client 10 alias how to#
- Sql native client 10 alias install#
- Sql native client 10 alias series#
Now when you go to the application (for the demo ill create a ODBC connection and point it to MyApplicationDB instead of the server name or IP Address.)Įnter your new A Host record for the Server Name and follow through the normal steps to create and ODBC. Open DNS and go to the domain root of your SQL Server and application domain.įill in the details of your Application (Try and keep your naming to a standard so its easier to work with, for instance I use the ApplicationName followed by DB) It lets you point an application at a sqo instance and easily move it to another instance without having alter any client side details. The choice of cname of Host(A) mainly cones down to Kerberos not working with cnames. One change can alter multiple connections. and selecting SQL Native Client Configuration, as shown in Figure 6-10. Simply navigate down to the SQL Native Client section within the config manager, right click and fill out. We have configured the publication and set up the path for the. Brian Kelley walks us through the steps on a mssqltips post. Setting up aliases is simple enough if you have the SQL configuration manager installed. This really seems a last ditch solution, if you have two databases’s and only want one to use the alias your out of luck. Moving a database to a new server and routing the old connections to the new instance.
Sql native client 10 alias install#
Where during the sharepoint install they set up the client sql alias to simplify moving to a different sql instance later should they need to Guide:Ī nice guide from SharePoint MVP Colin Phillips. In SQL Server Configuration Manager, expand SQL Server Native Client Configuration, right-click Aliases, and then click New Alias. I’ve yet to find an OS that doesn’t have cliconfg on it and I tried all the way back to Windows 2003 So if SQL Client Aliases seem useful to you, you’re in luck.
This is a favourite with SharePoint admin folk. SQL Native Client provides cliconfg.exe but I think it’s also built into Windows. SQL Server Client Network Utility (cliconfg.exe) Example use:
Sql native client 10 alias how to#
Ill list them below with examples and steps/links for how to configure each one. There’s a lot of different ways you can use alias’s with sql server.
Sql native client 10 alias series#
Things to try: Open SQL Server Client Network Utility by typing cliconfg.exe in your Run command.