Cannot Edit Jobs

Two days back we have installed SP2 on SQLServer2005 Active/Active Cluster which result in failure.

Only Database Services and Analysis Services where not updated and rest of the services got updated.

After a restart , the behaviour of SQLServer is helarious.

We got into lot of problem so we opened support from Microsoft.

One of the problem i forgot to mentioed to Microsoft was on editing the Job i cannot see anything inside,all the entries where empty closing the job window and opening it again i got all my entries back but on editing i got the below mentioned Error.

Error:

Creating an instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory failed due to the following error:c001f011(Microsoft.SqlServer.ManagedDTS)

If anyone faced the same problem and got any resolution please let me know.

Anyhelp will be appriciated.

Solved the Error.

In one of the artical i read tht after installation of SP2 few of the DLL left unregistered.

Registered the DTS.DLL and it work like charm.

"C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll"

Hope this help to others.

sql

Cannot connect to Sql Server 2005 Express. Any idea why ?

Hi everybody
I have a system with :
WinXP Pro, MSDE 2000, Framework 2.0 beta. On top of it i installed SqlServer
2005 Beta with Mixed Mode. I am using Query Analyzer and Enterperise Manager
from SQLServer 2000 to connect to it (manual says I can) but with no
success. I tried to log on with windows authentication as well as with Sql
authentication . I tried the following names to connect :
(local)\SQLEXPRESS; COMP_NAME\SQLEXPRESS; SQLEXPRESS; MSSQL$SQLEXPRESS and
so on but never got connected. It always say that the
SQL Server does not exist or Access denied.
I checked in the services where it is set to automatic and is running. I
also stopped and restarted but with no success. What i am missing ?
At the end I uninstalled everything and reinstalled only Framework 2.0 and
Sql Server 2005 Beta but having the same problem.
Anyone know how to fix this ?
Thanks in advance
Raja
hi, Raja,
"Ing. Rajesh Kumar" <iambad(Without This)@.post.cz> ha scritto nel messaggio
news:OFSx33CcEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi everybody
> I have a system with :
> WinXP Pro, MSDE 2000, Framework 2.0 beta. On top of it i installed
SqlServer
> 2005 Beta with Mixed Mode. I am using Query Analyzer and Enterperise
Manager
> from SQLServer 2000 to connect to it (manual says I can) but with no
> success. I tried to log on with windows authentication as well as with Sql
> authentication . I tried the following names to connect :
> (local)\SQLEXPRESS; COMP_NAME\SQLEXPRESS; SQLEXPRESS; MSSQL$SQLEXPRESS and
> so on but never got connected. It always say that the
> SQL Server does not exist or Access denied.
> I checked in the services where it is set to automatic and is running. I
> also stopped and restarted but with no success. What i am missing ?
> At the end I uninstalled everything and reinstalled only Framework 2.0 and
> Sql Server 2005 Beta but having the same problem.
frorm microsoft.private.sqlserver2005.express newsgroup:
1. Enable Protocols
a. Launch SQL Computer Manager
b. Expand "Server Network Configuration"
c. Expand Protocols for "SQLEXPRESS"
d. Enable Np (for local access)
e. Enable TCP (for remote access)
2. Restart SQL Express
a. can be done from either SQL Computer Manager, Services applet, or
command line
3. Start SQL Browser service from Service applet or command line
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply