October 15, 2005 at 4:04 am
Hi,
One of my user had installed MS-Project on a Server and connected to MS-SQl Server 2000.
But some how my sql server got currepted and now i cannot connect to sql server . Not even QA.
I opened EM and got this Error:
Error : Snap in creatin failed.
The snap is not created ,it may not be installed properly.
CLSID:{}
Pls guide me through ur experince as it is very urgent.
I dont want to reinstall sql server.
from
Killer
October 16, 2005 at 11:46 pm
What happens when you connect through QA?
If nothing else works, you could try reinstalling just the client tools.
October 17, 2005 at 8:22 pm
Hi,
I got the same error.
I installed the client tools only but now the error is diffrent.
No default instance.
So, i registered the DSO files but stil the same error.
from
Killer
October 18, 2005 at 6:08 am
Are you running Query Analyzer from the same machine that has SQL Server?
If not, 1) has a new firewall been installed? or any changes to an existing firewall?
2) Are you using XP and recently installed SP2 for XP? - this has a builtin firewall and blocks SQL Server.
3) Can you PING the SQL Server computer?
Do you have access to the SQL Server computer? Can you check to see:
1. you still have an account?
2. what port it is listening on?
3. any login errors?
-SQLBill
October 18, 2005 at 8:59 pm
Dear SQLBill,
I am running EM and QA from same machine,no login errors, can ping the server from network machine,
i am using windows 2003 sp1,yes i still have account,
1433 is the port number , no login errors.
from
Killer
October 21, 2005 at 3:52 am
Hi Everyone,
Error : Snap in creatin failed.
The snap is not created ,it may not be installed properly.
CLSID:{}
How to resolve error:
The above error means that
DSO is not working or no longer exists or not supported by sql server.
This happens when anysoftware uses the same dll files used by sql server and been deleted in unstalling that software.
These files are as follows
msmddo80.dll
msmddo.dll
msmdlock.dll
msmdnet.dll
msmdso.rll
just copy these files and the location where they are installed and register them on the server.
and try to restart the slql srever.
Hope this help all of u.
from
Killer
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply