Groups | Blog | Home
all groups > sql server data mining > october 2006 >

sql server data mining : Analysis Services 2005 Deployment Wizard



somuthomas NO[at]SPAM gmail.com
10/7/2006 3:27:34 AM
Hi,


I used the deployment wizard in the analysis services 2005 to convert
it into XML script. Using the SQL Management Studio I opened it as
Analysis Server scripts and used the local host as the system in the
connections windows then loaded the XML script into the Queries window
as a XMLA query. What has to be done after this in order to use it as a

production server?


Thanks,
Somu
Dejan Sarka
10/8/2006 12:00:00 AM
[quoted text, click to view]

Have you executed the ig XMLA query in SSMS?

--
Dejan Sarka

somuthomas NO[at]SPAM gmail.com
10/8/2006 11:00:33 PM
Hi,

Yes i did try it then it says "QUERY SUCCESSFULLY EXECUTED".. Can i use

the same System as backup and production server (since i have only one
system at my disposal)??


Thanks,
SOMU
somuthomas NO[at]SPAM gmail.com
10/9/2006 5:32:03 AM

Hi,
I was able to connect with a local machine but while synchronising the
dev and production servers i am getting an error "peer prematurely
closed the conn" , " error was encountered in the transport layer" Wat
should i do to over come this...

Thanks,
SOMU
AddThis Social Bookmark Button