instance of sql server

I am learning SQL Server 2005 and I was told to install a second instance of
SQL Server 2005 on my machine. How can I install a second instance of SQL
Server 2005 on my machine

I already installed SQL Server 2005, I guess this is my first instance. To
install a second instance, do I just run setup again?Yes, just run setup again to create a 'named' instance. Setup will ask you
for an instance name.

A computer can have up to 1 default instance (probably what you installed
initially) but many named instances. To connect to the default instance
after installation, specify only the computer name. For the named instance,
specify computer name and instance name separated by a backslash
('ComputerName\InstanceName').

--
Hope this helps.

Dan Guzman
SQL Server MVP

"David" <david_vcp@.hotmail.com> wrote in message
news:bMKdnc_BtsngZ9fZRVn-rg@.comcast.com...
>I am learning SQL Server 2005 and I was told to install a second instance
>of SQL Server 2005 on my machine. How can I install a second instance of
>SQL Server 2005 on my machine
> I already installed SQL Server 2005, I guess this is my first instance.
> To install a second instance, do I just run setup again?

instance name

Hello,
This is the present setup.
Server A --> sql server 2000
Server B --> sql server 2005

On my machine I point to an instance name of sql server 2000 to use. i.e.
sqlserver2000Server\instance1
On my local machine I have installed sql server 2000 and can use the enterprise manager. Have the Admin rights.
I have setup a daily backup job on sql 2000...

On server B, I installed sql 2005. Restored the sql 2000 backup onto sql 2005. And now I have the sql 2000 database in sql server 2005.

Now I can use the sql 2005 by refering to the serverB name (Not an instance).

In Server A, the applications are using a login name (sql authentication) i.e. username, password.

Questions
1) How do I install sql 2005 on my local machine (Remember that I have sql 2000)

2) If I should run the setup for sql 2005 on local machine, then during the installation, do I give it an instance name or should this instance name be done on the server i.e. server B ?

Thanks

1) How do I install sql 2005 on my local machine (Remember that I have sql 2000)

SQL Server 2000 and SQL Server 2005 can be installed side by side successfully on the same machine. You just need to run setup to install SQL Server 2005.

2) If I should run the setup for sql 2005 on local machine, then during the installation, do I give it an instance name or should this instance name be done on the server i.e. server B ?

Based on your scenario, I assume you install both SQL Server 2000 and 2005 as non-cluster installation. The instance name for SQL Server 2000 and 2005 should be unique on the same machine. So the instance names may be the same on different mahcines. But when we connect to an instance, we use machinename\instancename to specify which one to connect.

instance name

Hi,
my machine name is webdev5
when I run sql server, it asks for the server name, I enter 'webdev5'
and using windows authentication.
where can I find out about the instance name? on my machine? I am using
2005
thank you
kenInstance name is most commonly used when there are multiple installations of
SQL Server on the same computer. If you have only one SQL Server, and if you
did not deselect the "Use DEFAULT Instance" option when installing, then
your instance is named 'webdev5'.
Read about Instance and Instance Names in Books Online.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegroups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>|||Hi,
If you are logged into SQL Server Management studio then connect to SQL
server and open a Query window and execute
SELECT @.@.SERVERNAME
If its a default instance it just returns the machine name. This will be
trated as the SQL Server name. If you have Servername\Instancename;
then you have installed a named SQL Server instance.
You could also get this information from Errorlog of SQL Server. There you
have to look for Server name:.............
Thanks
Hari
SQL Server MVP
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegroups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>sql

Instance name

I have two machines install SQL Server 2000.
One has the same name as my machine name, eg. alan.
Another machine has the name as 'Local'.
Why is that the case ?Alan
> Another machine has the name as 'Local'.
> Why is that the case ?
A person, who installed SQL Server specified LOCAL as name of the SQL Server
If you want to change the name ,just delete the registration from EM and
create a new one with name of the machine
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>I have two machines install SQL Server 2000.
> One has the same name as my machine name, eg. alan.
> Another machine has the name as 'Local'.
> Why is that the case ?
>|||How do I create a new one with name of the machine when setup ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
> Alan
> A person, who installed SQL Server specified LOCAL as name of the SQL
> Server
> If you want to change the name ,just delete the registration from EM and
> create a new one with name of the machine
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>|||Hi,
I really don't understand why I installed SQL Server 2000 on 2 machines, one
in my office, one at home, why one has the machine name, eg. "alan", at my
office. But on my home machine, the server instance is called "LOCAL"?
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eixndxxoGHA.1600@.TK2MSFTNGP04.phx.gbl...
> How do I create a new one with name of the machine when setup ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
>

instance name

Hi,
my machine name is webdev5
when I run sql server, it asks for the server name, I enter 'webdev5'
and using windows authentication.
where can I find out about the instance name? on my machine? I am using
2005
thank you
ken
Instance name is most commonly used when there are multiple installations of
SQL Server on the same computer. If you have only one SQL Server, and if you
did not deselect the "Use DEFAULT Instance" option when installing, then
your instance is named 'webdev5'.
Read about Instance and Instance Names in Books Online.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegro ups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>
|||Hi,
If you are logged into SQL Server Management studio then connect to SQL
server and open a Query window and execute
SELECT @.@.SERVERNAME
If its a default instance it just returns the machine name. This will be
trated as the SQL Server name. If you have Servername\Instancename;
then you have installed a named SQL Server instance.
You could also get this information from Errorlog of SQL Server. There you
have to look for Server name:.............
Thanks
Hari
SQL Server MVP
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegro ups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>

Instance name

I have two machines install SQL Server 2000.
One has the same name as my machine name, eg. alan.
Another machine has the name as 'Local'.
Why is that the case ?Alan
> Another machine has the name as 'Local'.
> Why is that the case ?
A person, who installed SQL Server specified LOCAL as name of the SQL Server
If you want to change the name ,just delete the registration from EM and
create a new one with name of the machine
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>I have two machines install SQL Server 2000.
> One has the same name as my machine name, eg. alan.
> Another machine has the name as 'Local'.
> Why is that the case ?
>|||How do I create a new one with name of the machine when setup ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
> Alan
>> Another machine has the name as 'Local'.
>> Why is that the case ?
> A person, who installed SQL Server specified LOCAL as name of the SQL
> Server
> If you want to change the name ,just delete the registration from EM and
> create a new one with name of the machine
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>>I have two machines install SQL Server 2000.
>> One has the same name as my machine name, eg. alan.
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>|||Hi,
I really don't understand why I installed SQL Server 2000 on 2 machines, one
in my office, one at home, why one has the machine name, eg. "alan", at my
office. But on my home machine, the server instance is called "LOCAL"?
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eixndxxoGHA.1600@.TK2MSFTNGP04.phx.gbl...
> How do I create a new one with name of the machine when setup ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
>> Alan
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>> A person, who installed SQL Server specified LOCAL as name of the SQL
>> Server
>> If you want to change the name ,just delete the registration from EM and
>> create a new one with name of the machine
>>
>> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>>I have two machines install SQL Server 2000.
>> One has the same name as my machine name, eg. alan.
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>>
>

instance name

Hi,
my machine name is webdev5
when I run sql server, it asks for the server name, I enter 'webdev5'
and using windows authentication.
where can I find out about the instance name? on my machine? I am using
2005
thank you
kenInstance name is most commonly used when there are multiple installations of
SQL Server on the same computer. If you have only one SQL Server, and if you
did not deselect the "Use DEFAULT Instance" option when installing, then
your instance is named 'webdev5'.
Read about Instance and Instance Names in Books Online.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegroups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>|||Hi,
If you are logged into SQL Server Management studio then connect to SQL
server and open a Query window and execute
SELECT @.@.SERVERNAME
If its a default instance it just returns the machine name. This will be
trated as the SQL Server name. If you have Servername\Instancename;
then you have installed a named SQL Server instance.
You could also get this information from Errorlog of SQL Server. There you
have to look for Server name:.............
Thanks
Hari
SQL Server MVP
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegroups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>sql

instance

Hello,
This is the present setup.
Server A --> sql server 2000
Server B --> sql server 2005
On my machine I point to an instance name of sql server 2000 to use. i.e.
sqlserver2000Server\instance1
On my local machine I have installed sql server 2000 and can use the
enterprise manager. Have the Admin rights.
I have setup a daily backup job on sql 2000...
On server B, I installed sql 2005. Restored the sql 2000 backup onto sql
2005. And now I have the sql 2000 database in sql server 2005.
Now I can use the sql 2005 by refering to the serverB name (Not an instance)
.
In Server A, the applications are using a login name (sql authentication)
i.e. username, password.
Questions
1) How do I install sql 2005 on my local machine (Remember that I have sql
2000)
2) If I should run the setup for sql 2005 on local machine, then during the
installation, do I give it an instance name or should this instance name be
done on the server i.e. server B ?
ThanksHi
> Questions
> 1) How do I install sql 2005 on my local machine (Remember that I have sql
> 2000)
SQL Server 2005 is going be a named instance. They can co-exist.

> 2) If I should run the setup for sql 2005 on local machine, then during
> the
> installation, do I give it an instance name or should this instance name
> be
> done on the server i.e. server B ?
On the server when you are running the installation script
"farshad" <farshad@.discussions.microsoft.com> wrote in message
news:55564446-FB63-4BC4-9C1E-599300E7A0CB@.microsoft.com...
> Hello,
> This is the present setup.
> Server A --> sql server 2000
> Server B --> sql server 2005
> On my machine I point to an instance name of sql server 2000 to use. i.e.
> sqlserver2000Server\instance1
> On my local machine I have installed sql server 2000 and can use the
> enterprise manager. Have the Admin rights.
> I have setup a daily backup job on sql 2000...
> On server B, I installed sql 2005. Restored the sql 2000 backup onto sql
> 2005. And now I have the sql 2000 database in sql server 2005.
> Now I can use the sql 2005 by refering to the serverB name (Not an
> instance).
> In Server A, the applications are using a login name (sql authentication)
> i.e. username, password.
> Questions
> 1) How do I install sql 2005 on my local machine (Remember that I have sql
> 2000)
> 2) If I should run the setup for sql 2005 on local machine, then during
> the
> installation, do I give it an instance name or should this instance name
> be
> done on the server i.e. server B ?
> Thanks|||Not sure if this make a difference but during the installation of sql server
2005 on the server i.e. server B, I chose the default instance.
Thanks
"Uri Dimant" wrote:

> Hi
> SQL Server 2005 is going be a named instance. They can co-exist.
>
> On the server when you are running the installation script
>
> "farshad" <farshad@.discussions.microsoft.com> wrote in message
> news:55564446-FB63-4BC4-9C1E-599300E7A0CB@.microsoft.com...
>
>|||farshad (farshad@.discussions.microsoft.com) writes:
> Not sure if this make a difference but during the installation of sql
> server 2005 on the server i.e. server B, I chose the default instance.
Be careful when you install on ServerA. If you select "Default instance"
it will upgrade your SQL 2000 instance (if you have a default instance,
that is. This was a little unclear in your post.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Installting sqlserver 2005 on the client machine for windows application

Hi
I developed a windows application in Visual studio 2005 and the database is sqlexpress.
I wanted my application to run on another system.For that i have installed sqlexpress 2005 on that machine.But that machine doesn't show me any enterprise manager or query manager for sqlserver.
Is there any solution for this.

Thanks

hi,

yes... you have to separately download and install SQL Server Management Studio Express... http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

regards

|||SQL Server Express does not come with EM or Query Analyzer. These two components have been merged into the SQL Server Managment Studio. The SQL Server Management Studio Express (which actually is a stripped of SQL Server Managment Studio (aka SSMS)) can be downloaded separately from Microsoft or is already included in the Express Advanced Edition (which actually includes some other cool features like Reporting Services for SQL Server Express).

http://msdn.microsoft.com/vstudio/express/sql/download/

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.desql

Installing, creating database, updating schema?

Hi there,

I have a database on my test machine that will need to be installed on users
machines. I would like to create the database with the given schema on the
users machine and also with some suitable default values in the tables. I
note that although I can script the schema so that re-creating the structure
of the database is simple on the users machine, I cannot script the contents
of the tables also (automatically). What I would like to do is take some
kind of "snapshot", save it as a script and then run this script in my
installer. Are there any tools available to do this?

Secondly and related to the above: if I subsequently make changes to the
database schema (adding or removing columns, altering, adding or removing
stored procedures etc.), how do I roll out those changes to a customer? Do
I need to hand code an "upgrade" script, or is there a tool that will
produce a "difference between" script I can run on the customers machine?

Thanks for any tips you can give me about this.

RobinRobin Tucker (idontwanttobespammedanymore@.reallyidont.com) writes:
> I have a database on my test machine that will need to be installed on
> users machines. I would like to create the database with the given
> schema on the users machine and also with some suitable default values
> in the tables. I note that although I can script the schema so that
> re-creating the structure of the database is simple on the users
> machine, I cannot script the contents of the tables also
> (automatically). What I would like to do is take some kind of
> "snapshot", save it as a script and then run this script in my
> installer. Are there any tools available to do this?

SQL Server MVP Vyas Kondreddi has a tool that generates INSERT statements
from a table: http://vyaskn.tripod.com/code.htm#inserts

> Secondly and related to the above: if I subsequently make changes to the
> database schema (adding or removing columns, altering, adding or
> removing stored procedures etc.), how do I roll out those changes to a
> customer? Do I need to hand code an "upgrade" script, or is there a
> tool that will produce a "difference between" script I can run on the
> customers machine?

There are several paths to take. Many people use a third-party tool that
compares two databases and then generates a script. Very popular is
SQL Compare from Red Gate. I have not used this tool myself, though.

A better approach in my opinion, is to have all code under source control.
In this case, your development database is not your master, but the
version-control system is. A basic version-control system will not
provide any update scripts for you, as a version-control system is a
general container for all sorts of code. What you do is that when you
ship, you set a label, and then you can later inquire the VCS for
changes since that label. There are plenty of VCS on the market. Very
popular among Microsoft customers is Visual SourceSafe which is part
of Visual Studio. VSS is not a very good for serious configuraton
management, but it's easy to get started with, and works perfectly OK for
smaller groups.

There are a couple of third-party tools that are specialized for doing
version control on SQL Server. Typically, they sit on top of SourceSafe
or some other generic VCS. Unfortunately, I don't recall any names right
now.

In our shop we use VSS, together with a toolset that includes tools for
loading stored procedures (with a lot of bells and whistles, like
automatic insert of SET NOCOUNT ON, WITH ENCRYPTION (on request),
automatic GRANT, a preprocessor). We also have a tool that builds
update scripts from the checkins in SourceSafe. The tool also maintains
its own tables in the target databases, so that we know in which state
each database is in. This toolset is available as freeware on
http://www.abaris.se/abaperls/. (I uploaded the latest version of it,
just the other day, by the way.)

Judging from your question, you may be best off with something like
SQL Compare in the short run. But if more people get involved with
your work, you should definitely consider to move to a version-
control system. There are a few things to keep in mind with updating
from a model database:

o A development may contain junk code and junk tables from tests and
experiments.
o A table change may be as simple as adding a nullable column, but it
can also be very complex if you are making a major restructiring. A
tool probably needs some help in this case.
o If you have preloaded data that you want to deploy, you need a tool
where you selectively can migrate data.

The way we handle pre-loaded data by the way, is to enter the data in
Excel books, and then we have a tool that generates INSERT files from
the the Excel files. The files does not contain any INSERT statements,
but calls to stored procedures which inserts or updates. The reason we
use Excel is that some of our files are quite complex. and we have
different settings for different customers.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Very interesting. Thanks for your comprehensive reply. I think I will need
to study this question at some length before deciding which approach to
take.

Robin

"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns9595F230624F5Yazorman@.127.0.0.1...
> Robin Tucker (idontwanttobespammedanymore@.reallyidont.com) writes:
>> I have a database on my test machine that will need to be installed on
>> users machines. I would like to create the database with the given
>> schema on the users machine and also with some suitable default values
>> in the tables. I note that although I can script the schema so that
>> re-creating the structure of the database is simple on the users
>> machine, I cannot script the contents of the tables also
>> (automatically). What I would like to do is take some kind of
>> "snapshot", save it as a script and then run this script in my
>> installer. Are there any tools available to do this?
> SQL Server MVP Vyas Kondreddi has a tool that generates INSERT statements
> from a table: http://vyaskn.tripod.com/code.htm#inserts
>> Secondly and related to the above: if I subsequently make changes to the
>> database schema (adding or removing columns, altering, adding or
>> removing stored procedures etc.), how do I roll out those changes to a
>> customer? Do I need to hand code an "upgrade" script, or is there a
>> tool that will produce a "difference between" script I can run on the
>> customers machine?
> There are several paths to take. Many people use a third-party tool that
> compares two databases and then generates a script. Very popular is
> SQL Compare from Red Gate. I have not used this tool myself, though.
> A better approach in my opinion, is to have all code under source control.
> In this case, your development database is not your master, but the
> version-control system is. A basic version-control system will not
> provide any update scripts for you, as a version-control system is a
> general container for all sorts of code. What you do is that when you
> ship, you set a label, and then you can later inquire the VCS for
> changes since that label. There are plenty of VCS on the market. Very
> popular among Microsoft customers is Visual SourceSafe which is part
> of Visual Studio. VSS is not a very good for serious configuraton
> management, but it's easy to get started with, and works perfectly OK for
> smaller groups.
> There are a couple of third-party tools that are specialized for doing
> version control on SQL Server. Typically, they sit on top of SourceSafe
> or some other generic VCS. Unfortunately, I don't recall any names right
> now.
> In our shop we use VSS, together with a toolset that includes tools for
> loading stored procedures (with a lot of bells and whistles, like
> automatic insert of SET NOCOUNT ON, WITH ENCRYPTION (on request),
> automatic GRANT, a preprocessor). We also have a tool that builds
> update scripts from the checkins in SourceSafe. The tool also maintains
> its own tables in the target databases, so that we know in which state
> each database is in. This toolset is available as freeware on
> http://www.abaris.se/abaperls/. (I uploaded the latest version of it,
> just the other day, by the way.)
> Judging from your question, you may be best off with something like
> SQL Compare in the short run. But if more people get involved with
> your work, you should definitely consider to move to a version-
> control system. There are a few things to keep in mind with updating
> from a model database:
> o A development may contain junk code and junk tables from tests and
> experiments.
> o A table change may be as simple as adding a nullable column, but it
> can also be very complex if you are making a major restructiring. A
> tool probably needs some help in this case.
> o If you have preloaded data that you want to deploy, you need a tool
> where you selectively can migrate data.
> The way we handle pre-loaded data by the way, is to enter the data in
> Excel books, and then we have a tool that generates INSERT files from
> the the Excel files. The files does not contain any INSERT statements,
> but calls to stored procedures which inserts or updates. The reason we
> use Excel is that some of our files are quite complex. and we have
> different settings for different customers.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||I would recommend you have a look at Innovartis DB Ghost at
http://www.innovartis.co.uk/ It is designed specifically for your
requirement i.e. automated database change management, generation of
upgrade scripts, build verification, database synchronization,
deployment of changes, integration with version control system, handles
schema & data.

John McGrath
SQL Server DBA MCSE

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!sql

Installing two instances of Report server

Can we install two instances of report server on the same machine?. We want to use the same hardware for two different methods of custom authentication. Both the server applications would then talk to the same database.

cvajre,

Here's a step by step way of implementing 2 reporting instances.

http://bloggingabout.net/blogs/mglaser/archive/2006/12/18/multiple-reporting-services-instances-on-one-machine.aspx

Ham

Installing SS2005 RTM on machine which previously had CTP versions

Hi, when trying to Install SS2005 RTM on a machine which previously had CTP versions, the install is failing with "instance all ready exists" for SQL server an analysis server after about 30 minutes, the old versions where removed successfully via control panel.

I vaguely remember an article saying MS had a tool to clean up all the old references to the various CTP versions, but cant find a link for it, it is late so I maybe dreaming, but could somebody point me to it? I will be very grateful

Thanks

Pat

The file can be found in your CTP installation dir (sqlbuw.exe).
Shameless request to visit my blog where the exact location can be found :-) But a Search will get you going too :-)

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 SQLNCLI

I would like to install the SQLNCLI on our IIS machine, and possibly other
workstations that need to connect to SQL Server 2005. Where is the correct
location to get the most update to date version of SQLNCLI? Also need the
installation instructions and considerations.
Thanks
Greg.
Greg,
It's here in the latest Feature Pack: -
http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en
As a standalone it seems it will be in the feature pack.
Chris
"Greg Larsen" <gregalarsen@.removeit.msn.com> wrote in message
news:7BB4CC6F-73EA-4416-AB4E-6EE5BB8B19D8@.microsoft.com...
>I would like to install the SQLNCLI on our IIS machine, and possibly other
> workstations that need to connect to SQL Server 2005. Where is the
> correct
> location to get the most update to date version of SQLNCLI? Also need the
> installation instructions and considerations.
> Thanks
> Greg.

Installing SQLExpress on XPHome

The software install hangs when the install goes out to check for my machine configuration.

No error codes or anything. I have to go to task manager to stop the install. It may can take two or three times to End Task before the setup actually stops.

Thanks for any help.

Check out the Setup log files located at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files for more information about setup problems. You should also check the summary.txt file that is one directory up as that frequently points to the log where you will find the problem listed.

Regards,
Mike

|||

I think I have the same problem, the installer doesn't go further than "checking installed IIS" and I think I have found the correct log.

In the end of the file it says something about IIS, it looks like this:

<EndFunc Name='Write_sqlWellKnownAccountNames' Return='0' GetLastError='1008'>
PerfTime Stop: Write_sqlWellKnownAccountNames : Fri Apr 07 20:53:08 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='1008'>
Action ended 20:53:08: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (c) (74:44) [20:53:08:906]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action 20:53:08: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Detecting Installed IIS
Action start 20:53:08: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (c) (74:24) [20:53:08:906]: Invoking remote custom action. DLL: C:\DOCUME~1\Simon\LOKALA~1\Temp\MSI17.tmp, Entrypoint: CheckIIS
<Func Name='LaunchFunction'>
Function=CheckIIS
MSI (c) (74!34) [20:53:08:921]: PROPERTY CHANGE: Modifying InitStatus property. Its current value is '16'. Its new value: '20'.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: CheckIIS
PerfTime Start: CheckIIS : Fri Apr 07 20:53:08 2006
<Func Name='CheckIIS'>
Action 20:53:08: CheckIIS. Detecting Installed IIS
MSI (c) (74!34) [20:53:08:937]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is '0'.
MSI (c) (74!34) [20:53:08:937]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is '1'.
Skipping RS Feature Dependency Check
<Func Name='GetXMLAttributeValue'>
Error to find XML node /configuration/system.web/compilation
<EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'>
Failed to get ModuleID_RS_Server when getting the ASP Temp directory.

However, I don't know what to do about it. Do you know anything else about the problem after reading this? How should I do to install SQL Server Express?

|||

The end of my log-file looks identical to yours... I dont't seem to figure it out either..
Anybody?
Thanks!

EDIT:

After uninstalling, cleaning registry and restarting for about 40 times I found an old CD with SQL Server 2000 Evaluation Copy.

When trying to install this I get the error "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup."

When I restart I see no improvent...

Does this help helping us?

Thanks

/Martin

|||

I am having the exact same problem , it hangs where

it says checking IIs . I have been trying to get this

running for hours now . Microsoft please help us

I need this program to work very soon .....

Best wishes to all

TWS

Installing SQLExpress on XPHome

The software install hangs when the install goes out to check for my machine configuration.

No error codes or anything. I have to go to task manager to stop the install. It may can take two or three times to End Task before the setup actually stops.

Thanks for any help.

Check out the Setup log files located at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files for more information about setup problems. You should also check the summary.txt file that is one directory up as that frequently points to the log where you will find the problem listed.

Regards,
Mike

|||

I think I have the same problem, the installer doesn't go further than "checking installed IIS" and I think I have found the correct log.

In the end of the file it says something about IIS, it looks like this:

<EndFunc Name='Write_sqlWellKnownAccountNames' Return='0' GetLastError='1008'>
PerfTime Stop: Write_sqlWellKnownAccountNames : Fri Apr 07 20:53:08 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='1008'>
Action ended 20:53:08: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (c) (74:44) [20:53:08:906]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action 20:53:08: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Detecting Installed IIS
Action start 20:53:08: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (c) (74:24) [20:53:08:906]: Invoking remote custom action. DLL: C:\DOCUME~1\Simon\LOKALA~1\Temp\MSI17.tmp, Entrypoint: CheckIIS
<Func Name='LaunchFunction'>
Function=CheckIIS
MSI (c) (74!34) [20:53:08:921]: PROPERTY CHANGE: Modifying InitStatus property. Its current value is '16'. Its new value: '20'.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: CheckIIS
PerfTime Start: CheckIIS : Fri Apr 07 20:53:08 2006
<Func Name='CheckIIS'>
Action 20:53:08: CheckIIS. Detecting Installed IIS
MSI (c) (74!34) [20:53:08:937]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is '0'.
MSI (c) (74!34) [20:53:08:937]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is '1'.
Skipping RS Feature Dependency Check
<Func Name='GetXMLAttributeValue'>
Error to find XML node /configuration/system.web/compilation
<EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'>
Failed to get ModuleID_RS_Server when getting the ASP Temp directory.

However, I don't know what to do about it. Do you know anything else about the problem after reading this? How should I do to install SQL Server Express?

|||

The end of my log-file looks identical to yours... I dont't seem to figure it out either..
Anybody?
Thanks!

EDIT:

After uninstalling, cleaning registry and restarting for about 40 times I found an old CD with SQL Server 2000 Evaluation Copy.

When trying to install this I get the error "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup."

When I restart I see no improvent...

Does this help helping us?

Thanks

/Martin

|||

I am having the exact same problem , it hangs where

it says checking IIs . I have been trying to get this

running for hours now . Microsoft please help us

I need this program to work very soon .....

Best wishes to all

TWS

sql

installing sql2005 standard problems.

I have an issue with trying to install SQL 2005 standard on my XP machine.
I get an .hta file that is not readable and when I btpass that I get a
pop-up message:
please go to the control panel to install and configure system components.
WTF?
PLease assist...
Gene
Geno (genegodsey@.hotmail.com) writes:
> I have an issue with trying to install SQL 2005 standard on my XP machine.
> I get an .hta file that is not readable and when I btpass that I get a
> pop-up message:
> please go to the control panel to install and configure system components.
From where did you get the media? Was it a download? Did you buy a
CD/DVD?
If Autorun does not set in, splash.hta is indeed the file to click to
get it going.
Note that you need IE6 SP1 to install SQL 2005. (And SP2 of Windows XP.)
I know I once tried to run the install on a machine with only IE5 - the
splash.hta produced a bunch of cryptc error messages instead of telling
me just to keep out.
If the file is entirely unreadable, it appears that you have bad
media, and you should get a replacement.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||On Wed, 5 Apr 2006 12:19:12 -0400, "Geno" <genegodsey@.hotmail.com>
wrote:

>I have an issue with trying to install SQL 2005 standard on my XP machine.
>I get an .hta file that is not readable and when I btpass that I get a
>pop-up message:
>please go to the control panel to install and configure system components.
>WTF?
>PLease assist...
>Gene
In addition to the points that Erland made, assuming your disk
structure is the same as I have seen, navigate to the Servers and/or
Tools folders and run Setup.exe. Gets round the .hta problem, as far
as I am aware.
Andrew Watt [MVP]

Installing SQL Server Standard Edition 2005 after Installing SQL Server Express 2005

Hi

I have installed SQL Server Express 2005 on my machine.

I want to install SQL Server Standard Edition 2005 on my machine to check new services it has.

Can these 2 Editions coexist with each other, or any troubles you think might encounter?

Thanks

Yes, you can run these two editions on the same machine. By default, the instance name for an Express instance is SQLExpress. For the other editions, it is MSSQLSERVER, so you shouldn't have a instance name conflict, which is the only "gotcha" that people run into from time to time.

Thanks,
Sam Lester (MSFT)

|||One other gotcha is the management tools. SQL Express installs it's command line tools which will conflict with the management tools shipped with Standard Edition. See the following blog post regarding this topic: http://blogs.msdn.com/jpapiez/archive/2005/06/07/426418.aspx.|||

Hi,

Thanks for your answer.

It seems that I have installed finally SQL Server 2005 Standard Edition on my machine, but:

My previous Express Edition has gone, it seems my previous one has just been upgraded to Standard Edition.

Installing SQL Server Standard Edition 2005 after Installing SQL Server Express 2005

Hi

I have installed SQL Server Express 2005 on my machine.

I want to install SQL Server Standard Edition 2005 on my machine to check new services it has.

Can these 2 Editions coexist with each other, or any troubles you think might encounter?

Thanks

Yes, you can run these two editions on the same machine. By default, the instance name for an Express instance is SQLExpress. For the other editions, it is MSSQLSERVER, so you shouldn't have a instance name conflict, which is the only "gotcha" that people run into from time to time.

Thanks,
Sam Lester (MSFT)

|||One other gotcha is the management tools. SQL Express installs it's command line tools which will conflict with the management tools shipped with Standard Edition. See the following blog post regarding this topic: http://blogs.msdn.com/jpapiez/archive/2005/06/07/426418.aspx.|||

Hi,

Thanks for your answer.

It seems that I have installed finally SQL Server 2005 Standard Edition on my machine, but:

My previous Express Edition has gone, it seems my previous one has just been upgraded to Standard Edition.sql

Installing SQL Server Reporting Services

Current machine Windows XP Pro with sp2. Successfully installed all portions
of Reporting Services with exception to Report Designer to SQL Server 2000.
The message which appears at almost the conclusion of installation states
"There is a problem with this Windows Installer package. A program run as
part of the setup did not finish as expected. Contact your support personnel
or package vendor.". Then it rolls back the installation.
Looking through the Event Logs it shows there was an error registered due to
the msvcr71.dll. The error value is:
Error value: C0000013
Disk type: 5
This file is on the CD for the Reporting Services and it should not be
damaged, in use, etc. by any other process other than that of the installer.
After installing all but the designer, I even installed service pack 1 for
Reporting Services and still have the same result.
Ideas?
Your thoughts on this matter will be appreciated.Just wanted to post the resolution to the situation below.
From the event log it showed that it had a problem with the msvcr71.dll.
Comparing the datetime of the file on the CD to that of the system, they were
different.
So I copied the contents of the CD to the hard drive to point to the older
file to see if it would help. The result, it did not help so I put the
original file from the CD back into the Reportin Services install directory
of my hard drive.
In reading other posts regarding installs, there was a file mentioned in the
01SEP2004 post by Daniel Reib [MSFT] to an 'install problem' (original
subject for posting), which was RSRun.msi.
I installed this file with Visual Studio .NET open and within a project. It
seemed to be having a problem without VS.NET being open, at least on 2
machines. In the past attempts the event log showed that it was having a
problem starting up the VS.NET and that is why I opened the application and
project while installing. The install was successful and the Report Designer
is working.
Hope this helps some other people that experienced a similar issue.
-Guy
"Guy G" wrote:
> Current machine Windows XP Pro with sp2. Successfully installed all portions
> of Reporting Services with exception to Report Designer to SQL Server 2000.
> The message which appears at almost the conclusion of installation states
> "There is a problem with this Windows Installer package. A program run as
> part of the setup did not finish as expected. Contact your support personnel
> or package vendor.". Then it rolls back the installation.
> Looking through the Event Logs it shows there was an error registered due to
> the msvcr71.dll. The error value is:
> Error value: C0000013
> Disk type: 5
> This file is on the CD for the Reporting Services and it should not be
> damaged, in use, etc. by any other process other than that of the installer.
> After installing all but the designer, I even installed service pack 1 for
> Reporting Services and still have the same result.
> Ideas?
> Your thoughts on this matter will be appreciated.
>