Run-time error (R6009)

I installed a program that put Microsoft SQL Server on my system, Windows XP. The next day I tried to load a MSDOS Database program, Nutplus (Ultrapls), now I get a Run-Time error, R6009. The program will not load. Please help!!!!!, Thank you in advance.This seems to be a third party application and if your query is not related to SQL Server then approach vendor for suitable fix.

Running SSIS Packages in Management Studio

We are using SQL Server 2005 Standard edition.We have the development studio installed on a developer’s workstation.The SSIS package is accessing network folders using UNC and the tasks in packages are accessing SQL Server with a SQL Server id.

The SSIS package runs fine on the workstation. We deploy the SSIS package as a SSIS store on SQL Server.I receive Error 18456 Severity 14 State 8 error when I run the SSIS package as a SQL Agent job.

When I run the SSIS package from the Integration Services Management Studio, I get The AcquireConnection method call to the connection manager "dboSQLabm" failed with error code 0xC0202009.

I’m sure this is a permission based problem since it runs fine on my workstation.I tried logon onto the SQL Server with my id (I’m an admin to the server).I tried running the agent with my windows id.It looks like I’m getting problem connecting to the SQL Server tables since the logs are properly written to the network drive.

In SQL DTS 2000, all we needed to do was give the SQL agent id permission to the network folder. I tried to search the forums, but none of the solutions seem to work for my situation.

Do you use config files and do not save sensitive? This should take care of this issue.

There are quite a few posts about it in this forum

Philippe

|||The problem I was getting occurred whether I used a config file or not. I had the package set to EncryptSensitiveWithUserKey. I created another thread to get production deployment suggestions. We don't want our DBAs using BIDS to edit SQL connection manager settings when they migrate SSIS packages to production.|||

Then don't let them. Use configurations and the deployment wizard.

-Jamie

Running SqlAgent on a different processor

I have a machine with dual processor installed. I want sqlagent to be run on
the second processor while my normal queries run on the first processor is i
t
viable"Genius" <Genius@.discussions.microsoft.com> wrote in message
news:2D2F162B-F706-46BE-85E2-63D3BA9AF516@.microsoft.com...
> I have a machine with dual processor installed. I want sqlagent to be run
on
> the second processor while my normal queries run on the first processor is
it
> viable
>
As far as I know this is not possible... in almost every instance you're
better off letting the server OS manage the use context switching of
multi-processor machines.
Steve|||All the Whitepaper studies I've seen show this to be true: that the OS is
far more capable of handling the scheduling work through the SMP processors
than attempting to manually affinitizing the process yourself.
That being said, yes you can affinitize processes. You can manually set the
process affinity to a currently running executable through task manager. If
you want this to be permanent, you must create a registry key in the
Services Key for that process. There is a tool you can download from
Microsoft that will handle the details for you. Search for Process Affinity
to find it.
Sincerely,
Anthony Thomas
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:O896ydn8EHA.208@.TK2MSFTNGP12.phx.gbl...
"Genius" <Genius@.discussions.microsoft.com> wrote in message
news:2D2F162B-F706-46BE-85E2-63D3BA9AF516@.microsoft.com...
> I have a machine with dual processor installed. I want sqlagent to be run
on
> the second processor while my normal queries run on the first processor is
it
> viable
>
As far as I know this is not possible... in almost every instance you're
better off letting the server OS manage the use context switching of
multi-processor machines.
Steve

Running SqlAgent on a different processor

I have a machine with dual processor installed. I want sqlagent to be run on
the second processor while my normal queries run on the first processor is it
viable
"Genius" <Genius@.discussions.microsoft.com> wrote in message
news:2D2F162B-F706-46BE-85E2-63D3BA9AF516@.microsoft.com...
> I have a machine with dual processor installed. I want sqlagent to be run
on
> the second processor while my normal queries run on the first processor is
it
> viable
>
As far as I know this is not possible... in almost every instance you're
better off letting the server OS manage the use context switching of
multi-processor machines.
Steve
|||All the Whitepaper studies I've seen show this to be true: that the OS is
far more capable of handling the scheduling work through the SMP processors
than attempting to manually affinitizing the process yourself.
That being said, yes you can affinitize processes. You can manually set the
process affinity to a currently running executable through task manager. If
you want this to be permanent, you must create a registry key in the
Services Key for that process. There is a tool you can download from
Microsoft that will handle the details for you. Search for Process Affinity
to find it.
Sincerely,
Anthony Thomas

"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:O896ydn8EHA.208@.TK2MSFTNGP12.phx.gbl...
"Genius" <Genius@.discussions.microsoft.com> wrote in message
news:2D2F162B-F706-46BE-85E2-63D3BA9AF516@.microsoft.com...
> I have a machine with dual processor installed. I want sqlagent to be run
on
> the second processor while my normal queries run on the first processor is
it
> viable
>
As far as I know this is not possible... in almost every instance you're
better off letting the server OS manage the use context switching of
multi-processor machines.
Steve
sql

Running SqlAgent on a different processor

I have a machine with dual processor installed. I want sqlagent to be run on
the second processor while my normal queries run on the first processor is it
viable"Genius" <Genius@.discussions.microsoft.com> wrote in message
news:2D2F162B-F706-46BE-85E2-63D3BA9AF516@.microsoft.com...
> I have a machine with dual processor installed. I want sqlagent to be run
on
> the second processor while my normal queries run on the first processor is
it
> viable
>
As far as I know this is not possible... in almost every instance you're
better off letting the server OS manage the use context switching of
multi-processor machines.
Steve|||All the Whitepaper studies I've seen show this to be true: that the OS is
far more capable of handling the scheduling work through the SMP processors
than attempting to manually affinitizing the process yourself.
That being said, yes you can affinitize processes. You can manually set the
process affinity to a currently running executable through task manager. If
you want this to be permanent, you must create a registry key in the
Services Key for that process. There is a tool you can download from
Microsoft that will handle the details for you. Search for Process Affinity
to find it.
Sincerely,
Anthony Thomas
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:O896ydn8EHA.208@.TK2MSFTNGP12.phx.gbl...
"Genius" <Genius@.discussions.microsoft.com> wrote in message
news:2D2F162B-F706-46BE-85E2-63D3BA9AF516@.microsoft.com...
> I have a machine with dual processor installed. I want sqlagent to be run
on
> the second processor while my normal queries run on the first processor is
it
> viable
>
As far as I know this is not possible... in almost every instance you're
better off letting the server OS manage the use context switching of
multi-processor machines.
Steve

running sql xml versions next to each other?

Hi,
i have installed sql 2005 on my test machine, and it installed sql xml 4.0.
Now i wanted to try running BizTalk 2004 on it, but the install complains i
have to have sql xml 3.0 sp2 or higher...
So the question is, can i install sql xml 3.0sp3 on the machine, without
breaking the 4.0 or the sql 2005 install altogether?
thnx,
J.
Hello,
You should be able to use sqlxml 3.0 and sqlxml 4.0 side by side without
any problem.
Thanks,
Monica Frintu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

running sql xml versions next to each other?

Hi,
i have installed sql 2005 on my test machine, and it installed sql xml 4.0.
Now i wanted to try running BizTalk 2004 on it, but the install complains i
have to have sql xml 3.0 sp2 or higher...
So the question is, can i install sql xml 3.0sp3 on the machine, without
breaking the 4.0 or the sql 2005 install altogether?
thnx,
J.Hello,
You should be able to use sqlxml 3.0 and sqlxml 4.0 side by side without
any problem.
Thanks,
Monica Frintu
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Running SQL Server 2005 Workgroup on SBS 2003 R2

Hi,
We have SBS 2003 R2 installed and fully patched. We are getting a new
product that requires SQL Server 2005 Workgroup. Is there any reason
why SQL Server 2005 Workgroup would not run on SBS 2003 R2? Thanks,
EricIt works perfectly fine. SQL Server 2005 Workgroup Edition comes with
Windows SBS 2003 R2 Premium Edition. Your least expensive approach is to
upgrade your Windows SBS R2 Standard to Premium
"eric" <ericgo123@.gmail.com> wrote in message
news:1191624235.606165.90520@.22g2000hsm.googlegroups.com...
> Hi,
> We have SBS 2003 R2 installed and fully patched. We are getting a new
> product that requires SQL Server 2005 Workgroup. Is there any reason
> why SQL Server 2005 Workgroup would not run on SBS 2003 R2? Thanks,
> Eric
>

Running SQL Server 2000 and 2005 on the same computer

Does anyone know whether or not both versions can be installed on the same machine?I know the September CTP is able to co-exist on a machine with SQL 2000. I can not imagine they will do anything to change that in the RTM.

Running SQL server 2000 & 2005 side by side

Hai

My system is already installed with SQL server 2000 . Is it possible for me to install SQL server 2005 BETA CTP in the same machine and run both side by side.

Regards

I am not sure which CTP you have, since we have RTMed SQL 2005, it would be better if you want to evalute SQL Server to install the full SQL Server 2005 Eval version. Depening on which Beta you have, side-by-side installations may or may not work for you.

|||

hai bob

Thanks for your reply.

How can i check my version supports side by side execution.

Running SQL 7 and 2000 side-by-side

I have two application to be installed on one machine. One requires SQL7 and
the other SQL 2000. Eventually we will get to SQL 2000 for both but not
today. Is there any problems I need to be aware of with this scenario?No, they will compete for memory. Make sure you install SQL 7 first.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"DianeA" <DianeA@.discussions.microsoft.com> wrote in message
news:CB00DA74-555F-40CF-AFB0-686D5A3CA63C@.microsoft.com...
>I have two application to be installed on one machine. One requires SQL7
>and
> the other SQL 2000. Eventually we will get to SQL 2000 for both but not
> today. Is there any problems I need to be aware of with this scenario?

Running SQL 7 and 2000 side-by-side

I have two application to be installed on one machine. One requires SQL7 and
the other SQL 2000. Eventually we will get to SQL 2000 for both but not
today. Is there any problems I need to be aware of with this scenario?
No, they will compete for memory. Make sure you install SQL 7 first.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"DianeA" <DianeA@.discussions.microsoft.com> wrote in message
news:CB00DA74-555F-40CF-AFB0-686D5A3CA63C@.microsoft.com...
>I have two application to be installed on one machine. One requires SQL7
>and
> the other SQL 2000. Eventually we will get to SQL 2000 for both but not
> today. Is there any problems I need to be aware of with this scenario?

Running SQL 7 and 2000 side-by-side

I have two application to be installed on one machine. One requires SQL7 an
d
the other SQL 2000. Eventually we will get to SQL 2000 for both but not
today. Is there any problems I need to be aware of with this scenario?No, they will compete for memory. Make sure you install SQL 7 first.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"DianeA" <DianeA@.discussions.microsoft.com> wrote in message
news:CB00DA74-555F-40CF-AFB0-686D5A3CA63C@.microsoft.com...
>I have two application to be installed on one machine. One requires SQL7
>and
> the other SQL 2000. Eventually we will get to SQL 2000 for both but not
> today. Is there any problems I need to be aware of with this scenario?