Solved

sql server error

Posted on 2010-08-13
13
249 Views
Last Modified: 2012-06-21
I am basically facing saperate problems here. Both of the problem shave been triggered by supposedly one event. The computer is on active directory domain and when SQL server was installed on the system, there was a different user using the system. Now that user has been deleted from the domain and a new user is using the system.

Since the new user is created, SQL server started acting crazy. It gives 2 separate kind of errors on 2 separate events.

1. When I try to connect to the local instance, it gives error which says "Login failed for user kde\opusonecorp ( that is my current user on the domain)

2. This may be completely different thing but started showing up since the new user is created. This occurs when i try to connect my local SSMS to a remote instance, it says "Unable to cast COM object of type "system._comobject to interface type "Microsoft.VisualStudio.OLE.interop.Iserviceprovider" call on COM interface failed due to the following error:No such interface supported"

I am not sure whether there is any relationship between these two errors but they started showing up at the same time after en event occured, i just wanted to give you all the pieces of this puzzle.

Is there anything that anyone can suggest?
0
Comment
Question by:TheCommunicator
  • 8
  • 3
  • 2
13 Comments
 
LVL 12

Accepted Solution

by:
NormanMaina earned 300 total points
ID: 33432602
1)Problem number one is because the new users account is not setup on SQl Server

The below link has simple instructions on how to do that.

http://msdn.microsoft.com/en-us/library/aa337562.aspx

2)Seems teh dll is not registered properly.There are two things you can do here:

(a)unregister and then register the dll
 C:\windows\system32 > regsvr32.exe /u actxprxy.dll

then register it again C:\windows\system32 > regsvr32.exe actxprxy.dll

if that does not work;

(b) It seems that the IServiceProvider COM object is not registered on the system. Export the below registry entries.

[Copy from HERE]
Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}]
@="IServiceProvider"

[HKEY_CLASSES_ROOT\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\NumMethods]
@="4"

[HKEY_CLASSES_ROOT\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\ProxyStubClsid32]
@="{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}"

[HKEY_CURRENT_USER\Software\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}]
@="IServiceProvider"

[HKEY_CURRENT_USER\Software\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\NumMethods]
@="4"

[HKEY_CURRENT_USER\Software\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\ProxyStubClsid32]
@="{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}]
@="IServiceProvider"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\NumMethods]
@="4"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\ProxyStubClsid32]
@="{B8DA6310-E19B-11D0-933C-00A0C90DCAA9}"
[ ... TO HERE]

Then merge with your registry.
0
 

Author Comment

by:TheCommunicator
ID: 33432760
Hi,

I am trying to troubleshoot the issue number one by the MS link that you sent me. I have created a new user( which is my domain user) on my local SQl instance. Now, when i try to log on, it gives me following error. please take a look. I am attaching the screen shot

8-13-2010-12-09-01-PM.png
0
 
LVL 12

Assisted Solution

by:NormanMaina
NormanMaina earned 300 total points
ID: 33433117
Ok,you have to enable the tcp/ip protocol on your server..maybe even enable named pipes.

   1.  From the Microsoft SQL Server 2005 -> Configuration Tools, open the 'Microsoft SQL Server Configuration Manager'.
       
   2. Expand ‘SQL Server 2005 Network Configuration’, and then click ‘Protocols for <Instance Name>’.
      <Instance Name> is the name of the instance of Microsoft SQL
       
   3. Right-click ‘TCP/IP’ and then click ‘Enable’. The icon for the protocol will change to show that the protocol is enabled.
   4)restart the sql server service.
0
 

Author Comment

by:TheCommunicator
ID: 33434085
I did that. The same error persisted. Just to make sure. In configuration manager:

Shared memeory: enabled
named pipes: disabled
TCP/IP: enabled
VIA: disabled
0
 

Author Comment

by:TheCommunicator
ID: 33434097
I also tried enabling name pipes. No progress
0
 

Author Comment

by:TheCommunicator
ID: 33434172
I also tried registring and unregistring the DLl as you suggested. and I ended up with following error. I am attaching the snapshot for you to review.

erro4.png
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:TheCommunicator
ID: 33434199
I am sorry for the naive question but just wanted to ask that what does exporting registies mean. Do I have to enter these values to the registry? Or do something else?
0
 
LVL 7

Assisted Solution

by:rmm2001
rmm2001 earned 200 total points
ID: 33434562
Is "local" your server name? If not try putting "localhost" in there
0
 

Author Comment

by:TheCommunicator
ID: 33434690
I tried with localhost and it says that Log on failed. something   has to do with this changed user profile for sure.
0
 
LVL 12

Assisted Solution

by:NormanMaina
NormanMaina earned 300 total points
ID: 33436018
If you have Team Viewer ,give me your id and password i have look....
0
 

Author Comment

by:TheCommunicator
ID: 33441223
This is my company computer and my network guys don't allow me downloading anything without their permissions. That's really a problem
0
 
LVL 7

Assisted Solution

by:rmm2001
rmm2001 earned 200 total points
ID: 33441320
I'm curious  to see if it's jsut ssms that's giving you errors or if it's the server itself...try querying the database in command prompt . type in sqlcmd and put in your use info. so something like

sqlcmd -U username -P password (if you have one) then -S servername\instance name

If everything goes right you should be able to throw commands at it like you do via ssms. if you see a "1>" that's a good sign. Put a query in. then "Go". An then enter.
0
 

Author Comment

by:TheCommunicator
ID: 33448277
I am sorry to give up guys.   But i tried all these things and spent 3 days in my office hours. So I decided to re-install the sql.

I am really sorry for this.  I hope you will understand.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now