Hi all,
We had to rename the hostname of a server where SQL 2005 and Analysis
services were installed. SQL 2005 picked up the change no problem, but when
we try to connect to the Analysis services side of things, it's still
connecting to the old host name. I've been digging around and seen alot of
suggestions that say 'reinstall Analysis services' but I would prefer not to
if there is any other possibility.
If I do need to re-install, does anyone know if re-installing just analysis
services is possible, and how much of the existing data will be overwritten?
Any thoughts appreciated!!!
Edward
ebrooathealthydirectionsdotcom
Hit "rename sql server" on google. You'll get sites like
http://www.sql-server-performance.com/sql_server_maintenance.asp which show
how to us sp_dropserver and sp_addserver. I have not had to do this very
often, but it works.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"EB" <ebroo@.healthydirections.com> wrote in message
news:eyuunmiaHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi all,
> We had to rename the hostname of a server where SQL 2005 and Analysis
> services were installed. SQL 2005 picked up the change no problem, but
> when we try to connect to the Analysis services side of things, it's still
> connecting to the old host name. I've been digging around and seen alot of
> suggestions that say 'reinstall Analysis services' but I would prefer not
> to if there is any other possibility.
> If I do need to re-install, does anyone know if re-installing just
> analysis services is possible, and how much of the existing data will be
> overwritten?
> Any thoughts appreciated!!!
> Edward
> ebrooathealthydirectionsdotcom
>
sql
Wednesday, March 21, 2012
MSSQLServerOLAPService connection string name change
Labels:
analysisservices,
connection,
database,
hostname,
installed,
microsoft,
mssqlserverolapservice,
mysql,
oracle,
picked,
rename,
server,
sql,
string
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment