Cluster nodes

Hi All,

I've heard in a presentation that the number of supported nodes in a cluster on 64bit system is going to be limited to 4. Can you confirm that?
What about the number of instances? These are the informations that I have:
25 in a cluster (a drive letter is required per cluster group)
50 in a standalone server with Enterprise Edition
16 on the other Edition
Can you confirm as well?

Thanks for your response.
JeromeSQL Server 2005 Enterprise Edition will support as many nodes as the underlying operating system supports .. which is 8 nodes in current versions of Windows (in the editions that support Server Clustering). So the maximum number of nodes is 8, and that's true for both 32-bit and 64-bit.

In SQL Server 2000 32-bit edition the limit is 4 nodes, but the 64-bit edition supports 8 nodes.

Your instance numbers are correct though your number of 25 on a cluster is likely too high: typically you have the drive letters A:, B:, C: already assigned to local drives, so that leaves 23 letters for the cluster groups, and for a shared quorum cluster one more drive letter (Q:?) will be needed for the quorum drive, so that leaves 22. So 22 clustered instances is a more realistic limit, though with an MNS (Majority Node Set) cluster where the quorum info is kept on the local drive of each node you could get 23 clustered instances.

Thanks,

Don|||The maximum instances I have seen on MS SQL 2005 is 16 instances on 4 nodes.

Cluster nodes

Hi All,

I've heard in a presentation that the number of supported nodes in a cluster on 64bit system is going to be limited to 4. Can you confirm that?
What about the number of instances? These are the informations that I have:
25 in a cluster (a drive letter is required per cluster group)
50 in a standalone server with Enterprise Edition
16 on the other Edition
Can you confirm as well?

Thanks for your response.
JeromeSQL Server 2005 Enterprise Edition will support as many nodes as the underlying operating system supports .. which is 8 nodes in current versions of Windows (in the editions that support Server Clustering). So the maximum number of nodes is 8, and that's true for both 32-bit and 64-bit.

In SQL Server 2000 32-bit edition the limit is 4 nodes, but the 64-bit edition supports 8 nodes.

Your instance numbers are correct though your number of 25 on a cluster is likely too high: typically you have the drive letters A:, B:, C: already assigned to local drives, so that leaves 23 letters for the cluster groups, and for a shared quorum cluster one more drive letter (Q:?) will be needed for the quorum drive, so that leaves 22. So 22 clustered instances is a more realistic limit, though with an MNS (Majority Node Set) cluster where the quorum info is kept on the local drive of each node you could get 23 clustered instances.

Thanks,

Don|||The maximum instances I have seen on MS SQL 2005 is 16 instances on 4 nodes.sqlsql

Cluster DR

My production cluster disks are corruptd - i would like to find out how to
restore from backups
I have all system backups and mdf and ldf files of the databases - I would
like to keep the logins, jobs etc
Thanks
Restoring a cluster is almost exactly the same as restoring a stand-alone
SQL Server. The only difference is that when you restire the master
database, the disks have to be online using the cluster tool, but leave the
SQL Server service offline. You then start and stop it in single-user mode
using the command-line. See BOL for details on how to restore a SQL Server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"John Smith" <bukusu@.gmail.com> wrote in message
news:el5gBC7GGHA.532@.TK2MSFTNGP15.phx.gbl...
> My production cluster disks are corruptd - i would like to find out how to
> restore from backups
> I have all system backups and mdf and ldf files of the databases - I would
> like to keep the logins, jobs etc
>
> Thanks
>

ClubSite template + sql server 2005 not cooperating...

I've managed to get the clubsite template from asp.net up and running, sorda (http://www.flysniper.com), I get a system error which I believe is related to the fact that my DB isn't working correctly.

I'm trying to configure it to work with ms sql server 2005 which is running on the same machine as the website.

I've followed the instructions of Scott Gu (http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx)

while trying to run aspnet_regsql.exe I get the following error

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -S XXXXXXXXXX
-U YYYYYYYY -P ZZZZZZZZZ -A all -d flysniper

Start adding the following features:
Membership
Profile
RoleManager
Personalization
SqlWebEventProvider

.................
An error has occurred. Details of the exception:
An error has occurred while establishing a connection to the server. When conne
cting to SQL Server 2005, this failure may be caused by the fact that under the
default settings SQL Server does not allow remote connections. (provider: Named
Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Unable to connect to SQL Server database.

I have tried several different things (shooting in the dark) to resolve this issue, including:

verifing that port 445 is avaliable on the firewall per these directions:http://support.microsoft.com/default.aspx?scid=kb;en-us;839269

configured SQL server 2005 to allow remote connections following these directions:http://support.microsoft.com/kb/914277

with no change in results.

Anything else I should look into?

Thanks in advance,

Mike

I get that message when I forget to start sql server before trying to connect to the website.

|||

LockH - thanks for your response, I have confirmed that the SQL Service is up and running.

UPDATE: I have managed to get the aspnet_regsql.exe to run and the tables are created.

I have tried to set the connection string up correctly: <addname="ClubSiteDB"connectionString="Data Source=StormTrooper\FlySniper;Initial Catalog=FlySniperDev;Persist Security Info=True;User ID=XXXXXXXXXXXXX;Password=YYYYYYYYYYYY;"providerName="System.Data.SqlClient"/>

I think its just a switch somewhere that I'm missing.

I have set up a developer website for testing purposes, please usehttp://dev.flysniper.com/flysniperClubSite to see the actual error.

TIA,

Mike

|||

Did you create the tables in the database on the server, or did you copy the database files from your dev machine?

If you copied the database files onto that machine, did you go into database admin and attach the database files to that server?

|||

The tables were created directly on the server. It's my personal machine so I have direct access to it.

Thanks for you time,

Mike

CLR Stored procedure to access OleDb datasource, how?

I tried to write a CLR stored procedure using C# in SQL 2005 to access an
Access
database.
When I use the OleDbConnection class in System.Data, the procedure throws
SecurityException at runtime.
Output as following:
System.Security.SecurityException: Request for the permission of type
'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.Security.CodeAccessSecurityEngine.Check(Object demand,
StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.OleDb.OleDbConnection.PermissionDemand()
at System.Data.OleDb.OleDbConnectionFactory.PermissionDemand(DbConnection
outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Dbbest.Data.BulkStuff.bulkcopy(String source_oledb_connection_string,
String source_table, String destination_table, Int32 batchSize, Int32
notifyAfter)
The action that failed was:
Demand
The type of the first permission that failed was:
System.Data.OleDb.OleDbPermission
The Zone of the assembly that failed was:
MyComputerWhen you created the assembly did you set the permission set? If not,
then it is SAFE by default and you will not be able ot get to your
access database. You MAY have to go all the way to UNSAFE to get
there, I have not checked.
CREATE ASSEMBLY SQLCLRTest
FROM 'C:\MyDBApp\SQLCLRTest.dll'
WITH PERMISSION_SET = SAFE
SAFE, EXTERNAL_ACCESS, UNSAFE are the options that you have for this.
Steve

CLR Stored procedure to access Ole datasource, how?

I tried to write a CLR stored procedure using C# in SQL 2005 to access an Access
database.

When I use the OleDbConnection class in System.Data, the procedure throws SecurityException at runtime.
Output as following:

System.Security.SecurityException: Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.OleDb.OleDbConnection.PermissionDemand()
at System.Data.OleDb.OleDbConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Dbbest.Data.BulkStuff.bulkcopy(String source_oledb_connection_string, String source_table, String destination_table, Int32 batchSize, Int32 notifyAfter)
The action that failed was:
Demand
The type of the first permission that failed was:
System.Data.OleDb.OleDbPermission
The Zone of the assembly that failed was:
MyComputer

Hello Va1era,

The exception you encountered indicates that the C# assembly containing the stored procedure that you registered has insufficient permissions to create an OleDbConnection object, with respect to the .Net framework Code Access Security (CAS) policies. This probably means that your assembly was registered WITH PERMISSION_SET = SAFE, which is also the default if PERMISSION_SET is unspecified in the CREATE ASSEMBLY DDL statement.

To fix this, you can re-register your assembly WITH PERMISSION_SET = EXTERNAL_ACCESS to gain access to the ADO.Net classes (including OleDbConnection). If you are using Visual Studio, you will have to make this change from SAFE to EXTERNAL_ACCESS in the properties page of your C# database project.

To understand more about the CAS security permission buckets in SQL Server's hosted CLR (SAFE, EXTERNAL_ACCESS and UNSAFE), you can look at this document: http://bordecal.mvps.org/Nicole/SqlClrCas/SqlClrCasSpeculations.htm. Also, here is the MSDN page on CAS and ADO.Net 2.0: http://msdn2.microsoft.com/en-us/library/0x4t63kb.aspx

Hope this helps.

Thanks,
Ravi

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 Function errror cant get to lcoal file system

My users complain that they cant run a CLR function. I am told that it cant get access to the local file system. I do not how to code these so from SSIS is there any way to let the users gain access to this. If this is a permission issue what is the lease privilege that I can configure for this to work?

Thanks
AdminAnupHow are they connecting to SQL Server ? If you are using SQL Server authenitcation, they will use the SQL Server account permissions to access the files, if this one does not have any permissions, they will get a Access denied. The same situation if you are using Windows authentication and the individual users do not have access to the files. Did you try to run the function individually ? Which error do you get there if you try to let it run at a user context (and not probably one with administrative priviledges :-) )

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||it is using sql authentication.

Can you let me know which permission does sql authentication need to execute

and also if i change it to be windows does it need any admin privileges|||If you are using SQL Server Authentication, the SQL Server service account SQL Server is running with, will need to have rights on the accessed files / shares. If you are using Windows authentication, the logged in User wil need to have those rights.

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||Has the CLR assembly been granted EXTERNAL_ACCESS?|||Yes that was it as it was in Safe mode
Thanks

CLR (C#) to SQL Server 2005 System.Decimal mapping

Can someone tell me how are you supposed to map the CLR data type System.Decimal to a SQL server 2005 data type decimal? Maybe decimal(28,0) or what?

I don't think that decimal(28,0) is a good match. While decimal(28,0) seems to be similar, I think that you will be disappointed when you accomplish something like this:

SELECT HorrorsWhatHappened = cast( 123456.898794857 AS decimal(28,0))

HorrorsWhatHappened
123457

You 'should' know the precision/scale, and then map to the same precision/scale.

References:

http://msdn2.microsoft.com/en-us/library/4e5xt97a(VS.80).aspx

Also, from: http://geekswithblogs.net/lorint/Default.aspx

Read down to: Finding the scale in decimal values in .NET

...

So now if you have a pile of decimal numbers and you want to create a new table in SQL to hold all of them, you can find the one with the highest scale, and define that column appropriately when you go to use CREATE TABLE or ALTER TABLE. ...

Clone a SQL Server

We are in the process of upgrading from SQL Server 7 to SQL Server 2000.

Before we do that we want to run our system on our new server in a test environment to iron out any issues which may arrive from the upgrade, and to use for future testing. Is there a way to 'clone' a SQL 7 server onto a 2nd physical machine.

ThanksYou could restore sql7 database on sql2k box and do whatever tests needed.|||Originally posted by oj_n
You could restore sql7 database on sql2k box and do whatever tests needed.

I need to make sure all of the DTS pacjkages go as well.|||Here is a good kb that should help you...

http://support.microsoft.com/?id=314546|||There is a utility called DTSBackup2000 that's available free from SQLDTS.com. It works quite well, though I don't know what impact migrating from 7.0 to 2000 might have.

Regards,

Hugh Scott

Originally posted by GregCrossan
I need to make sure all of the DTS pacjkages go as well.

Clients not installing

Getting this error...
SMS Client Configuration Manager cannot connect to the machine
"ComputerName". The operating system reported error 1314: A required
privilege is not held by the client.
Possible cause: The client is not accessible.
Solution: Verify that the client is connected to the network and that the
SMS Service account or (if specified) the SMS Client Remote Installation
account have the required privileges, as specified in the SMS documentation.
Does the account I specified in Connection Accounts need to have local admin
perms? How can I double check?
Jason
Crap wrong group...sorry.
"JasonMeyer" <jason.meyer@.nospam.isd623.org> wrote in message
news:euwoiFFPFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Getting this error...
> SMS Client Configuration Manager cannot connect to the machine
> "ComputerName". The operating system reported error 1314: A required
> privilege is not held by the client.
> Possible cause: The client is not accessible.
> Solution: Verify that the client is connected to the network and that the
> SMS Service account or (if specified) the SMS Client Remote Installation
> account have the required privileges, as specified in the SMS
> documentation.
> Does the account I specified in Connection Accounts need to have local
> admin perms? How can I double check?
> Jason
>

client connection prblm

i hav just startd working with sql server 2000, i hav two systems, in 1 system i have installed server tools n other i installed client tools, now the prblm when i registrd a server frm client, it detect the server but then unable to connect with server the prblm it gives is invalid login

sever\guest

although i have login wid administrator from both system

plz any1 there to solve my prblm

thanks in advance

You are connecting using Windows credentials. That means you have to be logged in with Windows credentials that are valid on your SQL Server. If you simply logged in under the local administrator account, you will not be able to connect to the remote instance, because the SID of the local administrator account is not valid on any other machine.|||

thanx for reply

but i still doesnt got ur point if u can explain ur answer a bit

|||Local Administrator means that you are an administrator on the single machine that you are logging into. If you are physically logging into the machine with the built in account of Administrator, that means your Windows account is for that machine, only that machine, and no other machine in your entire network will understand what that account is nor will it allow you to access any other resource outside of the machine that you are logged into. If you are going to connect to a SQL Server on a different machine, using Windows credentials, then you MUST be logging into a machine using a domain account that has been granted access to the SQL Server.|||Also for informaton refer to KBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q328306 in this case.