How to determine licensing mode and number of licenses in SQL 2005

I'm trying to find out how my SQL 2005 server's licensing is set up. I
don't see it in the properties of the server and when I query
serverproperties, it says licenseType returns disabled and NumLicenses
returns NULL. In SQL 2000, there was a Control Panel applet, but it's not
there for SQL 2005.
Thanks for your help!Hi
This was an old problem with SQL2000 prior to SP2
http://support.microsoft.com/?kbid=291332
If you are using SQL 2005 Developer edition then you may not have a license
type as these don't support standard licencing e.g.
SELECT
CAST( SERVERPROPERTY('productversion') AS varchar(15)) AS productversion,
CAST( SERVERPROPERTY ('productlevel') AS varchar(15)) AS productlevel,
CAST( SERVERPROPERTY ('edition') AS varchar(20)) AS edition,
CAST( SERVERPROPERTY ('licensetype') AS varchar(15)) AS licensetype,
CAST( SERVERPROPERTY ('numlicenses') AS varchar(15)) AS Numlicenses
productversion productlevel edition licensetype
Numlicenses
-- -- -- --
--
9.00.2047.00 SP1 Developer Edition DISABLED NULL
John
"Nieves" wrote:

> I'm trying to find out how my SQL 2005 server's licensing is set up. I
> don't see it in the properties of the server and when I query
> serverproperties, it says licenseType returns disabled and NumLicenses
> returns NULL. In SQL 2000, there was a Control Panel applet, but it's not
> there for SQL 2005.
> Thanks for your help!
>
>sql

How to determine licensing mode and number of licenses in SQL 2005

I'm trying to find out how my SQL 2005 server's licensing is set up. I
don't see it in the properties of the server and when I query
serverproperties, it says licenseType returns disabled and NumLicenses
returns NULL. In SQL 2000, there was a Control Panel applet, but it's not
there for SQL 2005.
Thanks for your help!Hi
This was an old problem with SQL2000 prior to SP2
http://support.microsoft.com/?kbid=291332
If you are using SQL 2005 Developer edition then you may not have a license
type as these don't support standard licencing e.g.
SELECT
CAST( SERVERPROPERTY('productversion') AS varchar(15)) AS productversion,
CAST( SERVERPROPERTY ('productlevel') AS varchar(15)) AS productlevel,
CAST( SERVERPROPERTY ('edition') AS varchar(20)) AS edition,
CAST( SERVERPROPERTY ('licensetype') AS varchar(15)) AS licensetype,
CAST( SERVERPROPERTY ('numlicenses') AS varchar(15)) AS Numlicenses
productversion productlevel edition licensetype
Numlicenses
-- -- -- --
--
9.00.2047.00 SP1 Developer Edition DISABLED NULL
John
"Nieves" wrote:
> I'm trying to find out how my SQL 2005 server's licensing is set up. I
> don't see it in the properties of the server and when I query
> serverproperties, it says licenseType returns disabled and NumLicenses
> returns NULL. In SQL 2000, there was a Control Panel applet, but it's not
> there for SQL 2005.
> Thanks for your help!
>
>

How to Determine Data Source Associated with Report

Within report design mode, I can see the DataSet, but I can't tell if this
was created using a Shared Data Source or was it created before I created
and started using a Shared Data Source. I have a problem publishing reports
that used the Shared Data Source. Now I want to check and see how I
originally set the DataSet -- to use the Shared Data Source or not. Any way
to see that?
Thanks,
Boolean1On Mar 1, 1:24 pm, "Boolean1" <Boole...@.comcast.net> wrote:
> Within report design mode, I can see the DataSet, but I can't tell if this
> was created using a Shared Data Source or was it created before I created
> and started using a Shared Data Source. I have a problem publishing reports
> that used the Shared Data Source. Now I want to check and see how I
> originally set the DataSet -- to use the Shared Data Source or not. Any way
> to see that?
> Thanks,
> Boolean1
In the 'Data' tab select the datasets for the report in question and
select the Edit Selected Dataset button [...]. On the 'Query' tab,
below Datasource: is the datasource for the dataset. Select the [...]
button to the right. Near the bottom of the General tab look to see if
'Use shared datasource reference' is checked. Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer

How to determine Authentication Mode?

Given a server name, and before logging on to the server - how can I tell if
it's using Windows Authentication Mode or SQL Server Authentication?
I'm retreiving a list of servers as follows:
Dim dmoApp As SQLDMO.Application, dmoServerList As SQLDMO.NameList, srvrNm
As String
dmoApp = New SQLDMO.Application
dmoServerList = dmoApp.ListAvailableSQLServers
For i As Integer = 1 To dmoServerList.Count
srvrNm = dmoServerList.Item(i)
Next i
Thanks in advance for your help,
Hal Heinrich
VP Technology
Aralan Solutions Inc.Hal,
SQL Server always defaults to using Windows Authentication; it is up to the
developer to determine which authentication method to use.
And if you use some tool to generate the connection string for you, the
default will be to use Windows Authentication. This can be seen in the
connection string by the following line:
Integrated Security=SSPI
If that data|value pair is present, then your connection will use the
Windows Authentication mode. Simply remove this data|value pair from your
connection string and then you will be using the SQL Server Authentication
and be required to include user and password values.
Hope that helps.
Richard
"Hal Heinrich" wrote:

> Given a server name, and before logging on to the server - how can I tell
if
> it's using Windows Authentication Mode or SQL Server Authentication?
> I'm retreiving a list of servers as follows:
> Dim dmoApp As SQLDMO.Application, dmoServerList As SQLDMO.NameList, srvrNm
> As String
> dmoApp = New SQLDMO.Application
> dmoServerList = dmoApp.ListAvailableSQLServers
> For i As Integer = 1 To dmoServerList.Count
> srvrNm = dmoServerList.Item(i)
> Next i
> Thanks in advance for your help,
> Hal Heinrich
> VP Technology
> Aralan Solutions Inc.
>