ClassNotFoundException

Hi all,
I am new to java. I have installed SQL Server JDBC Driver SP3 on my
computer.
When I run the statement Class.forName("..."); , I get the
ClassNotFoundException.
I have read the following article
http://support.microsoft.com/default...;en-us;313100.
And I am sure that I have my CLASSPATH variable is like the following:
CLASSPATH=.;c:\program files\Microsoft SQL Server 2000 Driver for
JDBC\lib\msbase.jar;c:\program files\Microsoft SQL Server 2000 Driver for
JDBC\lib\msutil.jar;c:\program files\Microsoft SQL Server 2000 Driver for
JDBC\lib\mssqlserver.jar
But the exception still occurs. Even when I copied the 3 jar files into
c:\j2sdk\lib, it also didn't work.
Anyone can help me?
Thank you!
Hi Charlie,
Are you sure that the driver classes are accesible from your calling class,
ie, have you imported the driver package?
Ian
"Charlie Tong" wrote:

> Hi all,
> I am new to java. I have installed SQL Server JDBC Driver SP3 on my
> computer.
> When I run the statement Class.forName("..."); , I get the
> ClassNotFoundException.
> I have read the following article
> http://support.microsoft.com/default...;en-us;313100.
> And I am sure that I have my CLASSPATH variable is like the following:
> CLASSPATH=.;c:\program files\Microsoft SQL Server 2000 Driver for
> JDBC\lib\msbase.jar;c:\program files\Microsoft SQL Server 2000 Driver for
> JDBC\lib\msutil.jar;c:\program files\Microsoft SQL Server 2000 Driver for
> JDBC\lib\mssqlserver.jar
> But the exception still occurs. Even when I copied the 3 jar files into
> c:\j2sdk\lib, it also didn't work.
> Anyone can help me?
> Thank you!
>
>
|||It works now.
Thanks Ian!
"Ian555" <Ian555@.discussions.microsoft.com> wrote in message
news:CFED38BD-C33C-4336-97E3-624D5C5513DD@.microsoft.com...[vbcol=seagreen]
> Hi Charlie,
> Are you sure that the driver classes are accesible from your calling
> class,
> ie, have you imported the driver package?
> Ian
> "Charlie Tong" wrote:

Class not registered when opening AdomdConnection

I'm just getting started on Analysis Services.

I have installed AS on our SQL Server (2000), and I can access it with Analysis Manager and third-party tools. But when I try to open a connection with ADOMD.NET, I get a "class not registered" error message (error ID = -2147221164).

Here's my code:

AdomdConnection conn = new AdomdConnection();
conn.ConnectionString = "Data Source=Servername;Initial Catalog=MyCatalog;ConnectTo=8.0";
conn.Open(); // exception is thrown here

I have installed Visual C# 2005 Express, MSXML 4.0 SP2, and ADOMD.NET (from the SQL Server 2005 Feature Pack).

Daniel

did you ever resolve this. I get the same issue?

thx

Avi

|||

ADOMD.NET (9.0) that comes with SQL2K5 cannot connect directly to AS2K. It delegates to PTS 8.0. What I think you are seeing is that it isn't available. Try installing PTSLITE.EXE from your SQL2K SP4 (AS distribution) kit (located in the \msolap\install\pts subfolder).

_-_-_ Dave

sqlsql

Class not registered when opening AdomdConnection

I'm just getting started on Analysis Services.

I have installed AS on our SQL Server (2000), and I can access it with Analysis Manager and third-party tools. But when I try to open a connection with ADOMD.NET, I get a "class not registered" error message (error ID = -2147221164).

Here's my code:

AdomdConnection conn = new AdomdConnection();
conn.ConnectionString = "Data Source=Servername;Initial Catalog=MyCatalog;ConnectTo=8.0";
conn.Open(); // exception is thrown here

I have installed Visual C# 2005 Express, MSXML 4.0 SP2, and ADOMD.NET (from the SQL Server 2005 Feature Pack).

Daniel

did you ever resolve this. I get the same issue?

thx

Avi

|||

ADOMD.NET (9.0) that comes with SQL2K5 cannot connect directly to AS2K. It delegates to PTS 8.0. What I think you are seeing is that it isn't available. Try installing PTSLITE.EXE from your SQL2K SP4 (AS distribution) kit (located in the \msolap\install\pts subfolder).

_-_-_ Dave

check version of sql 2005

how do i check whether i have installed 64 bit /32 bit sql server 2005... if i see Program files and Program files (x86) directory can i be sure...

one more query..Is windows 2003 enterprise edition 64 bit Itanium based operating systems

Thanks in advance

Is this really a SSIS question or the SQL engine?

The standard SELECT/PRINT @.@.VERSION command works here for the SQL engine, just look in the output for x64 vs x86, or Itanium I presume, but cannot confirm, e.g.

Microsoft SQL Server 2005 - 9.00.2153.00 (X64)
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)
on Windows NT 5.2 (Build 3790: Service Pack 1)

The presence of the Program Files (x86) directory means you are running on a 64-bit OS with WOW support. The 64-bit applications are installed in the alternative Program Files, so the presence of SQL in there would indicate you have a 64-bit install of SQL as well.

Windows 2003 Enterprise Edition comes in Itanium, x64 and x86 flavours.

|||

Is there a mapping table available between @.@.version string and the SQL Server 2005?

For example,

SQL Server 2005 RTM x86 (32-bit) Enterprise Edition --> @.@.version=?

SQL Server 2005 RTM x64 (32-bit) Enterprise Edition --> @.@.version =?

SQL Server 2005 RTM IA64 (64-bit) Enterprise Edition -->@.@.version=?

SQL Server 2005 with SP1 (32-bit) --> @.@.version=?

etc, etc.

I am particularly interested in the build number of SP1 vs. RTM so that I can build a process to check if SP1 has been deployed successfully or not.

Thanks

Sean

|||The "current" release with all the hot fixes is 9.00.2153. If you version is other, you need updates.

See: http://support.microsoft.com/kb/321185|||

SQL Server Version Database
(http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx)

The versions will also be included in any KB that accompanies a service pack or hotfix, for the latter at a file level as well, since not all fixes change the @.@.version result.

The edition is not considered part of the version (build number), but is included in the @.@.version result.

For SSIS, there are some more notes here, as off course you may have patched SSIS independently of the engine, or may not even have the engine installed-

Service Pack Versions
(http://wiki.sqlis.com/default.aspx/SQLISWiki/ServicePackVersions.html)

Check the version of Service pack

How do I check the version of service pack installed to my
sql server...
I tried Select @.@.version
I tried select serverproperty('productlevel')
I get sp3 on the later and now I installed sp3a
still the output of select serverproperty('productlevel')
gives sp3
Please help
Thanks
Alka
Alka,
SERVERPROPERTY is returning SP3 because all the changes in SP3a are setup
related and there are no changes in the database engine.Heres a snippet from
SP3a readme file:
How to Distinguish Between SQL Server 2000 SP3 and SQL Server 2000 SP3a
To determine whether you have SQL Server 2000 SP3 or SQL Server 2000 SP3a
installed, check the version number of the Net-Library file, Ssnetlib.dll.
If the version number of this file is 2000.80.760.0, you have SQL Server
2000 SP3. If the version number of this file is 2000.80.766.0, you have SQL
Server 2000 SP3a.
Assuming that an instance was installed by using the default settings, you
can find the Ssnetlib.dll file in one of these locations:
a.. Default instance: C:\Program Files\Microsoft SQL
Server\Binn\Ssnetlib.dll
b.. Named instance: C:\Program Files\Microsoft
SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka
|||Alka,
The build of SQL did not change from SP3 to SP3A. Check that ssnetlib.dll is
now version 2000.80.766.0 then you have SP3A. If it is 2000.80.760.0 you
have SP3.
Chris Wood
Alberta Department of Energy
CANADA
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka
|||Thanks Dinesh
But my file shows version 2000.80.818.0
Please help...
Thanks
Alka
>--Original Message--
>Alka,
>SERVERPROPERTY is returning SP3 because all the changes
in SP3a are setup
>related and there are no changes in the database
engine.Heres a snippet from
>SP3a readme file:
>How to Distinguish Between SQL Server 2000 SP3 and SQL
Server 2000 SP3a
>To determine whether you have SQL Server 2000 SP3 or SQL
Server 2000 SP3a
>installed, check the version number of the Net-Library
file, Ssnetlib.dll.
>If the version number of this file is 2000.80.760.0, you
have SQL Server
>2000 SP3. If the version number of this file is
2000.80.766.0, you have SQL
>Server 2000 SP3a.
>Assuming that an instance was installed by using the
default settings, you
>can find the Ssnetlib.dll file in one of these locations:
> a.. Default instance: C:\Program Files\Microsoft SQL
>Server\Binn\Ssnetlib.dll
> b.. Named instance: C:\Program Files\Microsoft
>SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dl l
>
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Alka Srivaastava" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
my[vbcol=seagreen]
('productlevel')
>
>.
>
|||Alka,
May be some hotfix(http://support.microsoft.com/?kbid=821688). Can you check
the registry entry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Hotfixes\ ?If its a
hotfix, an entry will be made at this key.BTW, what is the output of select
@.@.version?
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5a401c42325$926b1570$a601280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dinesh
> But my file shows version 2000.80.818.0
> Please help...
> Thanks
> Alka
> in SP3a are setup
> engine.Heres a snippet from
> Server 2000 SP3a
> Server 2000 SP3a
> file, Ssnetlib.dll.
> have SQL Server
> 2000.80.766.0, you have SQL
> default settings, you
> wrote in message
> my
> ('productlevel')

Check the version of Service pack

How do I check the version of service pack installed to my
sql server...
I tried Select @.@.version
I tried select serverproperty('productlevel')
I get sp3 on the later and now I installed sp3a
still the output of select serverproperty('productlevel')
gives sp3
Please help
Thanks
AlkaAlka,
SERVERPROPERTY is returning SP3 because all the changes in SP3a are setup
related and there are no changes in the database engine.Heres a snippet from
SP3a readme file:
How to Distinguish Between SQL Server 2000 SP3 and SQL Server 2000 SP3a
To determine whether you have SQL Server 2000 SP3 or SQL Server 2000 SP3a
installed, check the version number of the Net-Library file, Ssnetlib.dll.
If the version number of this file is 2000.80.760.0, you have SQL Server
2000 SP3. If the version number of this file is 2000.80.766.0, you have SQL
Server 2000 SP3a.
Assuming that an instance was installed by using the default settings, you
can find the Ssnetlib.dll file in one of these locations:
a.. Default instance: C:\Program Files\Microsoft SQL
Server\Binn\Ssnetlib.dll
b.. Named instance: C:\Program Files\Microsoft
SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx
.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka|||Alka,
The build of SQL did not change from SP3 to SP3A. Check that ssnetlib.dll is
now version 2000.80.766.0 then you have SP3A. If it is 2000.80.760.0 you
have SP3.
Chris Wood
Alberta Department of Energy
CANADA
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx
.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka|||Thanks Dinesh
But my file shows version 2000.80.818.0
Please help...
Thanks
Alka
>--Original Message--
>Alka,
>SERVERPROPERTY is returning SP3 because all the changes
in SP3a are setup
>related and there are no changes in the database
engine.Heres a snippet from
>SP3a readme file:
>How to Distinguish Between SQL Server 2000 SP3 and SQL
Server 2000 SP3a
>To determine whether you have SQL Server 2000 SP3 or SQL
Server 2000 SP3a
>installed, check the version number of the Net-Library
file, Ssnetlib.dll.
>If the version number of this file is 2000.80.760.0, you
have SQL Server
>2000 SP3. If the version number of this file is
2000.80.766.0, you have SQL
>Server 2000 SP3a.
>Assuming that an instance was installed by using the
default settings, you
>can find the Ssnetlib.dll file in one of these locations:
> a.. Default instance: C:\Program Files\Microsoft SQL
>Server\Binn\Ssnetlib.dll
> b.. Named instance: C:\Program Files\Microsoft
>SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
>
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Alka Srivaastava" <anonymous@.discussions.microsoft.com>
wrote in message
> news:1d1f101c42320$fec140a0$a301280a@.phx
.gbl...
my[vbcol=seagreen]
('productlevel')[vbcol=seagreen]
>
>.
>|||Alka,
May be some hotfix(http://support.microsoft.com/?kbid=821688). Can you check
the registry entry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\Hotfixes\ ?If its a
hotfix, an entry will be made at this key.BTW, what is the output of select
@.@.version?
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5a401c42325$926b1570$a601280a@.phx
.gbl...[vbcol=seagreen]
> Thanks Dinesh
> But my file shows version 2000.80.818.0
> Please help...
> Thanks
> Alka
> in SP3a are setup
> engine.Heres a snippet from
> Server 2000 SP3a
> Server 2000 SP3a
> file, Ssnetlib.dll.
> have SQL Server
> 2000.80.766.0, you have SQL
> default settings, you
> wrote in message
> my
> ('productlevel')

Check the version of Service pack

How do I check the version of service pack installed to my
sql server...
I tried Select @.@.version
I tried select serverproperty('productlevel')
I get sp3 on the later and now I installed sp3a
still the output of select serverproperty('productlevel')
gives sp3
Please help
Thanks
AlkaAlka,
SERVERPROPERTY is returning SP3 because all the changes in SP3a are setup
related and there are no changes in the database engine.Heres a snippet from
SP3a readme file:
How to Distinguish Between SQL Server 2000 SP3 and SQL Server 2000 SP3a
To determine whether you have SQL Server 2000 SP3 or SQL Server 2000 SP3a
installed, check the version number of the Net-Library file, Ssnetlib.dll.
If the version number of this file is 2000.80.760.0, you have SQL Server
2000 SP3. If the version number of this file is 2000.80.766.0, you have SQL
Server 2000 SP3a.
Assuming that an instance was installed by using the default settings, you
can find the Ssnetlib.dll file in one of these locations:
a.. Default instance: C:\Program Files\Microsoft SQL
Server\Binn\Ssnetlib.dll
b.. Named instance: C:\Program Files\Microsoft
SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka|||Alka,
The build of SQL did not change from SP3 to SP3A. Check that ssnetlib.dll is
now version 2000.80.766.0 then you have SP3A. If it is 2000.80.760.0 you
have SP3.
Chris Wood
Alberta Department of Energy
CANADA
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka|||Thanks Dinesh
But my file shows version 2000.80.818.0
Please help...
Thanks
Alka
>--Original Message--
>Alka,
>SERVERPROPERTY is returning SP3 because all the changes
in SP3a are setup
>related and there are no changes in the database
engine.Heres a snippet from
>SP3a readme file:
>How to Distinguish Between SQL Server 2000 SP3 and SQL
Server 2000 SP3a
>To determine whether you have SQL Server 2000 SP3 or SQL
Server 2000 SP3a
>installed, check the version number of the Net-Library
file, Ssnetlib.dll.
>If the version number of this file is 2000.80.760.0, you
have SQL Server
>2000 SP3. If the version number of this file is
2000.80.766.0, you have SQL
>Server 2000 SP3a.
>Assuming that an instance was installed by using the
default settings, you
>can find the Ssnetlib.dll file in one of these locations:
> a.. Default instance: C:\Program Files\Microsoft SQL
>Server\Binn\Ssnetlib.dll
> b.. Named instance: C:\Program Files\Microsoft
>SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
>
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Alka Srivaastava" <anonymous@.discussions.microsoft.com>
wrote in message
>news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
>> How do I check the version of service pack installed to
my
>> sql server...
>> I tried Select @.@.version
>> I tried select serverproperty('productlevel')
>> I get sp3 on the later and now I installed sp3a
>> still the output of select serverproperty
('productlevel')
>> gives sp3
>> Please help
>> Thanks
>> Alka
>
>.
>|||Alka,
May be some hotfix(http://support.microsoft.com/?kbid=821688). Can you check
the registry entry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Hotfixes\ ?If its a
hotfix, an entry will be made at this key.BTW, what is the output of select
@.@.version?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5a401c42325$926b1570$a601280a@.phx.gbl...
> Thanks Dinesh
> But my file shows version 2000.80.818.0
> Please help...
> Thanks
> Alka
> >--Original Message--
> >Alka,
> >
> >SERVERPROPERTY is returning SP3 because all the changes
> in SP3a are setup
> >related and there are no changes in the database
> engine.Heres a snippet from
> >SP3a readme file:
> >How to Distinguish Between SQL Server 2000 SP3 and SQL
> Server 2000 SP3a
> >
> >To determine whether you have SQL Server 2000 SP3 or SQL
> Server 2000 SP3a
> >installed, check the version number of the Net-Library
> file, Ssnetlib.dll.
> >If the version number of this file is 2000.80.760.0, you
> have SQL Server
> >2000 SP3. If the version number of this file is
> 2000.80.766.0, you have SQL
> >Server 2000 SP3a.
> >
> >Assuming that an instance was installed by using the
> default settings, you
> >can find the Ssnetlib.dll file in one of these locations:
> > a.. Default instance: C:\Program Files\Microsoft SQL
> >Server\Binn\Ssnetlib.dll
> > b.. Named instance: C:\Program Files\Microsoft
> >SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
> >
> >
> >--
> >Dinesh
> >SQL Server MVP
> >--
> >--
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"Alka Srivaastava" <anonymous@.discussions.microsoft.com>
> wrote in message
> >news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
> >> How do I check the version of service pack installed to
> my
> >> sql server...
> >>
> >> I tried Select @.@.version
> >> I tried select serverproperty('productlevel')
> >>
> >> I get sp3 on the later and now I installed sp3a
> >> still the output of select serverproperty
> ('productlevel')
> >> gives sp3
> >>
> >> Please help
> >>
> >> Thanks
> >> Alka
> >
> >
> >.
> >

check sql server edition

is there a way to get the edition(e.g. sqlexpress,enterprise etc...) of an installed sql server instance in your local machine programatically?

Code Snippet

select serverproperty('Edition')

HTH!|||alright! thanks man! but is there some other way... without executing a query from the server?|||

I guess another way would be to query the registry for the information. Looking around there appears to be that information in the registry key for SQL2005:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\Edition

HTH!

|||

i've checked my registry... but it seems its not correct to read the registry when checking an installed sqlserver edition... it's not accurate..my machine have some previous sqlserver installations before and my registry looks like this..

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\Edition\Developer Edition

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup\Edition\DeveloperEdition

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.3\Setup\Edition\Express Edition

...

...

......

.........

............

...............

but there is only one developer edition instance installed in my machine...

|||

Hi,

I guess your registry showing is correct.

During SQL Server Setup, an instance ID is generated for each server component. The server components in this SQL Server release are the Database Engine, Analysis Services, and Reporting Services. The instance ID is in the format MSSQL.n, where n is the ordinal number of the component being installed. The instance ID is used in the file directory and the registry root.

The first instance ID generated is MSSQL.1; ID numbers are incremented for additional instances as MSSQL.2, MSSQL.3, and so on. If gaps occur in the ID sequence due to uninstalls, ID numbers are not generated to fill them. The most recently installed instance always has the highest instance ID number.

Server components are installed in directories with the format <instanceID>\<component name>. For example, a default or named instance with the Database Engine, Analysis Services, and Reporting Services would have the following default directories:

<Program Files>\Microsoft SQL Server\MSSQL.1\MSSQL\ for the Database Engine

<Program Files>\Microsoft SQL Server\MSSQL.2\OLAP\ for Analysis Services

<Program Files>\Microsoft SQL Server\MSSQL.3\RS\ for Reporting Services

check sql licence

Hi, May I know how to check what is my current sql licence installed? I've
learnt that in control panel, there is a SQL Licence setup icon which I can
check. But some of my MSSQL server don't have this icon. Can you help?
Thanks
andrewTry to run this:
select serverproperty('LicenseType')
, serverproperty('NumLicenses')
"andrew" wrote:

> Hi, May I know how to check what is my current sql licence installed? I'v
e
> learnt that in control panel, there is a SQL Licence setup icon which I ca
n
> check. But some of my MSSQL server don't have this icon. Can you help?
> Thanks
> andrew|||Hi,
The result is:
disabled, null
May I know how can I change the values?
"Andre Vigneau" wrote:
[vbcol=seagreen]
> Try to run this:
> select serverproperty('LicenseType')
> , serverproperty('NumLicenses')
>
> "andrew" wrote:
>|||andrew wrote:
> Hi,
> The result is:
> disabled, null
> May I know how can I change the values?
>
LicenceType is not "implemented" in a reliable way. There was post about
this same problem a couple weeks ago. Trying giving the ng a search on
Google.
David Gugick
Imceda Software
www.imceda.com

check sql licence

Hi, May I know how to check what is my current sql licence installed? I've
learnt that in control panel, there is a SQL Licence setup icon which I can
check. But some of my MSSQL server don't have this icon. Can you help?
Thanks
andrew
Try to run this:
select serverproperty('LicenseType')
, serverproperty('NumLicenses')
"andrew" wrote:

> Hi, May I know how to check what is my current sql licence installed? I've
> learnt that in control panel, there is a SQL Licence setup icon which I can
> check. But some of my MSSQL server don't have this icon. Can you help?
> Thanks
> andrew
|||Hi,
The result is:
disabled, null
May I know how can I change the values?
"Andre Vigneau" wrote:
[vbcol=seagreen]
> Try to run this:
> select serverproperty('LicenseType')
> , serverproperty('NumLicenses')
>
> "andrew" wrote:
|||andrew wrote:
> Hi,
> The result is:
> disabled, null
> May I know how can I change the values?
>
LicenceType is not "implemented" in a reliable way. There was post about
this same problem a couple weeks ago. Trying giving the ng a search on
Google.
David Gugick
Imceda Software
www.imceda.com

check sql licence

Hi, May I know how to check what is my current sql licence installed? I've
learnt that in control panel, there is a SQL Licence setup icon which I can
check. But some of my MSSQL server don't have this icon. Can you help?
Thanks
andrewTry to run this:
select serverproperty('LicenseType')
, serverproperty('NumLicenses')
"andrew" wrote:
> Hi, May I know how to check what is my current sql licence installed? I've
> learnt that in control panel, there is a SQL Licence setup icon which I can
> check. But some of my MSSQL server don't have this icon. Can you help?
> Thanks
> andrew|||Hi,
The result is:
disabled, null
May I know how can I change the values?
"Andre Vigneau" wrote:
> Try to run this:
> select serverproperty('LicenseType')
> , serverproperty('NumLicenses')
>
> "andrew" wrote:
> > Hi, May I know how to check what is my current sql licence installed? I've
> > learnt that in control panel, there is a SQL Licence setup icon which I can
> > check. But some of my MSSQL server don't have this icon. Can you help?
> >
> > Thanks
> > andrew|||andrew wrote:
> Hi,
> The result is:
> disabled, null
> May I know how can I change the values?
>
LicenceType is not "implemented" in a reliable way. There was post about
this same problem a couple weeks ago. Trying giving the ng a search on
Google.
--
David Gugick
Imceda Software
www.imceda.com