Hi,
I realized an active/passive Windows Cluster from two IBM xSeries346 with
Windows 2003 Enterprise Edition SP1 (patched..) and I use like a shared disk
an IBM EXP400 (certified..).
When Active server go down, passive server can't do automatically the
failover, the second server can't see shared disks..
any help?
thank's a lot
andrea
I can't tell you specifically what, but I recently heard of an issue where
teh drive letters for the shared droves were not "configured" correctly in
the SAN utilities.
Does the group go to the passive node and just sit there, or does it fail
back to the original active node? If on the Passive node, can you see the
drive in "My Computer"?
"Andrea Racca" wrote:
> Hi,
> I realized an active/passive Windows Cluster from two IBM xSeries346 with
> Windows 2003 Enterprise Edition SP1 (patched..) and I use like a shared disk
> an IBM EXP400 (certified..).
> When Active server go down, passive server can't do automatically the
> failover, the second server can't see shared disks..
> any help?
> thank's a lot
> andrea
>
>
sqlsql
Showing posts with label edition. Show all posts
Showing posts with label edition. Show all posts
Tuesday, March 27, 2012
Thursday, March 22, 2012
Cluster File Share failed
I have a Windows 2000 Advanced Server with SQL Server 2000
Enterprise Edition with SP3A. The cluster is set up as a
Active/Active cluster.
What would cause the Cluster File Share resource to fail?
I have a file share directory set up so that if my server
fails over the file share directory 'shot_p' will be
recognized on the failover server.
Event Viewer Error:
Cluster File Share resource 'shot_p' has failed a status
check. The error code is 64.
Thanks,
Mike
Sounds like your network name resource failed...
C:\>net helpmsg 64
The specified network name is no longer available.
C:\>
Regards,
John
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:21aef01c45afe$75b27840$a401280a@.phx.gbl...
> I have a Windows 2000 Advanced Server with SQL Server 2000
> Enterprise Edition with SP3A. The cluster is set up as a
> Active/Active cluster.
> What would cause the Cluster File Share resource to fail?
> I have a file share directory set up so that if my server
> fails over the file share directory 'shot_p' will be
> recognized on the failover server.
> Event Viewer Error:
> Cluster File Share resource 'shot_p' has failed a status
> check. The error code is 64.
> Thanks,
> Mike
Enterprise Edition with SP3A. The cluster is set up as a
Active/Active cluster.
What would cause the Cluster File Share resource to fail?
I have a file share directory set up so that if my server
fails over the file share directory 'shot_p' will be
recognized on the failover server.
Event Viewer Error:
Cluster File Share resource 'shot_p' has failed a status
check. The error code is 64.
Thanks,
Mike
Sounds like your network name resource failed...
C:\>net helpmsg 64
The specified network name is no longer available.
C:\>
Regards,
John
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:21aef01c45afe$75b27840$a401280a@.phx.gbl...
> I have a Windows 2000 Advanced Server with SQL Server 2000
> Enterprise Edition with SP3A. The cluster is set up as a
> Active/Active cluster.
> What would cause the Cluster File Share resource to fail?
> I have a file share directory set up so that if my server
> fails over the file share directory 'shot_p' will be
> recognized on the failover server.
> Event Viewer Error:
> Cluster File Share resource 'shot_p' has failed a status
> check. The error code is 64.
> Thanks,
> Mike
Monday, March 19, 2012
cluster
Hello ,
I have couple of questions on clustering as well as on hardware.
1) Is the license for SQL Server 2005 Enterprise edition ( Production) on
active/active and active/passive is same?
2) Is the license for sql server 2005 is socket based or processor based, is
there any differnce between them.
3) Do we have any figures for SQL Server 2005 performance on single socket
as well as dual socket servers ?
4) If we have a active/active cluster on single socket on quad core
processor , what will be the license as well as performance when compared to
the active/active on dual socket on quad processor?
Any input is appreciated?
Comments Inline
"IT" <IT@.discussions.microsoft.com> wrote in message
news:87B5B6CB-413D-4A12-A4D3-59CDAC0C569A@.microsoft.com...
> Hello ,
> I have couple of questions on clustering as well as on hardware.
> 1) Is the license for SQL Server 2005 Enterprise edition ( Production) on
> active/active and active/passive is same?
Sort of. There is a single-instance or N+1 exception to normal licensing
requirements. If you have a node that is always a standby system, Then it
doesn't have to be licensed for SQL. Two nodes, one instance, one license.
Four nodes, three instances, three licenses.
Also, on two-node clusters, you might look into Standard Edition for
clustering. It's lots cheaper and it does support two-node clusters.
> 2) Is the license for sql server 2005 is socket based or processor based,
> is
> there any differnce between them.
Socket-based. This makes dual and quad core systems very price competitive
from a licensing standpoint.
> 3) Do we have any figures for SQL Server 2005 performance on single socket
> as well as dual socket servers ?
I generally don't trust benchmarks all that much. With SQL, the nature of
the load can vary so much between systems that finding a matching benchmark
is difficult if not impossible. Dual and quad socket systems are commodity
priced so I wouldn't go with a single-socket system except for the very
lowest application. Certainly not for a cluster.
> 4) If we have a active/active cluster on single socket on quad core
> processor , what will be the license as well as performance when compared
> to
> the active/active on dual socket on quad processor?
>
Assuming per-socket licensing, you would need one socket license for the
first and four licenses for the second. CAL licensing (assuming the usage
meets the requirements) would be one server license and N CALS for the first
or two server licenses and N CALs for the second. N being the number of
client users or devices.
> Any input is appreciated?
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
|||Thanks that was helpful....
Is there any KB or white paper describing the same for some documentation...
"Geoff N. Hiten" wrote:
> Comments Inline
> "IT" <IT@.discussions.microsoft.com> wrote in message
> news:87B5B6CB-413D-4A12-A4D3-59CDAC0C569A@.microsoft.com...
> Sort of. There is a single-instance or N+1 exception to normal licensing
> requirements. If you have a node that is always a standby system, Then it
> doesn't have to be licensed for SQL. Two nodes, one instance, one license.
> Four nodes, three instances, three licenses.
> Also, on two-node clusters, you might look into Standard Edition for
> clustering. It's lots cheaper and it does support two-node clusters.
> Socket-based. This makes dual and quad core systems very price competitive
> from a licensing standpoint.
> I generally don't trust benchmarks all that much. With SQL, the nature of
> the load can vary so much between systems that finding a matching benchmark
> is difficult if not impossible. Dual and quad socket systems are commodity
> priced so I wouldn't go with a single-socket system except for the very
> lowest application. Certainly not for a cluster.
> Assuming per-socket licensing, you would need one socket license for the
> first and four licenses for the second. CAL licensing (assuming the usage
> meets the requirements) would be one server license and N CALS for the first
> or two server licenses and N CALs for the second. N being the number of
> client users or devices.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
|||Microsoft SQL Server 2005 Licensing
http://www.microsoft.com/sql/howtobuy/default.mspx#EXE
The links to the white paper and FAQ are very useful
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"IT" <IT@.discussions.microsoft.com> wrote in message
news:8848E76E-646D-4AA9-B7FD-7FCCA6D5DAFE@.microsoft.com...[vbcol=seagreen]
> Thanks that was helpful....
> Is there any KB or white paper describing the same for some
> documentation...
> "Geoff N. Hiten" wrote:
I have couple of questions on clustering as well as on hardware.
1) Is the license for SQL Server 2005 Enterprise edition ( Production) on
active/active and active/passive is same?
2) Is the license for sql server 2005 is socket based or processor based, is
there any differnce between them.
3) Do we have any figures for SQL Server 2005 performance on single socket
as well as dual socket servers ?
4) If we have a active/active cluster on single socket on quad core
processor , what will be the license as well as performance when compared to
the active/active on dual socket on quad processor?
Any input is appreciated?
Comments Inline
"IT" <IT@.discussions.microsoft.com> wrote in message
news:87B5B6CB-413D-4A12-A4D3-59CDAC0C569A@.microsoft.com...
> Hello ,
> I have couple of questions on clustering as well as on hardware.
> 1) Is the license for SQL Server 2005 Enterprise edition ( Production) on
> active/active and active/passive is same?
Sort of. There is a single-instance or N+1 exception to normal licensing
requirements. If you have a node that is always a standby system, Then it
doesn't have to be licensed for SQL. Two nodes, one instance, one license.
Four nodes, three instances, three licenses.
Also, on two-node clusters, you might look into Standard Edition for
clustering. It's lots cheaper and it does support two-node clusters.
> 2) Is the license for sql server 2005 is socket based or processor based,
> is
> there any differnce between them.
Socket-based. This makes dual and quad core systems very price competitive
from a licensing standpoint.
> 3) Do we have any figures for SQL Server 2005 performance on single socket
> as well as dual socket servers ?
I generally don't trust benchmarks all that much. With SQL, the nature of
the load can vary so much between systems that finding a matching benchmark
is difficult if not impossible. Dual and quad socket systems are commodity
priced so I wouldn't go with a single-socket system except for the very
lowest application. Certainly not for a cluster.
> 4) If we have a active/active cluster on single socket on quad core
> processor , what will be the license as well as performance when compared
> to
> the active/active on dual socket on quad processor?
>
Assuming per-socket licensing, you would need one socket license for the
first and four licenses for the second. CAL licensing (assuming the usage
meets the requirements) would be one server license and N CALS for the first
or two server licenses and N CALs for the second. N being the number of
client users or devices.
> Any input is appreciated?
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
|||Thanks that was helpful....
Is there any KB or white paper describing the same for some documentation...
"Geoff N. Hiten" wrote:
> Comments Inline
> "IT" <IT@.discussions.microsoft.com> wrote in message
> news:87B5B6CB-413D-4A12-A4D3-59CDAC0C569A@.microsoft.com...
> Sort of. There is a single-instance or N+1 exception to normal licensing
> requirements. If you have a node that is always a standby system, Then it
> doesn't have to be licensed for SQL. Two nodes, one instance, one license.
> Four nodes, three instances, three licenses.
> Also, on two-node clusters, you might look into Standard Edition for
> clustering. It's lots cheaper and it does support two-node clusters.
> Socket-based. This makes dual and quad core systems very price competitive
> from a licensing standpoint.
> I generally don't trust benchmarks all that much. With SQL, the nature of
> the load can vary so much between systems that finding a matching benchmark
> is difficult if not impossible. Dual and quad socket systems are commodity
> priced so I wouldn't go with a single-socket system except for the very
> lowest application. Certainly not for a cluster.
> Assuming per-socket licensing, you would need one socket license for the
> first and four licenses for the second. CAL licensing (assuming the usage
> meets the requirements) would be one server license and N CALS for the first
> or two server licenses and N CALs for the second. N being the number of
> client users or devices.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
|||Microsoft SQL Server 2005 Licensing
http://www.microsoft.com/sql/howtobuy/default.mspx#EXE
The links to the white paper and FAQ are very useful
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"IT" <IT@.discussions.microsoft.com> wrote in message
news:8848E76E-646D-4AA9-B7FD-7FCCA6D5DAFE@.microsoft.com...[vbcol=seagreen]
> Thanks that was helpful....
> Is there any KB or white paper describing the same for some
> documentation...
> "Geoff N. Hiten" wrote:
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
Wednesday, March 7, 2012
CLR and SQL 2005 Compact Edition
I believe that there is a also a new SQL database for the PDA. Am I right? Is it also possible to use (CF) .Net code inside this edition?
Yes. It's called SQL Server 2005 Mobile Edition. This works on Windows Mobile devices (PocketPC and SmartPhone). You need to install .NETCF 2.0 (compact framework) on the device for using SQL Mobile.
You can develop mobile applications using Visual Studio for Devices.
SQL Mobile is part of SQL Server 2005 or Visual Studio 2005.
You can get more information here:
The SQL Mobile page on MSDN : http://msdn.microsoft.com/mobility/sqlmobile/default.aspx
SQL Mobile page from SQL Server home: http://www.microsoft.com/sql/editions/sqlmobile/default.mspx
News groups: microsoft.public.sqlserver.ce. and
Msdn forums: You will find SQL Mobile under SQL Server: http://forums.microsoft.com/msdn/default.aspx?forumgroupid=19&siteid=1
Simply stated:
SQL Mobile components is a bunch of dlls that are linked in your device application project. So the database routines are embedded in your application code.
You declare some variables, structures
Application logic - pre data processing
query, modify, delete data from SQL Mobile
Application logic - post data processing
Closed not Answered - New Call with updates
ok here goes I uninstalled SQL Server Express and decided to Install the Standard Edition - Wow that was huge to do - lots of little things left
I have now installed SQL Server 2005 Standard.
But I cannot configure it properly.
(How I know this) I can open Business Intelligence Development Studio - can after some initial fiddling around
design a report/data/layout/preview - but cannot render a report to either
my local machine - nz3/reports
or to an external vmw server
My Report configuration is not complete and initialisation is not complete.
I am aware there are lots of instructions on books online , I have been reading them all as well.
But other than going round and round in circles I don't know how or in what order to tackle them.
I have a document with screen shots that may be much more helpful to explain
Is there anyone willing to jump in and see if they can guide me through this.
ok just an update here - but I still need some help! if someone would like to jump in
I have configured everything in Reporting Services configuration but initialisation is still not going.
All my services are running - my home page = localhost is showing this:
Your Web service is now running. You do not currently have a default Web page established for your users.
But on configuration my virtual report server is ticked?
What else could I check?
thanks
|||Re: SQL Server 2005 setup with Reporting Services ConfigurationFriday, February 24, 2012
Client tools only in SQL 7
How can I install client tools only in SQL 7? Desktop edition and advanced options?If I understand your question, simply insert the CD and run setup... choose
a custom install and select only client connectivity and Tools.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"marijn" <mklijs@.ons.nl> wrote in message
news:d35da914.0307300357.29ec16bb@.posting.google.com...
> How can I install client tools only in SQL 7? Desktop edition and advanced
options?
a custom install and select only client connectivity and Tools.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"marijn" <mklijs@.ons.nl> wrote in message
news:d35da914.0307300357.29ec16bb@.posting.google.com...
> How can I install client tools only in SQL 7? Desktop edition and advanced
options?
Sunday, February 19, 2012
client side print button not visible even in SQL Server 2005 Express SP 2.0
Hi All!
i installed SQL Server 2005 express edition Service Pack 2.0, SQL server Advance Services, and Toolkit . Still Print button in client side report is not visible in web form.
please help me.
thanks in advance.
Wel I guess we cannot do that...printing is not available on client SSRS...Too bad...And just to let you know, if you need to send query parameters to the report forget the client SSRS again...it sucks...you have to install the report on the Web server and that way yes you can print and send query parameters and so long...other way no solution...
rkraju:
Hi All!
i installed SQL Server 2005 express edition Service Pack 2.0, SQL server Advance Services, and Toolkit . Still Print button in client side report is not visible in web form.
please help me.
thanks in advance.
Read here...I'm feeling frustrated on this...
http://blogs.msdn.com/mohamed_sharafs_blog/archive/2005/12/20/LocalReportCustomCode.aspx
However if you've found another solution please let me know!!!Thanks a lot!
Tuesday, February 14, 2012
Client Hang
Hello,
We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3) that hangs our SQLServer Clients after starting a DTC transaction.
SQL Server service starts automatically at startup and it starts DTC.
?Does anybody know how to solve the problem and what is happening?
> Hello,
> We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3)
> that hangs our SQLServer Clients after starting a DTC transaction.
> SQL Server service starts automatically at startup and it starts DTC.
> ?Does anybody know how to solve the problem and what is happening?
>
It could be an MS DTC problem. You can use a tool named DTCPing to
troubleshoot MS DTC operation:
HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3) that hangs our SQLServer Clients after starting a DTC transaction.
SQL Server service starts automatically at startup and it starts DTC.
?Does anybody know how to solve the problem and what is happening?
> Hello,
> We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3)
> that hangs our SQLServer Clients after starting a DTC transaction.
> SQL Server service starts automatically at startup and it starts DTC.
> ?Does anybody know how to solve the problem and what is happening?
>
It could be an MS DTC problem. You can use a tool named DTCPing to
troubleshoot MS DTC operation:
HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Client Hang
Hello
We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3) that hangs our SQLServer Clients after starting a DTC transaction
SQL Server service starts automatically at startup and it starts DTC
¿Does anybody know how to solve the problem and what is happening?> Hello,
> We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3)
> that hangs our SQLServer Clients after starting a DTC transaction.
> SQL Server service starts automatically at startup and it starts DTC.
> ¿Does anybody know how to solve the problem and what is happening?
>
--
It could be an MS DTC problem. You can use a tool named DTCPing to
troubleshoot MS DTC operation:
HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3) that hangs our SQLServer Clients after starting a DTC transaction
SQL Server service starts automatically at startup and it starts DTC
¿Does anybody know how to solve the problem and what is happening?> Hello,
> We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3)
> that hangs our SQLServer Clients after starting a DTC transaction.
> SQL Server service starts automatically at startup and it starts DTC.
> ¿Does anybody know how to solve the problem and what is happening?
>
--
It could be an MS DTC problem. You can use a tool named DTCPing to
troubleshoot MS DTC operation:
HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Client Hang
Hello,
We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3) that h
angs our SQLServer Clients after starting a DTC transaction.
SQL Server service starts automatically at startup and it starts DTC.
?Does anybody know how to solve the problem and what is happening?
> Hello,
> We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3)
> that hangs our SQLServer Clients after starting a DTC transaction.
> SQL Server service starts automatically at startup and it starts DTC.
> ?Does anybody know how to solve the problem and what is happening?
>
--
It could be an MS DTC problem. You can use a tool named DTCPing to
troubleshoot MS DTC operation:
HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3) that h
angs our SQLServer Clients after starting a DTC transaction.
SQL Server service starts automatically at startup and it starts DTC.
?Does anybody know how to solve the problem and what is happening?
> Hello,
> We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3)
> that hangs our SQLServer Clients after starting a DTC transaction.
> SQL Server service starts automatically at startup and it starts DTC.
> ?Does anybody know how to solve the problem and what is happening?
>
--
It could be an MS DTC problem. You can use a tool named DTCPing to
troubleshoot MS DTC operation:
HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Sunday, February 12, 2012
Client can't be connected.
Hi,
I want to connect my win-XP client with win-server-2003 SQL Server.
I had done following task-
- I had installed SQL-2000 (Ent. Edition) on Win-Server 2003. And it is
successfully installed.
- In Win-S-2003 with the help of Active Directory I created domain and
created user on it.
- Client computer (Win-XP Prof.) configured with domain system. and I can
successfully login on that computer as a administrator.
- On client computer installed Sql-2000 (Ent. Edition) client tool.
- In Client Network Utility Configured my SQL Server
- In Enterprise Manager I done new registration with following configuration
-- Connect using = window authontication
-- Here I found following error : SQL Server does not exist or
access denied Connection Open(Connect())
Please help me to connect my client.
Hardik.
Hi
Can you connect to SQL Server, though EM, from the SQL Server console?
If not, is SQL Server running?
Can the client ping the SQL Server server?
Regards
Mike
"Hardik Shah" wrote:
> Hi,
> I want to connect my win-XP client with win-server-2003 SQL Server.
> I had done following task-
> - I had installed SQL-2000 (Ent. Edition) on Win-Server 2003. And it is
> successfully installed.
> - In Win-S-2003 with the help of Active Directory I created domain and
> created user on it.
> - Client computer (Win-XP Prof.) configured with domain system. and I can
> successfully login on that computer as a administrator.
> - On client computer installed Sql-2000 (Ent. Edition) client tool.
> - In Client Network Utility Configured my SQL Server
> - In Enterprise Manager I done new registration with following configuration
> -- Connect using = window authontication
> -- Here I found following error : SQL Server does not exist or
> access denied Connection Open(Connect())
> Please help me to connect my client.
>
> Hardik.
>
>
|||Hi,
Thanks for your reply.
I don't know how ping work . Please tell me how can client ping the SQL
Server
Hardik Shah
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:99ED019E-B7C0-473F-90D2-1AB2B7C059FC@.microsoft.com...[vbcol=seagreen]
> Hi
> Can you connect to SQL Server, though EM, from the SQL Server console?
> If not, is SQL Server running?
> Can the client ping the SQL Server server?
> Regards
> Mike
> "Hardik Shah" wrote:
can[vbcol=seagreen]
configuration[vbcol=seagreen]
|||Yes, I tried to ping my server it run successfully..
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:99ED019E-B7C0-473F-90D2-1AB2B7C059FC@.microsoft.com...[vbcol=seagreen]
> Hi
> Can you connect to SQL Server, though EM, from the SQL Server console?
> If not, is SQL Server running?
> Can the client ping the SQL Server server?
> Regards
> Mike
> "Hardik Shah" wrote:
can[vbcol=seagreen]
configuration[vbcol=seagreen]
I want to connect my win-XP client with win-server-2003 SQL Server.
I had done following task-
- I had installed SQL-2000 (Ent. Edition) on Win-Server 2003. And it is
successfully installed.
- In Win-S-2003 with the help of Active Directory I created domain and
created user on it.
- Client computer (Win-XP Prof.) configured with domain system. and I can
successfully login on that computer as a administrator.
- On client computer installed Sql-2000 (Ent. Edition) client tool.
- In Client Network Utility Configured my SQL Server
- In Enterprise Manager I done new registration with following configuration
-- Connect using = window authontication
-- Here I found following error : SQL Server does not exist or
access denied Connection Open(Connect())
Please help me to connect my client.
Hardik.
Hi
Can you connect to SQL Server, though EM, from the SQL Server console?
If not, is SQL Server running?
Can the client ping the SQL Server server?
Regards
Mike
"Hardik Shah" wrote:
> Hi,
> I want to connect my win-XP client with win-server-2003 SQL Server.
> I had done following task-
> - I had installed SQL-2000 (Ent. Edition) on Win-Server 2003. And it is
> successfully installed.
> - In Win-S-2003 with the help of Active Directory I created domain and
> created user on it.
> - Client computer (Win-XP Prof.) configured with domain system. and I can
> successfully login on that computer as a administrator.
> - On client computer installed Sql-2000 (Ent. Edition) client tool.
> - In Client Network Utility Configured my SQL Server
> - In Enterprise Manager I done new registration with following configuration
> -- Connect using = window authontication
> -- Here I found following error : SQL Server does not exist or
> access denied Connection Open(Connect())
> Please help me to connect my client.
>
> Hardik.
>
>
|||Hi,
Thanks for your reply.
I don't know how ping work . Please tell me how can client ping the SQL
Server
Hardik Shah
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:99ED019E-B7C0-473F-90D2-1AB2B7C059FC@.microsoft.com...[vbcol=seagreen]
> Hi
> Can you connect to SQL Server, though EM, from the SQL Server console?
> If not, is SQL Server running?
> Can the client ping the SQL Server server?
> Regards
> Mike
> "Hardik Shah" wrote:
can[vbcol=seagreen]
configuration[vbcol=seagreen]
|||Yes, I tried to ping my server it run successfully..
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:99ED019E-B7C0-473F-90D2-1AB2B7C059FC@.microsoft.com...[vbcol=seagreen]
> Hi
> Can you connect to SQL Server, though EM, from the SQL Server console?
> If not, is SQL Server running?
> Can the client ping the SQL Server server?
> Regards
> Mike
> "Hardik Shah" wrote:
can[vbcol=seagreen]
configuration[vbcol=seagreen]
Subscribe to:
Posts (Atom)