Installing Integrity Server on MS Server 2003 but having problems when Specifing the Database, prior to this install i've already installed JDBC driver on this server version 3.
At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
" A problem was encountered when trying to connect to the database JDBC.
[Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
for user SA, Reason: Not associated with a trusted SQL Server
connection"
Can please help
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...4603ecbf9ea539
*****************************************
The error message indicates you are trying to connect to SQL
Server using SQL authentication and a SQL Server login.
However, your SQL Server is configured for Windows
Authentication only. It's not a good idea to use sa but if
that's what is required you need to change SQL Server to use
both Windows and SQL Server authentication.
-Sue
On Wed, 10 Nov 2004 16:14:23 GMT, "jaimoon patel via
SQLMonster.com" <forum@.SQLMonster.com> wrote:
>Installing Integrity Server on MS Server 2003 but having problems when Specifing the Database, prior to this install i've already installed JDBC driver on this server version 3.
>At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
>" A problem was encountered when trying to connect to the database JDBC.
> [Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
> for user SA, Reason: Not associated with a trusted SQL Server
> connection"
>Can please help
>*****************************************
>* This message was posted via http://www.sqlmonster.com
>*
>* Report spam or abuse by clicking the following URL:
>* http://www.sqlmonster.com/Uwe/Abuse...4603ecbf9ea539
>*****************************************
Showing posts with label install. Show all posts
Showing posts with label install. Show all posts
Friday, March 9, 2012
Integrity Server Connecting to SQL Server
Installing Integrity Server on MS Server 2003 but having problems when Speci
fing the Database, prior to this install i've already installed JDBC driver
on this server version 3.
At this stage of install of the Integrity Server its trying to connect to th
e SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is
sitting in the same Domain. An Error appears
" A problem was encountered when trying to connect to the database JDBC.
[Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login fa
illed
for user SA, Reason: Not associated with a trusted SQL Server
connection"
Can please help
****************************************
*
* This message was posted via http://www.droptable.com
*
* Report spam or abuse by clicking the following URL:
* [url]http://www.droptable.com/Uwe/Abuse.aspx?aid=87f62ecdc6c849cbbf4603ecbf9ea539[/u
rl]
****************************************
*The error message indicates you are trying to connect to SQL
Server using SQL authentication and a SQL Server login.
However, your SQL Server is configured for Windows
Authentication only. It's not a good idea to use sa but if
that's what is required you need to change SQL Server to use
both Windows and SQL Server authentication.
-Sue
On Wed, 10 Nov 2004 16:14:23 GMT, "jaimoon patel via
droptable.com" <forum@.droptable.com> wrote:
>Installing Integrity Server on MS Server 2003 but having problems when Spec
ifing the Database, prior to this install i've already installed JDBC driver
on this server version 3.
>At this stage of install of the Integrity Server its trying to connect to t
he SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is
sitting in the same Domain. An Error appears
>" A problem was encountered when trying to connect to the database JDBC.
> [Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login
failled
> for user SA, Reason: Not associated with a trusted SQL Server
> connection"
>Can please help
> ****************************************
*
>* This message was posted via http://www.droptable.com
>*
>* Report spam or abuse by clicking the following URL:
>* [url]http://www.droptable.com/Uwe/Abuse.aspx?aid=87f62ecdc6c849cbbf4603ecbf9ea539[/
url]
> ****************************************
*
fing the Database, prior to this install i've already installed JDBC driver
on this server version 3.
At this stage of install of the Integrity Server its trying to connect to th
e SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is
sitting in the same Domain. An Error appears
" A problem was encountered when trying to connect to the database JDBC.
[Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login fa
illed
for user SA, Reason: Not associated with a trusted SQL Server
connection"
Can please help
****************************************
*
* This message was posted via http://www.droptable.com
*
* Report spam or abuse by clicking the following URL:
* [url]http://www.droptable.com/Uwe/Abuse.aspx?aid=87f62ecdc6c849cbbf4603ecbf9ea539[/u
rl]
****************************************
*The error message indicates you are trying to connect to SQL
Server using SQL authentication and a SQL Server login.
However, your SQL Server is configured for Windows
Authentication only. It's not a good idea to use sa but if
that's what is required you need to change SQL Server to use
both Windows and SQL Server authentication.
-Sue
On Wed, 10 Nov 2004 16:14:23 GMT, "jaimoon patel via
droptable.com" <forum@.droptable.com> wrote:
>Installing Integrity Server on MS Server 2003 but having problems when Spec
ifing the Database, prior to this install i've already installed JDBC driver
on this server version 3.
>At this stage of install of the Integrity Server its trying to connect to t
he SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is
sitting in the same Domain. An Error appears
>" A problem was encountered when trying to connect to the database JDBC.
> [Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login
failled
> for user SA, Reason: Not associated with a trusted SQL Server
> connection"
>Can please help
> ****************************************
*
>* This message was posted via http://www.droptable.com
>*
>* Report spam or abuse by clicking the following URL:
>* [url]http://www.droptable.com/Uwe/Abuse.aspx?aid=87f62ecdc6c849cbbf4603ecbf9ea539[/
url]
> ****************************************
*
Integrity Server Connecting to SQL Server
Installing Integrity Server on MS Server 2003 but having problems when Specifing the Database, prior to this install i've already installed JDBC driver on this server version 3.
At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
" A problem was encountered when trying to connect to the database JDBC.
[Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
for user SA, Reason: Not associated with a trusted SQL Server
connection"
Can please help
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=87f62ecdc6c849cbbf4603ecbf9ea539
*****************************************The error message indicates you are trying to connect to SQL
Server using SQL authentication and a SQL Server login.
However, your SQL Server is configured for Windows
Authentication only. It's not a good idea to use sa but if
that's what is required you need to change SQL Server to use
both Windows and SQL Server authentication.
-Sue
On Wed, 10 Nov 2004 16:14:23 GMT, "jaimoon patel via
SQLMonster.com" <forum@.SQLMonster.com> wrote:
>Installing Integrity Server on MS Server 2003 but having problems when Specifing the Database, prior to this install i've already installed JDBC driver on this server version 3.
>At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
>" A problem was encountered when trying to connect to the database JDBC.
> [Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
> for user SA, Reason: Not associated with a trusted SQL Server
> connection"
>Can please help
>*****************************************
>* This message was posted via http://www.sqlmonster.com
>*
>* Report spam or abuse by clicking the following URL:
>* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=87f62ecdc6c849cbbf4603ecbf9ea539
>*****************************************
At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
" A problem was encountered when trying to connect to the database JDBC.
[Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
for user SA, Reason: Not associated with a trusted SQL Server
connection"
Can please help
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=87f62ecdc6c849cbbf4603ecbf9ea539
*****************************************The error message indicates you are trying to connect to SQL
Server using SQL authentication and a SQL Server login.
However, your SQL Server is configured for Windows
Authentication only. It's not a good idea to use sa but if
that's what is required you need to change SQL Server to use
both Windows and SQL Server authentication.
-Sue
On Wed, 10 Nov 2004 16:14:23 GMT, "jaimoon patel via
SQLMonster.com" <forum@.SQLMonster.com> wrote:
>Installing Integrity Server on MS Server 2003 but having problems when Specifing the Database, prior to this install i've already installed JDBC driver on this server version 3.
>At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
>" A problem was encountered when trying to connect to the database JDBC.
> [Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
> for user SA, Reason: Not associated with a trusted SQL Server
> connection"
>Can please help
>*****************************************
>* This message was posted via http://www.sqlmonster.com
>*
>* Report spam or abuse by clicking the following URL:
>* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=87f62ecdc6c849cbbf4603ecbf9ea539
>*****************************************
Friday, February 24, 2012
Integration Services won't install
I am installing Visual Studio 2005 Professional on Windows XP.
I have finished installing Visual Studio 2005 Professional along with Service Pack 1. Now I am installing the Developer version of SQL 2005 that comes with Visual Studio 2005 Professional .
During the installation of SQL Server 2005, I got the following error during
the integration services installation portion:
Failed to install and configure assemblies: c:\program files\microsoft sql
server\90\dts\tasks\microsoft.sqlserver.msmqtask.d ll in the COM+ catalog.
Error -2146233087
Error message: unknown error 0x80131501
Error description: You must have administrative credentials to perform this
task.
I'm logged into Windows as Administrator.
This machine did previously have VS 2005 Standard and SQL 2005 Standard loaded. The software was RTM software as provided by Microsoft at their launch event. I did uninstall both products before attempting the upgrade.
Any help would be much appreciated.
Hi,
Refer below links for workaround
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=136467&SiteID=1
http://geekswithblogs.net/waterbaby/archive/2006/08/03/87048.aspx
HTH
Hemantgiri S. Goswami
|||This is an issue when Microsoft.SqlServer.MSMQTask is left behind in COM+ catalog. You can workaround it by:
1. Open Administrative Tools\Component Services
2. Go to Component Services\Computers\My Computer\COM+ Applications
3. Delete Microsoft.SqlServer.MSMQTask
Integration Services Install only
Can Integration Services only be installed on a server without installing any
other componenets of the SQL Server 2005 ?. If so, do I need a separate
license for it ?
I have SQL Server installed on a Server and I am trying to execute a IS
package on the SQL Server from a citrix box but returning an error. In
several places I read, they resolve it by installing the IS on the client
(Citrix server in my case).
T.I.AHi
Look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx or Books
Online and install SQL 2005 from the command line using the ADDLOCAL option
with the SQL_DTS child feature.
John
"DXC" wrote:
> Can Integration Services only be installed on a server without installing any
> other componenets of the SQL Server 2005 ?. If so, do I need a separate
> license for it ?
> I have SQL Server installed on a Server and I am trying to execute a IS
> package on the SQL Server from a citrix box but returning an error. In
> several places I read, they resolve it by installing the IS on the client
> (Citrix server in my case).
> T.I.A|||Thanks John. How about the licensing issue ?
"John Bell" wrote:
> Hi
> Look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx or Books
> Online and install SQL 2005 from the command line using the ADDLOCAL option
> with the SQL_DTS child feature.
> John
> "DXC" wrote:
> > Can Integration Services only be installed on a server without installing any
> > other componenets of the SQL Server 2005 ?. If so, do I need a separate
> > license for it ?
> >
> > I have SQL Server installed on a Server and I am trying to execute a IS
> > package on the SQL Server from a citrix box but returning an error. In
> > several places I read, they resolve it by installing the IS on the client
> > (Citrix server in my case).
> >
> > T.I.A|||Hi
You would need to consult your softwaer vendor, but if you install the SQL
Server Engine on this node I expect it will be the normal cost of an active
node.
John
"DXC" wrote:
> Thanks John. How about the licensing issue ?
>
> "John Bell" wrote:
> > Hi
> >
> > Look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx or Books
> > Online and install SQL 2005 from the command line using the ADDLOCAL option
> > with the SQL_DTS child feature.
> >
> > John
> >
> > "DXC" wrote:
> >
> > > Can Integration Services only be installed on a server without installing any
> > > other componenets of the SQL Server 2005 ?. If so, do I need a separate
> > > license for it ?
> > >
> > > I have SQL Server installed on a Server and I am trying to execute a IS
> > > package on the SQL Server from a citrix box but returning an error. In
> > > several places I read, they resolve it by installing the IS on the client
> > > (Citrix server in my case).
> > >
> > > T.I.A|||Thanks............
"John Bell" wrote:
> Hi
> You would need to consult your softwaer vendor, but if you install the SQL
> Server Engine on this node I expect it will be the normal cost of an active
> node.
> John
> "DXC" wrote:
> > Thanks John. How about the licensing issue ?
> >
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > Look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx or Books
> > > Online and install SQL 2005 from the command line using the ADDLOCAL option
> > > with the SQL_DTS child feature.
> > >
> > > John
> > >
> > > "DXC" wrote:
> > >
> > > > Can Integration Services only be installed on a server without installing any
> > > > other componenets of the SQL Server 2005 ?. If so, do I need a separate
> > > > license for it ?
> > > >
> > > > I have SQL Server installed on a Server and I am trying to execute a IS
> > > > package on the SQL Server from a citrix box but returning an error. In
> > > > several places I read, they resolve it by installing the IS on the client
> > > > (Citrix server in my case).
> > > >
> > > > T.I.A
other componenets of the SQL Server 2005 ?. If so, do I need a separate
license for it ?
I have SQL Server installed on a Server and I am trying to execute a IS
package on the SQL Server from a citrix box but returning an error. In
several places I read, they resolve it by installing the IS on the client
(Citrix server in my case).
T.I.AHi
Look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx or Books
Online and install SQL 2005 from the command line using the ADDLOCAL option
with the SQL_DTS child feature.
John
"DXC" wrote:
> Can Integration Services only be installed on a server without installing any
> other componenets of the SQL Server 2005 ?. If so, do I need a separate
> license for it ?
> I have SQL Server installed on a Server and I am trying to execute a IS
> package on the SQL Server from a citrix box but returning an error. In
> several places I read, they resolve it by installing the IS on the client
> (Citrix server in my case).
> T.I.A|||Thanks John. How about the licensing issue ?
"John Bell" wrote:
> Hi
> Look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx or Books
> Online and install SQL 2005 from the command line using the ADDLOCAL option
> with the SQL_DTS child feature.
> John
> "DXC" wrote:
> > Can Integration Services only be installed on a server without installing any
> > other componenets of the SQL Server 2005 ?. If so, do I need a separate
> > license for it ?
> >
> > I have SQL Server installed on a Server and I am trying to execute a IS
> > package on the SQL Server from a citrix box but returning an error. In
> > several places I read, they resolve it by installing the IS on the client
> > (Citrix server in my case).
> >
> > T.I.A|||Hi
You would need to consult your softwaer vendor, but if you install the SQL
Server Engine on this node I expect it will be the normal cost of an active
node.
John
"DXC" wrote:
> Thanks John. How about the licensing issue ?
>
> "John Bell" wrote:
> > Hi
> >
> > Look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx or Books
> > Online and install SQL 2005 from the command line using the ADDLOCAL option
> > with the SQL_DTS child feature.
> >
> > John
> >
> > "DXC" wrote:
> >
> > > Can Integration Services only be installed on a server without installing any
> > > other componenets of the SQL Server 2005 ?. If so, do I need a separate
> > > license for it ?
> > >
> > > I have SQL Server installed on a Server and I am trying to execute a IS
> > > package on the SQL Server from a citrix box but returning an error. In
> > > several places I read, they resolve it by installing the IS on the client
> > > (Citrix server in my case).
> > >
> > > T.I.A|||Thanks............
"John Bell" wrote:
> Hi
> You would need to consult your softwaer vendor, but if you install the SQL
> Server Engine on this node I expect it will be the normal cost of an active
> node.
> John
> "DXC" wrote:
> > Thanks John. How about the licensing issue ?
> >
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > Look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx or Books
> > > Online and install SQL 2005 from the command line using the ADDLOCAL option
> > > with the SQL_DTS child feature.
> > >
> > > John
> > >
> > > "DXC" wrote:
> > >
> > > > Can Integration Services only be installed on a server without installing any
> > > > other componenets of the SQL Server 2005 ?. If so, do I need a separate
> > > > license for it ?
> > > >
> > > > I have SQL Server installed on a Server and I am trying to execute a IS
> > > > package on the SQL Server from a citrix box but returning an error. In
> > > > several places I read, they resolve it by installing the IS on the client
> > > > (Citrix server in my case).
> > > >
> > > > T.I.A
Integration Services Install only
Can Integration Services only be installed on a server without installing an
y
other componenets of the SQL Server 2005 ?. If so, do I need a separate
license for it ?
I have SQL Server installed on a Server and I am trying to execute a IS
package on the SQL Server from a citrix box but returning an error. In
several places I read, they resolve it by installing the IS on the client
(Citrix server in my case).
T.I.AHi
Look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx or Books
Online and install SQL 2005 from the command line using the ADDLOCAL option
with the SQL_DTS child feature.
John
"DXC" wrote:
> Can Integration Services only be installed on a server without installing
any
> other componenets of the SQL Server 2005 ?. If so, do I need a separate
> license for it ?
> I have SQL Server installed on a Server and I am trying to execute a IS
> package on the SQL Server from a citrix box but returning an error. In
> several places I read, they resolve it by installing the IS on the client
> (Citrix server in my case).
> T.I.A|||Thanks John. How about the licensing issue ?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx or Books
> Online and install SQL 2005 from the command line using the ADDLOCAL optio
n
> with the SQL_DTS child feature.
> John
> "DXC" wrote:
>|||Hi
You would need to consult your softwaer vendor, but if you install the SQL
Server Engine on this node I expect it will be the normal cost of an active
node.
John
"DXC" wrote:
[vbcol=seagreen]
> Thanks John. How about the licensing issue ?
>
> "John Bell" wrote:
>|||Thanks............
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You would need to consult your softwaer vendor, but if you install the SQL
> Server Engine on this node I expect it will be the normal cost of an activ
e
> node.
> John
> "DXC" wrote:
>
y
other componenets of the SQL Server 2005 ?. If so, do I need a separate
license for it ?
I have SQL Server installed on a Server and I am trying to execute a IS
package on the SQL Server from a citrix box but returning an error. In
several places I read, they resolve it by installing the IS on the client
(Citrix server in my case).
T.I.AHi
Look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx or Books
Online and install SQL 2005 from the command line using the ADDLOCAL option
with the SQL_DTS child feature.
John
"DXC" wrote:
> Can Integration Services only be installed on a server without installing
any
> other componenets of the SQL Server 2005 ?. If so, do I need a separate
> license for it ?
> I have SQL Server installed on a Server and I am trying to execute a IS
> package on the SQL Server from a citrix box but returning an error. In
> several places I read, they resolve it by installing the IS on the client
> (Citrix server in my case).
> T.I.A|||Thanks John. How about the licensing issue ?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx or Books
> Online and install SQL 2005 from the command line using the ADDLOCAL optio
n
> with the SQL_DTS child feature.
> John
> "DXC" wrote:
>|||Hi
You would need to consult your softwaer vendor, but if you install the SQL
Server Engine on this node I expect it will be the normal cost of an active
node.
John
"DXC" wrote:
[vbcol=seagreen]
> Thanks John. How about the licensing issue ?
>
> "John Bell" wrote:
>|||Thanks............
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You would need to consult your softwaer vendor, but if you install the SQL
> Server Engine on this node I expect it will be the normal cost of an activ
e
> node.
> John
> "DXC" wrote:
>
Subscribe to:
Posts (Atom)