MSSQLServerOLAPService connection string name change

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
ebrooathealthydirectionsdotcomHit "rename sql server" on google. You'll get sites like
http://www.sql-server-performance.c...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
>

MSSQLServerOLAPService connection string name change

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

MSsql Standard connect error

Hello
I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
instance name "mssql" ( hostname ="DBServer". Now I can only connect
from localhost with path "DBServer\mssql". From all other computers in
my network i cannot connect ( error "Mssql server does not exist...").
I cant even connect from localhost with path "localhost\mssql".
Previous I had Mssql 2000 Developer Edition installed on other Win2003
SP1 and I had no problems with connecting.
What can be wrong ?
Best Regards
Wojciech Znaniecki
Is SP3 or higher installed on the Win2K3 server? Is the instance listening
on TCP? Check the SQL Server errorlog to find out...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"wojtas_z" <wojtas_z@.poczta.fm> wrote in message
news:1131012588.047990.42900@.g14g2000cwa.googlegro ups.com...
> Hello
> I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
> instance name "mssql" ( hostname ="DBServer". Now I can only connect
> from localhost with path "DBServer\mssql". From all other computers in
> my network i cannot connect ( error "Mssql server does not exist...").
> I cant even connect from localhost with path "localhost\mssql".
> Previous I had Mssql 2000 Developer Edition installed on other Win2003
> SP1 and I had no problems with connecting.
> What can be wrong ?
> Best Regards
> Wojciech Znaniecki
>

MSsql Standard connect error

Hello
I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
instance name "mssql" ( hostname ="DBServer". Now I can only connect
from localhost with path "DBServer\mssql". From all other computers in
my network i cannot connect ( error "Mssql server does not exist...").
I cant even connect from localhost with path "localhost\mssql".
Previous I had Mssql 2000 Developer Edition installed on other Win2003
SP1 and I had no problems with connecting.
What can be wrong ?
Best Regards
Wojciech ZnanieckiIs SP3 or higher installed on the Win2K3 server? Is the instance listening
on TCP? Check the SQL Server errorlog to find out...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"wojtas_z" <wojtas_z@.poczta.fm> wrote in message
news:1131012588.047990.42900@.g14g2000cwa.googlegroups.com...
> Hello
> I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
> instance name "mssql" ( hostname ="DBServer". Now I can only connect
> from localhost with path "DBServer\mssql". From all other computers in
> my network i cannot connect ( error "Mssql server does not exist...").
> I cant even connect from localhost with path "localhost\mssql".
> Previous I had Mssql 2000 Developer Edition installed on other Win2003
> SP1 and I had no problems with connecting.
> What can be wrong ?
> Best Regards
> Wojciech Znaniecki
>