MSSQL2005 Express SP2 on Vista Professional does not support Extended SP?

Can you explain please why Extended SP does not work under Vista ?

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6000: )

UAC turned off. MSQSL runs under Administrator account.

Any call of user esp - and SQL server goes to loop.
If I call system esp - all works fine.

If I try to read properties of ESP from Management Studio - I have the same effect - SQL server is in loop.

select object_id('dbo.xp_mylog')

-- works.

EXEC('sp_helpextendedproc ''xp_mylog''')

xp_mylog c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\LogEsp.dll

exec master..xp_mylog

die forever

Konstantin

Hi Konstantin,

Have you enabled extended sprocs? They are disabled by default.

Mike

|||

No I did not. How to do this ? I know how to do in Stanard Edition. But this option not visible in Express edition.

There is a TSQL statement to change it or change it in the registry ?

|||

is any body can halp me ?

|||

Is there is anybody from Microsoft who knows how to enable ESP ?

|||

I guess, this is what Mike means:

Open SAC > ...for features ... Navigate your instance ... OLE Automation > enable

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Extended Stored Procedure is not ActiveX

MSSQL2005 Express SP2 on Vista Professional does not support Extended SP?

Can you explain please why Extended SP does not work under Vista ?

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6000: )

UAC turned off. MSQSL runs under Administrator account.

Any call of user esp - and SQL server goes to loop.
If I call system esp - all works fine.

If I try to read properties of ESP from Management Studio - I have the same effect - SQL server is in loop.

select object_id('dbo.xp_mylog')

-- works.

EXEC('sp_helpextendedproc ''xp_mylog''')

xp_mylog c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\LogEsp.dll

exec master..xp_mylog

die forever

Konstantin

Hi Konstantin,

Have you enabled extended sprocs? They are disabled by default.

Mike

|||

No I did not. How to do this ? I know how to do in Stanard Edition. But this option not visible in Express edition.

There is a TSQL statement to change it or change it in the registry ?

|||

is any body can halp me ?

|||

Is there is anybody from Microsoft who knows how to enable ESP ?

|||

I guess, this is what Mike means:

Open SAC > ...for features ... Navigate your instance ... OLE Automation > enable

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Extended Stored Procedure is not ActiveX

MSSQL2005 Express SP2 on Vista Professional does not support Extended SP?

Can you explain please why Extended SP does not work under Vista ?

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6000: )

UAC turned off. MSQSL runs under Administrator account.

Any call of user esp - and SQL server goes to loop.
If I call system esp - all works fine.

If I try to read properties of ESP from Management Studio - I have the same effect - SQL server is in loop.

select object_id('dbo.xp_mylog')

-- works.

EXEC('sp_helpextendedproc ''xp_mylog''')

xp_mylog c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\LogEsp.dll

exec master..xp_mylog

die forever

Konstantin

Hi Konstantin,

Have you enabled extended sprocs? They are disabled by default.

Mike

|||

No I did not. How to do this ? I know how to do in Stanard Edition. But this option not visible in Express edition.

There is a TSQL statement to change it or change it in the registry ?

|||

is any body can halp me ?

|||

Is there is anybody from Microsoft who knows how to enable ESP ?

|||

I guess, this is what Mike means:

Open SAC > ...for features ... Navigate your instance ... OLE Automation > enable

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Extended Stored Procedure is not ActiveX

MSSQL2005 Express SP2 on Vista Professional does not support Extended SP?

Can you explain please why Extended SP does not work under Vista ?

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6000: )

UAC turned off. MSQSL runs under Administrator account.

Any call of user esp - and SQL server goes to loop.
If I call system esp - all works fine.

If I try to read properties of ESP from Management Studio - I have the same effect - SQL server is in loop.

select object_id('dbo.xp_mylog')

-- works.

EXEC('sp_helpextendedproc ''xp_mylog''')

xp_mylog c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\LogEsp.dll

exec master..xp_mylog

die forever

Konstantin

Hi Konstantin,

Have you enabled extended sprocs? They are disabled by default.

Mike

|||

No I did not. How to do this ? I know how to do in Stanard Edition. But this option not visible in Express edition.

There is a TSQL statement to change it or change it in the registry ?

|||

is any body can halp me ?

|||

Is there is anybody from Microsoft who knows how to enable ESP ?

|||

I guess, this is what Mike means:

Open SAC > ...for features ... Navigate your instance ... OLE Automation > enable

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Extended Stored Procedure is not ActiveX

MSSQL with one or more users

People, can u in few words explain to me which method is better: to use MSSQL own auth system - logins or to use one login for connection and make own auth subsystem?
Of course both methods works but i wanna know pluses and minuses of both methods.

RegardsIt is not a right question to ask it depends on level of security you want to achieve.

In case of a windows authentication:
If I, for example, logged in to my computer and left the room, anyone can stop by and get into the database. But on the other hand you dont have to do anything to get to the database. Users who got rights because they need to use some applications that connect to the database can easily get to the server itself and change any data they want on the back end. Some of them really think that they are very smart and know what they do. Especially when they try to update\delete with no WHERE condition or just do counts on millions of records (this can use up all server resources and stop the server from responding).

In case of a password protection:
If you have password protected login it is harder to get to the server you need to know a password. Also in very secure and protected environments (I work in one) password can be provided through a front end applications where they hashed before actually logging in to SQL Server. So in this case regular user doesnt even know his actual password to get to the server directly and each action of such user can be monitored and recorded.

So in first case it is less secure but much easier.
In second case it is opposite more secure but harder to get to the server.

It is the same as your mail box. Do you want your friends or relatives being able to get to your mail or you would put a password and will protect it from nosy readers.

Hope I answered your question.