How can I programmatically know if RS is installed on a server or not

Hi,,
I have a list of SQL servers available in our network in a ComboBox ,I want
to show a message if there is no reporting service installed on a server of
user choice ,I tried to use listChildern ,,but when there is no RS ,,it
thows an Exception inside the web referenc.
ThanksOne suggestion would be to put the code calling ListChildren inside of
a Try Catch block. If you catch the exception you can display a
message box saying reporting services was not found.
More info on Try Catch can be found here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingtrycatchblocktocatchexceptions.asp
The problem with this approach is you'll have to set the Url property
of the web reference and assume the report server is installed at the
default location (http://machinename/reportserver). If someone
installed the report server at a different location you'll need a more
robust mechanism to find it. I'd suggest trying WMI (windows
management instrumentation). There is an example in the docs showing
how to connect to a remote report server:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_wmi_6iua.asp
Note: the sample code in the docs also needs a try / catch in case the
server does not have SSRS installed.
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Fri, 12 Nov 2004 11:25:32 -0800, "ALI-R" <newbie@.microsoft.com>
wrote:
>Hi,,
>I have a list of SQL servers available in our network in a ComboBox ,I want
>to show a message if there is no reporting service installed on a server of
>user choice ,I tried to use listChildern ,,but when there is no RS ,,it
>thows an Exception inside the web referenc.
>Thanks
>

How can I make tempdb to its original size?

Hi, everybody!
I installed MS SQL Server 2000, and add two files to tempdb.
And now I want to make tempdb to its original size by removing two files
which had beed added.
How can I do it?http://www.support.microsoft.com/?id=307487
Andrew J. Kelly
SQL Server MVP
"Kim Keuk Tae" <zyuuzika@.korea.com> wrote in message
news:uF0WdC1cDHA.2572@.TK2MSFTNGP11.phx.gbl...
>
> Hi, everybody!
> I installed MS SQL Server 2000, and add two files to tempdb.
> And now I want to make tempdb to its original size by removing two files
> which had beed added.
> How can I do it?
>
>

how can I make a report that will run against a list of servers?

Hi, I have SQL 2005 sp2 installed on a test server that I run admin type
reports from. I have a report that I want to run against a list of servers,
the list is from an SQL table on the same server as RS. I've found that data
source parameters are possible, but I can't seem to get it to work. Can
anyone point to an example?Have you tried the examples provided? You mention data source parameters. It
makes me wonder if you are looking at the right information. What you want
to do is base your data source as an expression. From Books OnLine
>>>>>>
You can put an expression into a connection string to allow users to select
the data source at run time. For example, suppose a multinational firm has
data servers in several countries. With an expression-based connection
string, a user who is running a sales report can select a data source for a
particular country before running the report.
The following example illustrates the use of a data source expression in a
SQL Server connection string. The example assumes you have created a report
parameter named ServerName:
Copy Code
="data source=" & Parameters!ServerName.Value & ";initial
catalog=AdventureWorks
Data source expressions are processed at run time or when a report is
previewed. The expression must be written in Visual Basic. Use the following
guidelines when defining a data source expression:
a.. Design the report using a static connection string. A static
connection string refers to a connection string that is not set through an
expression (for example, when you follow the steps for creating a
report-specific or shared data source, you are defining a static connection
string). Using a static connection string allows you to connect to the data
source in Report Designer so that you can get the query results you need to
create the report.
b.. When defining the data source connection, do not use a shared data
source. You cannot use a data source expression in a shared data source. You
must define a report-specific data source for the report.
c.. Specify credentials separately from the connection string. You can use
stored credentials, prompted credentials, or integrated security.
d.. Add a report parameter to specify a data source. For parameter values,
you can either provide a static list of available values (in this case, the
available values should be data sources you can use with the report) or
define a query that retrieves a list of data sources at run time.
e.. Be sure that the list of data sources shares the same database schema.
All report design begins with schema information. If there is a mismatch
between the schema used to define the report and the actual schema used by
the report at run time, the report might not run.
f.. Before publishing the report, replace the static connection string
with an expression. Wait until you are finished designing the report before
you replace the static connection string with an expression. Once you use an
expression, you cannot execute the query in Report Designer. Furthermore,
the field list in the Datasets window and the Parameters list will not
update automatically.
>>>>>>>
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"DBAGURU" <DBAGURU@.discussions.microsoft.com> wrote in message
news:9260F115-1407-4227-8A74-2D545456E620@.microsoft.com...
> Hi, I have SQL 2005 sp2 installed on a test server that I run admin type
> reports from. I have a report that I want to run against a list of
> servers,
> the list is from an SQL table on the same server as RS. I've found that
> data
> source parameters are possible, but I can't seem to get it to work. Can
> anyone point to an example?
begin 666 copycode.gif
M1TE&.#EA#P`/`.9F`).BM[+"V*[$\(&NY:Z_U'.AWER,VIBKQBE4JIFLQ_S]
M_LO/U)*P[8JN_,73\JFXSF2%R=;>[/;Y_>OO]BM7L6Z<VB)&CZ:]["!!AJ"Y
M[VB7U9RPSM+;\9>FNZ.RR"-(EOGZ_")%CIRKP;+)\*[0_Z^^U#5EQ2E4K*FY
MSX*?V,_9YM+6W9JMRFZ7YV".Y\S7[-'ZINOS)"JX+K:_^KO^R5,FR=0HIJN
MRI:FN^;J\^#F\25-G25*F+_+W=+>\,#*X,+.Y/7V^[K%U/O]_B-'DG^G\_#T
M^\?2X7.2T4=NNI_%^B%#B=OD]_?X^Z_#[?#R^)>IQ*K![XZX\"%#BIRUYZ*Q
MQV:"I?#S^*.RQYJNS*O"[]/>]55YP2I7LW*:ZH6GZR=0I%MRC[[.\#5)8U&#
MT?_______P``````````````````````````````````````````````````
M`````````````````````````````````````````````````"'Y! $``&8`
M+ `````/``\```>?@.&:"@.X2%AH>"`0$$! \>*X@.!99-E558+AR64"CA"89B%
M*&4S)#X``EI1&0P,+X)8DR!/.0*495\F0&8B94I2`P47MEXC%#\="D$3.A%4
M90T-'"Y=)V `3< 5&C*41DP.63L`5S J1STI944M!F1D-SP`8_/S2&5#-%MB
F3@.E$AA!EVKDC<R"$(2X2-L1@.D> `E"6&DB! 8*/&!PM3, 0"`#L`
`
end|||Thanks for the prompt reply Bruce. The BOL info you listed was the
information I was looking at. However, I want my reports to run
automatically, with no user intervention against a list of server names.
What led me to believe this was possible was the quote:
> d.. Add a report parameter to specify a data source. For parameter values,
> you can either provide a static list of available values (in this case, the
> available values should be data sources you can use with the report) or
> define a query that retrieves a list of data sources at run time.
Is this still possible ?
"Bruce L-C [MVP]" wrote:
> Have you tried the examples provided? You mention data source parameters. It
> makes me wonder if you are looking at the right information. What you want
> to do is base your data source as an expression. From Books OnLine
> >>>>>>
> You can put an expression into a connection string to allow users to select
> the data source at run time. For example, suppose a multinational firm has
> data servers in several countries. With an expression-based connection
> string, a user who is running a sales report can select a data source for a
> particular country before running the report.
> The following example illustrates the use of a data source expression in a
> SQL Server connection string. The example assumes you have created a report
> parameter named ServerName:
> Copy Code
> ="data source=" & Parameters!ServerName.Value & ";initial
> catalog=AdventureWorks
> Data source expressions are processed at run time or when a report is
> previewed. The expression must be written in Visual Basic. Use the following
> guidelines when defining a data source expression:
> a.. Design the report using a static connection string. A static
> connection string refers to a connection string that is not set through an
> expression (for example, when you follow the steps for creating a
> report-specific or shared data source, you are defining a static connection
> string). Using a static connection string allows you to connect to the data
> source in Report Designer so that you can get the query results you need to
> create the report.
>
> b.. When defining the data source connection, do not use a shared data
> source. You cannot use a data source expression in a shared data source. You
> must define a report-specific data source for the report.
>
> c.. Specify credentials separately from the connection string. You can use
> stored credentials, prompted credentials, or integrated security.
>
> d.. Add a report parameter to specify a data source. For parameter values,
> you can either provide a static list of available values (in this case, the
> available values should be data sources you can use with the report) or
> define a query that retrieves a list of data sources at run time.
>
> e.. Be sure that the list of data sources shares the same database schema.
> All report design begins with schema information. If there is a mismatch
> between the schema used to define the report and the actual schema used by
> the report at run time, the report might not run.
>
> f.. Before publishing the report, replace the static connection string
> with an expression. Wait until you are finished designing the report before
> you replace the static connection string with an expression. Once you use an
> expression, you cannot execute the query in Report Designer. Furthermore,
> the field list in the Datasets window and the Parameters list will not
> update automatically.
> >>>>>>>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "DBAGURU" <DBAGURU@.discussions.microsoft.com> wrote in message
> news:9260F115-1407-4227-8A74-2D545456E620@.microsoft.com...
> > Hi, I have SQL 2005 sp2 installed on a test server that I run admin type
> > reports from. I have a report that I want to run against a list of
> > servers,
> > the list is from an SQL table on the same server as RS. I've found that
> > data
> > source parameters are possible, but I can't seem to get it to work. Can
> > anyone point to an example?
>
>|||You could have a main report that is empty. Then have a subreport that has a
parameter like the example. Embed the subreport into the main report, right
mouse click, parameters and map the parameter to one of the server. Repeat
with a different server with each subreport.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"DBAGURU" <DBAGURU@.discussions.microsoft.com> wrote in message
news:02A4BBD3-9376-4EA9-AE7D-A89FFE9FD75F@.microsoft.com...
> Thanks for the prompt reply Bruce. The BOL info you listed was the
> information I was looking at. However, I want my reports to run
> automatically, with no user intervention against a list of server names.
> What led me to believe this was possible was the quote:
>> d.. Add a report parameter to specify a data source. For parameter
>> values,
>> you can either provide a static list of available values (in this case,
>> the
>> available values should be data sources you can use with the report) or
>> define a query that retrieves a list of data sources at run time.
> Is this still possible ?
>
> "Bruce L-C [MVP]" wrote:
>> Have you tried the examples provided? You mention data source parameters.
>> It
>> makes me wonder if you are looking at the right information. What you
>> want
>> to do is base your data source as an expression. From Books OnLine
>> >>>>>>
>> You can put an expression into a connection string to allow users to
>> select
>> the data source at run time. For example, suppose a multinational firm
>> has
>> data servers in several countries. With an expression-based connection
>> string, a user who is running a sales report can select a data source for
>> a
>> particular country before running the report.
>> The following example illustrates the use of a data source expression in
>> a
>> SQL Server connection string. The example assumes you have created a
>> report
>> parameter named ServerName:
>> Copy Code
>> ="data source=" & Parameters!ServerName.Value & ";initial
>> catalog=AdventureWorks
>> Data source expressions are processed at run time or when a report is
>> previewed. The expression must be written in Visual Basic. Use the
>> following
>> guidelines when defining a data source expression:
>> a.. Design the report using a static connection string. A static
>> connection string refers to a connection string that is not set through
>> an
>> expression (for example, when you follow the steps for creating a
>> report-specific or shared data source, you are defining a static
>> connection
>> string). Using a static connection string allows you to connect to the
>> data
>> source in Report Designer so that you can get the query results you need
>> to
>> create the report.
>>
>> b.. When defining the data source connection, do not use a shared data
>> source. You cannot use a data source expression in a shared data source.
>> You
>> must define a report-specific data source for the report.
>>
>> c.. Specify credentials separately from the connection string. You can
>> use
>> stored credentials, prompted credentials, or integrated security.
>>
>> d.. Add a report parameter to specify a data source. For parameter
>> values,
>> you can either provide a static list of available values (in this case,
>> the
>> available values should be data sources you can use with the report) or
>> define a query that retrieves a list of data sources at run time.
>>
>> e.. Be sure that the list of data sources shares the same database
>> schema.
>> All report design begins with schema information. If there is a mismatch
>> between the schema used to define the report and the actual schema used
>> by
>> the report at run time, the report might not run.
>>
>> f.. Before publishing the report, replace the static connection string
>> with an expression. Wait until you are finished designing the report
>> before
>> you replace the static connection string with an expression. Once you use
>> an
>> expression, you cannot execute the query in Report Designer. Furthermore,
>> the field list in the Datasets window and the Parameters list will not
>> update automatically.
>> >>>>>>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "DBAGURU" <DBAGURU@.discussions.microsoft.com> wrote in message
>> news:9260F115-1407-4227-8A74-2D545456E620@.microsoft.com...
>> > Hi, I have SQL 2005 sp2 installed on a test server that I run admin
>> > type
>> > reports from. I have a report that I want to run against a list of
>> > servers,
>> > the list is from an SQL table on the same server as RS. I've found
>> > that
>> > data
>> > source parameters are possible, but I can't seem to get it to work.
>> > Can
>> > anyone point to an example?
>>|||I'll give it a shot & let you know. Thanks.
"Bruce L-C [MVP]" wrote:
> You could have a main report that is empty. Then have a subreport that has a
> parameter like the example. Embed the subreport into the main report, right
> mouse click, parameters and map the parameter to one of the server. Repeat
> with a different server with each subreport.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "DBAGURU" <DBAGURU@.discussions.microsoft.com> wrote in message
> news:02A4BBD3-9376-4EA9-AE7D-A89FFE9FD75F@.microsoft.com...
> > Thanks for the prompt reply Bruce. The BOL info you listed was the
> > information I was looking at. However, I want my reports to run
> > automatically, with no user intervention against a list of server names.
> > What led me to believe this was possible was the quote:
> >> d.. Add a report parameter to specify a data source. For parameter
> >> values,
> >> you can either provide a static list of available values (in this case,
> >> the
> >> available values should be data sources you can use with the report) or
> >> define a query that retrieves a list of data sources at run time.
> >
> > Is this still possible ?
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Have you tried the examples provided? You mention data source parameters.
> >> It
> >> makes me wonder if you are looking at the right information. What you
> >> want
> >> to do is base your data source as an expression. From Books OnLine
> >> >>>>>>
> >> You can put an expression into a connection string to allow users to
> >> select
> >> the data source at run time. For example, suppose a multinational firm
> >> has
> >> data servers in several countries. With an expression-based connection
> >> string, a user who is running a sales report can select a data source for
> >> a
> >> particular country before running the report.
> >>
> >> The following example illustrates the use of a data source expression in
> >> a
> >> SQL Server connection string. The example assumes you have created a
> >> report
> >> parameter named ServerName:
> >>
> >> Copy Code
> >> ="data source=" & Parameters!ServerName.Value & ";initial
> >> catalog=AdventureWorks
> >>
> >> Data source expressions are processed at run time or when a report is
> >> previewed. The expression must be written in Visual Basic. Use the
> >> following
> >> guidelines when defining a data source expression:
> >>
> >> a.. Design the report using a static connection string. A static
> >> connection string refers to a connection string that is not set through
> >> an
> >> expression (for example, when you follow the steps for creating a
> >> report-specific or shared data source, you are defining a static
> >> connection
> >> string). Using a static connection string allows you to connect to the
> >> data
> >> source in Report Designer so that you can get the query results you need
> >> to
> >> create the report.
> >>
> >>
> >> b.. When defining the data source connection, do not use a shared data
> >> source. You cannot use a data source expression in a shared data source.
> >> You
> >> must define a report-specific data source for the report.
> >>
> >>
> >> c.. Specify credentials separately from the connection string. You can
> >> use
> >> stored credentials, prompted credentials, or integrated security.
> >>
> >>
> >> d.. Add a report parameter to specify a data source. For parameter
> >> values,
> >> you can either provide a static list of available values (in this case,
> >> the
> >> available values should be data sources you can use with the report) or
> >> define a query that retrieves a list of data sources at run time.
> >>
> >>
> >> e.. Be sure that the list of data sources shares the same database
> >> schema.
> >> All report design begins with schema information. If there is a mismatch
> >> between the schema used to define the report and the actual schema used
> >> by
> >> the report at run time, the report might not run.
> >>
> >>
> >> f.. Before publishing the report, replace the static connection string
> >> with an expression. Wait until you are finished designing the report
> >> before
> >> you replace the static connection string with an expression. Once you use
> >> an
> >> expression, you cannot execute the query in Report Designer. Furthermore,
> >> the field list in the Datasets window and the Parameters list will not
> >> update automatically.
> >>
> >> >>>>>>>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "DBAGURU" <DBAGURU@.discussions.microsoft.com> wrote in message
> >> news:9260F115-1407-4227-8A74-2D545456E620@.microsoft.com...
> >> > Hi, I have SQL 2005 sp2 installed on a test server that I run admin
> >> > type
> >> > reports from. I have a report that I want to run against a list of
> >> > servers,
> >> > the list is from an SQL table on the same server as RS. I've found
> >> > that
> >> > data
> >> > source parameters are possible, but I can't seem to get it to work.
> >> > Can
> >> > anyone point to an example?
> >>
> >>
> >>
>
>

How can I know which patches I need?

I have sql server 2000 sp3a installed.
How can I know (and from where can I download) which patches have I to
install on my box?
Any help appreciated.
Regards.
Fabrizio Maccarrone
--
YAMSSQLU
(Yet Another MSSQL User)Hi,
Infact sp3a is the latest service pack available for SQL 2000.
How can I know (and from where can I download) which patches have I to
install on my box?
Have a look into the microsoft site once ina week to get the information.
http://www.microsoft.com/sql/
Thanks
Hari
MCDBA
"Fabrizio Maccarrone" <fabrizio (at) 7mates (punto) com> wrote in message
news:e05gLMcXEHA.2844@.TK2MSFTNGP11.phx.gbl...
> I have sql server 2000 sp3a installed.
> How can I know (and from where can I download) which patches have I to
> install on my box?
> Any help appreciated.
> Regards.
> --
> Fabrizio Maccarrone
> --
> YAMSSQLU
> (Yet Another MSSQL User)
>
>

How Can I Know What is the licensing mode that was installed for S

How Can I Know What is the licensing mode that was installed for SQLSERVER.
If the sqlserver was installed per processor Licensing for example, mi contract must be match with this installation type or isn't necessary?
select serverproperty('LicenseType')
and yes it should match the actual license you purchased :-)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message
news:46AA03FC-E4AE-4380-BA7E-B8847B1B74B6@.microsoft.com...
> How Can I Know What is the licensing mode that was installed for
SQLSERVER.
> If the sqlserver was installed per processor Licensing for example, mi
contract must be match with this installation type or isn't necessary?
>
|||Hi
If you get this!
http://support.microsoft.com/default...b;en-us;291332
John
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message
news:46AA03FC-E4AE-4380-BA7E-B8847B1B74B6@.microsoft.com...
> How Can I Know What is the licensing mode that was installed for
SQLSERVER.
> If the sqlserver was installed per processor Licensing for example, mi
contract must be match with this installation type or isn't necessary?
>
|||In the article it says that the bug with showing "DIABLED" was first
corrected in SQL2K Sp2. I'm on SP3 on all of my servers, but I still get
result "DISABLED" when I run the select serverproperty('LicenseType'). Does
anyone know if this is an issue that has come back with SP3?
Regards
Steen
"John Bell" <jbellnewsposts@.hotmail.com> skrev i en meddelelse
news:%23uvr0btXEHA.2364@.TK2MSFTNGP12.phx.gbl...
> Hi
> If you get this!
> http://support.microsoft.com/default...b;en-us;291332
> John
> "Lorena" <Lorena@.discussions.microsoft.com> wrote in message
> news:46AA03FC-E4AE-4380-BA7E-B8847B1B74B6@.microsoft.com...
> SQLSERVER.
> contract must be match with this installation type or isn't necessary?
>

How Can I Know What is the licensing mode that was installed for S

How Can I Know What is the licensing mode that was installed for SQLSERVER.
If the sqlserver was installed per processor Licensing for example, mi contr
act must be match with this installation type or isn't necessary?select serverproperty('LicenseType')
and yes it should match the actual license you purchased :-)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message
news:46AA03FC-E4AE-4380-BA7E-B8847B1B74B6@.microsoft.com...
> How Can I Know What is the licensing mode that was installed for
SQLSERVER.
> If the sqlserver was installed per processor Licensing for example, mi
contract must be match with this installation type or isn't necessary?
>|||Hi
If you get this!
http://support.microsoft.com/defaul...kb;en-us;291332
John
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message
news:46AA03FC-E4AE-4380-BA7E-B8847B1B74B6@.microsoft.com...
> How Can I Know What is the licensing mode that was installed for
SQLSERVER.
> If the sqlserver was installed per processor Licensing for example, mi
contract must be match with this installation type or isn't necessary?
>|||In the article it says that the bug with showing "DIABLED" was first
corrected in SQL2K Sp2. I'm on SP3 on all of my servers, but I still get
result "DISABLED" when I run the select serverproperty('LicenseType'). Does
anyone know if this is an issue that has come back with SP3?
Regards
Steen
"John Bell" <jbellnewsposts@.hotmail.com> skrev i en meddelelse
news:%23uvr0btXEHA.2364@.TK2MSFTNGP12.phx.gbl...
> Hi
> If you get this!
> http://support.microsoft.com/defaul...kb;en-us;291332
> John
> "Lorena" <Lorena@.discussions.microsoft.com> wrote in message
> news:46AA03FC-E4AE-4380-BA7E-B8847B1B74B6@.microsoft.com...
> SQLSERVER.
> contract must be match with this installation type or isn't necessary?
>

How Can I Know What is the licensing mode that was installed for S

How Can I Know What is the licensing mode that was installed for SQLSERVER.
If the sqlserver was installed per processor Licensing for example, mi contract must be match with this installation type or isn't necessary?select serverproperty('LicenseType')
and yes it should match the actual license you purchased :-)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message
news:46AA03FC-E4AE-4380-BA7E-B8847B1B74B6@.microsoft.com...
> How Can I Know What is the licensing mode that was installed for
SQLSERVER.
> If the sqlserver was installed per processor Licensing for example, mi
contract must be match with this installation type or isn't necessary?
>|||Hi
If you get this!
http://support.microsoft.com/default.aspx?scid=kb;en-us;291332
John
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message
news:46AA03FC-E4AE-4380-BA7E-B8847B1B74B6@.microsoft.com...
> How Can I Know What is the licensing mode that was installed for
SQLSERVER.
> If the sqlserver was installed per processor Licensing for example, mi
contract must be match with this installation type or isn't necessary?
>|||In the article it says that the bug with showing "DIABLED" was first
corrected in SQL2K Sp2. I'm on SP3 on all of my servers, but I still get
result "DISABLED" when I run the select serverproperty('LicenseType'). Does
anyone know if this is an issue that has come back with SP3?
Regards
Steen
"John Bell" <jbellnewsposts@.hotmail.com> skrev i en meddelelse
news:%23uvr0btXEHA.2364@.TK2MSFTNGP12.phx.gbl...
> Hi
> If you get this!
> http://support.microsoft.com/default.aspx?scid=kb;en-us;291332
> John
> "Lorena" <Lorena@.discussions.microsoft.com> wrote in message
> news:46AA03FC-E4AE-4380-BA7E-B8847B1B74B6@.microsoft.com...
> > How Can I Know What is the licensing mode that was installed for
> SQLSERVER.
> > If the sqlserver was installed per processor Licensing for example, mi
> contract must be match with this installation type or isn't necessary?
> >
> >
>

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

I have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!

All VS2005 pro comes with free SQL Server 2005 developer edition so you can install one in each Vista and do the needed configuration of enabling browser service, and enabling both TCP/IP and Named Pipes in configuration Manager and use the Surface Area Configuration tool to allow both local and remote and allow TCP/IP and Named Pipes. While you are at it also configure mixed Authentication so all developer can register each other SQL Server and access all in one place.

Another option is to uninstall Express and use Express Advanced that comes with Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

|||

Thanks for the reply. My question probably not clear for what we're trying to do. Actually, we are trying to install an instance of SQL Server 2005 Developer Edition (whcih come with Visual Studio Developer Edition into a machine running Windows 2000 SP4). And then I installed the Visual Studio 2005 professional edition into my company which is running on a Vista version Ultimate. Both installation success without any big problem. However, I would like to be able to manage that SQL Server 2005 Developer edition which installed in that Windows 2000 server through my local computer (Windows Vista with Visual Studio 2005 Prof installed). The problem is, there is a SQL Server 2005 Express edition installed into my computer (Vista) when I installed teh Visual Studio. And now, I tried to install the Sql Server Mangement Studio from SQL SErver 2005 Developer edition into my Vista machine, the system doesnt allow me to do it. So, do i have to uninstall the express edition in my local computer (vista) and then install the SSMS from the SQL Server 2005 Developer edition disc? Or, there's somoe other work around that it will allow me to install the SSMS from SQL Server 2005 Developer edition and the same time, keep the 2005 Express edition running in my local computer system. My reason is, the SSMS is just a management tools, it shouldnt depends on what version of DB engine installed into my local computer. Anyone please help

|||

I am one of the people who got the SQL Server developer edition price down from $450 to $50 list so I don't think such strange uses is valid. However you can uninstall the standard Express and use the Advanced which is also free and comes with most features of the full product including Management Studio. But you still have to do what I have explained in my first post because Express and the Developer edition comes with most services disabled.

|||

ic.. so uninstall the pre-installed sql server express from my computer (which has the visual studio 2005 prof edition installed) wont affect my visual studio 2005, right? Just want to make sure before i uninstall anything sorry about the noob question..

|||

Actually Microsoft now let you download the Management Studio for standard Express so download it below and install it. This link also gives you features compare of the Advanced and the Standard Express. But remember you have to go back and use my remote connection instruction. Hope this helps.

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

I have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!

All VS2005 pro comes with free SQL Server 2005 developer edition so you can install one in each Vista and do the needed configuration of enabling browser service, and enabling both TCP/IP and Named Pipes in configuration Manager and use the Surface Area Configuration tool to allow both local and remote and allow TCP/IP and Named Pipes. While you are at it also configure mixed Authentication so all developer can register each other SQL Server and access all in one place.

Another option is to uninstall Express and use Express Advanced that comes with Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

|||

Thanks for the reply. My question probably not clear for what we're trying to do. Actually, we are trying to install an instance of SQL Server 2005 Developer Edition (whcih come with Visual Studio Developer Edition into a machine running Windows 2000 SP4). And then I installed the Visual Studio 2005 professional edition into my company which is running on a Vista version Ultimate. Both installation success without any big problem. However, I would like to be able to manage that SQL Server 2005 Developer edition which installed in that Windows 2000 server through my local computer (Windows Vista with Visual Studio 2005 Prof installed). The problem is, there is a SQL Server 2005 Express edition installed into my computer (Vista) when I installed teh Visual Studio. And now, I tried to install the Sql Server Mangement Studio from SQL SErver 2005 Developer edition into my Vista machine, the system doesnt allow me to do it. So, do i have to uninstall the express edition in my local computer (vista) and then install the SSMS from the SQL Server 2005 Developer edition disc? Or, there's somoe other work around that it will allow me to install the SSMS from SQL Server 2005 Developer edition and the same time, keep the 2005 Express edition running in my local computer system. My reason is, the SSMS is just a management tools, it shouldnt depends on what version of DB engine installed into my local computer. Anyone please help

|||

I am one of the people who got the SQL Server developer edition price down from $450 to $50 list so I don't think such strange uses is valid. However you can uninstall the standard Express and use the Advanced which is also free and comes with most features of the full product including Management Studio. But you still have to do what I have explained in my first post because Express and the Developer edition comes with most services disabled.

|||

ic.. so uninstall the pre-installed sql server express from my computer (which has the visual studio 2005 prof edition installed) wont affect my visual studio 2005, right? Just want to make sure before i uninstall anything sorry about the noob question..

|||

Actually Microsoft now let you download the Management Studio for standard Express so download it below and install it. This link also gives you features compare of the Advanced and the Standard Express. But remember you have to go back and use my remote connection instruction. Hope this helps.

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

I have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!

All VS2005 pro comes with free SQL Server 2005 developer edition so you can install one in each Vista and do the needed configuration of enabling browser service, and enabling both TCP/IP and Named Pipes in configuration Manager and use the Surface Area Configuration tool to allow both local and remote and allow TCP/IP and Named Pipes. While you are at it also configure mixed Authentication so all developer can register each other SQL Server and access all in one place.

Another option is to uninstall Express and use Express Advanced that comes with Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

|||

Thanks for the reply. My question probably not clear for what we're trying to do. Actually, we are trying to install an instance of SQL Server 2005 Developer Edition (whcih come with Visual Studio Developer Edition into a machine running Windows 2000 SP4). And then I installed the Visual Studio 2005 professional edition into my company which is running on a Vista version Ultimate. Both installation success without any big problem. However, I would like to be able to manage that SQL Server 2005 Developer edition which installed in that Windows 2000 server through my local computer (Windows Vista with Visual Studio 2005 Prof installed). The problem is, there is a SQL Server 2005 Express edition installed into my computer (Vista) when I installed teh Visual Studio. And now, I tried to install the Sql Server Mangement Studio from SQL SErver 2005 Developer edition into my Vista machine, the system doesnt allow me to do it. So, do i have to uninstall the express edition in my local computer (vista) and then install the SSMS from the SQL Server 2005 Developer edition disc? Or, there's somoe other work around that it will allow me to install the SSMS from SQL Server 2005 Developer edition and the same time, keep the 2005 Express edition running in my local computer system. My reason is, the SSMS is just a management tools, it shouldnt depends on what version of DB engine installed into my local computer. Anyone please help

|||

I am one of the people who got the SQL Server developer edition price down from $450 to $50 list so I don't think such strange uses is valid. However you can uninstall the standard Express and use the Advanced which is also free and comes with most features of the full product including Management Studio. But you still have to do what I have explained in my first post because Express and the Developer edition comes with most services disabled.

|||

ic.. so uninstall the pre-installed sql server express from my computer (which has the visual studio 2005 prof edition installed) wont affect my visual studio 2005, right? Just want to make sure before i uninstall anything sorry about the noob question..

|||

Actually Microsoft now let you download the Management Studio for standard Express so download it below and install it. This link also gives you features compare of the Advanced and the Standard Express. But remember you have to go back and use my remote connection instruction. Hope this helps.

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

I have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!

All VS2005 pro comes with free SQL Server 2005 developer edition so you can install one in each Vista and do the needed configuration of enabling browser service, and enabling both TCP/IP and Named Pipes in configuration Manager and use the Surface Area Configuration tool to allow both local and remote and allow TCP/IP and Named Pipes. While you are at it also configure mixed Authentication so all developer can register each other SQL Server and access all in one place.

Another option is to uninstall Express and use Express Advanced that comes with Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

|||

Thanks for the reply. My question probably not clear for what we're trying to do. Actually, we are trying to install an instance of SQL Server 2005 Developer Edition (whcih come with Visual Studio Developer Edition into a machine running Windows 2000 SP4). And then I installed the Visual Studio 2005 professional edition into my company which is running on a Vista version Ultimate. Both installation success without any big problem. However, I would like to be able to manage that SQL Server 2005 Developer edition which installed in that Windows 2000 server through my local computer (Windows Vista with Visual Studio 2005 Prof installed). The problem is, there is a SQL Server 2005 Express edition installed into my computer (Vista) when I installed teh Visual Studio. And now, I tried to install the Sql Server Mangement Studio from SQL SErver 2005 Developer edition into my Vista machine, the system doesnt allow me to do it. So, do i have to uninstall the express edition in my local computer (vista) and then install the SSMS from the SQL Server 2005 Developer edition disc? Or, there's somoe other work around that it will allow me to install the SSMS from SQL Server 2005 Developer edition and the same time, keep the 2005 Express edition running in my local computer system. My reason is, the SSMS is just a management tools, it shouldnt depends on what version of DB engine installed into my local computer. Anyone please help

|||

I am one of the people who got the SQL Server developer edition price down from $450 to $50 list so I don't think such strange uses is valid. However you can uninstall the standard Express and use the Advanced which is also free and comes with most features of the full product including Management Studio. But you still have to do what I have explained in my first post because Express and the Developer edition comes with most services disabled.

|||

ic.. so uninstall the pre-installed sql server express from my computer (which has the visual studio 2005 prof edition installed) wont affect my visual studio 2005, right? Just want to make sure before i uninstall anything sorry about the noob question..

|||

Actually Microsoft now let you download the Management Studio for standard Express so download it below and install it. This link also gives you features compare of the Advanced and the Standard Express. But remember you have to go back and use my remote connection instruction. Hope this helps.

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

I have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!

All VS2005 pro comes with free SQL Server 2005 developer edition so you can install one in each Vista and do the needed configuration of enabling browser service, and enabling both TCP/IP and Named Pipes in configuration Manager and use the Surface Area Configuration tool to allow both local and remote and allow TCP/IP and Named Pipes. While you are at it also configure mixed Authentication so all developer can register each other SQL Server and access all in one place.

Another option is to uninstall Express and use Express Advanced that comes with Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

|||

Thanks for the reply. My question probably not clear for what we're trying to do. Actually, we are trying to install an instance of SQL Server 2005 Developer Edition (whcih come with Visual Studio Developer Edition into a machine running Windows 2000 SP4). And then I installed the Visual Studio 2005 professional edition into my company which is running on a Vista version Ultimate. Both installation success without any big problem. However, I would like to be able to manage that SQL Server 2005 Developer edition which installed in that Windows 2000 server through my local computer (Windows Vista with Visual Studio 2005 Prof installed). The problem is, there is a SQL Server 2005 Express edition installed into my computer (Vista) when I installed teh Visual Studio. And now, I tried to install the Sql Server Mangement Studio from SQL SErver 2005 Developer edition into my Vista machine, the system doesnt allow me to do it. So, do i have to uninstall the express edition in my local computer (vista) and then install the SSMS from the SQL Server 2005 Developer edition disc? Or, there's somoe other work around that it will allow me to install the SSMS from SQL Server 2005 Developer edition and the same time, keep the 2005 Express edition running in my local computer system. My reason is, the SSMS is just a management tools, it shouldnt depends on what version of DB engine installed into my local computer. Anyone please help

|||

I am one of the people who got the SQL Server developer edition price down from $450 to $50 list so I don't think such strange uses is valid. However you can uninstall the standard Express and use the Advanced which is also free and comes with most features of the full product including Management Studio. But you still have to do what I have explained in my first post because Express and the Developer edition comes with most services disabled.

|||

ic.. so uninstall the pre-installed sql server express from my computer (which has the visual studio 2005 prof edition installed) wont affect my visual studio 2005, right? Just want to make sure before i uninstall anything sorry about the noob question..

|||

Actually Microsoft now let you download the Management Studio for standard Express so download it below and install it. This link also gives you features compare of the Advanced and the Standard Express. But remember you have to go back and use my remote connection instruction. Hope this helps.

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

I have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!

All VS2005 pro comes with free SQL Server 2005 developer edition so you can install one in each Vista and do the needed configuration of enabling browser service, and enabling both TCP/IP and Named Pipes in configuration Manager and use the Surface Area Configuration tool to allow both local and remote and allow TCP/IP and Named Pipes. While you are at it also configure mixed Authentication so all developer can register each other SQL Server and access all in one place.

Another option is to uninstall Express and use Express Advanced that comes with Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

|||

Thanks for the reply. My question probably not clear for what we're trying to do. Actually, we are trying to install an instance of SQL Server 2005 Developer Edition (whcih come with Visual Studio Developer Edition into a machine running Windows 2000 SP4). And then I installed the Visual Studio 2005 professional edition into my company which is running on a Vista version Ultimate. Both installation success without any big problem. However, I would like to be able to manage that SQL Server 2005 Developer edition which installed in that Windows 2000 server through my local computer (Windows Vista with Visual Studio 2005 Prof installed). The problem is, there is a SQL Server 2005 Express edition installed into my computer (Vista) when I installed teh Visual Studio. And now, I tried to install the Sql Server Mangement Studio from SQL SErver 2005 Developer edition into my Vista machine, the system doesnt allow me to do it. So, do i have to uninstall the express edition in my local computer (vista) and then install the SSMS from the SQL Server 2005 Developer edition disc? Or, there's somoe other work around that it will allow me to install the SSMS from SQL Server 2005 Developer edition and the same time, keep the 2005 Express edition running in my local computer system. My reason is, the SSMS is just a management tools, it shouldnt depends on what version of DB engine installed into my local computer. Anyone please help

|||

I am one of the people who got the SQL Server developer edition price down from $450 to $50 list so I don't think such strange uses is valid. However you can uninstall the standard Express and use the Advanced which is also free and comes with most features of the full product including Management Studio. But you still have to do what I have explained in my first post because Express and the Developer edition comes with most services disabled.

|||

ic.. so uninstall the pre-installed sql server express from my computer (which has the visual studio 2005 prof edition installed) wont affect my visual studio 2005, right? Just want to make sure before i uninstall anything sorry about the noob question..

|||

Actually Microsoft now let you download the Management Studio for standard Express so download it below and install it. This link also gives you features compare of the Advanced and the Standard Express. But remember you have to go back and use my remote connection instruction. Hope this helps.

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

how can i install reporting services 2005

Hi,
I installed sql server 2005 enterprise edition and visual studion 2005
professional.
but i am unable to create any projects. how can i create a report project '
(i cant find a business intelligence project anyw here
thanks in advanceYou need to install the BI client tools from the SQL Server CD/DVD.
Note that you did not need VS 2005 unless you are writing custom assemblies
or using VS specific tools (like the new controls found in VS 2005).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RP" <RP@.discussions.microsoft.com> wrote in message
news:D06128B6-9838-47EE-A853-3BAD7187B66F@.microsoft.com...
> Hi,
> I installed sql server 2005 enterprise edition and visual studion 2005
> professional.
> but i am unable to create any projects. how can i create a report project
> '
> (i cant find a business intelligence project anyw here
> thanks in advance|||Bruce,
Can you tell me what options i have to select when installing sql server to
select BIclient tools ?
Thanks
"Bruce L-C [MVP]" wrote:
> You need to install the BI client tools from the SQL Server CD/DVD.
> Note that you did not need VS 2005 unless you are writing custom assemblies
> or using VS specific tools (like the new controls found in VS 2005).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RP" <RP@.discussions.microsoft.com> wrote in message
> news:D06128B6-9838-47EE-A853-3BAD7187B66F@.microsoft.com...
> > Hi,
> > I installed sql server 2005 enterprise edition and visual studion 2005
> > professional.
> > but i am unable to create any projects. how can i create a report project
> > '
> > (i cant find a business intelligence project anyw here
> > thanks in advance
>
>|||I haven't installed it for awhile but it was obvious at the time.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RP" <RP@.discussions.microsoft.com> wrote in message
news:410BFD9A-F285-434A-985B-D18837488701@.microsoft.com...
> Bruce,
> Can you tell me what options i have to select when installing sql server
> to
> select BIclient tools ?
> Thanks
> "Bruce L-C [MVP]" wrote:
>> You need to install the BI client tools from the SQL Server CD/DVD.
>> Note that you did not need VS 2005 unless you are writing custom
>> assemblies
>> or using VS specific tools (like the new controls found in VS 2005).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RP" <RP@.discussions.microsoft.com> wrote in message
>> news:D06128B6-9838-47EE-A853-3BAD7187B66F@.microsoft.com...
>> > Hi,
>> > I installed sql server 2005 enterprise edition and visual studion 2005
>> > professional.
>> > but i am unable to create any projects. how can i create a report
>> > project
>> > '
>> > (i cant find a business intelligence project anyw here
>> > thanks in advance
>>

How can I have SQL 9.0 instance in management studio

I've installed SQL Server 2005 and SQL Server 2000 side by side.

Now when I open SQL Server Management Studio it runs the SQL version 8 that belongs to SQL Server 2000.

How can I start with SQL Server 2005 (SQL 9.0) to create new database under the new features?

thank you.

First, register the SQL 2005 instance...click 'view...registered servers'...then, in the registered servers window, register your SQL 2005 instance appropriately.

Once you've registered the server, right click on it and choose 'connect...object explorer'. If the Object Explorer pane isn't viewable, make it so by choosing 'view...object explorer' from the menus. Then, in Object Explorer simply expand the instance to view all objects, nodes, etc.

HTH

|||

Thanks Chad,

I have two Instances of SQL Server. one is ServerName which is based on SQL 8.0 (2000) and another one is ServerName/SQLEXPRESS based on SQL 9.0.

If I want to work with features in SQL Server 2005 I have to choose SQLEXPRESS instance.

I don't sure about SQL Server Express edition. only I know it has fewer features rather than SQL Server 2005 Enterprise edition.

I really want an instance of SQL Server 2005 Enterprise edition.

What can I do?

Thanks Chad.

|||

I see. Well, if you're going to use the instance for development use only, your best bet is to get a copy of the Developer Edition, which is exactly the same as the Enterprise Edition, however it is not licensed for commercial/production use, only developmental/test/demo use.

If you want an Enterprise Version, then you'd need to purchase it.

Alternatively, you could download a 180-day trial version for free as well.

Do you have an MSDN subscription? If so, you can download the developer edition and use it. If not, you'll have to purchase it as well.

Go here for more information on the developer edition, trial edition, and information on how to get them:

http://www.microsoft.com/sql/editions/developer/default.mspx

HTH

How can I find out whether SSIS is installed in the server?

Thanks a lot.

What exactly do you mean? By script/scheduling or simply looking for file system for any DLL or whatever?

|||Have a look at the service SQL Server Integration Services, if it is present you have SSIS installed. YOu can check that by open the SCM or type in the "net start" on the commandline on the server.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Thanks. I checked SQL Server Integration Services. It is disabled. I just started. Thanks.