Problem restoring transaction log

Dear all
I have a problem restoring a transaction log backup.
Platform SQL Server 2000 Standard Edition SP 2
Recovery mode = FULL
Transaction log backed up when empty to give us a nice
point to return to after some tests.
Backup was performed with Enterprise Manager.
Tlog has been grown from 23Gb to 46Gb after backup to
accommodate large load of transactions.
No dump device was created when backing up Tlog. Tlog
backed up to a file.
Filename: D:\DBSYS\MSSQL\BACKUP\SD70DbR7-Empty-Tlog
When restoring in Enterprise Manager (no matter what
options I choose) I get the infamous message:
The preceding restore operation did not specify WITH
NORECOVERY or WITH STANDBY.
Restart the restore sequence, specifying WITH NORECOVERY
or WITH STANDBY for all but the final step.
I've tried from filegroups and from devices. Specified
backups and specified "Leave DB non-operational
for more Tlog restores"
No joy.
I've tried to use a standalone restore script:
RESTORE LOG SD70DbR7
FROM DISK ='D:\DBSYS\MSSQL\BACKUP\SD70DbR7-Empty-Tlog'
WITH RECOVERY
I get the same message.
I have to specify a file as the TLog is not backed up to a
backup device.
This could be a big mistake on my part
I've specified WITH NORECOVERY and still the same message.
I've said FILE=1 but sill the same message.
When I leave out the very necessary FROM statement I get
teh nice message:
RESTORE LOG successfully processed 0 pages in 0.000
seconds (0.000 MB/sec).
I have some theories as to why I can't restore my TLog but
it seems obscene:
Could the fact that this database has not been backed up
be the issue?
Not on a suitable service pack.
Any suggestions?
Thanks
/SteveYou have to restore the database before you can restore the log. The error
message is saying that you did not do a restore leaving the server in
"norecovery" or "standby" mode so you cannot restore the log. Restore the
database backup and all log backups before that t-log backup using
norecovery and then apply that restore with recovery.
Christian Smith
"Steven Devaney" <Steven.Devaney@.Nospam.thx> wrote in message
news:1281a01c3f646$a327e430$a401280a@.phx
.gbl...
> Dear all
> I have a problem restoring a transaction log backup.
> Platform SQL Server 2000 Standard Edition SP 2
> Recovery mode = FULL
> Transaction log backed up when empty to give us a nice
> point to return to after some tests.
> Backup was performed with Enterprise Manager.
> Tlog has been grown from 23Gb to 46Gb after backup to
> accommodate large load of transactions.
> No dump device was created when backing up Tlog. Tlog
> backed up to a file.
> Filename: D:\DBSYS\MSSQL\BACKUP\SD70DbR7-Empty-Tlog
> When restoring in Enterprise Manager (no matter what
> options I choose) I get the infamous message:
> The preceding restore operation did not specify WITH
> NORECOVERY or WITH STANDBY.
> Restart the restore sequence, specifying WITH NORECOVERY
> or WITH STANDBY for all but the final step.
> I've tried from filegroups and from devices. Specified
> backups and specified "Leave DB non-operational
> for more Tlog restores"
> No joy.
> I've tried to use a standalone restore script:
> RESTORE LOG SD70DbR7
> FROM DISK ='D:\DBSYS\MSSQL\BACKUP\SD70DbR7-Empty-Tlog'
> WITH RECOVERY
> I get the same message.
> I have to specify a file as the TLog is not backed up to a
> backup device.
> This could be a big mistake on my part
> I've specified WITH NORECOVERY and still the same message.
> I've said FILE=1 but sill the same message.
> When I leave out the very necessary FROM statement I get
> teh nice message:
> RESTORE LOG successfully processed 0 pages in 0.000
> seconds (0.000 MB/sec).
> I have some theories as to why I can't restore my TLog but
> it seems obscene:
> Could the fact that this database has not been backed up
> be the issue?
> Not on a suitable service pack.
> Any suggestions?
>
> Thanks
> /Steve
>|||Thank you Christian.
As there is no space to do a backup to, I will have to go
for a plan B.
Thanks for the advice - at least it stops me searching for
something that can't be done.
>--Original Message--
>You have to restore the database before you can restore
the log. The error
>message is saying that you did not do a restore leaving
the server in
>"norecovery" or "standby" mode so you cannot restore the
log. Restore the
>database backup and all log backups before that t-log
backup using
>norecovery and then apply that restore with recovery.
>Christian Smith
>"Steven Devaney" <Steven.Devaney@.Nospam.thx> wrote in
message
> news:1281a01c3f646$a327e430$a401280a@.phx
.gbl...
to a
message.
but
>
>.
>sql

Problem restoring transaction log

Dear all
I have a problem restoring a transaction log backup.
Platform SQL Server 2000 Standard Edition SP 2
Recovery mode = FULL
Transaction log backed up when empty to give us a nice
point to return to after some tests.
Backup was performed with Enterprise Manager.
Tlog has been grown from 23Gb to 46Gb after backup to
accommodate large load of transactions.
No dump device was created when backing up Tlog. Tlog
backed up to a file.
Filename: D:\DBSYS\MSSQL\BACKUP\SD70DbR7-Empty-Tlog
When restoring in Enterprise Manager (no matter what
options I choose) I get the infamous message:
The preceding restore operation did not specify WITH
NORECOVERY or WITH STANDBY.
Restart the restore sequence, specifying WITH NORECOVERY
or WITH STANDBY for all but the final step.
I've tried from filegroups and from devices. Specified
backups and specified "Leave DB non-operational
for more Tlog restores"
No joy.
I've tried to use a standalone restore script:
RESTORE LOG SD70DbR7
FROM DISK ='D:\DBSYS\MSSQL\BACKUP\SD70DbR7-Empty-Tlog'
WITH RECOVERY
I get the same message.
I have to specify a file as the TLog is not backed up to a
backup device.
This could be a big mistake on my part
I've specified WITH NORECOVERY and still the same message.
I've said FILE=1 but sill the same message.
When I leave out the very necessary FROM statement I get
teh nice message:
RESTORE LOG successfully processed 0 pages in 0.000
seconds (0.000 MB/sec).
I have some theories as to why I can't restore my TLog but
it seems obscene:
Could the fact that this database has not been backed up
be the issue?
Not on a suitable service pack.
Any suggestions?
Thanks
/SteveYou have to restore the database before you can restore the log. The error
message is saying that you did not do a restore leaving the server in
"norecovery" or "standby" mode so you cannot restore the log. Restore the
database backup and all log backups before that t-log backup using
norecovery and then apply that restore with recovery.
Christian Smith
"Steven Devaney" <Steven.Devaney@.Nospam.thx> wrote in message
news:1281a01c3f646$a327e430$a401280a@.phx.gbl...
> Dear all
> I have a problem restoring a transaction log backup.
> Platform SQL Server 2000 Standard Edition SP 2
> Recovery mode = FULL
> Transaction log backed up when empty to give us a nice
> point to return to after some tests.
> Backup was performed with Enterprise Manager.
> Tlog has been grown from 23Gb to 46Gb after backup to
> accommodate large load of transactions.
> No dump device was created when backing up Tlog. Tlog
> backed up to a file.
> Filename: D:\DBSYS\MSSQL\BACKUP\SD70DbR7-Empty-Tlog
> When restoring in Enterprise Manager (no matter what
> options I choose) I get the infamous message:
> The preceding restore operation did not specify WITH
> NORECOVERY or WITH STANDBY.
> Restart the restore sequence, specifying WITH NORECOVERY
> or WITH STANDBY for all but the final step.
> I've tried from filegroups and from devices. Specified
> backups and specified "Leave DB non-operational
> for more Tlog restores"
> No joy.
> I've tried to use a standalone restore script:
> RESTORE LOG SD70DbR7
> FROM DISK ='D:\DBSYS\MSSQL\BACKUP\SD70DbR7-Empty-Tlog'
> WITH RECOVERY
> I get the same message.
> I have to specify a file as the TLog is not backed up to a
> backup device.
> This could be a big mistake on my part
> I've specified WITH NORECOVERY and still the same message.
> I've said FILE=1 but sill the same message.
> When I leave out the very necessary FROM statement I get
> teh nice message:
> RESTORE LOG successfully processed 0 pages in 0.000
> seconds (0.000 MB/sec).
> I have some theories as to why I can't restore my TLog but
> it seems obscene:
> Could the fact that this database has not been backed up
> be the issue?
> Not on a suitable service pack.
> Any suggestions?
>
> Thanks
> /Steve
>|||Thank you Christian.
As there is no space to do a backup to, I will have to go
for a plan B.
Thanks for the advice - at least it stops me searching for
something that can't be done.
>--Original Message--
>You have to restore the database before you can restore
the log. The error
>message is saying that you did not do a restore leaving
the server in
>"norecovery" or "standby" mode so you cannot restore the
log. Restore the
>database backup and all log backups before that t-log
backup using
>norecovery and then apply that restore with recovery.
>Christian Smith
>"Steven Devaney" <Steven.Devaney@.Nospam.thx> wrote in
message
>news:1281a01c3f646$a327e430$a401280a@.phx.gbl...
>> Dear all
>> I have a problem restoring a transaction log backup.
>> Platform SQL Server 2000 Standard Edition SP 2
>> Recovery mode = FULL
>> Transaction log backed up when empty to give us a nice
>> point to return to after some tests.
>> Backup was performed with Enterprise Manager.
>> Tlog has been grown from 23Gb to 46Gb after backup to
>> accommodate large load of transactions.
>> No dump device was created when backing up Tlog. Tlog
>> backed up to a file.
>> Filename: D:\DBSYS\MSSQL\BACKUP\SD70DbR7-Empty-Tlog
>> When restoring in Enterprise Manager (no matter what
>> options I choose) I get the infamous message:
>> The preceding restore operation did not specify WITH
>> NORECOVERY or WITH STANDBY.
>> Restart the restore sequence, specifying WITH NORECOVERY
>> or WITH STANDBY for all but the final step.
>> I've tried from filegroups and from devices. Specified
>> backups and specified "Leave DB non-operational
>> for more Tlog restores"
>> No joy.
>> I've tried to use a standalone restore script:
>> RESTORE LOG SD70DbR7
>> FROM DISK ='D:\DBSYS\MSSQL\BACKUP\SD70DbR7-Empty-Tlog'
>> WITH RECOVERY
>> I get the same message.
>> I have to specify a file as the TLog is not backed up
to a
>> backup device.
>> This could be a big mistake on my part
>> I've specified WITH NORECOVERY and still the same
message.
>> I've said FILE=1 but sill the same message.
>> When I leave out the very necessary FROM statement I get
>> teh nice message:
>> RESTORE LOG successfully processed 0 pages in 0.000
>> seconds (0.000 MB/sec).
>> I have some theories as to why I can't restore my TLog
but
>> it seems obscene:
>> Could the fact that this database has not been backed up
>> be the issue?
>> Not on a suitable service pack.
>> Any suggestions?
>>
>> Thanks
>> /Steve
>
>.
>

Problem replicating from Std Edition to Developer Edition

Trying to replicate,

from: Win 2K Server, SQL Std Edition 8.00.818 SP3
to: Win XP Pro, SQL Developer Edition 8.00.2039 SP4

XP has Firewall 'Off', and I added sqlservr.exe and port 1433 to the exceptions list.

Subscription on Win 2K Server gets error that it cannot connect to the subscriber system: SQL Server does not exist or access denied.

Ping from the Win2K to the WinXP box works fine.

The WinXP SQL login works when I connect from my desktop to the XP box using both SQL Ent Mgr and Query Analyzer.

Any ideas?

Looking at the merge agent properties, how does it connect to the publisher, sql login or windows login? If sql login, see if the login has access, and if the password is set correctly. If windows login, it's using the credentials that started the sql server agent service. Find out what login starts the sql server agent service and see if it has access to your publisher machine.

problem of uploading asp.net website on web server

i have developed a website using asp.net, c# withSQL SERVER EXPRESS EDITION 2005. The database is being used both for retreival and updation purpose. the website is working accordingly when i m running it on my system, ie., data is getting retreived from the database and it is also getting updated on button click. But when i m uloading my site on the httpdocs folder of web server, connectivity with database is failing miserably, ie neither getting retreived from the database nor getting updated. The error message displayed by the web server is given underneath. i have used Grid view for displaying data from the database and Details view for updating the database.

i have used window authentication for connecting with the database.

Please help me with finding out a solution for it. give me proper explanation and i need to do

Server Error in '/' Application.

---

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

smartymca:

this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections

Have you checked to see if this is the case or not? Simply pasting this error into google should show you how to do this.

|||

Hello smartymca,

I have recently uploaded my first ASP.NET website to the web, and I had exactly the same problem and error message. I found there were two reasons for this:

1. My hosting company require that my SQL Server database be located on a different server to the rest of my files! So check with your provider to see if your database needs to be in a specific place. I had to remove my database from my App_Data folder and recreate it on the correct server. I also had to change the connection string in my application to match the database's new location.

2. Now that my database was on a different server, the login system didn't work! This was because the default connection string for the Membership provider was no longer valid. There is however a very good video on this website that guides you through setting this up. It's the"ASP.NET How Do I? #13" video.

I hope this helps. If you think your problem is caused by the same thing then write back and maybe I can help.

|||

You will probably want to you SQL authentication because chances are, the SQL Server and the application server are on two different servers.

Who is your host?

|||

my web services provider is PROWEBS (prowebs.co.in).

|||

thanks for your reply. Yes i think my problem is same as your's, so please guide me.

My provider is (prowebs.co.in).

Tell me the steps you followed.

|||

smarty,

I've had a look at your provider's website and it appears to be exactly the same setup as my provider. You have to place your SQL Server database on a specific server for it to work - in your case, it is the "3Essentials MSSQL" server.

Unfortunately you cannot simply copy your existing database to the server (I had the same problem). A new empty database must be created on the 3Essentials server. Then, there are two things you can do.

If your database is still quite small and simple, you could recreate the tables yourself by connecting to your new database through MS Visual Studio. This is what I did.

If your database already has a lot of data in it and would take too long to recreate, you can transfer the data from your old database to your new database. This requires making a backup of your database using MS SQL Enterprise Manager (supposedly free to download from Microsoft, although when I tried, the download wasn't there) and then sending this backup to your provider so they can upload it for you. Detailed instructions can be found in your provider's FAQ.

smarty - are you using MS Visual Studio? If so, and you would like to try the first option, let me know and perhaps I could walk you through it. Send me a private message.

Patrick

|||

Patrick,

thnx for ur prompt reply..........

yes i m using MS Visual Studio and m also interested in using the first option............So, plz guide me through...........

|||

Ok,

1. Login to your user account at Prowebs. Find the database management section, and create a new MS SQL 2005 database. You'll give it a name, and a username and password.

2. Find out the server address for your new database. I guess it will be something like sql.3essentials.com. Also try and find out the connection string - my hosting company has a neat tool that tells you what it is. If yours doesn't, don't worry - you can find out in Visual Studio later.

3. Open up Visual Studio 2005. Click on the View menu and choose Server Explorer. Click on 'Connect to Database'.

4. In the new window, select the following options:

Datasource: Microsoft SQL Server

|||

i didn't get the server name. i put my dbi.3Essentials.com as server name but it still showing the same error which i have already given u.

|||

smarty,

Did you go through all the steps that I gave you? If not, how far did you get?

Problem installing SQL2K on WinXP Home

Hello there!

I am trying to install MS SQL 2000 Server on Windows XP Home edition.
I found in Microsoft that the above installation is possible.
But when i run the installation, i am getting a black screen that is
closes after a second. Nothing else happens.
Any ideas how to troubleshoot this?

Thank youLook for a log file named sqlstp.log. This is the log file created during the installation process. There should be some information in that log which might help you.|||Originally posted by rnealejr
Look for a log file named sqlstp.log. This is the log file created during the installation process. There should be some information in that log which might help you.

I searched for the file you are referring but with no success. I cannot find such a file anywhere on my disk.

Any other ideas?!

Thanks for the reply.

Problem installing SQL Server Reporting Services

I've been trying to install the MSDN Developers edition of SQL Server
Reporting Services for serveral hours. My environment is as follows:
XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
(Enterprise).
I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
The problem is that when I try to install the RS I only get the option
to install the Client Components (not very helpful for developing
reports locally)
While this looks like a great tool I'm inclined to go back to using
Crystal Reports unless I can get this resolved without <<<wasting>>
much more time!
Anyone have any thoughts?
GlennYou only want the client app on your computer. You can only install the RS
Enterprise on a server. The client app works perfectly fine for developing
reports and deploying them locally to view them. You will have to setup a
separate report server to deploy reports into production, if I understand
your needs.
"Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> I've been trying to install the MSDN Developers edition of SQL Server
> Reporting Services for serveral hours. My environment is as follows:
> XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> (Enterprise).
> I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> The problem is that when I try to install the RS I only get the option
> to install the Client Components (not very helpful for developing
> reports locally)
> While this looks like a great tool I'm inclined to go back to using
> Crystal Reports unless I can get this resolved without <<<wasting>>
> much more time!
> Anyone have any thoughts?
> Glenn|||You are supposed to be able to install this version of XP Pro (see this
link: http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp)
Do you have XP Pro with SP1?
Another point to consider, XP Pro does not have IIS by default running. Have
you installed IIS? Add/Remove Programs Windows Components.
IIS needs to be installed plus ASP.Net needs to be installed and running. My
guess is something with the web server is not setup correctly.
Bruce L-C
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:eOVowwufEHA.2468@.TK2MSFTNGP12.phx.gbl...
> You only want the client app on your computer. You can only install the
RS
> Enterprise on a server. The client app works perfectly fine for
developing
> reports and deploying them locally to view them. You will have to setup a
> separate report server to deploy reports into production, if I understand
> your needs.
>
> "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> > I've been trying to install the MSDN Developers edition of SQL Server
> > Reporting Services for serveral hours. My environment is as follows:
> >
> > XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> > (Enterprise).
> >
> > I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> > The problem is that when I try to install the RS I only get the option
> > to install the Client Components (not very helpful for developing
> > reports locally)
> >
> > While this looks like a great tool I'm inclined to go back to using
> > Crystal Reports unless I can get this resolved without <<<wasting>>
> > much more time!
> >
> > Anyone have any thoughts?
> >
> > Glenn
>|||I am having the same problem.
"Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> I've been trying to install the MSDN Developers edition of SQL Server
> Reporting Services for serveral hours. My environment is as follows:
> XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> (Enterprise).
> I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> The problem is that when I try to install the RS I only get the option
> to install the Client Components (not very helpful for developing
> reports locally)
> While this looks like a great tool I'm inclined to go back to using
> Crystal Reports unless I can get this resolved without <<<wasting>>
> much more time!
> Anyone have any thoughts?
> Glenn|||I'm having a similar problem...
Enterprise and Developer set up on one server machine, Developer on 2
other desktops. If you access Report Manager from the Server machine,
everything looks fine. But Report Manager accessed from the
non-server machines shows the top banner only... No tabs, no folders,
nothing below the line, so a developer can't upload without switching
over to the server, and even then there are often errors.
Is there some configuration subtlety we missed?
Otherwise this thing is giving me problems with OutOfMemory errors on
local debugs that I know aren't too big.
Ideas?
Jody
"Lance" <ldacy@.fellowshiptech.com> wrote in message news:<eOVowwufEHA.2468@.TK2MSFTNGP12.phx.gbl>...
> You only want the client app on your computer. You can only install the RS
> Enterprise on a server. The client app works perfectly fine for developing
> reports and deploying them locally to view them. You will have to setup a
> separate report server to deploy reports into production, if I understand
> your needs.
>
> "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> > I've been trying to install the MSDN Developers edition of SQL Server
> > Reporting Services for serveral hours. My environment is as follows:
> >
> > XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> > (Enterprise).
> >
> > I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> > The problem is that when I try to install the RS I only get the option
> > to install the Client Components (not very helpful for developing
> > reports locally)
> >
> > While this looks like a great tool I'm inclined to go back to using
> > Crystal Reports unless I can get this resolved without <<<wasting>>
> > much more time!
> >
> > Anyone have any thoughts?
> >
> > Glenn|||Your problem seems different. He was having a problem installing. Your
problem seems to be accessing it. It looks to me like you haven't setup your
roles for the developers on other machines.
Bruce L-C
"JodyT" <datagal@.msn.com> wrote in message
news:f9d864c3.0408111251.61c4d16f@.posting.google.com...
> I'm having a similar problem...
> Enterprise and Developer set up on one server machine, Developer on 2
> other desktops. If you access Report Manager from the Server machine,
> everything looks fine. But Report Manager accessed from the
> non-server machines shows the top banner only... No tabs, no folders,
> nothing below the line, so a developer can't upload without switching
> over to the server, and even then there are often errors.
> Is there some configuration subtlety we missed?
> Otherwise this thing is giving me problems with OutOfMemory errors on
> local debugs that I know aren't too big.
> Ideas?
> Jody
>
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
news:<eOVowwufEHA.2468@.TK2MSFTNGP12.phx.gbl>...
> > You only want the client app on your computer. You can only install the
RS
> > Enterprise on a server. The client app works perfectly fine for
developing
> > reports and deploying them locally to view them. You will have to setup
a
> > separate report server to deploy reports into production, if I
understand
> > your needs.
> >
> >
> > "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> > news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> > > I've been trying to install the MSDN Developers edition of SQL Server
> > > Reporting Services for serveral hours. My environment is as follows:
> > >
> > > XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> > > (Enterprise).
> > >
> > > I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> > > The problem is that when I try to install the RS I only get the option
> > > to install the Client Components (not very helpful for developing
> > > reports locally)
> > >
> > > While this looks like a great tool I'm inclined to go back to using
> > > Crystal Reports unless I can get this resolved without <<<wasting>>
> > > much more time!
> > >
> > > Anyone have any thoughts?
> > >
> > > Glenn|||Hello all. Thanks for the feedback... sorry for not finishing up the
thread.
My solution was to re-install WIN XP Pro SP1. Once SP1 was
re-installed RS installed with no further problems.
Hope this helps!
Glenn
"Kurt" <kurt_junk@.sdlf.com> wrote in message news:<OUz#lSzfEHA.1092@.TK2MSFTNGP11.phx.gbl>...
> I am having the same problem.
> "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> > I've been trying to install the MSDN Developers edition of SQL Server
> > Reporting Services for serveral hours. My environment is as follows:
> >
> > XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> > (Enterprise).
> >
> > I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> > The problem is that when I try to install the RS I only get the option
> > to install the Client Components (not very helpful for developing
> > reports locally)
> >
> > While this looks like a great tool I'm inclined to go back to using
> > Crystal Reports unless I can get this resolved without <<<wasting>>
> > much more time!
> >
> > Anyone have any thoughts?
> >
> > Glenn

PROBLEM INSTALLING SQL SERVER EXPRESS

Hi,

I successfully installed Visual Basic 2005 express edition and but the SQL Server component did not get installed.

12:37:11 AM Sunday, April 09, 2006: [Fail] ConfigSamplesDll_DoTasks:: [Fail] Config_SSE_INST_Install: SQL Express service install (failed). The process did not return a success value. ExitCode: 1282 Command: 'C:\Documents and Settings\Oluwaseyi Awoga\Local Settings\Temp\SQLEXPR32.exe -q /norebootchk /qn reboot=ReallySuppress addlocal=all SCCCHECKLEVEL=IncompatibleComponents:1 instancename=SQLEXPRESS'.

I keep getting this error. Can anybody help me? I have uninstalled and installed ALL versions of the .NET framework etc several times. Thanks

This is also the error signature. Thanks for your help.

Error Signature:
EventType : BEX P1 : setup.exe P2 : 2005.90.1399.0 P3 : 434f6403
P4 : msdtcprx.dll P5 : 2001.12.4414.258 P6 : 41109703 P7 : 0000a2c9
P8 : c0000409 P9 : 00000000

|||

This is the content of the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files

Microsoft SQL Server 2005 Setup beginning at Sun Apr 09 01:46:18 2006
Process ID : 952
c:\e37376beb65a16277a8441b9\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/3/9 1:46:17
Complete: LoadResourcesAction at: 2006/3/9 1:46:18, returned true
Running: ParseBootstrapOptionsAction at: 2006/3/9 1:46:18
Loaded DLL:c:\e37376beb65a16277a8441b9\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/3/9 1:46:18, returned true
Running: ValidateWinNTAction at: 2006/3/9 1:46:18
Complete: ValidateWinNTAction at: 2006/3/9 1:46:18, returned true
Running: ValidateMinOSAction at: 2006/3/9 1:46:18
Complete: ValidateMinOSAction at: 2006/3/9 1:46:18, returned true
Running: PerformSCCAction at: 2006/3/9 1:46:18
Complete: PerformSCCAction at: 2006/3/9 1:46:18, returned true
Running: ActivateLoggingAction at: 2006/3/9 1:46:18
Complete: ActivateLoggingAction at: 2006/3/9 1:46:18, returned true
Running: DetectPatchedBootstrapAction at: 2006/3/9 1:46:18
Complete: DetectPatchedBootstrapAction at: 2006/3/9 1:46:18, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__952" returned false.
Running: PerformSCCAction2 at: 2006/3/9 1:46:18
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2006/3/9 1:46:18, returned true
Running: PerformDotNetCheck at: 2006/3/9 1:46:18
Complete: PerformDotNetCheck at: 2006/3/9 1:46:18, returned true
Running: ComponentUpdateAction at: 2006/3/9 1:46:18
Complete: ComponentUpdateAction at: 2006/3/9 1:46:23, returned true
Running: DetectLocalBootstrapAction at: 2006/3/9 1:46:23
Complete: DetectLocalBootstrapAction at: 2006/3/9 1:46:23, returned true
Running: LaunchLocalBootstrapAction at: 2006/3/9 1:46:23
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 1282
Aborting queue processing as nested installer has completed
Message pump returning: 1282

Thanks!!

|||

I'm going to move this to the SQL Setup forum.

- Mike

|||

I don't believe 1282 is a Setup error code; it's probably a Windows error code. 1282 translates to stack buffer overflow. We did fix one or two such issues a long time back. If the version of Express you're trying to install is pre-RTM then please download the RTM version or the remastered Express SP1 which should be available soon, and try again. If you're already trying with RTM then I suspect we're going to need to see the complete SQL Install logs to debug your problem.

Paul

Problem installing SQL Server 2005 Express with Advance Services CTP

Hi,

I was unable to install the CTP version of SS Express Edition SP1 with Advance Services. The installation failed with the following error message:

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

However, I was able to install and run the standard CTP version of SS Express Edition SP1 without any problems, even though the above error message indicated I may have login problem. First let me confess that my computer does not have IIS installed, which as I understand is only needed for running the Report Services. Is it necessary for IIS to be up and running while installing SSEE with Advance Services?

The main reason I want to install SSEE with Advance Services is to use the full text search capability. I do not need the Report Services, and was hoping there is an option to turn it off and not require IIS. Is this possible?

Mike

Hi Mike,

You do not need to have IIS installed or running to install Express Advanced as long as you don't need Reporting Services. As far as the error you're getting, we'd really need to check for additional informaiton in the setup log. Could you check that out and get back to the thread with the info from the log?

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Hi Mike,

I am glad to hear that IIS is not required for SQLExpress Advanced installation. The error I got is as follows taken from the summary log file.

Machine : WS2
Product : Microsoft SQL Server 2005
Product Version : 9.1.2040.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_WS2_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error Number : 29515

Background information: (OS: Windows XP SP2)

1. Logged in as user with local administrative priviliges.

2. Installed SQL Express RTM a while back, and was able to login to instance and use databases.

3. Attempted to install SQLExpress Advanced CTP without uninstalling SQLExpress RTM. This process is suppose to upgrade the existing installation.

4. *** Installation fails and the sql server setup installation rolls back. *** The previous installation (SQLExpress RTM) is automatically restored, and I am able to login to the sql server.

5. l then try to install SQLExpress CTP. This works perfectly. Note I did not make any changes between steps 4 and 5 (e.g. no reboot, etc.).

Looking through the log files it looks like the SQLExpress Advanced is trying to make an ODBC connection and failing. Why is it trying to use ODBC?

Anyway there is a lot of information in the logs that I do not understand, so it would be better if I could send them to you. (All the log files are in a 1.3M cab file) Please advise.

Thanks,

Mike

|||I am having the same error message also. I previously installed Visual Studio 2005 (not express). Could this have changed the sa password?|||

Hi, I've got the same problem - any ideas?

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x4818

BUTTONS:

&Retry
Cancel

|||I have the same error during setup. I was upgrading a named instance of SSEE 2005 to SSEE w/ Advanced Services.

I used Windows Auth for the install; my windows account is a local admin on the server in question (Win2k Server) and my account has the sysadmin role in SQL Server.

I also tried it using SQL Server Auth with the SA account. That immediately showed the message:

"SQL Server Setup cannot upgrade the specified instance by using SQL Server credentials. You must use Windows Authentication credentials for the upgrade."

So, I find it strange that the setup fails with the message:

"SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information."
(The Error Number in the log summary is 29515)

It says the login failed for user 'sa' even though I used Windows Authentication.

Btw, I used the download posted here: http://msdn.microsoft.com/vstudio/express/sql/download/ Is that still a CTP?
|||More info from the error log:

SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.

Error Code: 0x80074818 (18456)
Windows Error Text: Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Wed Oct 26 16:37:41 2005
Function Name: OdbcConnection::connect@.connect
Source Line Number: 148

- Context --

Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80074818 (18456)
ipt
SqlScriptHlpr

Error Code: 18456
MSI (s) (34!D4) [16:38:57:313]: Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
<Failure Type='Fatal' Error='18456'>
<EndFunc Name='LaunchFunction' Return='18456' GetLastError='203'>
MSI (s) (34:C8) [16:38:57:360]: User policy value 'DisableRollback' is 0
MSI (s) (34:C8) [16:38:57:360]: Machine policy value 'DisableRollback' is 0
Action ended 16:38:57: InstallFinalize. Return value 3.
|||

Seems to be an issue that happens during upgrade.

In order to correctly upgrade from Express Edition to Express Edition with Advanced Services, follow the instructions in the SQL Express blog at: http://blogs.msdn.com/sqlexpress/archive/2006/04/20/UpgradeToAdvanced.aspx

If you've already tried to upgrade and received the error "Login failed for user 'sa'" then you will need to follow the instructions in the SQL Express blog at: http://blogs.msdn.com/sqlexpress/archive/2006/04/20/580312.aspx

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||Brilliant!
I ran into the same problem yesterday. Will try to use the blog posts to solve my problem. :)

Kaisa
|||The new version of SQLEXP_ADV worked just fine, I was using an earlier version saved on my CD's from Apr, but I just don't understand why these things just get so hard to fine. Great Job!!!! Keep up the hard work....

Problem installing SQL Server 2005 Express Edition with Advanced Services SP2

Don't know if this is the appropriate forum...

I have encountered a showstopper problem during installation. I have installed SSEE on a fresh XP, all the checks but memory requirements passed. In the final stage of the install, during the "real work", the Client Component installation failed due to missing ASP.NET state service (? spelling). After the failure the installation continued, but marked both the db engine and the management studio failed. Despite this, management studio was installed and later I have removed it with the control panel applet.

I have found a service (executable: aspnet_state.exe), started it and retried the installation. It failed again so I have removed everything installed except the VSS writer and started it again. This time the installation completed (and finally got BIDS).

Is it enough to start this ASP service manually for a painless install? I don't want to play this "on the field" ever...

I'd need to see the install log from a failed attempt to really understand the problem. This is the first time I've heard mention of the asp.net state service, so this doesn't seem like a common issue. We should get to the bottom of what is really happening before you start trying to start random services on your customers computers.

Mike

|||Is earlier install logs kept? There were two attempts after it, one successfull and one uninstall. At the end of the first failed attempt the installer sent an error report on a form looked like the standard error reporting form - had the installer an unhandled exception or was it my installation feedback?|||

Mike,

I hate to post in someone elses thread, but this sounds like the exact same issue I am having. Here is the ERRORLOG:

2007-04-30 14:15:39.88 Server Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)
Feb 13 2007 23:02:48
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 2)

2007-04-30 14:15:39.88 Server (c) 2005 Microsoft Corporation.
2007-04-30 14:15:39.88 Server All rights reserved.
2007-04-30 14:15:39.88 Server Server process ID is 2088.
2007-04-30 14:15:39.88 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-04-30 14:15:39.88 Server This instance of SQL Server last reported using a process ID of 3108 at 4/30/2007 2:08:46 PM (local) 4/30/2007 6:08:46 PM (UTC). This is an informational message only; no user action is required.
2007-04-30 14:15:39.88 Server Registry startup parameters:
2007-04-30 14:15:39.88 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-04-30 14:15:39.88 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-04-30 14:15:39.88 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-04-30 14:15:39.93 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-04-30 14:15:39.93 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-04-30 14:15:40.10 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-04-30 14:15:40.19 Server Could not query the FIPS compliance mode flag from registry. Error 2(The system cannot find the file specified.).
2007-04-30 14:15:40.26 Server Database mirroring has been enabled on this instance of SQL Server.
2007-04-30 14:15:40.27 spid5s Starting up database 'master'.
2007-04-30 14:15:40.30 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.30 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.30 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.30 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.32 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.32 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.32 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.32 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

I went into the Computer Management console and tried to restart the SQLEXPRESS service (SQL Server Active Directory Helper also) and it gives me "server-specific error code 3417"

Thanks in advance,

Nick

|||According to the end of your log your problem is that your database is in a compressed folder (usually blue letters in Explorer). I think you should uncompress the c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA folder (right-click on the folder, Properties, Special button and uncheck). Or mark it as a read-only database but I don't think you want to do that.|||

All your logs should be sitting in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files. They are number sequentially and you can also use the create date to identify the correct log. The standard error reporting dialog does not collect personal informaiton, nor does it collect the install logs, so I can access anything related to that.

MIke

|||

Regarding Nick's issue - We don't support installing to compressed folders so you'll need to uncompress before doing any install/upgrade.

Mike

|||There is no "Special" button|||

"Unfortunatelly" I have a hungarian XP so the button label re-translation failed. It is the button on the right side of attributes read only and hidden.

Here is an official description:

To set the compression state of a folder or file

1.

In My Computer or Windows Explorer, right-click the file or folder to compress or decompress.

2.

Click Properties to display the Properties dialog box.

3.

On the General tab, click Advanced.

4.

In the Advanced Attributes dialog box, select or clear the Compress contents to save disk space check box and then click OK.

5.

In the Properties dialog box, click OK.

6.

If the compression state was altered for a folder, in the Confirm Attribute Changes dialog box, select whether to make the compression apply only to the selected folder or to the selected folder and all its files and subfolders. Click OK when done.

Note Windows XP Professional can compress closed paging files. However, when you restart Windows XP Professional, the paging files revert to an uncompressed state. For information about paging files, see the topics on virtual memory in Windows XP Professional Help.

You can set Windows Explorer to display alternate colors for compressed files and folders by using the following procedure:

To display alternate colors for compressed files and folders

1.

In My Computer or Windows Explorer, click the Tools menu, and then click Folder Options.

2.

On the View tab, select the Show encrypted or compressed NTFS files in color check box.

3.

Click OK to return to Windows Explorer or My Computer.

|||

I was having a similar problem, only that for me I could not restart the service after it had stopprd.

Setting permissions on the ...sql server\MSSQL1\data folder sorted me out.

I granted full control on the folder to the machine\users group.

Problem installing SQL Server 2005 Express Edition with Advanced Services SP2

Don't know if this is the appropriate forum...

I have encountered a showstopper problem during installation. I have installed SSEE on a fresh XP, all the checks but memory requirements passed. In the final stage of the install, during the "real work", the Client Component installation failed due to missing ASP.NET state service (? spelling). After the failure the installation continued, but marked both the db engine and the management studio failed. Despite this, management studio was installed and later I have removed it with the control panel applet.

I have found a service (executable: aspnet_state.exe), started it and retried the installation. It failed again so I have removed everything installed except the VSS writer and started it again. This time the installation completed (and finally got BIDS).

Is it enough to start this ASP service manually for a painless install? I don't want to play this "on the field" ever...

I'd need to see the install log from a failed attempt to really understand the problem. This is the first time I've heard mention of the asp.net state service, so this doesn't seem like a common issue. We should get to the bottom of what is really happening before you start trying to start random services on your customers computers.

Mike

|||Is earlier install logs kept? There were two attempts after it, one successfull and one uninstall. At the end of the first failed attempt the installer sent an error report on a form looked like the standard error reporting form - had the installer an unhandled exception or was it my installation feedback?|||

Mike,

I hate to post in someone elses thread, but this sounds like the exact same issue I am having. Here is the ERRORLOG:

2007-04-30 14:15:39.88 Server Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)
Feb 13 2007 23:02:48
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 2)

2007-04-30 14:15:39.88 Server (c) 2005 Microsoft Corporation.
2007-04-30 14:15:39.88 Server All rights reserved.
2007-04-30 14:15:39.88 Server Server process ID is 2088.
2007-04-30 14:15:39.88 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-04-30 14:15:39.88 Server This instance of SQL Server last reported using a process ID of 3108 at 4/30/2007 2:08:46 PM (local) 4/30/2007 6:08:46 PM (UTC). This is an informational message only; no user action is required.
2007-04-30 14:15:39.88 Server Registry startup parameters:
2007-04-30 14:15:39.88 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-04-30 14:15:39.88 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-04-30 14:15:39.88 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-04-30 14:15:39.93 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-04-30 14:15:39.93 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-04-30 14:15:40.10 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-04-30 14:15:40.19 Server Could not query the FIPS compliance mode flag from registry. Error 2(The system cannot find the file specified.).
2007-04-30 14:15:40.26 Server Database mirroring has been enabled on this instance of SQL Server.
2007-04-30 14:15:40.27 spid5s Starting up database 'master'.
2007-04-30 14:15:40.30 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.30 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.30 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.30 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.32 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.32 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.32 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.32 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

I went into the Computer Management console and tried to restart the SQLEXPRESS service (SQL Server Active Directory Helper also) and it gives me "server-specific error code 3417"

Thanks in advance,

Nick

|||According to the end of your log your problem is that your database is in a compressed folder (usually blue letters in Explorer). I think you should uncompress the c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA folder (right-click on the folder, Properties, Special button and uncheck). Or mark it as a read-only database but I don't think you want to do that.|||

All your logs should be sitting in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files. They are number sequentially and you can also use the create date to identify the correct log. The standard error reporting dialog does not collect personal informaiton, nor does it collect the install logs, so I can access anything related to that.

MIke

|||

Regarding Nick's issue - We don't support installing to compressed folders so you'll need to uncompress before doing any install/upgrade.

Mike

|||There is no "Special" button|||

"Unfortunatelly" I have a hungarian XP so the button label re-translation failed. It is the button on the right side of attributes read only and hidden.

Here is an official description:

To set the compression state of a folder or file

1.

In My Computer or Windows Explorer, right-click the file or folder to compress or decompress.

2.

Click Properties to display the Properties dialog box.

3.

On the General tab, click Advanced.

4.

In the Advanced Attributes dialog box, select or clear the Compress contents to save disk space check box and then click OK.

5.

In the Properties dialog box, click OK.

6.

If the compression state was altered for a folder, in the Confirm Attribute Changes dialog box, select whether to make the compression apply only to the selected folder or to the selected folder and all its files and subfolders. Click OK when done.

Note Windows XP Professional can compress closed paging files. However, when you restart Windows XP Professional, the paging files revert to an uncompressed state. For information about paging files, see the topics on virtual memory in Windows XP Professional Help.

You can set Windows Explorer to display alternate colors for compressed files and folders by using the following procedure:

To display alternate colors for compressed files and folders

1.

In My Computer or Windows Explorer, click the Tools menu, and then click Folder Options.

2.

On the View tab, select the Show encrypted or compressed NTFS files in color check box.

3.

Click OK to return to Windows Explorer or My Computer.

|||

I was having a similar problem, only that for me I could not restart the service after it had stopprd.

Setting permissions on the ...sql server\MSSQL1\data folder sorted me out.

I granted full control on the folder to the machine\users group.

Problem installing SQL Server 2005 Express Edition

I have downloaded a free set of SQL Server 2005 Express edition. This set up has been installed successfully on my machine but it is showing me following links.

SQL Server Instance=SQLExpress

User Id=sa

Password=admin12

Start --> Microsoft Sql Server 2005 -->Configuration Tools --->SQL Server Configuration Manager

--->SQL Server Eroor and Usage Reporting

---->SQL Server Surface Area Configuration

But I don't find any option to start SQL Server 2005 express edition. Please help me out how to start SQL Server 2005 express edition?

dineshpatil:

But I don't find any option to start SQL Server 2005 express edition. Please help me out how to start SQL Server 2005 express edition?

You can use the SQL Server Surface area configuration to start/stop services like your SQL instance.

If you want a GUI interface then you need to install SQL Server Management Studio.

|||

Dear Jimmy,

Thanks for your reply. I have started SQL Server instance service. Is SQL Server Management Studio is free?
If it is free, Please provide me URL path from where I can download?

Is there any other way with which I can run or access Microsoft SQL Server 2005 Express Edition?

|||

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

|||

dineshpatil:

Thanks for your reply. I have started SQL Server instance service. Is SQL Server Management Studio is free?
If it is free, Please provide me URL path from where I can download?

Yes it is free and you can download it here

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

dineshpatil:

Is there any other way with which I can run or access Microsoft SQL Server 2005 Express Edition?

Your Express database is already installed so you can use it right away. You can either connect from the VS IDE, but if you want a GUI to the database then you need to use the SQL Management tool another 3rd party tool or rely on Visual Studio's server explorer.

|||

Thanks guys. Now it is working fine.

Problem Installing SQL Server 2005 Enterprise Edition On Windows Server 2003 Box

While attempting to install SQL Server 2005 Enterprise Edition on a Windows Server 2003 box, it is failing as follows...

Microsoft SQL Server 2005 Setup beginning at Thu Sep 20 11:11:35 2007
Process ID : 5440
E:\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/8/20 11:11:35
Complete: LoadResourcesAction at: 2007/8/20 11:11:35, returned true
Running: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35
Loaded DLL:E:\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5440"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/8/20 11:11:35
Complete: ValidateWinNTAction at: 2007/8/20 11:11:35, returned true
Running: ValidateMinOSAction at: 2007/8/20 11:11:35
Complete: ValidateMinOSAction at: 2007/8/20 11:11:35, returned true
Running: PerformSCCAction at: 2007/8/20 11:11:35
Complete: PerformSCCAction at: 2007/8/20 11:11:35, returned true
Running: ActivateLoggingAction at: 2007/8/20 11:11:35
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
00CFCFC8Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5440"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Any ideas?

Thanks in advance.

Ensure that you have all the prerequisites installed for installing sql 2005 in windows 2003 server ! you need to have windows 2003 server with SP1,.NET framework 2.0 etc.......pls refer the link for the prerequsites !

http://technet.microsoft.com/hi-in/library/ms143506.aspx

Thanxx
Deepak

Problem installing SQL Server 2005 Developer Edition

Hi,

I have a problem installing SQL Server 2005 Developer Edition.

When I start the setup, I get the message:

"SQL Server Setup could not run. Another instance of SQL Server Setup is already running. The running instance must complete before you can run SQL Server Setup again"

I am using Windows XP and have SQL Server 2000 and SQL Server Express 2005 installed.

I shut down both instances before I attempted to do the install but I still get the message.

I checked active tasks but no tasks with SQL* is running.

Please advise.

Thanks

Have you rebooted the computer?|||

Hi,

Yes I did, but when I reboot the services start automatically and then I stop them manually and then attemp the setup - But the same message displays.

Thanks.

|||Try uninstalling "Microsoft SQL Server Setup Support Files" then re-run the setup.|||Moving to the setup group

Problem installing SQL Server 2005 Developer Edition

Hi,

I have a problem installing SQL Server 2005 Developer Edition.

When I start the setup, I get the message:

"SQL Server Setup could not run. Another instance of SQL Server Setup is already running. The running instance must complete before you can run SQL Server Setup again"

I am using Windows XP and have SQL Server 2000 and SQL Server Express 2005 installed.

I shut down both instances before I attempted to do the install but I still get the message.

I checked active tasks but no tasks with SQL* is running.

Please advise.

Thanks

Have you rebooted the computer?|||

Hi,

Yes I did, but when I reboot the services start automatically and then I stop them manually and then attemp the setup - But the same message displays.

Thanks.

|||Try uninstalling "Microsoft SQL Server Setup Support Files" then re-run the setup.|||Moving to the setup group

Problem installing server instance on windows xp sp2

Hello all,

I have a problem installing a SQL Server 2005 (developper edition) on my windows XP SP2 machine.

When I launch the setup, all the requirements are ok, but I'm just allowed to install client components and documentations. I can't install the database server instance.

The Sql Server is downloaded from MSDN (2 iso files extracted to my HD)

My machine is a P4 2.8Ghz HT with 1Gig of RAM.

Thanks for your help

FYI, here's the Report for the system configuration check:

System Configuration Check

- WMI Service Requirement (Success)

Messages

WMI Service Requirement

Check Passed

- MSXML Requirement (Success)

Messages

MSXML Requirement

Check Passed

- Operating System Minimum Level Requirement (Success)

Messages

Operating System Minimum Level Requirement

Check Passed

- Operating System Service Pack Level Requirement. (Success)

Messages

Operating System Service Pack Level Requirement.

Check Passed

- SQL Server Edition Operating System Compatibility (Success)

Messages

SQL Server Edition Operating System Compatibility

Check Passed

- Minimum Hardware Requirement (Success)

Messages

Minimum Hardware Requirement

Check Passed

- IIS Feature Requirement (Success)

Messages

IIS Feature Requirement

Check Passed

- Pending Reboot Requirement (Success)

Messages

Pending Reboot Requirement

Check Passed

- Performance Monitor Counter Requirement (Success)

Messages

Performance Monitor Counter Requirement

Check Passed

- Default Installation Path Permission Requirement (Success)

Messages

Default Installation Path Permission Requirement

Check Passed

- Internet Explorer Requirement (Success)

Messages

Internet Explorer Requirement

Check Passed

- COM Plus Catalog Requirement (Success)

Messages

COM Plus Catalog Requirement

Check Passed

- ASP.Net Version Registration Requirement (Success)

Messages

ASP.Net Version Registration Requirement

Check Passed

- Minimum MDAC Version Requirement (Success)

Messages

Minimum MDAC Version Requirement

Check Passed

What Edition are you trying to install? Only the Express and Developer Editions can be installed on a Windows XP SP2 box (haven't tried the Workgroup edition yet)|||

This is the developer edition of SQL server 2005 (not beta).

Thanks,

Pat

|||Just in addition, Workgroup edition as well as Standard edition will work on Windows XP SP2 machines.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Are you using SQL Server professional or Home ? Home is not supported by Developer Edition and therefore only will allow you to install the client components.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Problem installing Advanced Services on Domain Controller

I try to install SQL Express Edition with Advanced Services on Small Business Server 2003 Standard Edition. Actually I install it without any problems.

I set database service (SQL SERVER (SQLEXPRESS)) to use domain account (administrator of domain). I configure report server windows identity to domain account (administrator of domain). When I try to access page Reports I have following problem . Error is

Unable to connect to the remote server.

Please, can somebody help me?

this is I found in log file

w3wp!ui!1!25.4.2006-08:00:35:: e ERROR: Unable to connect to the remote server
w3wp!ui!1!25.4.2006-08:00:37:: e ERROR: HTTP status code --> 500
-Details--
System.Net.WebException: Unable to connect to the remote server > System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
End of inner exception stack trace
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!25.4.2006-08:00:38:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

What Reports are you trying to access? Do they have anything to do with SQL Express? (Are you talking about SQL Reporting Services?)

Why are you trying to run SQL Express on a Domain Controller in the first place?

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||

I try to access http://localhost/reports$sqlexpress. (Yes this is reporting services.)

I have only one server in domain (small business server 2003). I do not want to install SQL Express with Advanced Services on client computer.

|||

I'm moving this over to the Reporting Service forum as they'll have a better idea what is going on with this issue.

- Mike

Problem install RS2000

hi,I have a W2003 Server Standard Edition.I Installed VS2005 with ASP 2.0
,For some reasons My DB is SQL SERVER 2000.
Now I tried to install RS2000-So first I installed VS2003 and when the
install started i got error that ASP.NET 1.1 isn't registered,although it is!
So I removed The IIS(6.0) and Re-installed it,and then I preform
"aspnet_regiis.exe -i" for both 1.1 and 2.0 but still i get this error that
1.1 isn't register...
Any Idea?Several issues. First, if you want RS 2005 can use SQL 2000 for its
object/metadata storage. If your server is on a different box than where you
are developing you do not need to install VS at all.
RS 2000 tries to install to the default website. Check in IIS what version
of dotnet the default website is running. It must be 1.1.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"'" <@.discussions.microsoft.com> wrote in message
news:0DCF02DD-5671-4C89-BFB6-6579D52DA671@.microsoft.com...
> hi,I have a W2003 Server Standard Edition.I Installed VS2005 with ASP 2.0
> ,For some reasons My DB is SQL SERVER 2000.
> Now I tried to install RS2000-So first I installed VS2003 and when the
> install started i got error that ASP.NET 1.1 isn't registered,although it
> is!
> So I removed The IIS(6.0) and Re-installed it,and then I preform
> "aspnet_regiis.exe -i" for both 1.1 and 2.0 but still i get this error
> that
> 1.1 isn't register...
> Any Idea?
>