July 2, 2012 at 1:29 pm
Hi,
We have SQL Server 2008 R2 named instance and we need to configure Sharepoint to use that sql instance.
In SharePoint configuration wizard, I want to give that sql server alias (alias should have sql server named instance with port number)
So this alias shoud be created on SQL Server box? or on SharePoint Server?
Thanks
July 2, 2012 at 2:15 pm
Not sure really what you are asking but I found this article which explains how to setup an alias.
http://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/[/url]
It doesn't really make sense to have the alias be on the SharePoint server. If you can define it remotely it would kind of defeat the purpose of an alias. 😉
There are countless other articles that explain how to create an alias for a named instance.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 2, 2012 at 2:33 pm
Thanks Sean,
I understand how to create alias but got confused where to configure i.e on sql server or on client computer:
from the link http://msdn.microsoft.com/en-us/library/ms190445(v=sql.105).aspx
It says, we need to set up alias on Client. Please clarify..
SQL Server aliasing is something to do on the "client" computer not on sql server computer.
Terminology gets slightly confusing. For client to use alias you don’t create alias on the SQL Server – you create it on the client (e.g. your web server that connects to the SQL Server as its client).
On the client usually you don’t have SQL Server Configuration Manager unless you installed it from SQL Server media. Here again, the name of the utility SQL **Server** Configuration Manager can throw you off (thinking you need to do it on the SQL Server).
On Windows Operating System (Windows 2000 and onwards??) there is a graphical utility that you can start by typing clicong.exe on command prompt. Watch out!! Utility is build specific (32 bit and 64 bit), that is, depending upon the cliconfg build it will set 32 bit or 64 bit alias. Obviously, on 32 bit computers you cannot run a 64 client app that use 64 bit or 32 SQL client but on 64 bit computers you can have either 32 or 64 bit app using 32 bit or 64 bit SQL client. Depending upon what SQL client library version (32 or 64 bit) you using you will need to use the appropriate cliconfg.exe. For example, SharePoint 2010 uses 64 bit SQL client and SQL Server 2008/R2 Management Studio itself is a 32 bit app and uses 32 bit client to connect to SQL.
For 64 bit client aliasing use cliconfg.exe from system32 (already in path and you can just type and run).
For 32 bit client aliasing switch to C:\Windows\SysWOW64 folder and run cliconfg.exe from there.
July 2, 2012 at 2:36 pm
gmamata7 (7/2/2012)
Thanks Sean,I understand how to create alias but got confused where to configure i.e on sql server or on client computer:
from the link http://msdn.microsoft.com/en-us/library/ms190445(v=sql.105).aspx
It says, we need to set up alias on Client. Please clarify..
SQL Server aliasing is something to do on the "client" computer not on sql server computer.
Terminology gets slightly confusing. For client to use alias you don’t create alias on the SQL Server – you create it on the client (e.g. your web server that connects to the SQL Server as its client).
On the client usually you don’t have SQL Server Configuration Manager unless you installed it from SQL Server media. Here again, the name of the utility SQL **Server** Configuration Manager can throw you off (thinking you need to do it on the SQL Server).
On Windows Operating System (Windows 2000 and onwards??) there is a graphical utility that you can start by typing clicong.exe on command prompt. Watch out!! Utility is build specific (32 bit and 64 bit), that is, depending upon the cliconfg build it will set 32 bit or 64 bit alias. Obviously, on 32 bit computers you cannot run a 64 client app that use 64 bit or 32 SQL client but on 64 bit computers you can have either 32 or 64 bit app using 32 bit or 64 bit SQL client. Depending upon what SQL client library version (32 or 64 bit) you using you will need to use the appropriate cliconfg.exe. For example, SharePoint 2010 uses 64 bit SQL client and SQL Server 2008/R2 Management Studio itself is a 32 bit app and uses 32 bit client to connect to SQL.
For 64 bit client aliasing use cliconfg.exe from system32 (already in path and you can just type and run).
For 32 bit client aliasing switch to C:\Windows\SysWOW64 folder and run cliconfg.exe from there.
The link you referenced is talking about how to setup a system DSN. This is different in that it is establishes this DSN on a machine. I assume from your original post that you were trying to establish an alias to the named instance? That is done on the sql server and then can be referenced in your connection string from the Sharepoint server. Does that help clarify at all or did I make it worse???
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 2, 2012 at 5:57 pm
Hi
The link which was sent to you in the first thread was correct for creating a SQL Server Instance alias. After creating the alias, reference it by using the Alias Name.
http://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/
Regards
Srikanth Reddy Kundur
July 17, 2012 at 2:11 pm
We need to configure SQL Server alias on Client servers NOT on SQL Server box.
July 17, 2012 at 2:32 pm
gmamata7 (7/17/2012)
We need to configure SQL Server alias on Client servers NOT on SQL Server box.
Ok, let's all take a moment and think about this... If you reference a default instance by the servername, and a named instance by servername\instancename... How do you think the "client" knows which server to look for? If the alias was created on the SQL Server, your "client" would never find the server to get the alias without first knowing the server! So, of course the "alias" has to be on the machine that is connecting to the SQL Server.
Jared
CE - Microsoft
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply