Hi
I was doing steps on page 15 / 16 of attached sheet
I was doing the microsoft example about cube to setup DSN SOURCE CONNECTION to ACCESS database (food mart) when i do a test it works
but after i do design storage and go to Process the cube
it gives me error
'test connection failed because of an error in initializing provide
(microsoft) ODBC DRIVER manager data source name not found and no default driver specified
one more error found
Microsoft ODBC DRIVER MANAGER driver sql connect attr failed: IMOO6
ThanksOriginally posted by sjumma
Hi
I was doing steps on page 15 / 16 of attached sheet
I was doing the microsoft example about cube to setup DSN SOURCE CONNECTION to ACCESS database (food mart) when i do a test it works
but after i do design storage and go to Process the cube
it gives me error
'test connection failed because of an error in initializing provide
(microsoft) ODBC DRIVER manager data source name not found and no default driver specified
one more error found
Microsoft ODBC DRIVER MANAGER driver sql connect attr failed: IMOO6
Thanks
Ensure you have applied SP3. I'm pretty sure there is an MDAC upgrade.|||Hi
I have already upgraded with the patch but still does not work
Showing posts with label setup. Show all posts
Showing posts with label setup. Show all posts
Sunday, March 25, 2012
Thursday, March 22, 2012
Analysis Server
Can somebody help me understand what it take to install and setup Analysis
Server?
Is it part of standard MSSQL 2000 setup procedure?
Thx
YuriW
Yuri,
The procedure to install Analysis services is mentioned in
BooksOnLine(BOL).Here is the url:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\ola
pdmad.chm::/aginstalling_5trn.htm
To access a url, open up BOL and in the 'Go' menu, select 'url' and feed in
the above value.In case you dont have BOL installed, here is the same page
in the web:
'Running Setup'
http://msdn.microsoft.com/library/en...asp?frame=true
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy. com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>
|||In addition to Dinesh's answer, simply put the SQL CD in, and do
autorun.exe... Choose Install Database components, the next window will
give you an option to install Analysis services... Click click you are
done..
Then install the service pack..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy. com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>
sql
Server?
Is it part of standard MSSQL 2000 setup procedure?
Thx
YuriW
Yuri,
The procedure to install Analysis services is mentioned in
BooksOnLine(BOL).Here is the url:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\ola
pdmad.chm::/aginstalling_5trn.htm
To access a url, open up BOL and in the 'Go' menu, select 'url' and feed in
the above value.In case you dont have BOL installed, here is the same page
in the web:
'Running Setup'
http://msdn.microsoft.com/library/en...asp?frame=true
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy. com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>
|||In addition to Dinesh's answer, simply put the SQL CD in, and do
autorun.exe... Choose Install Database components, the next window will
give you an option to install Analysis services... Click click you are
done..
Then install the service pack..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy. com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>
sql
Analysis Server
Can somebody help me understand what it take to install and setup Analysis
Server?
Is it part of standard MSSQL 2000 setup procedure?
Thx
YuriWYuri,
The procedure to install Analysis services is mentioned in
BooksOnLine(BOL).Here is the url:
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\ola
pdmad.chm::/aginstalling_5trn.htm
To access a url, open up BOL and in the 'Go' menu, select 'url' and feed in
the above value.In case you dont have BOL installed, here is the same page
in the web:
'Running Setup'
/url]
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
[url]http://www.tkdinesh.com" target="_blank">http://msdn.microsoft.com/library/e...ww.tkdinesh.com
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy.com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>|||In addition to Dinesh's answer, simply put the SQL CD in, and do
autorun.exe... Choose Install Database components, the next window will
give you an option to install Analysis services... Click click you are
done..
Then install the service pack..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy.com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>
Server?
Is it part of standard MSSQL 2000 setup procedure?
Thx
YuriWYuri,
The procedure to install Analysis services is mentioned in
BooksOnLine(BOL).Here is the url:
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\ola
pdmad.chm::/aginstalling_5trn.htm
To access a url, open up BOL and in the 'Go' menu, select 'url' and feed in
the above value.In case you dont have BOL installed, here is the same page
in the web:
'Running Setup'
/url]
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
[url]http://www.tkdinesh.com" target="_blank">http://msdn.microsoft.com/library/e...ww.tkdinesh.com
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy.com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>|||In addition to Dinesh's answer, simply put the SQL CD in, and do
autorun.exe... Choose Install Database components, the next window will
give you an option to install Analysis services... Click click you are
done..
Then install the service pack..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy.com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>
Monday, March 19, 2012
An issue with ReplicationUser
I have set-up a Replication on a SQL 2005 Cluster. I used a domain account to setup the replication. This domain account is also present in the local administrator group of both nodes of cluster. However my subscriptions fail with a message "Executed as user domain\user. A required privilege is not held by the client. The step failed." I am not sure what privilege the domain user should have.
Any tips on what kind of user account I should be using? Thanks.
This is not an issue any more.Thursday, February 16, 2012
Ambiguous column name error
Hi all,
I am a newbee at SQl and replication. But I have setup a Transactional
replication model, the Source server is both publisher and Distributor, and
SQL 2000 SP4 is used.
The snapshot is created, but the distribution fails. And the following error
is generated, 'ambiguous column name' with a column specified. Is there
anything that we can do about this or did the developer used the wrong naming
conventions in his desgin?
Help would be greatly appreciated!!!
Remco
Anyone?
I am a newbee at SQl and replication. But I have setup a Transactional
replication model, the Source server is both publisher and Distributor, and
SQL 2000 SP4 is used.
The snapshot is created, but the distribution fails. And the following error
is generated, 'ambiguous column name' with a column specified. Is there
anything that we can do about this or did the developer used the wrong naming
conventions in his desgin?
Help would be greatly appreciated!!!
Remco
Anyone?
Amazon Web Service Call with Web Service Task
With the new improvments to the web service task, we can now use variables as arguments in web service calls. I am trying to setup a call to the amazon web service ECS. I am trying to do a simple sellerlookup. I have played with the settings and gotten nowhere. I get one of two error when I try to execute. I can always use a scripting task or write my own task, but I would like to use the built in task if it is possible. Has anyone used AWS with SSIS?
[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Object reference not set to an instance of an object.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
or
[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Method 'ProxyNamespace.AWSECommerceService.SellerLookup' not found.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
Hi,
I'm having the same problem with a web service, did you can an answer to this?
Thanks, Paul.
|||Did anyone ever resolved this?
Thanks Henry
|||I resolved mine it was actually an issue with data type assignment in the variable passed. This error reporting for this task is terrible.|||Thanks Hnery have not solved it
Paul.
|||Thanks Henry have now solved it
Paul.
Amazon Web Service Call with Web Service Task
With the new improvments to the web service task, we can now use variables as arguments in web service calls. I am trying to setup a call to the amazon web service ECS. I am trying to do a simple sellerlookup. I have played with the settings and gotten nowhere. I get one of two error when I try to execute. I can always use a scripting task or write my own task, but I would like to use the built in task if it is possible. Has anyone used AWS with SSIS?
[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Object reference not set to an instance of an object.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
or
[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Method 'ProxyNamespace.AWSECommerceService.SellerLookup' not found.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
Hi,
I'm having the same problem with a web service, did you can an answer to this?
Thanks, Paul.
|||Did anyone ever resolved this?
Thanks Henry
|||I resolved mine it was actually an issue with data type assignment in the variable passed. This error reporting for this task is terrible.|||Thanks Hnery have not solved it
Paul.
|||Thanks Henry have now solved it
Paul.
Subscribe to:
Posts (Atom)