Can't create databases in Management Studio

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?).

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.

|||

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!

|||

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

|||Sure, you need to uninstall the nVidia firewall software.

Can't create databases in Management Studio

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?).

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.

|||

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!

|||

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

|||Sure, you need to uninstall the nVidia firewall software.

cant connect to MSSQL Server Express 2005

Hi,

i have installed MS SQL Server Express 2005 on my local machine. Also the managment Studio. I can connect to the MS SQL Server Express 2005 with my c# programm and with the mangament studio.

I have in Windows/system32 the file ntwdblib.dll version 2000.80.2039.0. The TCP/IP and Ip Protocl are active. But i cant connect with php to the local MS SQL Server Express 2005.

My php code is:

mssql_connect('192.168.0.2,1433', 'martin', '');

I get the return code Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 192.168.0.2,1433 in c:\Inetpub\wwwroot\Projekte\Skripte\mssql_connection.php on line 2

Does anyone know what i made wrong or i have forgotten?

mfg martin

Are you trying to use Windows authentication or SQL Server authentication ? I guess that the user account your are trying to gain access with is not allowed access or can′t be determined (due to the web environment)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hello,

i use Windows authentication and SQL Server authentication. Im trying to get in with my local windows account. But if i use a false account or password i would get an other error from php (false username or so like this).

martin

|||

If you are using make sure that the credential is passed along with the WebServer authentification. If you use WIndows authentication you won′t have to pass a Username nor password as the authentication made without the credentials of the actual user. If the credential (token) cannot be passed through the middletier to the database, then you can not connect. If the used system does not support this, you will have to use SQL Server authentication.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Yeah. Thank you. It works.

cant connect to MSSQL Server Express 2005

Hi,

i have installed MS SQL Server Express 2005 on my local machine. Also the managment Studio. I can connect to the MS SQL Server Express 2005 with my c# programm and with the mangament studio.

I have in Windows/system32 the file ntwdblib.dll version 2000.80.2039.0. The TCP/IP and Ip Protocl are active. But i cant connect with php to the local MS SQL Server Express 2005.

My php code is:

mssql_connect('192.168.0.2,1433', 'martin', '');

I get the return code Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 192.168.0.2,1433 in c:\Inetpub\wwwroot\Projekte\Skripte\mssql_connection.php on line 2

Does anyone know what i made wrong or i have forgotten?

mfg martin

Are you trying to use Windows authentication or SQL Server authentication ? I guess that the user account your are trying to gain access with is not allowed access or can′t be determined (due to the web environment)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hello,

i use Windows authentication and SQL Server authentication. Im trying to get in with my local windows account. But if i use a false account or password i would get an other error from php (false username or so like this).

martin

|||

If you are using make sure that the credential is passed along with the WebServer authentification. If you use WIndows authentication you won′t have to pass a Username nor password as the authentication made without the credentials of the actual user. If the credential (token) cannot be passed through the middletier to the database, then you can not connect. If the used system does not support this, you will have to use SQL Server authentication.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Yeah. Thank you. It works.