Hooking old apps to SQL 2005

We would like to have our old apps talk with SQL 2005. What do I have to do
to make that happen. I have installed the SQL 2005 native client, and
defined an alias to the SQL Server. I still get connection errors so
obviously I have not done enough to set this up, or it can't be done .
Can someone direct me to some documentation or explain how to do this?
Thanks.
BarryNevermind, got it working
"barryfz" <barry@.noemail.noemail> wrote in message
news:u5NWWks7FHA.4076@.tk2msftngp13.phx.gbl...
> We would like to have our old apps talk with SQL 2005. What do I have to
> do to make that happen. I have installed the SQL 2005 native client, and
> defined an alias to the SQL Server. I still get connection errors so
> obviously I have not done enough to set this up, or it can't be done .
> Can someone direct me to some documentation or explain how to do this?
> Thanks.
> --
> Barry
>|||Would you be willing to post the results so we can see how you did it?
--
burt_king@.yahoo.com
"barryfz" wrote:

> Nevermind, got it working
>
> "barryfz" <barry@.noemail.noemail> wrote in message
> news:u5NWWks7FHA.4076@.tk2msftngp13.phx.gbl...
>
>

Higher Level Edition Error Message

Hello all,

I just installed the June CTP Client Tools on a fresh hard drive (no previous CTPs installed). I am trying to run a package that was written in the April CTP and runs successfully on other computers with the June CTP installed.

When I run the package, it fails on an 'Execute Package Task', and I get the error message:
"The task cannot run on this edition of Integration Services. It requires a higher level edition."

I know the package is okay because it runs on other June CTP computers. Did I miss something in my install? Any suggestions?

Thanks for your time,
Jessica
Did you install SSIS on the PC in question or just tools. If just the tools then that is your problem as you must install SSIS in order to run packages outside of the designer. As a workaround you can set the execute package task to run in process instead of out of process and that will also allow the package to run. We have changed the default from out of process to in process for the next CTP to try and mitigate this issue somewhat, although running outside of the designer still won't work but that is by design.

HTH,|||That was the problem!

Thanks!
Jessica

hiding/password Protecting Enterprise Manager

I have installed SQL 2000 and Enterprise Manager. I have a .Net application
I am developing. I need Enterprise Manager to make data table changes as I
finish my application, but I am afraid my test and final users will use the
Enterprise Manager to change data. I do not want users to change data
without using my application. Can I limit Enterprise Manager or password
protect or block access to other users?
Thanks
Paul DeWitt
Paul DeWitt wrote:
> I have installed SQL 2000 and Enterprise Manager. I have a .Net
> application I am developing. I need Enterprise Manager to make data
> table changes as I finish my application, but I am afraid my test and
> final users will use the Enterprise Manager to change data. I do not
> want users to change data without using my application. Can I limit
> Enterprise Manager or password protect or block access to other users?
> Thanks
> Paul DeWitt
Users can only perform operations that they have security to perform. If
you don't grant access to the tables and use stored procedures to change
and select data, then users logging into the database using any tool
(SQL Enterprise Manager, Query Analyzer, ISQL, OSQL, etc.) will not be
able to change any data unless they call the stored procedures from
those apps. If you do not provide some underlying security in the
database or your users have dbo or admin rights in the database, there
is nothing to prevent them from changing data and nothing you can really
do to stop it, short of encrypting yourself in the application.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Check out application roles (sp_setapprole).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul DeWitt" <PaulDeWitt@.discussions.microsoft.com> wrote in message
news:E0B9510C-7A3A-4EBB-8EA7-A202FC715D1E@.microsoft.com...
>I have installed SQL 2000 and Enterprise Manager. I have a .Net application
> I am developing. I need Enterprise Manager to make data table changes as I
> finish my application, but I am afraid my test and final users will use the
> Enterprise Manager to change data. I do not want users to change data
> without using my application. Can I limit Enterprise Manager or password
> protect or block access to other users?
> Thanks
> Paul DeWitt