Instance name contains a dash

Hello

We are in the process of upgrading our SQL 2K server to a cluster environment. Currently the server is setup as a default instance running on a single box with log shipping as a warm backup

It is required to create an instance name for the new cluster to work. My question is

1) Has anybody tried to have an instance name that dash (-) in it.

Example: \\SERVERNAME\xxx-xx-xxx

I am told that it is not possible to have a server instance named this way. Would like to know if this naming convention is possible under SQL2K If not what is the suggested workaround

This will save a lot of time in application modifications

Thanks in advance

Gabe J

Don't do it, invest the work now and you will have a much more relaxing future. If it takes much time to modify your application to work with another instance name you probably have a design issue in your application.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks for the advice.

SQL 2000 books online does not specifically mention that dash (-) cannot be used in an instance name ( you can even create tables and other objects in a database that contains a dash in them why not instance name?). Could you please be a little more specific as what exactly the issues would be if the instance name contained dashes.

I have to justify the requirement to make program changes, for that I need to understand what the issues are going to be.

Appreciate your help

Gabe J

|||

I don′t have any specific issue in mind that I can tell of if you use special characters in instance names. Sure you can have special characters in Tables and other objects, but "What you can do" is often the opposite "What is prefered to do". As from my experience I wouldn′t bet on that horse and take the risk of naming the object or even the instance with special characters, although I can. Thats just my two cents, perhaps someone has another opinion about that, but unless you have a hand on your code and have the opportunity to correct that thing (as of my opinion) I would that effort in it.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

In general I agree with what Jens has to say. As far as I know, putting a dash in the instance name is supported. I remember back in the 7.0 days testers went to a lot of trouble to make sure that dashes worked fine in the server name. I don't remember finding any issues there (but it was a long time ago). I do seem to remember that our automation at the time needed multiple changes to run on those servers. :(

The effort was worth it for Microsoft but might not be for your arbitrary application.

|||

One of the suggestions made to get around with this issue is to place a registry hack by adding a key called "Connectto" in the following node

HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MSSQLServer\Client\

And specify the value as the OLD server name = "XXX-XX-XXX"

and data = DBNMPNTW,\\<New Server name>\pipe\MSSQL$<Instance name>\sql\query

When applications connect irrespective of the connection string, this registry value connects to the SQL server instance.

Seems to work . Agree this is just a workaround instead of solving the real issue of making application modifications.

Has anyone tried this ?

Thanks for you suggestions

|||

Not sure where you heard about this registry hack, but I would not recommend using it unless it was mentioned in a specific Microsoft article...This ***hack*** may not work after a future release. Looks like this workaround maybe setting up a alias for the server. If this is the case, you should use SQL Server Configuration Manager instead.

As others have said, I am not really sure if dashes are supported, but I would not use...SQL Server maybe able to handle it fine, but some other external component may not.

Thanks,

Peter Saddow

|||

Agree that this is a **hack**. The SQL Server is a 2K version not 2005. How do I use the configuration manager to set up and alias name for the instance at the server level?

Thanks

|||

For SQL Server 2000, use SQL Server Client Network Utility. Select the "Alias" tab and enter the required information.

Hope this helps,

Peter Saddow

Instance caching without default parameter values

I am working with a well-studied DBA who claims that all report parameters
must have default values in order to configure instance caching. Is there
any truth to this? I don't see anything of this kind in BOL.
We actually get rsProcessAborted errors if they don't have defaults (even
though reports only execute when all parameters are provided.)
--
Paul Turley, MCSD, MCDBA, MSF, MCT
nospam at scout-master.comThis might help someone figure it out. It looks like a Reporting Services
issue to me...I'm the DBA ;)
----
--
Start snippet from Report_Server.log
----
--
aspnet_wp!processing!eec!4/26/2005-16:51:08:: e ERROR: An exception has
occurred in data source 'AGG'. Details: System.IndexOutOfRangeException:
Index was outside the bounds of the array.
at
Microsoft.ReportingServices.Library.IndexedStreamHeader.get_LastUncompressed
Offset()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.get_Interna
lUncompressedLength()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer(
)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Strea
m store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStr
eam(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName,
Int32 chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.b..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.g..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.aw.c()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.aw.b()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)
aspnet_wp!processing!d20!4/26/2005-16:51:08:: e ERROR: An exception has
occurred in data source 'AGG2'. Details: System.IndexOutOfRangeException:
Index was outside the bounds of the array.
at
Microsoft.ReportingServices.Library.IndexedStreamHeader.get_LastUncompressed
Offset()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.get_Interna
lUncompressedLength()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer(
)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Strea
m store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStr
eam(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName,
Int32 chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.b..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.g..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.aw.c()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.aw.b()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)
aspnet_wp!processing!eec!4/26/2005-16:51:08:: e ERROR: An exception has
occurred. Trying to abort processing. Details:
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.ReportingServices.Library.IndexedStreamHeader.get_LastUncompressed
Offset()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.get_Interna
lUncompressedLength()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer(
)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Strea
m store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStr
eam(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName,
Int32 chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.b..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.g..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.aw.c()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.aw.b()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)
aspnet_wp!processing!d20!4/26/2005-16:51:08:: e ERROR: An exception has
occurred. Trying to abort processing. Details:
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.ReportingServices.Library.IndexedStreamHeader.get_LastUncompressed
Offset()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.get_Interna
lUncompressedLength()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer(
)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Strea
m store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStr
eam(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName,
Int32 chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.b..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.g..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.aw.c()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.aw.b()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)
aspnet_wp!processing!eec!4/26/2005-16:51:08:: i INFO: Merge abort handler
called. Aborting data sources ...
aspnet_wp!processing!eec!4/26/2005-16:51:08:: i INFO: Data source
'Staging_xxxxxx_Reader': Abort handler called. CanAbort = True.
aspnet_wp!processing!d20!4/26/2005-16:51:08:: i INFO: Some other thread is
aborting processing.
aspnet_wp!processing!eec!4/26/2005-16:51:08:: i INFO: Abort callback
successful.
aspnet_wp!processing!d20!4/26/2005-16:51:08:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.ReportingServices.Library.IndexedStreamHeader.get_LastUncompressed
Offset()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.get_Interna
lUncompressedLength()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer(
)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Strea
m store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStr
eam(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName,
Int32 chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.b..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.g..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.aw.c()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.aw.b()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)
-- End of inner exception stack trace --
aspnet_wp!processing!d20!4/26/2005-16:51:08:: e ERROR: Data source
'Staging_xxxxxx_Reader': An error has occurred. Details:
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
System.IndexOutOfRangeException: Index was outside the bounds of the array.
aspnet_wp!processing!d20!4/26/2005-16:51:08:: w WARN: Data source
'Staging_xxxxxx_Reader': Report processing has been aborted.
aspnet_wp!processing!d20!4/26/2005-16:51:08:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at
Microsoft.ReportingServices.Library.IndexedStreamHeader.get_LastUncompressed
Offset()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.get_Interna
lUncompressedLength()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer(
)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Strea
m store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStr
eam(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName,
Int32 chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.b..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.g..ctor(DataSet A_0,
Int32 A_1, UInt32 A_2, GetReportChunk A_3)
at Microsoft.ReportingServices.ReportProcessing.aw.c()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)
at Microsoft.ReportingServices.ReportProcessing.aw.b()
at Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)
-- End of inner exception stack trace --
aspnet_wp!library!d20!04/26/2005-16:51:08:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!d20!04/26/2005-16:51:08:: e ERROR: Reporting Services
error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An
error has occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
System.IndexOutOfRangeException: Index was outside the bounds of the array.
----
--
End snippet from Report_Server.log
----
--
-- HTH
Regards,
Don R. Watters
Walt Disney Internet Group
"Paul Turley" <nospam@.turleyfamily_dot_org> wrote in message
news:ONjOkApSFHA.3184@.TK2MSFTNGP14.phx.gbl...
> I am working with a well-studied DBA who claims that all report parameters
> must have default values in order to configure instance caching. Is there
> any truth to this? I don't see anything of this kind in BOL.
> We actually get rsProcessAborted errors if they don't have defaults (even
> though reports only execute when all parameters are provided.)
> --
> Paul Turley, MCSD, MCDBA, MSF, MCT
> nospam at scout-master.com
>|||As for the first part, no, the cache is based on a combination of report,
credentials, and parameter values. As for the second one, I don't know what
specific error you are getting.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul Turley" <nospam@.turleyfamily_dot_org> wrote in message
news:ONjOkApSFHA.3184@.TK2MSFTNGP14.phx.gbl...
>I am working with a well-studied DBA who claims that all report parameters
>must have default values in order to configure instance caching. Is there
>any truth to this? I don't see anything of this kind in BOL.
> We actually get rsProcessAborted errors if they don't have defaults (even
> though reports only execute when all parameters are provided.)
> --
> Paul Turley, MCSD, MCDBA, MSF, MCT
> nospam at scout-master.com
>|||The specific error is in my other post, on Paul's main thread.
-- Don
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%235mdZw6SFHA.616@.TK2MSFTNGP12.phx.gbl...
> As for the first part, no, the cache is based on a combination of report,
> credentials, and parameter values. As for the second one, I don't know
what
> specific error you are getting.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Paul Turley" <nospam@.turleyfamily_dot_org> wrote in message
> news:ONjOkApSFHA.3184@.TK2MSFTNGP14.phx.gbl...
> >I am working with a well-studied DBA who claims that all report
parameters
> >must have default values in order to configure instance caching. Is
there
> >any truth to this? I don't see anything of this kind in BOL.
> >
> > We actually get rsProcessAborted errors if they don't have defaults
(even
> > though reports only execute when all parameters are provided.)
> >
> > --
> > Paul Turley, MCSD, MCDBA, MSF, MCT
> > nospam at scout-master.com
> >
>|||Try refreshing your dataset and deleting and readding the dataset to your
table.
"Paul Turley" wrote:
> I am working with a well-studied DBA who claims that all report parameters
> must have default values in order to configure instance caching. Is there
> any truth to this? I don't see anything of this kind in BOL.
> We actually get rsProcessAborted errors if they don't have defaults (even
> though reports only execute when all parameters are provided.)
> --
> Paul Turley, MCSD, MCDBA, MSF, MCT
> nospam at scout-master.com
>
>

Installing SQLServer2005 but Preserve Current SQLServer2000

I have a default installation of SQLServer2000 on a host running
Win2003. I want to install SQLServer2005 on the same machine, but
preserve the original SQLServer2000 installation. How do I do this --
install into new directory? new directory and named instance? just
new named instance? What stumbling blocks could I run into?red_valsen@.yahoo.com wrote:

Quote:

Originally Posted by

I have a default installation of SQLServer2000 on a host running
Win2003. I want to install SQLServer2005 on the same machine, but
preserve the original SQLServer2000 installation. How do I do this --
install into new directory? new directory and named instance? just
new named instance? What stumbling blocks could I run into?

I believe new directory and named instance is necessary and sufficient.|||2005 will work side-by-side with 2000 as a named instance. Just note
that there is no Microsoft tool to migrate a database back to 2000.

You will want to set a different data/backups folder - e.g. \mssql2005.

* * * * * * * * * * * * * * * * * * * * * *

red_valsen@.yahoo.com wrote:

Quote:

Originally Posted by

I have a default installation of SQLServer2000 on a host running
Win2003. I want to install SQLServer2005 on the same machine, but
preserve the original SQLServer2000 installation. How do I do this --
install into new directory? new directory and named instance? just
new named instance? What stumbling blocks could I run into?

installing sql server 2005 express with advanced services sp2

I just installed SQL Server 2005 Express Edition with Advanced Services SP2
with the default installations options. I found afterwards that there are
no tools installed to help me view and manage the database files. Could I
just rerun the installation and add those in? Which options do I need to
choose to install those needed tools?
Daniel
SQL Server 2005 Express Edition with Advanced Services has SQL Server
Management Studio Express with it.
This is one of the additional feature of this edition of SQL Server 2005
Express.
However, there is no SSMSE with SQL Server 2005 Express Edition
I have not setup this edition of SQL Server yet (I'm downloading it now)
however in the other editions of SQL Server there is a setting in Components
to Install window in SQL Server setup. You should check Client
Tools\Management Tools option in SQL Server Setup to be able to install this
GUI to manage your SQL Server Instances.
I'll let you know how to install management tools after testing it.
P.S.
Daniel, I just do not want to cause any confusion so I wanted to clarify
this:
SQL Server 2005 Express Edition with Advanced Services is a next generation
of SQL Server 2005 Express Edition. They all are for free.
Ekrem nsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
> AFAIK, the tools is a separate download (SQL Server Management Studio
> Express).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Daniel Brower" <newstbs@.cableone.net> wrote in message
> news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl.. .
>
|||Hello Daniel,
I performed the test.
To install only SQL Server Management Studio Express for SQL Server 2005
Express Edition with Advanced Services follow this path:
- Extract your setup files to a folder using this command "sqlexpr_adv.exe
/x". Setup will ask you for a folder for extraction.
- Go to that extracted setup files folder and open Setup folder and find
"sqlserver2005_ssmsee" file and run it.
This will install SQL Server Management Studio Express
P.S.
Run "sqlserver2005_ssmsee_x64" if your system is x64.
Ekrem nsoy
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl.. .
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2
>with the default installations options. I found afterwards that there are
>no tools installed to help me view and manage the database files. Could I
>just rerun the installation and add those in? Which options do I need to
>choose to install those needed tools?
> Daniel
>

installing sql server 2005 express with advanced services sp2

I just installed SQL Server 2005 Express Edition with Advanced Services SP2
with the default installations options. I found afterwards that there are
no tools installed to help me view and manage the database files. Could I
just rerun the installation and add those in? Which options do I need to
choose to install those needed tools?
DanielAFAIK, the tools is a separate download (SQL Server Management Studio Express).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2 with the default
>installations options. I found afterwards that there are no tools installed to help me view and
>manage the database files. Could I just rerun the installation and add those in? Which options do
>I need to choose to install those needed tools?
> Daniel
>|||SQL Server 2005 Express Edition with Advanced Services has SQL Server
Management Studio Express with it.
This is one of the additional feature of this edition of SQL Server 2005
Express.
However, there is no SSMSE with SQL Server 2005 Express Edition
I have not setup this edition of SQL Server yet (I'm downloading it now)
however in the other editions of SQL Server there is a setting in Components
to Install window in SQL Server setup. You should check Client
Tools\Management Tools option in SQL Server Setup to be able to install this
GUI to manage your SQL Server Instances.
I'll let you know how to install management tools after testing it.
P.S.
Daniel, I just do not want to cause any confusion so I wanted to clarify
this:
SQL Server 2005 Express Edition with Advanced Services is a next generation
of SQL Server 2005 Express Edition. They all are for free.
--
Ekrem Önsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
> AFAIK, the tools is a separate download (SQL Server Management Studio
> Express).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Daniel Brower" <newstbs@.cableone.net> wrote in message
> news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>>I just installed SQL Server 2005 Express Edition with Advanced Services
>>SP2 with the default installations options. I found afterwards that there
>>are no tools installed to help me view and manage the database files.
>>Could I just rerun the installation and add those in? Which options do I
>>need to choose to install those needed tools?
>> Daniel
>|||Hello Daniel,
I performed the test.
To install only SQL Server Management Studio Express for SQL Server 2005
Express Edition with Advanced Services follow this path:
- Extract your setup files to a folder using this command "sqlexpr_adv.exe
/x". Setup will ask you for a folder for extraction.
- Go to that extracted setup files folder and open Setup folder and find
"sqlserver2005_ssmsee" file and run it.
This will install SQL Server Management Studio Express
P.S.
Run "sqlserver2005_ssmsee_x64" if your system is x64.
--
Ekrem Önsoy
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2
>with the default installations options. I found afterwards that there are
>no tools installed to help me view and manage the database files. Could I
>just rerun the installation and add those in? Which options do I need to
>choose to install those needed tools?
> Daniel
>|||> SQL Server 2005 Express Edition with Advanced Services has SQL Server Management Studio Express
> with it.
Ahh, cool. I didn't know that. :-)
> SQL Server 2005 Express Edition with Advanced Services is a next generation of SQL Server 2005
> Express Edition. They all are for free.
To the best of my knowledge, the two are both equally "current generation". The regular express is
kept with minimal features so it is quick to download and (can) only install core services. This can
be important both for download speed and to not "litter" the machine with unnecessary stuff.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:238E4914-3A21-468D-BC2B-6EDE2D7B411E@.microsoft.com...
> SQL Server 2005 Express Edition with Advanced Services has SQL Server Management Studio Express
> with it.
> This is one of the additional feature of this edition of SQL Server 2005 Express.
> However, there is no SSMSE with SQL Server 2005 Express Edition
> I have not setup this edition of SQL Server yet (I'm downloading it now) however in the other
> editions of SQL Server there is a setting in Components to Install window in SQL Server setup. You
> should check Client Tools\Management Tools option in SQL Server Setup to be able to install this
> GUI to manage your SQL Server Instances.
> I'll let you know how to install management tools after testing it.
> P.S.
> Daniel, I just do not want to cause any confusion so I wanted to clarify this:
> SQL Server 2005 Express Edition with Advanced Services is a next generation of SQL Server 2005
> Express Edition. They all are for free.
> --
> Ekrem Önsoy
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
>> AFAIK, the tools is a separate download (SQL Server Management Studio Express).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Daniel Brower" <newstbs@.cableone.net> wrote in message
>> news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>>I just installed SQL Server 2005 Express Edition with Advanced Services SP2 with the default
>>installations options. I found afterwards that there are no tools installed to help me view and
>>manage the database files. Could I just rerun the installation and add those in? Which options
>>do I need to choose to install those needed tools?
>> Daniel
>>
>

installing sql server 2005 express with advanced services sp2

I just installed SQL Server 2005 Express Edition with Advanced Services SP2
with the default installations options. I found afterwards that there are
no tools installed to help me view and manage the database files. Could I
just rerun the installation and add those in? Which options do I need to
choose to install those needed tools?
DanielAFAIK, the tools is a separate download (SQL Server Management Studio Expres
s).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2
with the default
>installations options. I found afterwards that there are no tools installe
d to help me view and
>manage the database files. Could I just rerun the installation and add tho
se in? Which options do
>I need to choose to install those needed tools?
> Daniel
>|||SQL Server 2005 Express Edition with Advanced Services has SQL Server
Management Studio Express with it.
This is one of the additional feature of this edition of SQL Server 2005
Express.
However, there is no SSMSE with SQL Server 2005 Express Edition
I have not setup this edition of SQL Server yet (I'm downloading it now)
however in the other editions of SQL Server there is a setting in Components
to Install window in SQL Server setup. You should check Client
Tools\Management Tools option in SQL Server Setup to be able to install this
GUI to manage your SQL Server Instances.
I'll let you know how to install management tools after testing it.
P.S.
Daniel, I just do not want to cause any confusion so I wanted to clarify
this:
SQL Server 2005 Express Edition with Advanced Services is a next generation
of SQL Server 2005 Express Edition. They all are for free.
Ekrem nsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
> AFAIK, the tools is a separate download (SQL Server Management Studio
> Express).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Daniel Brower" <newstbs@.cableone.net> wrote in message
> news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>|||Hello Daniel,
I performed the test.
To install only SQL Server Management Studio Express for SQL Server 2005
Express Edition with Advanced Services follow this path:
- Extract your setup files to a folder using this command "sqlexpr_adv.exe
/x". Setup will ask you for a folder for extraction.
- Go to that extracted setup files folder and open Setup folder and find
"sqlserver2005_ssmsee" file and run it.
This will install SQL Server Management Studio Express
P.S.
Run "sqlserver2005_ssmsee_x64" if your system is x64.
Ekrem nsoy
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2
>with the default installations options. I found afterwards that there are
>no tools installed to help me view and manage the database files. Could I
>just rerun the installation and add those in? Which options do I need to
>choose to install those needed tools?
> Daniel
>|||> SQL Server 2005 Express Edition with Advanced Services has SQL Server Management Studio Ex
press
> with it.
Ahh, cool. I didn't know that. :-)

> SQL Server 2005 Express Edition with Advanced Services is a next generatio
n of SQL Server 2005
> Express Edition. They all are for free.
To the best of my knowledge, the two are both equally "current generation".
The regular express is
kept with minimal features so it is quick to download and (can) only install
core services. This can
be important both for download speed and to not "litter" the machine with un
necessary stuff.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:238E4914-3A21-468D-BC2B-6EDE2D7B411E@.microsoft.com...
> SQL Server 2005 Express Edition with Advanced Services has SQL Server Mana
gement Studio Express
> with it.
> This is one of the additional feature of this edition of SQL Server 2005 E
xpress.
> However, there is no SSMSE with SQL Server 2005 Express Edition
> I have not setup this edition of SQL Server yet (I'm downloading it now) h
owever in the other
> editions of SQL Server there is a setting in Components to Install window
in SQL Server setup. You
> should check Client Tools\Management Tools option in SQL Server Setup to b
e able to install this
> GUI to manage your SQL Server Instances.
> I'll let you know how to install management tools after testing it.
> P.S.
> Daniel, I just do not want to cause any confusion so I wanted to clarify t
his:
> SQL Server 2005 Express Edition with Advanced Services is a next generatio
n of SQL Server 2005
> Express Edition. They all are for free.
> --
> Ekrem nsoy
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
>sql

Installing Sql Reporting services on a seperate website

Hi
I am installing SQL reporting services. By Default the SQL reporting
services gets installed on the Default Website.
My IIS 6.0 website is running as a seperate website and not on Default Web
Site.
Is it possible to install SQL reporting services on a separate website other
than the Default Website?
Any help is appreciated.
Regards
-RizI don't know the answer to your question however, if it does install the
Reporting services to the default website, can't you just create a new
virtual directory on your seperate website pointing at the same directory and
with the same setup?
"Riz" wrote:
> Hi
> I am installing SQL reporting services. By Default the SQL reporting
> services gets installed on the Default Website.
> My IIS 6.0 website is running as a seperate website and not on Default Web
> Site.
> Is it possible to install SQL reporting services on a separate website other
> than the Default Website?
> Any help is appreciated.
> Regards
> -Riz|||Setup does not allow you to install to anything but the default website.
Once installed you can move it to another website. You should follow these
directions to move the vdir:
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Riz" <Riz@.discussions.microsoft.com> wrote in message
news:B4B60697-70F8-42E2-BC59-E8C24BA3BD21@.microsoft.com...
> Hi
> I am installing SQL reporting services. By Default the SQL reporting
> services gets installed on the Default Website.
> My IIS 6.0 website is running as a seperate website and not on Default Web
> Site.
> Is it possible to install SQL reporting services on a separate website
> other
> than the Default Website?
> Any help is appreciated.
> Regards
> -Riz

Installing SQL 2005 Developer Edition

I want to install SQL 2005 developer edition (and want to keep a
default instance of SQL 2000 running on my machine)
Couple of months ago I installed VS.net 2005 edition and it installed
SQL express edition? So I went to Add/Remove programs and removed SQL
express (along with management studio express).
Now, when I started to install SQL 2005 developer edition it is giving
me option for either default instance or named instance. If I select
default instance it won't allow me install because there is already a
default instance for SQL 2000.
Is there any issues installing named instance of SQL 2005? Sometimes
based on my past experience, it is best to install a default instance
because code samples and other things won't work if you install named
instance.
Please advice.It's not posible to have SQL Server 2000 default instance and SQL Server
2005 default instance on the same machine. One of them should be named
instance in this case
"c_shah" <shah.chirag@.netzero.net> wrote in message
news:1141398000.428873.219560@.j33g2000cwa.googlegroups.com...
>I want to install SQL 2005 developer edition (and want to keep a
> default instance of SQL 2000 running on my machine)
> Couple of months ago I installed VS.net 2005 edition and it installed
> SQL express edition? So I went to Add/Remove programs and removed SQL
> express (along with management studio express).
> Now, when I started to install SQL 2005 developer edition it is giving
> me option for either default instance or named instance. If I select
> default instance it won't allow me install because there is already a
> default instance for SQL 2000.
> Is there any issues installing named instance of SQL 2005? Sometimes
> based on my past experience, it is best to install a default instance
> because code samples and other things won't work if you install named
> instance.
> Please advice.
>|||I have both installed on the same machine without a problem
2000 is default, 2005 is named
http://sqlservercode.blogspot.com/|||I just installed it looks like that it is working fine. Thank you.|||Sure thing - please read again what I've read with attention :)
"SQL" <denis.gobo@.gmail.com> wrote in message
news:1141402303.677170.51520@.e56g2000cwe.googlegroups.com...
>I have both installed on the same machine without a problem
> 2000 is default, 2005 is named
> http://sqlservercode.blogspot.com/
>