[Mary Mallazzo]

Hello
We are just starting to use SmarList builder to publish excel reports. The SQL server name is incorrect.  It needs to be corrected each time a file is refreshed.  Where is that server name stored?

Thank you

——————————
Mary Mallazzo
Fromkin Brothers
Edison NJ
——————————

[Gerald Buenafe]

Hi Mary,
Do you have access to your SQL Server?  If so, can you run the select statement below?

select @@SERVERNAME

Is that the correct server Name?

——————————
Gerald Buenafe
Owner/Consultant
BTP Technologies LLC
CHANTILLY VA
——————————
——————————————-

[Mary Mallazzo]

Actually that does not return the correct server name. That returns the name that is excel is using.

——————————
Mary Mallazzo
Fromkin Brothers
Edison NJ
——————————
——————————————-

[Gerald Buenafe]

OK, at least it is consistent.

— here is a script that can change to the right server name.  I would suggest that you have to work with your IT or DBA on this.

— verify name incorrect

SELECT @@servername;

 

— Remove the old name from the SQL server

sp_dropserver ‘<name from @@servername>’;

go

 

— Add the new name, with local set as well.

sp_addserver ‘<new server name>’,LOCAL;

GO

 

— verify change taken

SELECT @@servername;

——————————
Gerald Buenafe
Owner/Consultant
BTP Technologies LLC
CHANTILLY VA
——————————
——————————————-

[Mary Mallazzo]

Thanks!

——————————
Mary Mallazzo
Fromkin Brothers
Edison NJ
——————————
——————————————-

[Gerald Buenafe]

You are welcome!  Hope that helps

——————————
Gerald Buenafe
Owner/Consultant
BTP Technologies LLC
CHANTILLY VA
——————————
——————————————-

[Mwalimu Phiri]

Hi Mary, were you able to resolve this issue? Depending on the source issue, you may need to redeploy the report and the connection strings pointing to the correct server.

——————————
Mwalimu Phiri, MSc
——————————
——————————————-

[Mary Mallazzo]

Not yet.  Passed on the info regarding needing to change the name of the SQL server to our hardware/server support vendor.  They are afraid to make the changed.  Feel they need to do “more research” on what the effect will be.

——————————
Mary Mallazzo
Fromkin Brothers
Edison NJ
——————————
——————————————-