I seem to be having a number of problems using managment studio (MS) against my locally installed SQL 2005 Standard Edition. E.g. when I create a default database using MS it says...
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The server could not load DCOM. (Microsoft SQL Server, Error: 7404)
For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=7404&LinkId=20476
However, the hyperlinks are less than helpful. I also get problems doing various maintance work from MS. I don't think its a database engine problem 'cause I can do all the work via TSQL DDL but the interface is so much easier to use (or should be). BTW it's running on XP Pro (firewall problem ).
Can't create databases in Management Studio
MaheshAtchuthan
Finally sorted it out. It was the NVidia client to the motherboards Hardware Firewall that was causing the problem. I had to remove that to get IE7 working and now SQL Server is creating databases!
cgillum
Abhinav Mohan
I am getting all those exact same error messages when creating a database. My IE 7 is working just fine however. Can you tell me what you had to do to disable an nVidia motherboard hardware firewall thing I've never heard of that, it sounds like it is worth a try at this point.
npack@hotmail.com
Golf4Fun
I've also found an Event Log entry but don't know what it's asking me to enable...
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17102
Date: 06/02/2006
Time: 20:12:06
User: N/A
Computer: TITAN
Description:
Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.