Installation Error: run

Showing posts with label run. Show all posts

Friday, March 30, 2012

Installing MSSQL 2005 SP2 deleted all documents in my documents

hi,
Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
running it on XP SP2.
anybody run into this? restoring OS does not bring back the files.
any help would be appreciated.
Doron, shalom
I have just installed SP2 on XP SP2 and it worked just fine. What is the
path of your SQL Server instalaltion?
<doron.almog@.gmail.com> wrote in message
news:1172531419.194567.175800@.h3g2000cwc.googlegro ups.com...
> hi,
> Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
> running it on XP SP2.
> anybody run into this? restoring OS does not bring back the files.
> any help would be appreciated.
>

Installing MSSQL 2005 SP2 deleted all documents in my documents

hi,
Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
running it on XP SP2.
anybody run into this? restoring OS does not bring back the files.
any help would be appreciated.Doron, shalom
I have just installed SP2 on XP SP2 and it worked just fine. What is the
path of your SQL Server instalaltion?
<doron.almog@.gmail.com> wrote in message
news:1172531419.194567.175800@.h3g2000cwc.googlegroups.com...
> hi,
> Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
> running it on XP SP2.
> anybody run into this? restoring OS does not bring back the files.
> any help would be appreciated.
>

Installing MSSQL 2005 SP2 deleted all documents in my documents

hi,
Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
running it on XP SP2.
anybody run into this? restoring OS does not bring back the files.
any help would be appreciated.Doron, shalom
I have just installed SP2 on XP SP2 and it worked just fine. What is the
path of your SQL Server instalaltion?
<doron.almog@.gmail.com> wrote in message
news:1172531419.194567.175800@.h3g2000cwc.googlegroups.com...
> hi,
> Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
> running it on XP SP2.
> anybody run into this? restoring OS does not bring back the files.
> any help would be appreciated.
>

Installing MSDE SA password error.

I've been trying to install MSDE so i could run ASP.Net Forums. But whenever i run the setup.exe file, it gives me a pop up message with the following message:

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to the readme for more details. Set up will now Exit."

Could any body please tell me what to do??...

Yes. I'm stupid. And please excuse my ignoracne.Go to run and type the following replace path and password optionally you can specify authentication mode (default is windows) SECURITYMODE=SQL.

f:\sql2ksp3\MSDE\setup.exe sapwd="password"

Hope this helps

Regards
S(:

Installing MSDE 2000a

I have downloaded MSDE 2000a and installed it from the run command on Windows
XP SP2 but can only connect with the login "Trusted NT connection" and not
with the sa login. Can someone please give me the correct command to type to
install with sql or mixed authentication.
http://support.microsoft.com/default...b;en-us;319930
look at the heading "Enable Mixed Mode Authentication After Installation"
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cwsjnr" wrote:

> I have downloaded MSDE 2000a and installed it from the run command on Windows
> XP SP2 but can only connect with the login "Trusted NT connection" and not
> with the sa login. Can someone please give me the correct command to type to
> install with sql or mixed authentication.

Friday, March 23, 2012

Installing 64-Bit SQL 2005 on a 64-Bit server which needs .net 1.1 for CRM installed.

I am in the process of installing SQL 2005 on a new server that is also going to have MS CRM 3.0 installed

CRM needs the .net 1.1 which has you run "cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1"

I installed .net 1.1 32-Bit and 2.0 64-Bit on the server. Then cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

During the initial stages of the SQL install I receive the foloowing warning:

- ASP.Net Version Registration Requirement (Warning)

Messages

ASP.Net Version Registration Requirement

32-bit ASP.Net is Registered. Required 64-bit ASP.Net to install Microsoft Reporting Services 2005(64-bit).

Do I need to run cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 0 before the install of SQL and then cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 after?

Or do I need to install SQL 2005 64-bit without reporting services and then install SQL 2005 32-bit reporting services on the same server?

Here is a thread containing a workaround (including your cmd line questions). My guess is that you'll want to run them both and then launch the installer again.

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=798330&SiteID=17

Thanks,
Sam Lester (MSFT)

Installing 64-Bit SQL 2005 on a 64-Bit server which needs .net 1.1 for CRM installed.

ASP.Net Version Registration Requirement

32-bit ASP.Net is Registered. Required 64-bit ASP.Net to install Microsoft Reporting Services 2005(64-bit).

Or do I need to install SQL 2005 64-bit without reporting services and then install SQL 2005 32-bit reporting services on the same server?

Here is a thread containing a workaround (including your cmd line questions). My guess is that you'll want to run them both and then launch the installer again.

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=798330&SiteID=17

Thanks,
Sam Lester (MSFT)

installing 2nd instance

I am trying to install a second instance of sql server 2000. I am running xp
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't remember
now the limitations on the Developer Edition, is this one of them or is there
another problem? I am using mixed mode with an sa login.
--
JBWhat did the error log say was the issue?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"JB" <JB@.discussions.microsoft.com> wrote in message
news:03A65A47-1ADD-42AD-86A5-B937A651A346@.microsoft.com...
I am trying to install a second instance of sql server 2000. I am running
xp
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't
remember
now the limitations on the Developer Edition, is this one of them or is
there
another problem? I am using mixed mode with an sa login.
--
JB|||Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
--
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't remember
> now the limitations on the Developer Edition, is this one of them or is there
> another problem? I am using mixed mode with an sa login.
> --
> JB|||Have you tried applying SP3a or SP4? It's not clear what the build number
of SQL Server is. This is on Windows 2003, right?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"JB" <JB@.discussions.microsoft.com> wrote in message
news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
--
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running
> xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I
> try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not
> exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't
> remember
> now the limitations on the Developer Edition, is this one of them or is
> there
> another problem? I am using mixed mode with an sa login.
> --
> JB|||Per your suggestion. I first installed sp3a on the existing instance of SQL
Server(default instance). This ran without problems and the instance runs
ok. Then I ran the install for 2nd (named) instance. There aren't many
options during the install. I generally clicked Next. On one page, my user
name was displayed along with the domain. I entered my password. A page or
two later, I selected mixed mode and entered the sa password. The intall
seemed to go without any problems. When I then started Enterprise manager to
register the server, first it does not list the new instance in the select a
server page. If I type in the name and continue, I eventually get the
error, "sql server does not exist or access denied
ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on the
just installed named instance. The setup sees the new instance(i.e. it shows
in a list of instances to upgrade) but when I select the instance and
proceed, eventually I get the error "a service control operation failed for
MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
failure." I am running windows xp pro sp 2.
--
JB
"Tom Moreau" wrote:
> Have you tried applying SP3a or SP4? It's not clear what the build number
> of SQL Server is. This is on Windows 2003, right?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> ..
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
> Here is the whole lot:
> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2006-09-24 20:56:50.54 server All rights reserved.
> 2006-09-24 20:56:50.54 server Server Process ID is 160.
> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
> 'normal'(2 CPUs detected).
> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
> processing.
> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
> Blocks, [5000] Lock Owner Blocks.
> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2006-09-24 20:56:50.60 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2006-09-24 20:56:50.62 spid3 Warning ******************
> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
> Named Pipes.
> 2006-09-24 20:56:51.06 server SQL Server is ready for client connections
> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
> 2006-09-24 20:56:52.84 spid3 Recovery complete.
> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
> skipped.
> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
> changed from 0 to 1. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
> changed from 1 to 0. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
> request from Service Control Manager.
> --
> JB
>
> "JB" wrote:
> > I am trying to install a second instance of sql server 2000. I am running
> > xp
> > pro and using the developer edition. When I run the install, it completes
> > normally. The registry has entries for the new named instance. When I
> > try
> > to register the new server using enterprise manager and add it to a group,
> > first the wizard does not list the new name. If I type in the name and
> > proceed, I eventually get an error message saying "sql server does not
> > exist
> > or access denied. ..." The error log shows that it gets part way with
> > starting the service but then is stopped before completing. I don't
> > remember
> > now the limitations on the Developer Edition, is this one of them or is
> > there
> > another problem? I am using mixed mode with an sa login.
> > --
> > JB
>|||What are you typing in for the name? ServerName\InstanceName
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"JB" <JB@.discussions.microsoft.com> wrote in message
news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...
> Per your suggestion. I first installed sp3a on the existing instance of
> SQL
> Server(default instance). This ran without problems and the instance runs
> ok. Then I ran the install for 2nd (named) instance. There aren't many
> options during the install. I generally clicked Next. On one page, my
> user
> name was displayed along with the domain. I entered my password. A page
> or
> two later, I selected mixed mode and entered the sa password. The intall
> seemed to go without any problems. When I then started Enterprise manager
> to
> register the server, first it does not list the new instance in the select
> a
> server page. If I type in the name and continue, I eventually get the
> error, "sql server does not exist or access denied
> ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on
> the
> just installed named instance. The setup sees the new instance(i.e. it
> shows
> in a list of instances to upgrade) but when I select the instance and
> proceed, eventually I get the error "a service control operation failed
> for
> MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
> failure." I am running windows xp pro sp 2.
> --
> JB
>
> "Tom Moreau" wrote:
>> Have you tried applying SP3a or SP4? It's not clear what the build
>> number
>> of SQL Server is. This is on Windows 2003, right?
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> ..
>> "JB" <JB@.discussions.microsoft.com> wrote in message
>> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
>> Here is the whole lot:
>> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
>> Corporation.
>> 2006-09-24 20:56:50.54 server All rights reserved.
>> 2006-09-24 20:56:50.54 server Server Process ID is 160.
>> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
>> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
>> 'normal'(2 CPUs detected).
>> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
>> processing.
>> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500]
>> Lock
>> Blocks, [5000] Lock Owner Blocks.
>> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
>> Transaction Coordinator.
>> 2006-09-24 20:56:50.60 server Failed to obtain
>> TransactionDispenserInterface: Result Code = 0x8004d01b
>> 2006-09-24 20:56:50.62 spid3 Warning ******************
>> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
>> Updates allowed to system catalogs.
>> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
>> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
>> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
>> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
>> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
>> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
>> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
>> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
>> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared
>> Memory,
>> Named Pipes.
>> 2006-09-24 20:56:51.06 server SQL Server is ready for client
>> connections
>> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
>> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
>> 2006-09-24 20:56:52.84 spid3 Recovery complete.
>> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
>> skipped.
>> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
>> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
>> changed from 0 to 1. Run the RECONFIGURE statement to install..
>> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
>> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
>> changed from 1 to 0. Run the RECONFIGURE statement to install..
>> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
>> request from Service Control Manager.
>> --
>> JB
>>
>> "JB" wrote:
>> > I am trying to install a second instance of sql server 2000. I am
>> > running
>> > xp
>> > pro and using the developer edition. When I run the install, it
>> > completes
>> > normally. The registry has entries for the new named instance. When I
>> > try
>> > to register the new server using enterprise manager and add it to a
>> > group,
>> > first the wizard does not list the new name. If I type in the name and
>> > proceed, I eventually get an error message saying "sql server does not
>> > exist
>> > or access denied. ..." The error log shows that it gets part way with
>> > starting the service but then is stopped before completing. I don't
>> > remember
>> > now the limitations on the Developer Edition, is this one of them or is
>> > there
>> > another problem? I am using mixed mode with an sa login.
>> > --
>> > JB
>>|||I typed in just the instance name. I am on the road for a day or two and
won't be able to try servername\instancename until I return to my office.
However, when I tried to run sp3a againt the new instance, it showed
instancename in the selection list. sp3a was then was unable to connect to
the instance and as a result, the sp3a upgrade failed to run. It that case,
there was no issue with servername\instancename since I didn't need to type
anything. In both the sp3a upgrade and register server cases, sql recognizes
that the instance is there, it just cannot make a connection. The failure
has to do with logon but I can't see what the problem is.
--
JB
"Roger Wolter[MSFT]" wrote:
> What are you typing in for the name? ServerName\InstanceName
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...
> > Per your suggestion. I first installed sp3a on the existing instance of
> > SQL
> > Server(default instance). This ran without problems and the instance runs
> > ok. Then I ran the install for 2nd (named) instance. There aren't many
> > options during the install. I generally clicked Next. On one page, my
> > user
> > name was displayed along with the domain. I entered my password. A page
> > or
> > two later, I selected mixed mode and entered the sa password. The intall
> > seemed to go without any problems. When I then started Enterprise manager
> > to
> > register the server, first it does not list the new instance in the select
> > a
> > server page. If I type in the name and continue, I eventually get the
> > error, "sql server does not exist or access denied
> > ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on
> > the
> > just installed named instance. The setup sees the new instance(i.e. it
> > shows
> > in a list of instances to upgrade) but when I select the instance and
> > proceed, eventually I get the error "a service control operation failed
> > for
> > MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
> > failure." I am running windows xp pro sp 2.
> > --
> > JB
> >
> >
> > "Tom Moreau" wrote:
> >
> >> Have you tried applying SP3a or SP4? It's not clear what the build
> >> number
> >> of SQL Server is. This is on Windows 2003, right?
> >>
> >> --
> >> Tom
> >>
> >> ----
> >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> >> SQL Server MVP
> >> Toronto, ON Canada
> >> ..
> >> "JB" <JB@.discussions.microsoft.com> wrote in message
> >> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
> >> Here is the whole lot:
> >>
> >> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
> >> Corporation.
> >> 2006-09-24 20:56:50.54 server All rights reserved.
> >> 2006-09-24 20:56:50.54 server Server Process ID is 160.
> >> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
> >> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
> >> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
> >> 'normal'(2 CPUs detected).
> >> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
> >> processing.
> >> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500]
> >> Lock
> >> Blocks, [5000] Lock Owner Blocks.
> >> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
> >> Transaction Coordinator.
> >> 2006-09-24 20:56:50.60 server Failed to obtain
> >> TransactionDispenserInterface: Result Code = 0x8004d01b
> >> 2006-09-24 20:56:50.62 spid3 Warning ******************
> >> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
> >> Updates allowed to system catalogs.
> >> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
> >> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
> >> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
> >> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
> >> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
> >> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
> >> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
> >> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
> >> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared
> >> Memory,
> >> Named Pipes.
> >> 2006-09-24 20:56:51.06 server SQL Server is ready for client
> >> connections
> >> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
> >> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
> >> 2006-09-24 20:56:52.84 spid3 Recovery complete.
> >> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
> >> skipped.
> >> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
> >> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
> >> changed from 0 to 1. Run the RECONFIGURE statement to install..
> >> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
> >> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
> >> changed from 1 to 0. Run the RECONFIGURE statement to install..
> >> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
> >> request from Service Control Manager.
> >>
> >> --
> >> JB
> >>
> >>
> >> "JB" wrote:
> >>
> >> > I am trying to install a second instance of sql server 2000. I am
> >> > running
> >> > xp
> >> > pro and using the developer edition. When I run the install, it
> >> > completes
> >> > normally. The registry has entries for the new named instance. When I
> >> > try
> >> > to register the new server using enterprise manager and add it to a
> >> > group,
> >> > first the wizard does not list the new name. If I type in the name and
> >> > proceed, I eventually get an error message saying "sql server does not
> >> > exist
> >> > or access denied. ..." The error log shows that it gets part way with
> >> > starting the service but then is stopped before completing. I don't
> >> > remember
> >> > now the limitations on the Developer Edition, is this one of them or is
> >> > there
> >> > another problem? I am using mixed mode with an sa login.
> >> > --
> >> > JB
> >>
> >>
>
>

Wednesday, March 21, 2012

Installed SQLServer 2005 TrialEdition

Hi Fellows,

I am really in a fix.I have downloaded the trial version from MIcrosoft site and run setup with named instance. But I cannot find my management console link anywhere. Can anyone help me here .

My site is : Windows XP Professional SP2

Installed : SQLServer 2005 180Day Trial Pack downloaded from Microsoft Network.

I ran setup from : server directory and also from tools directory.

In my programes menu I can only see Configuration Toolsunder which there are three options :

1) SQL Server Configuration Tool

2) SQL Server Surface Configuration Tool and

3) SQL Server Error and Usage Reporting

Is it SQL Server 2005 Enterprise edition? XP SP2 does not support Enterprise edition. You need server operating systems to support Enterprise edition such as W2K SP4, W2K3 EE SP2, Longhorn Server.

|||

I dont know . I just downloaded the server from MSDN site it was an x86 executable file . My PC is a Win XP Professional on our internal Domain .

|||What does the Splash screen tell you ? After calling the installer you should get the splah screen showing the dition type you are trying to install.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

I just uninstalled everything and run the installer again . It says SQL 2005 Server but does not give anytype of edition. However now I find that the Management Console is appearing in the program menu.

Thanks to all . But I am still mystified as to why it should do like this .

Regards

|||Strange thing, I just started my ISO and it directly gives me the edition type as of [1]

[1] http://www.sqlserver2005.de/SharedFiles/SplashScreen.jpg

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Two questions:

1/How did you uninstall everything? I uninstalled in the wrong order from add/remove programs now I am in three quarters installed limbo. [Ghosting the machine seems the simplest way out].

2/I did not get the tools setup to work, or the sample database install in the server directory, the error message was (in both cases)
"The following components that you chose to install are already installed on the machine. To view a report of available options and alternatives click on Details."
Clicking on details was unhelpful (said to maintain components from add/remove programs)
[The components that were already installed did not mention the sample databases]

This is on Windows 2000 SP4, with sqlserver 2005 evaluation edition.

Thank you for your time,
Turloch|||

I simply went to the Add/remove programs and selected the Microsoft SQL Server 2005 , clicked remove . It asked and it simply removed it clean including the native client etc. Although the Add/Remove page still shows the name it has actually removed the product. To remove the name from the list you will have to select them one by one and click remove. It will prompt you with something like 'This program can only be used for removing installed options' Just click Ok and the entry will go away .

For the tools setup to work when you install you will get a page after the SQL support files and Native client are installed wherein you are asked to choose what you wish to install . Select both the SQL database services as well as the Client tools ( Last option on the page ) then click next .

Regards

|||Thanks...

I went add/remove [the wrong sql server component first] and the computer removed the entry in add/remove programs but left the program (mostly) intact [I had to repair .net from the add/remove programs section]

>For

the tools setup to work when you install you will get a page after the

SQL support files and Native client are installed wherein you are asked

to choose what you wish to install . Select both the SQL database

services as well as the Client tools ( Last option on the page ) then

click next .

I still get the error/warning:

"The following

components that you chose to install are already installed on the

machine. To view a report of available options and alternatives click

on Details."

[Component is:

Workstation components, Books Online and development tools 9:00.1399.06]

Maybe I was just unlucky not to choose the databases on my first install.

I can install the sample databases that have there own msi, I suppose I can create a test

database and or try to attach those database files for now, thanks.

Thank you for your time,

Turloch

|||[FYI: I attached the demo databases installed as .msi files into my limping sql server install]|||I didn′t understand your last reply, is the problem solved ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Yes I managed to resolve the problem . Here is what I did

1) Went to Add/Remove programs

2) Select MS SQL Server 2005

3) Clicked on Remove ( It asked me what components I want to remove so I checked Both Database Server and Workgroup Client )

4) Then removed everything else that was MS SQL

5) Re-ran the setup file

Wala .. I had the SQL Server Management Console in the Program List.

Thanks all

Regards

Monday, March 12, 2012

Installation problem - Cannot see home directory

I installed reporting services with SQL server 2005 on Windows Server 2003 R2. After installation which run successful without warning I want to check my installation. I open IE on the server and type:

http://localhost/reportserver$SQLEXPRESS but all I got is:

localhost/ReportServer$SQLExpress - /

2 lines

-----------

Microsoft SQL Server Reporting Services Version 9.00.2047.00

And that's all. Why I cannot see the home directory displayed ?

Appart selecting Chinese_PRC_90 for the collate I think I have just validated the default option for everything.

When I start the RS Configuration Manager, I see the Initialization button in grey and I cannot access it. Is this normal ?

I have explained why it is not working in the thread below because Express is free Microsoft have it setup you have to choose use either the Algebra end which is the Advanced or Toolkit which is the Calculus end, to use both you need the no deployment developer edition which cost a few dollars. Hope this helps.

http://forums.asp.net/thread/1482957.aspx

|||

Thank you for the answer. I tried to read carefully all the links you provided but I still cannot understand. On the server (Windows server 2003) I installed only the SQL Server 2005 Express Edition with Advanced Services SP1 (SQLEXPR_ADV.EXE). I did again the installation installing only SQL server engine with shared tools and reporting services with shared tools. I did not install any client part. But it is still the same.

|||

(SQL Server 2005 Express Edition Toolkit)

And because Express is free you cannot use the Tool Kit and the Advanced together because the Tool Kit is for the Calculus end and the Advanced is for the Algebra end, Microsoft have it setup you cannot have both, to use both you need the developer edition. Hope this helps.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

I hope you understand the above, the developer edition.

http://www.provantage.com/microsoft-e32-00575~7MCSB0EX.htm

|||

Thank you for the help but this is just the information you already provided in the first link you gave.

I partially solved my problem. To access the reporting services I should use the URL:http://localhost/reports$SQLExpress.

This worked on a new installation I have done. And finally after comparing my new installation with old one I fixed my problem.

Also I used the information fromhttp://sqljunkies.com/Article/525B575A-7F61-483A-AC8F-FEC700C34674.scuk explaining how to move reporting service default directories.

Thank you.

|||I am glad you have resolved your problem but that is what I have been trying to explain to you now you are using the Tool Kit you cannot use any part of the Advanced. That is what Microsoft said you have to use both ends separately.

installation problem

Hi,
I am facing a problem installing MSDE2000 on some computers. When i run my application setup program MSDE gets installed on some computers while it does not install on some others consistently.
I am using a merge module to install MSDE2000 with InstallShiel 9.
The target OS is NT4.0 SP6.
Any inputs will be most welcome.
regards,
Henry
Make sure you download the DevStudio 9.01 service pack from Install Shield
(just to do Tools | Check for Updates from within DevStudio). The merge
module for SQL gets updated with that. Otherwise, Install Shield tech
support might suggest to use the Install Shield redistributable for MSDE
instead.
************************************************** *****************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
************************************************** *****************
"Henry" <anonymous@.discussions.microsoft.com> wrote in message
news:EAFBF9A8-B3A3-4D55-82B7-78F4224CB685@.microsoft.com...
> Hi,
> I am facing a problem installing MSDE2000 on some computers. When i run my
application setup program MSDE gets installed on some computers while it
does not install on some others consistently.
> I am using a merge module to install MSDE2000 with InstallShiel 9.
> The target OS is NT4.0 SP6.
> Any inputs will be most welcome.
> regards,
> Henry

Friday, March 30, 2012

Installing MSSQL 2005 SP2 deleted all documents in my documents

Installing MSSQL 2005 SP2 deleted all documents in my documents

Installing MSSQL 2005 SP2 deleted all documents in my documents

Installing MSDE SA password error.

Installing MSDE 2000a

Friday, March 23, 2012

Installing 64-Bit SQL 2005 on a 64-Bit server which needs .net 1.1 for CRM installed.

Installing 64-Bit SQL 2005 on a 64-Bit server which needs .net 1.1 for CRM installed.

installing 2nd instance

installing 2nd instance

installing 2nd instance

Wednesday, March 21, 2012

Installed SQLServer 2005 TrialEdition

Monday, March 12, 2012

Installation problem - Cannot see home directory

installation problem

Installation Error

Blog Archive

About Me