Frustration.. slow performace when editing a DTS

I have tried many things and even the worst case thing which I was trying to avoid i.e. uninstalled MSDE SP3 and Analysis Services and service packs but the problem is still not solved...

Whenever I open a DTS in design view and double click on the link (the line connecting the two) between the source and destination servers the PC goes to sleep and comes back after a long time and then the same problem occurs when I press on the transformation tab...

I know this may sound weird but that really is the case :eek:

Please help :oSounds like the DTS designer can not connect to one of the machines that the Data Transform Task is moving data to and/or from. Check the connection parameters, and make sure you can connect to all of the machines.|||Thanks for the reply.

The source is a MS-SQL server on the LAN while the destination is MSDE SP3 on my box. I have been doing similar data importing related tasks (with the same settings, source, and destination) in the past but never experienced this problem. I can connect to both machines so that part is also covered.

Connection parameters is new for me so can you please guide how to go about checking the connection parameters i.e. from where are these defined and what should be the settings??|||While still trying to solve the problem, I brought up task manager and I have concluded that everytime the problem happens the MMC.EXE process is choking the CPU...

Does this provide any clues?|||Connection parameters is new for me so can you please guide how to go about checking the connection parameters i.e. from where are these defined and what should be the settings??

Just double-click on the connections and check the login, machine name, and database. If all are good, then it is something else.

Frustrated programmer wants to create a SQL server database

SQL server 2000 (developer edition) has been installed and uninstalled
(although it still ran even after it said that it was uninstalled) multiple
times. The "create database" button is grayed out and the wizard doesn't
exist.
Curious, is there a super-secret-special hand-shake/password that I should
be using to make the SQl server enterprise allow me to create a database?
Any help/insight would be greatly appreciated.
Thanks,
--Michael
(Please forgive if I sound ... frustrated. It's been 7 hours of
install/uninstall torment with absolutely no headway since the first install.
I hope this isn't a sign of what the new year is to bring...!!)
Hi Michael
You don't say who you are logging in as or what tools you are using? If you
are a local administrator and log in using windows authentication then you
should be able to create a database. If you are in Enterprise Manager then
you should have the local instance registered, if not check out Books Online
regarding registering an instance in EM. Then you should be able to open the
tree up to see the Database branch under which are the master/model/tempdb
databases etc. Right Click the Database branch and see if you can create a
database from the menu options.
Failing that use Query Analyser and issue a CREATE DATABASE command, the
full syntax is in Books Online.
John
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)
|||No, theres no secret thingy. However, if you have permissions to create
database, try using query analyser and CREATE DATABASE statement. If
statement fails, at least youll get an error and try to find out whats
wrong.
MC
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)

Frustrated programmer wants to create a SQL server database

SQL server 2000 (developer edition) has been installed and uninstalled
(although it still ran even after it said that it was uninstalled) multiple
times. The "create database" button is grayed out and the wizard doesn't
exist.
Curious, is there a super-secret-special hand-shake/password that I should
be using to make the SQl server enterprise allow me to create a database?
Any help/insight would be greatly appreciated.
Thanks,
--Michael
(Please forgive if I sound ... frustrated. It's been 7 hours of
install/uninstall torment with absolutely no headway since the first install
.
I hope this isn't a sign of what the new year is to bring...!!)Hi Michael
You don't say who you are logging in as or what tools you are using? If you
are a local administrator and log in using windows authentication then you
should be able to create a database. If you are in Enterprise Manager then
you should have the local instance registered, if not check out Books Online
regarding registering an instance in EM. Then you should be able to open the
tree up to see the Database branch under which are the master/model/tempdb
databases etc. Right Click the Database branch and see if you can create a
database from the menu options.
Failing that use Query Analyser and issue a CREATE DATABASE command, the
full syntax is in Books Online.
John
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)|||No, theres no secret thingy. However, if you have permissions to create
database, try using query analyser and CREATE DATABASE statement. If
statement fails, at least youll get an error and try to find out whats
wrong.
MC
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)

Frustrated programmer wants to create a SQL server database

SQL server 2000 (developer edition) has been installed and uninstalled
(although it still ran even after it said that it was uninstalled) multiple
times. The "create database" button is grayed out and the wizard doesn't
exist.
Curious, is there a super-secret-special hand-shake/password that I should
be using to make the SQl server enterprise allow me to create a database?
Any help/insight would be greatly appreciated.
Thanks,
--Michael
(Please forgive if I sound ... frustrated. It's been 7 hours of
install/uninstall torment with absolutely no headway since the first install.
I hope this isn't a sign of what the new year is to bring...!!)Hi Michael
You don't say who you are logging in as or what tools you are using? If you
are a local administrator and log in using windows authentication then you
should be able to create a database. If you are in Enterprise Manager then
you should have the local instance registered, if not check out Books Online
regarding registering an instance in EM. Then you should be able to open the
tree up to see the Database branch under which are the master/model/tempdb
databases etc. Right Click the Database branch and see if you can create a
database from the menu options.
Failing that use Query Analyser and issue a CREATE DATABASE command, the
full syntax is in Books Online.
John
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)|||No, theres no secret thingy. However, if you have permissions to create
database, try using query analyser and CREATE DATABASE statement. If
statement fails, at least youll get an error and try to find out whats
wrong.
MC
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)sql