Showing posts with label enabled. Show all posts
Showing posts with label enabled. Show all posts

Thursday, March 8, 2012

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

In Sql Statement then it gives me error
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
The configuration option 'clr enabled' does not exist, or it may be an advanced option.
Valid configuration options are:

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

OR

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

In Sql Statement then it gives me error
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
The configuration option 'clr enabled' does not exist, or it may be an advanced option.
Valid configuration options are:

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

OR

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

In Sql Statement then it gives me error
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
The configuration option 'clr enabled' does not exist, or it may be an advanced option.
Valid configuration options are:

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

OR

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

In Sql Statement then it gives me error
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
The configuration option 'clr enabled' does not exist, or it may be an advanced option.
Valid configuration options are:

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

OR

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

In Sql Statement then it gives me error
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
The configuration option 'clr enabled' does not exist, or it may be an advanced option.
Valid configuration options are:

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

OR

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

In Sql Statement then it gives me error
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
The configuration option 'clr enabled' does not exist, or it may be an advanced option.
Valid configuration options are:

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

OR

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

In Sql Statement then it gives me error
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
The configuration option 'clr enabled' does not exist, or it may be an advanced option.
Valid configuration options are:

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

OR

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Integration in SQL Server (Problem in "sp_configure ''clr enabled'', 1")

HIiiiiiii all

I have installed both sql server 2000 and sql server 2005 Developer Edition in my system as well as .net 2003 and 2005. Now i want to enable clr integration in sql server 2005. so when i write

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

In Sql Statement then it gives me error
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
The configuration option 'clr enabled' does not exist, or it may be an advanced option.
Valid configuration options are:

I have created a database user which have all the rights and roles. and while i check the stored system procedure sp_configure it is affacting mainly two system tables in the master tables

master.dbo.spt_values
master.dbo.sysconfigures
and this table does not contains field like ''clr enabled'' so tht we can change the state

so plz plz help me to enable clr in the sql server 2005.
I need it so muchhh...

Thanking you in advance

Try enabling the 'advanced options' before you enable clr

sp_configure 'show advanced options', 1

OR

Use the surface area configuration manager to 'Enable CLR Integration'

Programs->Microsoft SQL Server ->Config tools->Surface Area Config Mgr.

|||

Hiiiii

I have also tried the enabling advance option using this script

EXEC sp_configure 'show advanced options', 1 -- make them available

reconfigure

EXEC sp_configure 'clr enabled', 1 -- turn on OLE

reconfigure

EXEC sp_configure -- to see the new value

EXEC sp_configure 'show advanced options', 0 -- make them unavailable

reconfigure

but this script also gives me error like this

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

The configuration option 'clr enabled' does not exist, or it may be an advanced option.

Valid configuration options are:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

and i dont know much about surface area config mgr but i think it is for remote database or wht

Plz help me i need this urgently and

thnxxxxx again.......

|||

Surface Area Config Mgr. is the easiest way to do it.

Open up Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

Click on the 'Surface Area Configurations for Features' link at the bottom of the dialog to bring up next dialog.

In this second dialog, in the left pane select 'View by instance' tab. It shows you a tree view, something like

- MSSQLSERVER

- Database Engine

Ad Hoc Remote Queries

CLR Integration

DAC

...

Choose MSSQLSERVER/Database Engine/CLR Integration

Check the 'Enable CLR Integration' in the right pane and say 'OK'.

Hopefully this should set you up.

|||

Hiiiiiiiii

I have set up this sucessfully

Really this is easyest way to do this

thnxxxxxxx a lot

and how do i check tht my clr confitration is enabled or not

because when i write query like this

exec sp_configure 'show advance options'

then this again executes with the previous err....

thnx a lot

|||

select [value_in_use] from sys.configurations where name = 'clr enabled'

|||

Hi,

I don't see CLR Integration and all that you have listed above. I did an upgrade from SQL 2000 to 2005. Have I missed out something during the installation?

Thanks in advance,

APUK

|||

Hi,

I re-installed SQL 2005 with upgrade option and got those options.

Thanks,

APUK

CLR Enabled

Can anyone tell me what this means and how to fix it? I created a stored procedure in VS2005 and did a build. When I went to SQL Server there was the stored procedure but when I run it I get the error....

Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option

I changed the 'clr enabled' property to 1 using sp_configure but I still get this error.

Thanks
Mike

Hi.

You need to run RECONFIGURE.

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go|||Thank you again Gorm!|||

Gorm Braarvig wrote:

Hi.

You need to run RECONFIGURE.

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go

Hi!

I'm having the same problem. I'm just wondrin what that 'something' is. Is that a placeholder of some sort? What can be the values for that?I really need a working command using that 'something'. Thanks.|||That 'something' is the value you want to change through sp_configure. In the case of enabling CLR, it is 'clr enabled'. The full code for this is:

sp_configure 'clr enabled', 1
go
reconfigure
go

The reconfigure is important, and it has to be done in a separate batch, therefore the go between the sp_configure and reconfigure.

Also, you can change this as well (together with other stuff) through the SQL Server Surface Area Consiguration tool (SAC). Go to Start | SQL Server | Configuration Tools and you'll find it. (The names are from memory and not correct - but you'll know what I mean).

Niels
|||

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go

'something' is a placeholder, yes. To see all possible configurable options you might try

-- sp_configure test

sp_configure 'show advanced options', 1

go

RECONFIGURE

go

sp_configure

go

-- EO sp_configure test

This should list everything you can replace 'something' with.

I guess that most of what you are supposed to turn on or off is available in GUIs too. I usually guess wrong, though.


Hope this helps.

|||I've done everything you suggested guys. I even verified it in the Surface Area Configuration. Still no luck.

The sproc works using sqlcmd. Is this a normal behavior?|||

vanni wrote:

I've done everything you suggested guys. I even verified it in the Surface Area Configuration. Still no luck.

The sproc works using sqlcmd. Is this a normal behavior?


Hmm, are you saying that you can execute the SQLCLR proc from sqlcmd but not from somewhere else? If that's the case; where can you not execute the proc from, and what is the error. If the error is that the CLR is not enabled I'd say that you are not executing against the same server instance as you do when executing using sqlcmd.

Niels
|||I only have 1 instance of SQLEXPRESS, with instance name 'SQLExpress'.Sad|||

Are you perhaps running a user instance as well? If so, you'll need to enable CLR integration in the user instance separately from the main instance.

|||

Hi Nicole! This is something new. How should I know that I'm using a User's intance? Btw, the db i'm using is local, found within the project's folder. Does this have any bearing on my problem?

|||If your connection string contains "User Instance = true", then you're using a user instance.|||

I'm indeed using user instance. I only enabled CLR integration on the main instance. My problem is how to enable it in the user instance. Is there a way to do so on the fly in my C# app?

|||

Just issue the same series of T-SQL statements (already covered earlier in this thread) that you would use to enable CLR use in a standard instance. Using ADO.NET, this can be accomplished by setting the CommandText property of a SqlCommand instance to the desired T-SQL statement, then calling the ExecuteNonQuery method of the SqlCommand.

|||

This works very well!

But if I change the .Net application, adds new methods etc. how do I tell the MS SQL Server about the new features, without dropping and adding the assembly?

CLR Enabled

Can anyone tell me what this means and how to fix it? I created a stored procedure in VS2005 and did a build. When I went to SQL Server there was the stored procedure but when I run it I get the error....

Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option

I changed the 'clr enabled' property to 1 using sp_configure but I still get this error.

Thanks
Mike

Hi.

You need to run RECONFIGURE.

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go|||Thank you again Gorm!|||

Gorm Braarvig wrote:

Hi.

You need to run RECONFIGURE.

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go

Hi!

I'm having the same problem. I'm just wondrin what that 'something' is. Is that a placeholder of some sort? What can be the values for that?I really need a working command using that 'something'. Thanks.|||That 'something' is the value you want to change through sp_configure. In the case of enabling CLR, it is 'clr enabled'. The full code for this is:

sp_configure 'clr enabled', 1
go
reconfigure
go

The reconfigure is important, and it has to be done in a separate batch, therefore the go between the sp_configure and reconfigure.

Also, you can change this as well (together with other stuff) through the SQL Server Surface Area Consiguration tool (SAC). Go to Start | SQL Server | Configuration Tools and you'll find it. (The names are from memory and not correct - but you'll know what I mean).

Niels|||

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go

'something' is a placeholder, yes. To see all possible configurable options you might try

-- sp_configure test

sp_configure 'show advanced options', 1

go

RECONFIGURE

go

sp_configure

go

-- EO sp_configure test

This should list everything you can replace 'something' with.

I guess that most of what you are supposed to turn on or off is available in GUIs too. I usually guess wrong, though.


Hope this helps.

|||I've done everything you suggested guys. I even verified it in the Surface Area Configuration. Still no luck.

The sproc works using sqlcmd. Is this a normal behavior?|||

vanni wrote:

I've done everything you suggested guys. I even verified it in the Surface Area Configuration. Still no luck.

The sproc works using sqlcmd. Is this a normal behavior?


Hmm, are you saying that you can execute the SQLCLR proc from sqlcmd but not from somewhere else? If that's the case; where can you not execute the proc from, and what is the error. If the error is that the CLR is not enabled I'd say that you are not executing against the same server instance as you do when executing using sqlcmd.

Niels|||I only have 1 instance of SQLEXPRESS, with instance name 'SQLExpress'.Sad|||

Are you perhaps running a user instance as well? If so, you'll need to enable CLR integration in the user instance separately from the main instance.

|||

Hi Nicole! This is something new. How should I know that I'm using a User's intance? Btw, the db i'm using is local, found within the project's folder. Does this have any bearing on my problem?

|||If your connection string contains "User Instance = true", then you're using a user instance.|||

I'm indeed using user instance. I only enabled CLR integration on the main instance. My problem is how to enable it in the user instance. Is there a way to do so on the fly in my C# app?

|||

Just issue the same series of T-SQL statements (already covered earlier in this thread) that you would use to enable CLR use in a standard instance. Using ADO.NET, this can be accomplished by setting the CommandText property of a SqlCommand instance to the desired T-SQL statement, then calling the ExecuteNonQuery method of the SqlCommand.

|||

This works very well!

But if I change the .Net application, adds new methods etc. how do I tell the MS SQL Server about the new features, without dropping and adding the assembly?

CLR Enabled

Can anyone tell me what this means and how to fix it? I created a stored procedure in VS2005 and did a build. When I went to SQL Server there was the stored procedure but when I run it I get the error....

Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option

I changed the 'clr enabled' property to 1 using sp_configure but I still get this error.

Thanks
Mike

Hi.

You need to run RECONFIGURE.

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go|||Thank you again Gorm!|||

Gorm Braarvig wrote:

Hi.

You need to run RECONFIGURE.

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go

Hi!

I'm having the same problem. I'm just wondrin what that 'something' is. Is that a placeholder of some sort? What can be the values for that?I really need a working command using that 'something'. Thanks.|||That 'something' is the value you want to change through sp_configure. In the case of enabling CLR, it is 'clr enabled'. The full code for this is:

sp_configure 'clr enabled', 1
go
reconfigure
go

The reconfigure is important, and it has to be done in a separate batch, therefore the go between the sp_configure and reconfigure.

Also, you can change this as well (together with other stuff) through the SQL Server Surface Area Consiguration tool (SAC). Go to Start | SQL Server | Configuration Tools and you'll find it. (The names are from memory and not correct - but you'll know what I mean).

Niels
|||

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go

'something' is a placeholder, yes. To see all possible configurable options you might try

-- sp_configure test

sp_configure 'show advanced options', 1

go

RECONFIGURE

go

sp_configure

go

-- EO sp_configure test

This should list everything you can replace 'something' with.

I guess that most of what you are supposed to turn on or off is available in GUIs too. I usually guess wrong, though.


Hope this helps.

|||I've done everything you suggested guys. I even verified it in the Surface Area Configuration. Still no luck.

The sproc works using sqlcmd. Is this a normal behavior?|||

vanni wrote:

I've done everything you suggested guys. I even verified it in the Surface Area Configuration. Still no luck.

The sproc works using sqlcmd. Is this a normal behavior?


Hmm, are you saying that you can execute the SQLCLR proc from sqlcmd but not from somewhere else? If that's the case; where can you not execute the proc from, and what is the error. If the error is that the CLR is not enabled I'd say that you are not executing against the same server instance as you do when executing using sqlcmd.

Niels
|||I only have 1 instance of SQLEXPRESS, with instance name 'SQLExpress'.Sad|||

Are you perhaps running a user instance as well? If so, you'll need to enable CLR integration in the user instance separately from the main instance.

|||

Hi Nicole! This is something new. How should I know that I'm using a User's intance? Btw, the db i'm using is local, found within the project's folder. Does this have any bearing on my problem?

|||If your connection string contains "User Instance = true", then you're using a user instance.|||

I'm indeed using user instance. I only enabled CLR integration on the main instance. My problem is how to enable it in the user instance. Is there a way to do so on the fly in my C# app?

|||

Just issue the same series of T-SQL statements (already covered earlier in this thread) that you would use to enable CLR use in a standard instance. Using ADO.NET, this can be accomplished by setting the CommandText property of a SqlCommand instance to the desired T-SQL statement, then calling the ExecuteNonQuery method of the SqlCommand.

|||

This works very well!

But if I change the .Net application, adds new methods etc. how do I tell the MS SQL Server about the new features, without dropping and adding the assembly?

CLR Enabled

Can anyone tell me what this means and how to fix it? I created a stored procedure in VS2005 and did a build. When I went to SQL Server there was the stored procedure but when I run it I get the error....

Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option

I changed the 'clr enabled' property to 1 using sp_configure but I still get this error.

Thanks
Mike

Hi.

You need to run RECONFIGURE.

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go|||Thank you again Gorm!|||

Gorm Braarvig wrote:

Hi.

You need to run RECONFIGURE.

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go

Hi!

I'm having the same problem. I'm just wondrin what that 'something' is. Is that a placeholder of some sort? What can be the values for that?I really need a working command using that 'something'. Thanks.|||That 'something' is the value you want to change through sp_configure. In the case of enabling CLR, it is 'clr enabled'. The full code for this is:

sp_configure 'clr enabled', 1
go
reconfigure
go

The reconfigure is important, and it has to be done in a separate batch, therefore the go between the sp_configure and reconfigure.

Also, you can change this as well (together with other stuff) through the SQL Server Surface Area Consiguration tool (SAC). Go to Start | SQL Server | Configuration Tools and you'll find it. (The names are from memory and not correct - but you'll know what I mean).

Niels
|||

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go

'something' is a placeholder, yes. To see all possible configurable options you might try

-- sp_configure test

sp_configure 'show advanced options', 1

go

RECONFIGURE

go

sp_configure

go

-- EO sp_configure test

This should list everything you can replace 'something' with.

I guess that most of what you are supposed to turn on or off is available in GUIs too. I usually guess wrong, though.


Hope this helps.

|||I've done everything you suggested guys. I even verified it in the Surface Area Configuration. Still no luck.

The sproc works using sqlcmd. Is this a normal behavior?|||

vanni wrote:

I've done everything you suggested guys. I even verified it in the Surface Area Configuration. Still no luck.

The sproc works using sqlcmd. Is this a normal behavior?


Hmm, are you saying that you can execute the SQLCLR proc from sqlcmd but not from somewhere else? If that's the case; where can you not execute the proc from, and what is the error. If the error is that the CLR is not enabled I'd say that you are not executing against the same server instance as you do when executing using sqlcmd.

Niels
|||I only have 1 instance of SQLEXPRESS, with instance name 'SQLExpress'.Sad|||

Are you perhaps running a user instance as well? If so, you'll need to enable CLR integration in the user instance separately from the main instance.

|||

Hi Nicole! This is something new. How should I know that I'm using a User's intance? Btw, the db i'm using is local, found within the project's folder. Does this have any bearing on my problem?

|||If your connection string contains "User Instance = true", then you're using a user instance.|||

I'm indeed using user instance. I only enabled CLR integration on the main instance. My problem is how to enable it in the user instance. Is there a way to do so on the fly in my C# app?

|||

Just issue the same series of T-SQL statements (already covered earlier in this thread) that you would use to enable CLR use in a standard instance. Using ADO.NET, this can be accomplished by setting the CommandText property of a SqlCommand instance to the desired T-SQL statement, then calling the ExecuteNonQuery method of the SqlCommand.

|||

This works very well!

But if I change the .Net application, adds new methods etc. how do I tell the MS SQL Server about the new features, without dropping and adding the assembly?

CLR Enabled

Can anyone tell me what this means and how to fix it? I created a stored procedure in VS2005 and did a build. When I went to SQL Server there was the stored procedure but when I run it I get the error....

Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option

I changed the 'clr enabled' property to 1 using sp_configure but I still get this error.

Thanks
Mike

Hi.

You need to run RECONFIGURE.

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go|||Thank you again Gorm!|||

Gorm Braarvig wrote:

Hi.

You need to run RECONFIGURE.

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go

Hi!

I'm having the same problem. I'm just wondrin what that 'something' is. Is that a placeholder of some sort? What can be the values for that?I really need a working command using that 'something'. Thanks.|||That 'something' is the value you want to change through sp_configure. In the case of enabling CLR, it is 'clr enabled'. The full code for this is:

sp_configure 'clr enabled', 1
go
reconfigure
go

The reconfigure is important, and it has to be done in a separate batch, therefore the go between the sp_configure and reconfigure.

Also, you can change this as well (together with other stuff) through the SQL Server Surface Area Consiguration tool (SAC). Go to Start | SQL Server | Configuration Tools and you'll find it. (The names are from memory and not correct - but you'll know what I mean).

Niels|||

sp_configure 'something', value
go
RECONFIGURE
go
sp_configure 'something'
go

'something' is a placeholder, yes. To see all possible configurable options you might try

-- sp_configure test

sp_configure 'show advanced options', 1

go

RECONFIGURE

go

sp_configure

go

-- EO sp_configure test

This should list everything you can replace 'something' with.

I guess that most of what you are supposed to turn on or off is available in GUIs too. I usually guess wrong, though.


Hope this helps.

|||I've done everything you suggested guys. I even verified it in the Surface Area Configuration. Still no luck.

The sproc works using sqlcmd. Is this a normal behavior?|||

vanni wrote:

I've done everything you suggested guys. I even verified it in the Surface Area Configuration. Still no luck.

The sproc works using sqlcmd. Is this a normal behavior?


Hmm, are you saying that you can execute the SQLCLR proc from sqlcmd but not from somewhere else? If that's the case; where can you not execute the proc from, and what is the error. If the error is that the CLR is not enabled I'd say that you are not executing against the same server instance as you do when executing using sqlcmd.

Niels|||I only have 1 instance of SQLEXPRESS, with instance name 'SQLExpress'.Sad|||

Are you perhaps running a user instance as well? If so, you'll need to enable CLR integration in the user instance separately from the main instance.

|||

Hi Nicole! This is something new. How should I know that I'm using a User's intance? Btw, the db i'm using is local, found within the project's folder. Does this have any bearing on my problem?

|||If your connection string contains "User Instance = true", then you're using a user instance.|||

I'm indeed using user instance. I only enabled CLR integration on the main instance. My problem is how to enable it in the user instance. Is there a way to do so on the fly in my C# app?

|||

Just issue the same series of T-SQL statements (already covered earlier in this thread) that you would use to enable CLR use in a standard instance. Using ADO.NET, this can be accomplished by setting the CommandText property of a SqlCommand instance to the desired T-SQL statement, then calling the ExecuteNonQuery method of the SqlCommand.

|||

This works very well!

But if I change the .Net application, adds new methods etc. how do I tell the MS SQL Server about the new features, without dropping and adding the assembly?

Sunday, February 19, 2012

Client Side Redirect - Database Mirroring

Hi All,

My apologies if this question seems abit basic, but I'm a DBA by trade and programming .Net isn't my strong point ;)

I've enabled database mirroring on 3 SQL 2005 servers, a principal, a mirror and a witness.

Principal - SQL 2005 Enterprise Edition, SP1

Mirror - SQL 2005 Enterprise Edition, SP1

Witness - SQL 2005 Express, SP1

I've written some test code to test the mirroring but as soon as the connection is pulled from the principal, the client re-direct doesn't work and the program bombs. I'd be grateful fi someone could have a look at my code below and tell me if there's any schoolboy errors?

(NB, the user running the code is a sys admin on all 3 servers)

Thanks in advance.

Imports System.Data.SqlClient

Public Class Form1

Dim DCTADS As New SqlClient.SqlConnection

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

DCTADS.ConnectionString = "Network=dbmssocn; Server=STUD; Failover Partner=DBDRTEST; Database=mirrortest; Integrated Security=True"

DCTADS.Open()

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim cmd As New SqlClient.SqlCommand

cmd.CommandText = "Select fulldesc from unclproduct where internal = '20000110'"

cmd.Connection = DCTADS

Dim dr As SqlClient.SqlDataReader

dr = cmd.ExecuteReader

MsgBox(DCTADS.DataSource.ToString)

If dr.Read Then

MsgBox(dr("fulldesc").ToString)

End If

dr.Close()

End Sub

End Class

Here is more detailed discussion for client redirect (http://msdn2.microsoft.com/en-us/library/ms366348.aspx). From the code I did not see any problem. One thing to check is to make sure the TCP/IP and "allow remote connection" are enabled on both principal and mirror because by default these two settings are disable after SQL server is installed.

Sunday, February 12, 2012

Client cannot access SQL 2005 Express Server

I've installed SQL 2005 Express, enabled local and Remote connections but my client app cannot connect to the SQL server. I'm getting access denied or SQL does not exists. Any idea's on how to resolve this issue?

Perhaps these articles will help:

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html