Showing posts with label execute. Show all posts
Showing posts with label execute. Show all posts

Thursday, March 22, 2012

Connecting To Server

Hi,

As you know in SQL Server we must connect to a server to create , manage and execute databases. My problem is, I can't connect. I have searched the web for some information, they all say "write to server name your machine name to connect". I did so and get an error.

the message is ;
An error has occured while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider: Named Pipes Provider,error:40-Could not open a connection to SQL Server)(Microsoft SQL Server,Error :53)

My pc is not connected to a server.

How can I make my pc act like a server so that i can connect to it.

Hi,

This is a usual problem that occurs whilst using SQL Server 2005.

You can resolve this issue by following steps...

Use Surface Area Configuration tool to manage your connection protocol Add SQL Server Service as an Exception in Windows Firewall Use MACHINE_NAME\INSTANCE_NAME to reduce conflicts.|||

firstly thanks for the advise, Now i have a proble in Surface Area Configuration tool.

when I click to surface area configuration for services and connections an error occurs.

it says.

TITLE: Surface Area Configuration

No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)

now how can i solve this question ?

|||

Welcome,

First, have you logged in as administrator? If not, then do so. If you are using Windows Vista, then even if you are logged in as an administrator, right click the Surface Area Configuration tool and say "Run As Administrator".

This should solve your problem.

I guess, there are no further issues related with this.

Lastly, if all fails, the genuine solution is - re-install Smile If still you are facing problems, let me know.

Mayur Tendulkar

Microsoft Student Partner

|||

Have you installed a SQL Server Edition on your local computer?

|||

Thats a good question, you have to confirm what edition of SQL 2005 you have installed here.

http://www.sql-server-performance.com//faq/?f=143 too fyi.

|||

thanks to everyone tryin to help.

I have solved the problem Smile

|||

Hi,

Its good to know that you have solved the problem. Smile

But if you could post the exact cause and solution over here, then someday - somewhere, it might help others.

Mayur Tendulkar

Microsoft Student Partner

Tuesday, March 20, 2012

Connecting to Oracle 9i Server using ODBC from an SSIS package

I am trying to connect to a Oracle 9i Server to execute a sql task, but the connection when tested seems to fail with the following error from the Integration Services Project:

Test connection failed because of an error in initializing provider. ERROR [NA000][Microsoft][ODBC driver for Oracle][Oracle]ORA-12541: TNS:no listener

ERROR[IM006][Microsoft ODBC Driver Manager] Driver's SQLSetConnectAttr failed

ERROR[0100][Microsoft ODBC Driver Manager] The driver does not support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

The connection was configured and tested from Oracle's SQLPlus session. Please note that the port that the TNS Server is listening is not the default. Is there somewhere I can specify the port in the SSIS connection manager to resolve the issue.

I have tried OLEDB connection and that does not work either.

Any inputs will be appreciated.

Thanks,

Monisha

I use the ODBC Connection in my jobs connecting to Oracle without a problem. Generally this message occurs because the Oracle listener is down. You don't have to specify the port in the SSIS connection manager.|||

I have the DSN created using Microsoft ODBC Driver for Oracle and from the same box I can connect the Oracle server from a SqlPlus session, but when I drag an execute sql task in a SSIS package and create a ODBC connection using system datasource name. I specify the username and password. When I hit the test connection button I get the error that I mentioned earlier.

Test connection failed because of an error in initializing provider. ERROR [NA000][Microsoft][ODBC driver for Oracle][Oracle]ORA-12541: TNS:no listener

ERROR[IM006][Microsoft ODBC Driver Manager] Driver's SQLSetConnectAttr failed

ERROR[0100][Microsoft ODBC Driver Manager] The driver does not support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

|||Hi,

Im runnign into the same problem. MY DSN works fine when i test in the Data Access tool while creating it. When i use it with in my activex script task it throws an error when i execute a SQL the same error. Did you find a solution for this. Please suggest. Im trying to connect from my DTS Package.

thank you,
Raja

Connecting to Oracle 9i Server using ODBC from an SSIS package

I am trying to connect to a Oracle 9i Server to execute a sql task, but the connection when tested seems to fail with the following error from the Integration Services Project:

Test connection failed because of an error in initializing provider. ERROR [NA000][Microsoft][ODBC driver for Oracle][Oracle]ORA-12541: TNS:no listener

ERROR[IM006][Microsoft ODBC Driver Manager] Driver's SQLSetConnectAttr failed

ERROR[0100][Microsoft ODBC Driver Manager] The driver does not support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

The connection was configured and tested from Oracle's SQLPlus session. Please note that the port that the TNS Server is listening is not the default. Is there somewhere I can specify the port in the SSIS connection manager to resolve the issue.

I have tried OLEDB connection and that does not work either.

Any inputs will be appreciated.

Thanks,

Monisha

I use the ODBC Connection in my jobs connecting to Oracle without a problem. Generally this message occurs because the Oracle listener is down. You don't have to specify the port in the SSIS connection manager.|||

I have the DSN created using Microsoft ODBC Driver for Oracle and from the same box I can connect the Oracle server from a SqlPlus session, but when I drag an execute sql task in a SSIS package and create a ODBC connection using system datasource name. I specify the username and password. When I hit the test connection button I get the error that I mentioned earlier.

Test connection failed because of an error in initializing provider. ERROR [NA000][Microsoft][ODBC driver for Oracle][Oracle]ORA-12541: TNS:no listener

ERROR[IM006][Microsoft ODBC Driver Manager] Driver's SQLSetConnectAttr failed

ERROR[0100][Microsoft ODBC Driver Manager] The driver does not support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

|||Hi,

Im runnign into the same problem. MY DSN works fine when i test in the Data Access tool while creating it. When i use it with in my activex script task it throws an error when i execute a SQL the same error. Did you find a solution for this. Please suggest. Im trying to connect from my DTS Package.

thank you,
Raja

Sunday, February 19, 2012

Connecting Execute SQL Task with Firebird Connection Manager

Hi,


I'm using Integration Service between Firebird and MS SQL 2005. I can able to move data from Firebird db tables to MS SQL db tables using DataReader source (Firebird Connection Manager) and SQL Server Destination (SQL Server Connection Manager) component.


Now I want to execute parametrized SQL statement to fetch data from Firebird DB using Execute SQL Task Component. In this process while trying to set Connection property to this component I can able to view only MS SQL Connection Manager and it is not listing Firebird Connection Manager.

Now I need a help to get connect this Execute SQL Task component with Firebird connection Manager. Help me to find out where I'm making mistake.

FYI. I'm using Firebird .Net Provieder 2.0.1
Thanks in advance.

Suku

More clarification on my query


Here, the mentioned Firebird Connection Manager is a custom created connection manager and we created using Firebird .Net Provider 2.0.1


I tried with Lookup component too, it shows only the destination connection Manager (MS SQL) but not the Source one (Firebird Custom Connection Manager).

Suku

|||

Could you try to set the connection type to Ado .NET in the Execute SQL Task UI?

Lookup can only use OLE DB connections not Ado .NET.

Thanks.

|||

Hi,

Were you able to resolve this issue? I also have a custom connection manager that I am trying to use from Execute SQL Task. Unfortunatelly I don't see my connection object in Execute SQL Task Editor, though it gets added as a new connection successfully. My custom connection manager is basically a very simplified version of the Microsoft's SqlConnectionManager Sample. I am trying to make a custom connection manager which will hide the login info.

Thanks!

Connecting Execute SQL Task with Custom Connection Manager

Hi,


I'm using Integration Service between Firebird and MS SQL 2005. I can able to move data from Firebird db tables to MS SQL db tables using DataReader source (Firebird Connection Manager) and SQL Server Destination (SQL Server Connection Manager) component.


Now I want to execute parametrized SQL statement to fetch data from Firebird DB using Execute SQL Task Component. In this process while trying to set Connection property to this component I can able to view only MS SQL Connection Manager and it is not listing Firebird Connection Manager.

Now I need a help to get connect this Execute SQL Task component with Firebird connection Manager. Help me to find out where I'm making mistake.

FYI. I'm using Firebird .Net Provieder 2.0.1
Thanks in advance.

Suku

More clarification on my query


Here, the mentioned Firebird Connection Manager is a custom created connection manager and we created using Firebird .Net Provider 2.0.1


I tried with Lookup component too, it shows only the destination connection Manager (MS SQL) but not the Source one (Firebird Custom Connection Manager).

Suku

|||

Could you try to set the connection type to Ado .NET in the Execute SQL Task UI?

Lookup can only use OLE DB connections not Ado .NET.

Thanks.

|||

Hi,

Were you able to resolve this issue? I also have a custom connection manager that I am trying to use from Execute SQL Task. Unfortunatelly I don't see my connection object in Execute SQL Task Editor, though it gets added as a new connection successfully. My custom connection manager is basically a very simplified version of the Microsoft's SqlConnectionManager Sample. I am trying to make a custom connection manager which will hide the login info.

Thanks!

Tuesday, February 14, 2012

Connect to SSAS on TCP/IP using Java + execute XMLA

Hi,

I have done this in .Net, but that is easy because you get .Net libraries to help you connect and send XMLA over TCP/IP.

I would want to do the same using Java:

Connect to SSAS 2005 on TCP/IP, or even SOAP over TCP/IP

Then execute XMLA commands

and retrieve XMLA responses.

How to accomplish this?

Regards

Vijay R

The TCP/IP bindings to XMLA that AS use as proprietrary and also patented, therefore you cannot connect directly over TCP/IP to AS. You can use HTTP instead.|||

Hi Mosha,

Thanks a lot,

But to use HTTP we need to use IIS,

any other way to do this?

Regards

Vijay R

|||

But to use HTTP we need to use IIS

Yes. What is a problem with using IIS ?

|||

Hi Mosha,

Thanks for the quick reply,

No problem with IIS, but the dependency increases and my customer does not want to spend extra on another server.

They use java based servers like JMS.

I have told them that either we need to use AMO.Net in an .Net code or use IIS.

The problem is because of the xmla specification and ssas 2005 information given in books,

My customer points out to me that we can do an SOAP over tcp/ip and pass XMLA commands, as printed in the books!

I am not finding a valid technical angle to tackle this.

apart from that I had another related question:

we can use oledb and connect to ssas2005, right?

1) can we pass xmla commands using oledb? command like <Create>, <Alter> etc

2) the new jdbc driver for sql 2005, does it allow to connect to ssas 2005?

Thanks once more mosha

Regards

|||

No problem with IIS, but the dependency increases and my customer does not want to spend extra on another server

There is no need to spend extra on another server. You can have IIS and Analysis Services server on the same machine.

My customer points out to me that we can do an SOAP over tcp/ip and pass XMLA commands, as printed in the books!

Your customer is wrong. He cannot do that. Microsoft's OLEDB driver and ADOMD.NET can do that, but as I pointed earlier the TCP/IP bindings to XMLA are proprietrary and patent protected.

we can use oledb and connect to ssas2005, right?

Correct

1) can we pass xmla commands using oledb? command like <Create>, <Alter> etc

Yes

2) the new jdbc driver for sql 2005, does it allow to connect to ssas 2005?

No

|||

Hi Mosha,

Thanks a lot :-)

I have been quite a fan of yours!! I am currently in the US, any chance that you are here?

If possible, I was hoping to meet you.

No problem anyway, bye

Thanks again.

Regards

Vijay R

|||

Hi Mosha,

I can java, but donn't like it, therevore i use .Net pure and can communicate with SSAS through XMLA over TCP from my own code without adomd.net and other proprietary junk. Yes I haven't compression and encription, but it runs!!!

What law I break?

|||

Hi,

I tried some java code,

that opens a socket connection and sends the xmla in a soap envelope as a string.

but the connections itself in ssas profiler displays as anonymous logon,

the query does not come through to the server at all !

Regards

Vijay R

|||

Hi all,

When reading the following statements by Mosha, i was very excited:

we can use oledb and connect to ssas2005, right?

Correct

1) can we pass xmla commands using oledb? command like <Create>, <Alter> etc

Yes

Then I had to ask... How? Do I need to use a different provider / connection string? Do I need to wrap my XMLA in anything? Where can I find further information on this.

Thankyou

Aranda

|||

You should send SSPI handshacke info. How to obtain it in java I don't know. In the .Net it is pretty easy.

|||

Hi,

can you please explain in detail as to how to send the SSPI handshake info In a .net program?

it would be helpful if you can give a code snippet that expains the procesure.

Regards

|||

Hi,

Mosha wrote "as I pointed earlier the TCP/IP bindings to XMLA are proprietrary and patent protected."

Therefore here is not a right place to speak it about.

Regards

|||

:-)

So how about this Vladimir Chtepa: vijay_rb@.yahoo.com

in any case, thanks for the interaction.

Regards

Connect to SSAS on TCP/IP using Java + execute XMLA

Hi,

I have done this in .Net, but that is easy because you get .Net libraries to help you connect and send XMLA over TCP/IP.

I would want to do the same using Java:

Connect to SSAS 2005 on TCP/IP, or even SOAP over TCP/IP

Then execute XMLA commands

and retrieve XMLA responses.

How to accomplish this?

Regards

Vijay R

The TCP/IP bindings to XMLA that AS use as proprietrary and also patented, therefore you cannot connect directly over TCP/IP to AS. You can use HTTP instead.|||

Hi Mosha,

Thanks a lot,

But to use HTTP we need to use IIS,

any other way to do this?

Regards

Vijay R

|||

But to use HTTP we need to use IIS

Yes. What is a problem with using IIS ?

|||

Hi Mosha,

Thanks for the quick reply,

No problem with IIS, but the dependency increases and my customer does not want to spend extra on another server.

They use java based servers like JMS.

I have told them that either we need to use AMO.Net in an .Net code or use IIS.

The problem is because of the xmla specification and ssas 2005 information given in books,

My customer points out to me that we can do an SOAP over tcp/ip and pass XMLA commands, as printed in the books!

I am not finding a valid technical angle to tackle this.

apart from that I had another related question:

we can use oledb and connect to ssas2005, right?

1) can we pass xmla commands using oledb? command like <Create>, <Alter> etc

2) the new jdbc driver for sql 2005, does it allow to connect to ssas 2005?

Thanks once more mosha

Regards

|||

No problem with IIS, but the dependency increases and my customer does not want to spend extra on another server

There is no need to spend extra on another server. You can have IIS and Analysis Services server on the same machine.

My customer points out to me that we can do an SOAP over tcp/ip and pass XMLA commands, as printed in the books!

Your customer is wrong. He cannot do that. Microsoft's OLEDB driver and ADOMD.NET can do that, but as I pointed earlier the TCP/IP bindings to XMLA are proprietrary and patent protected.

we can use oledb and connect to ssas2005, right?

Correct

1) can we pass xmla commands using oledb? command like <Create>, <Alter> etc

Yes

2) the new jdbc driver for sql 2005, does it allow to connect to ssas 2005?

No

|||

Hi Mosha,

Thanks a lot :-)

I have been quite a fan of yours!! I am currently in the US, any chance that you are here?

If possible, I was hoping to meet you.

No problem anyway, bye

Thanks again.

Regards

Vijay R

|||

Hi Mosha,

I can java, but donn't like it, therevore i use .Net pure and can communicate with SSAS through XMLA over TCP from my own code without adomd.net and other proprietary junk. Yes I haven't compression and encription, but it runs!!!

What law I break?

|||

Hi,

I tried some java code,

that opens a socket connection and sends the xmla in a soap envelope as a string.

but the connections itself in ssas profiler displays as anonymous logon,

the query does not come through to the server at all !

Regards

Vijay R

|||

Hi all,

When reading the following statements by Mosha, i was very excited:

we can use oledb and connect to ssas2005, right?

Correct

1) can we pass xmla commands using oledb? command like <Create>, <Alter> etc

Yes

Then I had to ask... How? Do I need to use a different provider / connection string? Do I need to wrap my XMLA in anything? Where can I find further information on this.

Thankyou

Aranda

|||

You should send SSPI handshacke info. How to obtain it in java I don't know. In the .Net it is pretty easy.

|||

Hi,

can you please explain in detail as to how to send the SSPI handshake info In a .net program?

it would be helpful if you can give a code snippet that expains the procesure.

Regards

|||

Hi,

Mosha wrote "as I pointed earlier the TCP/IP bindings to XMLA are proprietrary and patent protected."

Therefore here is not a right place to speak it about.

Regards

|||

:-)

So how about this Vladimir Chtepa: vijay_rb@.yahoo.com

in any case, thanks for the interaction.

Regards

Connect to SSAS on TCP/IP using Java + execute XMLA

Hi,

I have done this in .Net, but that is easy because you get .Net libraries to help you connect and send XMLA over TCP/IP.

I would want to do the same using Java:

Connect to SSAS 2005 on TCP/IP, or even SOAP over TCP/IP

Then execute XMLA commands

and retrieve XMLA responses.

How to accomplish this?

Regards

Vijay R

The TCP/IP bindings to XMLA that AS use as proprietrary and also patented, therefore you cannot connect directly over TCP/IP to AS. You can use HTTP instead.|||

Hi Mosha,

Thanks a lot,

But to use HTTP we need to use IIS,

any other way to do this?

Regards

Vijay R

|||

But to use HTTP we need to use IIS

Yes. What is a problem with using IIS ?

|||

Hi Mosha,

Thanks for the quick reply,

No problem with IIS, but the dependency increases and my customer does not want to spend extra on another server.

They use java based servers like JMS.

I have told them that either we need to use AMO.Net in an .Net code or use IIS.

The problem is because of the xmla specification and ssas 2005 information given in books,

My customer points out to me that we can do an SOAP over tcp/ip and pass XMLA commands, as printed in the books!

I am not finding a valid technical angle to tackle this.

apart from that I had another related question:

we can use oledb and connect to ssas2005, right?

1) can we pass xmla commands using oledb? command like <Create>, <Alter> etc

2) the new jdbc driver for sql 2005, does it allow to connect to ssas 2005?

Thanks once more mosha

Regards

|||

No problem with IIS, but the dependency increases and my customer does not want to spend extra on another server

There is no need to spend extra on another server. You can have IIS and Analysis Services server on the same machine.

My customer points out to me that we can do an SOAP over tcp/ip and pass XMLA commands, as printed in the books!

Your customer is wrong. He cannot do that. Microsoft's OLEDB driver and ADOMD.NET can do that, but as I pointed earlier the TCP/IP bindings to XMLA are proprietrary and patent protected.

we can use oledb and connect to ssas2005, right?

Correct

1) can we pass xmla commands using oledb? command like <Create>, <Alter> etc

Yes

2) the new jdbc driver for sql 2005, does it allow to connect to ssas 2005?

No

|||

Hi Mosha,

Thanks a lot :-)

I have been quite a fan of yours!! I am currently in the US, any chance that you are here?

If possible, I was hoping to meet you.

No problem anyway, bye

Thanks again.

Regards

Vijay R

|||

Hi Mosha,

I can java, but donn't like it, therevore i use .Net pure and can communicate with SSAS through XMLA over TCP from my own code without adomd.net and other proprietary junk. Yes I haven't compression and encription, but it runs!!!

What law I break?

|||

Hi,

I tried some java code,

that opens a socket connection and sends the xmla in a soap envelope as a string.

but the connections itself in ssas profiler displays as anonymous logon,

the query does not come through to the server at all !

Regards

Vijay R

|||

Hi all,

When reading the following statements by Mosha, i was very excited:

we can use oledb and connect to ssas2005, right?

Correct

1) can we pass xmla commands using oledb? command like <Create>, <Alter> etc

Yes

Then I had to ask... How? Do I need to use a different provider / connection string? Do I need to wrap my XMLA in anything? Where can I find further information on this.

Thankyou

Aranda

|||

You should send SSPI handshacke info. How to obtain it in java I don't know. In the .Net it is pretty easy.

|||

Hi,

can you please explain in detail as to how to send the SSPI handshake info In a .net program?

it would be helpful if you can give a code snippet that expains the procesure.

Regards

|||

Hi,

Mosha wrote "as I pointed earlier the TCP/IP bindings to XMLA are proprietrary and patent protected."

Therefore here is not a right place to speak it about.

Regards

|||

:-)

So how about this Vladimir Chtepa: vijay_rb@.yahoo.com

in any case, thanks for the interaction.

Regards