Problem Running Sql Server 2005 Express on Vista

I have been trying to get Sql Server 2005 Express Advanced with SP2 installed and operating on my Vista machine. It seems to install ok but when I open Management Studio Express and try to create a new db or attach an existing one, I get error messages. So although it seems to be installed, I can't really use it.

When I try to create a new database I get:

TITLE: Microsoft SQL ServerManagement Studio Express

----------

Create failed for Database'practice'. (Microsoft.SqlServer.Express.Smo)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476

----------

ADDITIONAL INFORMATION:

An exception occurred whileexecuting a Transact-SQL statement or batch.(Microsoft.SqlServer.Express.ConnectionInfo)

----------

CREATE DATABASE permission denied indatabase 'master'. (Microsoft SQL Server, Error: 262)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

----------

BUTTONS:

OK

----------

When I try to attach an existing database I get:

TITLE: Microsoft SQL ServerManagement Studio Express

----------

Failed to retrieve data for thisrequest. (Microsoft.SqlServer.Express.SmoEnum)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

----------

ADDITIONAL INFORMATION:

An exception occurred whileexecuting a Transact-SQL statement or batch.(Microsoft.SqlServer.Express.ConnectionInfo)

----------

The server principal"Dave-PC\Dave" is not able to access the database "model"under the current security context. (Microsoft SQL Server, Error: 916)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476

----------

BUTTONS:

OK

----------

I have tried following the links in the error messages but the result is: "We're sorryThereis no additional information about this issue in the Error and EventLog Messages or Knowledge Base databases at this time. You can use thelinks in the Support area to determine whether any additionalinformation might be available elsewhere."

I am successfully using both programs on my XP SP2 machines, so I know how to install and run them on XP, just not on Vista (yet). Any suggestions on how to proceed?

I had alot of VS issues when I switched to Vista. Are you running the management studio as an admin? As a test you may want to turn off UAC and see if that fixes your issue. If it does then you just need to change the permissions that you are running with.

|||

Thanks for the suggestion. It worked and I am able to run Sql Server 2005 Express via Management Studio to create and attached databases.

Question: Do I have to toggle the UAC on and off every time I want to use SQL Server Express (or leave it off always if I am willing to accept the security issues)? Or do I have other options?

|||

I personally turned mine off just because I am the only user of the PC and I'm fairly certain that if I was going to do something harmful to my own PC I'd just turn UAC off at the time I was doing it anyway. There is however a way to set the program to always run in admin mode. I'm on an XP machine right now so I can't post instructions myself but step 3 in the below article should be what you need.

http://4sysops.com/archives/vista%E2%80%99s-uac-8-ways-how-to-elevate-an-application-to-run-it-with-administrator-rights/

|||

Thanks for help. I hope I get equally good advice as I sort out some of my other Vista problems!

Problem restoring SQL Svr 2000 Master db - wrong server version?

I'm trying to rebuild from a meltdown. I'm using disk backup files. I
could have sworn that I had SQL Server 2000 SP3 installed on the old
machine, but maybe not.

With SP3 installed, I get a message along the lines that the restore
can't be done because the backup was created using server version
134218262 and this server is version 134218488.

I've searched the documentation and can't find any reference to those
version numbers.

In any case, I thought SQL Server 2000 could restore backups created
on any SP level to any SP level.

Any ideas?

--
Regards.
Richard.On Tue, 13 Jan 2004 06:30:12 GMT, Richard Sherratt
<richard.sherratt@.NOTHINGHEREbrunsley.com.au> wrote:

>I'm trying to rebuild from a meltdown. I'm using disk backup files. I
>could have sworn that I had SQL Server 2000 SP3 installed on the old
>machine, but maybe not.

Ooop. Sorry. I had SP2 installed.

--
Regards.
Richard.|||"Richard Sherratt" <richard.sherratt@.NOTHINGHEREbrunsley.com.au> wrote in
message news:dp7700dtggi3ev97mmgfgtacct926mjdb4@.4ax.com...
> On Tue, 13 Jan 2004 06:30:12 GMT, Richard Sherratt
> <richard.sherratt@.NOTHINGHEREbrunsley.com.au> wrote:
> >I'm trying to rebuild from a meltdown. I'm using disk backup files. I
> >could have sworn that I had SQL Server 2000 SP3 installed on the old
> >machine, but maybe not.
> Ooop. Sorry. I had SP2 installed.

You mention the master DB in the subject.

I believe the system databases (Master, Model, MSDB) have to be restored to
the same level service pack they were backed up from.

Otherwise you're right. You can restore different SP levels of dbs to
different servers.

>
> --
> Regards.
> Richard.|||"Greg D. Moore \(Strider\)" <mooregr@.greenms.com> wrote in message news:<eRSMb.72883$Dq1.66308@.twister.nyroc.rr.com>...
> "Richard Sherratt" <richard.sherratt@.NOTHINGHEREbrunsley.com.au> wrote in
> message news:dp7700dtggi3ev97mmgfgtacct926mjdb4@.4ax.com...
> > On Tue, 13 Jan 2004 06:30:12 GMT, Richard Sherratt
> > <richard.sherratt@.NOTHINGHEREbrunsley.com.au> wrote:
> > >I'm trying to rebuild from a meltdown. I'm using disk backup files. I
> > >could have sworn that I had SQL Server 2000 SP3 installed on the old
> > >machine, but maybe not.
> > Ooop. Sorry. I had SP2 installed.
> You mention the master DB in the subject.
> I believe the system databases (Master, Model, MSDB) have to be restored to
> the same level service pack they were backed up from.
> Otherwise you're right. You can restore different SP levels of dbs to
> different servers.

As part of a D&R test we restored databases to new servers, much the
same as you appear to be trying.

My best guess is that you have a different server name. We made sure
that the servers had the same name as the 'real' ones. If you are
dealing with a meltdown, this might actually help because your client
software won't have to be modified for the new server name.
>
> > --
> > Regards.
> > Richard.|||On Tue, 13 Jan 2004 13:59:38 GMT, "Greg D. Moore \(Strider\)"
<mooregr@.greenms.com> wrote:

<snip
>You mention the master DB in the subject.
>I believe the system databases (Master, Model, MSDB) have to be restored to
>the same level service pack they were backed up from.
>Otherwise you're right. You can restore different SP levels of dbs to
>different servers.

Thanks. That would explain it.

--
Regards.
Richard.

Problem restoring backup

I am running SQL 7...

I had a database on a Sql Server on a WinXP machine but I needed to reinstall that machine and I installed Win2k...

Before I format the machine I have made a backup from my database. Now, on the Win2k, I cant restore this backup. Sql Server shows the following error message:

The volume on device 'c:\backup.bak' is not a member of the media family.

Plz, help me on this... I dont know much about Sqlserver and this is the ONLY backup I have... The backup file seems fine... There was no errors during the backup proccess...

If u dont know whats happening, could u tell if exists some program that can read the backup file and extracts its data to another format?What I do is...
i create a backup device that is the same name as the old backup.
i then put the backup file where u set up the backup device to be. at this point the server should see it and use it as a lagit device
Jim

Originally posted by trojahn
I am running SQL 7...

I had a database on a Sql Server on a WinXP machine but I needed to reinstall that machine and I installed Win2k...

Before I format the machine I have made a backup from my database. Now, on the Win2k, I cant restore this backup. Sql Server shows the following error message:

The volume on device 'c:\backup.bak' is not a member of the media family.

Plz, help me on this... I dont know much about Sqlserver and this is the ONLY backup I have... The backup file seems fine... There was no errors during the backup proccess...

If u dont know whats happening, could u tell if exists some program that can read the backup file and extracts its data to another format?|||JDionne,

I need to ask u for a little more favor... Could u give me more details on how to do that? I really dont know much about Sql Server... I just follow the setup procedure of my so called technical support that now says that I did something wrong...

Edit -=-=-=-=-=-
I just figure out how to do what u said but theres a major problem... I dont know where the backup device was on the first machine... I there a way to figure that out?|||The location of the first back up dosent mater. I would create the backup device in eh mssql\backups directory just to stick to a standard.
Once u have created that device with the same name as the old backup file and move it to that dir, the server will use the file.

the following code will tell u whats in the backup when u go to restore.
run this in query analizer substituting your backup device name

RESTORE FILELISTONLY
FROM [Maersk Data Warehouse Full Backup]

after u know whats in the device u can use the following code to restore it. u will need to change the database name, backup device and mdf,ldf, (and if u have a ndf) file names
the To line indicates wehre u want it to restore to and again i would follow the standard just so u know where they are. If u have any questions just post it and ill see if i can help
Regards Jim

RESTORE DATABASE [Maersk Data Warehouse]
FROM [Maersk Data Warehouse Full Backup]
with recovery
, move 'Maersk Data Warehouse_Data'to 'E:\MSSQL\Data\Maersk Data Warehouse_Data.MDF'
, move 'Maersk Data Warehouse_Log' to 'F:\MSSQL\Data\Maersk Data Warehouse_Log.LDF'
, move 'Maersk Data Warehouse User Tables'to 'E:\MSSQL\Data\Maersk Data Warehouse_Data.NDF'

Originally posted by trojahn
JDionne,

I need to ask u for a little more favor... Could u give me more details on how to do that? I really dont know much about Sql Server... I just follow the setup procedure of my so called technical support that now says that I did something wrong...

Edit -=-=-=-=-=-
I just figure out how to do what u said but theres a major problem... I dont know where the backup device was on the first machine... I there a way to figure that out?

Problem registering server in Enterprise manager

Hi,
I've recently installed SQL Server 2000 on a laptop. The laptop has a
wireless connection to the LAN. I am able to register the other SQL Servers
on the network on the intance on the laptop, but I cannot register the
instance on the laptop from the others; I get the error message "SQL Server
does not existor access denied.|ConnectionOpen (Connect()"
*SQL Server is running on the laptop
*SQL Server agent is also running
*The login and password I use are correct (and I use SQL Server
authentication).
*I have installed SP3a
*I have disabled the Windows XP SP2 firewall and even uninstalled my other
firewall.
*The instance of SQL Server I am trying to register does show up as an
available server in the Register SQL Server Wizard.
What might be the problem? I would also very much appreciate if someone
could point me in the right direction regarding how to troubleshoot this
better, so I can find out where the failure occurs.Try registering the instance of SQL on the laptop FROM the laptop, but do no
t
use the localhost syntax, use the same syntax which is failing from across
the wireless network, whether that's using a netbios name, or rcpip
addresss... What happens then?
"Daniel" wrote:

> Hi,
> I've recently installed SQL Server 2000 on a laptop. The laptop has a
> wireless connection to the LAN. I am able to register the other SQL Server
s
> on the network on the intance on the laptop, but I cannot register the
> instance on the laptop from the others; I get the error message "SQL Serve
r
> does not existor access denied.|ConnectionOpen (Connect()"
> *SQL Server is running on the laptop
> *SQL Server agent is also running
> *The login and password I use are correct (and I use SQL Server
> authentication).
> *I have installed SP3a
> *I have disabled the Windows XP SP2 firewall and even uninstalled my other
> firewall.
> *The instance of SQL Server I am trying to register does show up as an
> available server in the Register SQL Server Wizard.
> What might be the problem? I would also very much appreciate if someone
> could point me in the right direction regarding how to troubleshoot this
> better, so I can find out where the failure occurs.
>|||I am using the Register SQL Server Wizard in Enterprise manager. From the
list of available servers, I choose Laptop3 (the name of the laptop). If I d
o
the same thing FROM the laptop there are no problems. Does this indicate tha
t
the problem is not actually SQL Server related, but rather something with th
e
network? I had the same symptoms a while back when registering other
instances of SQL Server, and that time I solved it by allowing incoming
traffic on ports TCP 1433, UDP 1434 and file and printer sharing in the
Windows XP Firewall. This time that didn't solve the problem and neither did
deactivating the firewall altogether.
Perhaps I should also say that when I installed SQL Server on the laptop, I
had to choose to let SQL Server and SQL Server Agent log in on the local
system account, because for some reason the domain user account I tried coul
d
not be validated. I changed this after the installation so now they both log
in on a domain user account.
The activated protocols are TCP/IP (1433) and named pipes.
"CBretana" wrote:

> Try registering the instance of SQL on the laptop FROM the laptop, but do
not
> use the localhost syntax, use the same syntax which is failing from across
> the wireless network, whether that's using a netbios name, or rcpip
> addresss... What happens then?|||I'd have whoever is responsible for your wireless access point check it out.
Sometimes traffic is filtered either to or from the wireless network for
security reasons. There may be necessary components of the registration
process that aren't allowed to pass through the wireless access point.
"Daniel" <daXniel_kriXstensXen_@.hotmail.com (remove the Xs)> wrote in
message news:26EEB241-9BAA-40D5-8846-DAC1AB702E7D@.microsoft.com...
> Hi,
> I've recently installed SQL Server 2000 on a laptop. The laptop has a
> wireless connection to the LAN. I am able to register the other SQL
Servers
> on the network on the intance on the laptop, but I cannot register the
> instance on the laptop from the others; I get the error message "SQL
Server
> does not existor access denied.|ConnectionOpen (Connect()"
> *SQL Server is running on the laptop
> *SQL Server agent is also running
> *The login and password I use are correct (and I use SQL Server
> authentication).
> *I have installed SP3a
> *I have disabled the Windows XP SP2 firewall and even uninstalled my other
> firewall.
> *The instance of SQL Server I am trying to register does show up as an
> available server in the Register SQL Server Wizard.
> What might be the problem? I would also very much appreciate if someone
> could point me in the right direction regarding how to troubleshoot this
> better, so I can find out where the failure occurs.
>|||When you attempt to register the server, you are logging in. There are two
ways to do this, with a userID and password, or using what is called
"Integrated security" which uses the userID / password of whomever is logged
on to the box you're doing it from. Which of these you are using depends on
how you installed SQL Server. When you installed SQL, did you select
Integrated Secutrity only, or did you choose Itegrated security AND SQL
Server Security ?
When you attempt to register the SQL Server, are you asked to enter a UserID
And Password? My guess is that you are not.. If that's true, then when you
attempt to register from another box, the SQL Server is not recognozing the
UserID of whomever is logged on there as being a valid Login...
Try to actually enter the "sa" and the sa password from the remote
Enterprise manager, AND from the laptop Enterprise Manager, and see if
there's a difference...
"Daniel" wrote:

> I am using the Register SQL Server Wizard in Enterprise manager. From the
> list of available servers, I choose Laptop3 (the name of the laptop). If I
do
> the same thing FROM the laptop there are no problems. Does this indicate t
hat
> the problem is not actually SQL Server related, but rather something with
the
> network? I had the same symptoms a while back when registering other
> instances of SQL Server, and that time I solved it by allowing incoming
> traffic on ports TCP 1433, UDP 1434 and file and printer sharing in the
> Windows XP Firewall. This time that didn't solve the problem and neither d
id
> deactivating the firewall altogether.
> Perhaps I should also say that when I installed SQL Server on the laptop,
I
> had to choose to let SQL Server and SQL Server Agent log in on the local
> system account, because for some reason the domain user account I tried co
uld
> not be validated. I changed this after the installation so now they both l
og
> in on a domain user account.
> The activated protocols are TCP/IP (1433) and named pipes.
>
> "CBretana" wrote:
>
>|||"CBretana" wrote:
> When you attempt to register the server, you are logging in. There are tw
o
> ways to do this, with a userID and password, or using what is called
> "Integrated security" which uses the userID / password of whomever is logg
ed
> on to the box you're doing it from. Which of these you are using depends
on
> how you installed SQL Server. When you installed SQL, did you select
> Integrated Secutrity only, or did you choose Itegrated security AND SQL
> Server Security ?
I chose mixed mode.

> When you attempt to register the SQL Server, are you asked to enter a User
ID
> And Password? My guess is that you are not.. If that's true, then when yo
u
> attempt to register from another box, the SQL Server is not recognozing th
e
> UserID of whomever is logged on there as being a valid Login...
> Try to actually enter the "sa" and the sa password from the remote
> Enterprise manager, AND from the laptop Enterprise Manager, and see if
> there's a difference...
Actually that's precisely what I do, and it only works from the laptop.
Sorry I didn't mention this already.|||Unfortunately, the guy responsible for these things are on vacation. I've
been able to register SQL Servers on laptops connected to the wireless acces
s
point previously. However, I did tamper with the wireless access point to ge
t
the new laptops to be able to connect to it. Pretty stupid of me not to chec
k
whether the SQL Servers on the old laptops are still accesible... That will
be the first thing I'll do on Monday. Even if it doesn't solve the problem i
t
will narrow down the possible causes of it.
"Mike Jansen" wrote:

> I'd have whoever is responsible for your wireless access point check it ou
t.
> Sometimes traffic is filtered either to or from the wireless network for
> security reasons. There may be necessary components of the registration
> process that aren't allowed to pass through the wireless access point.
> "Daniel" <daXniel_kriXstensXen_@.hotmail.com (remove the Xs)> wrote in
> message news:26EEB241-9BAA-40D5-8846-DAC1AB702E7D@.microsoft.com...
> Servers
> Server
>
>|||Ok, sorry, I should have asked this last time but forgot, since I askedit
first time...
From laptop, when you register, are you using "local" or typing the
laptop's server name, or IP Address to specify the server?
If you are using "local", then try using the same thing, on the laptop, that
is failing from over the network...
Say it's ServerName...
If that then also fails, on laptop, same as it fails from over network,
then your problem is related to networking. Try using the IPAddress
directly instead of server name. If that works, then problem is name
resolution (DNS or WINs resolution) issues.
"Daniel" wrote:

> "CBretana" wrote:
> I chose mixed mode.
>
> Actually that's precisely what I do, and it only works from the laptop.
> Sorry I didn't mention this already.

Problem processing cubes in example Adventure Works DW

Hi,

I've installed the sample databases, and I am trying to process the cubes in the sample.

I keep getting errors like this, for cube "adventure Works":

Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_DimCustomer, Column: AddressLine1, Value: 8011 Mcnutt Ave. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Customer of Dimension: Customer from Database: Adventure Works DW, Record: 1024.

I have set processing to ignore errors, but the cube is never successfully processed.

What can I do to get the cube processed?

Hi John,

Could you please check that you have installed the right AdventureWorksDW relational DB, and that your AdventureWorksDW AS DB's datasource points to it.

YL

|||

Yan,

The "Adventure Works DW" AS DB datasource points to the "AdventureWorksDW" database installed as sample (on the same machine), going by the connection string.

How can I check that I have the "right" AdventureWorksDW?

John

|||

John,

If you installed the sample Adventure Works DW successfully, and verified that the relational DB is also installed and no records in it were removed, the processing should work.

Yan

|||

I've fixed the problem. I had SS 2000 installed as my default instance and 2005 as a named instance and it appears that was the source of the problem. I've had to uninstall both, then reinstall only 2005, but the sample is now working.

Problem processing cubes in example Adventure Works DW

Hi,

I've installed the sample databases, and I am trying to process the cubes in the sample.

I keep getting errors like this, for cube "adventure Works":

Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_DimCustomer, Column: AddressLine1, Value: 8011 Mcnutt Ave. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Customer of Dimension: Customer from Database: Adventure Works DW, Record: 1024.

I have set processing to ignore errors, but the cube is never successfully processed.

What can I do to get the cube processed?

Hi John,

Could you please check that you have installed the right AdventureWorksDW relational DB, and that your AdventureWorksDW AS DB's datasource points to it.

YL

|||

Yan,

The "Adventure Works DW" AS DB datasource points to the "AdventureWorksDW" database installed as sample (on the same machine), going by the connection string.

How can I check that I have the "right" AdventureWorksDW?

John

|||

John,

If you installed the sample Adventure Works DW successfully, and verified that the relational DB is also installed and no records in it were removed, the processing should work.

Yan

|||

I've fixed the problem. I had SS 2000 installed as my default instance and 2005 as a named instance and it appears that was the source of the problem. I've had to uninstall both, then reinstall only 2005, but the sample is now working.

problem of connection with sqlserver2005

Hello,

I installed sqlserver2005_express on my PC (localhost) and I try to execute a sql query with ASP.NET.

Here's my page :
Dim mySqlConnection as SqlConnection = new SqlConnection("server=JOE10155\SQLEXPRESS;Trusted_Connection=yes;UID=sa;PWD=xxxx;database=xxxx")
Dim mySqlDataAdapter as SqlDataAdapter = new SqlDataAdapter("SELECT * FROM Entreprise WHERE (EntrepriseNr =999)", mySqlConnection)
Dim myDataSet as DataSet = new DataSet()
mySqlDataAdapter.Fill(myDataSet,"Entreprise")

The problem is :
System.Data.SqlClient.SqlException: Autorisation SELECT refusée sur l'objet 'Entreprise', base de données 'xxxx', schéma dbo'.

if someone have an idea?

Thanks

PS : I use Microsoft SQL Server Management Studio Express.

Hi,

that is French? :-)

I'm not good with it, but sounds as if the user who you connect as (give the credentiuals into connection string) wouldn't have permissions to SELECT fromEntreprise table

Problem moving RS Virtual Directories

I installed RS using the default settings (but without SSL) and it worked fine. Then I installed SP1.
Initially installed to:
http://www.ourdomain.com/reports
http://www.ourdomain.com/reportserver
Then I attempted to move the virtual directories to take advantage of SSL and everything stopped.
So in IIS I created a new web site using a sub-domain:
http://reports.ourdomain.com and loaded a certificate.
Then I saved the 2 original virtual directories as config files and then re-installed them under this new web site e.g.
https://reports.ourdomain.com/reports
https://reports.ourdomain.com/reportserver
I then edited the config files RSWebApplication.config & RSReportServer.config with the following changes
<UrlRoot>http://OurServerName/ReportServer</UrlRoot> --> <UrlRoot>https://reports.ourdomain.com/ReportServer</UrlRoot>
<ReportServerUrl>http://OurServerName/ReportServer</ReportServerUrl> --> <ReportServerUrl>https://reports.ourdomain.com/ReportServer</ReportServerUrl>
And now nothing works... I get the "Server Error in '/REPORTS' Application." error i.e. an aspx error with nothing logged in the RS log.
Something I suspect is that changing the URL from the servername to the domain name is making the permissions act differently - but while its getting the aspx error I can't see what is going wrong. I can't even seem to make it give me the full error. Its giving me the standard:
"Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off"."
And even though the custom errors tag is set as specified its not giving me any error information.
Has anyone any suggestions as to what might be going wrong?

see if this article helps. there are a couple little weird thingsyou need for the virtual directories to work that you might not expect:
http://www.sqljunkies.com/Article/525B575A-7F61-483A-AC8F-FEC700C34674.scuk

Problem migrating RS 2000 database to RS 2005

Hi all,
I have RS 2000 SP2 (8.00.1038.00) installed on one server. RS 2005 is
installed on another server and I followed the steps from Migrating Reporting
Services (SQL Server 2005 Books Online).
I managed to copy the MDF files ReportServer and ReportServerTempDB and
their associated log files from the SQL 2000 server to the SQL 2005 server.
They were attached in SQL 2005 successfully.
However error occurred when I tried to upgrade the database from the RS
Configuration Manager.
"There was a problem applying the database upgrade script."
----
System.Data.SqlClient.SqlException: Cannot find the user 'RSExecRole',
because it does not exist or you do not have permission.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String
connectionString, String script)
The weird thing is when I repeated the procedure, I didn't see the above
error again and it managed to proceed but with errors.
"Creating a Grant Rights script for NT AUTHORITY\NetworkService
The grant rights script was generated successfully."
"The Reporting Services rights were not applied properly. The user may
still not have appropriate access to Reporting Services resources.
----
System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in
the current database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String
connectionString, String script)
The creation of grant right script was repeated.
"Creating a Grant Rights script for NT Authority\NetworkService
The grant rights script was generated successfully."
"The Reporting Services rights were not applied properly. The user may
still not have appropriate access to Reporting Services resources.
-----
System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in
the current database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String
connectionString, String script)
It looks like the main culprit is 'RSExecRole'. Any idea how to correct this?
Thanks.
--
Best regards,
JudeHi all,
After some investigations, I managed to get it to work and thought I'd share
it here for the benefit of all.
To migrate a RS 2000 database from a SQL Server 2000 server to another
server running SQL Server 2005, follow the steps in SQL Server 2005 Books
Online under Migrating Reporting Services.
As mentioned in my previous post, it failed at the step where the database
was upgraded. The workaround is: create a new RS database in the RS
Configuration Manager before upgrading. Do not give it the same name as the
RS database.
When this is done, you can upgrade the RS 2000 database. I managed to
migrate the RS 2000 database to RS 2005 successfully using this workaround.
Good luck.
Best regards,
Jude
"Jude Wong" wrote:
> Hi all,
> I have RS 2000 SP2 (8.00.1038.00) installed on one server. RS 2005 is
> installed on another server and I followed the steps from Migrating Reporting
> Services (SQL Server 2005 Books Online).
> I managed to copy the MDF files ReportServer and ReportServerTempDB and
> their associated log files from the SQL 2000 server to the SQL 2005 server.
> They were attached in SQL 2005 successfully.
> However error occurred when I tried to upgrade the database from the RS
> Configuration Manager.
> "There was a problem applying the database upgrade script."
> ----
> System.Data.SqlClient.SqlException: Cannot find the user 'RSExecRole',
> because it does not exist or you do not have permission.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
> methodName, Boolean async)
> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String
> connectionString, String script)
> The weird thing is when I repeated the procedure, I didn't see the above
> error again and it managed to proceed but with errors.
> "Creating a Grant Rights script for NT AUTHORITY\NetworkService
> The grant rights script was generated successfully."
> "The Reporting Services rights were not applied properly. The user may
> still not have appropriate access to Reporting Services resources."
> ----
> System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in
> the current database.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
> methodName, Boolean async)
> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String
> connectionString, String script)
> The creation of grant right script was repeated.
> "Creating a Grant Rights script for NT Authority\NetworkService
> The grant rights script was generated successfully."
> "The Reporting Services rights were not applied properly. The user may
> still not have appropriate access to Reporting Services resources."
> -----
> System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in
> the current database.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
> methodName, Boolean async)
> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String
> connectionString, String script)
> It looks like the main culprit is 'RSExecRole'. Any idea how to correct this?
> Thanks.
>
> --
> Best regards,
> Jude

Problem istalling SQL2000 RS

I am trying to install SQL 2000 RS on my Vista box. I have installed VS
2003. But installation program says I don't have IIS running as well as ASP
1.1 framework not being registered or installed. Can someone please help me?
ThanksOn May 13, 6:21 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> I am trying to install SQL 2000 RS on my Vista box. I have installed VS
> 2003. But installation program says I don't have IIS running as well as ASP
> 1.1 framework not being registered or installed. Can someone please help me?
> Thanks
I'm not completely sure, but I don't believe that SSRS 2000 can run on
Vista. I believe that you need SQL Server/SSRS 2005 SP2 to run it on
Vista.
Regards,
Enrique Martinez
Sr. Software Consultant

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 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 Express

When I attempt to install the standalone SQL Server 2005 Express, the install hangs at "Detecting Installed IIS". I have reboot the PC.

I have sucessfully installed the other parts of Visual Studio Team Developers Edition.

I am running XP Pro SP2.

Previously I had Beta 2 and the Release candidate installed on my PC and I carefully followed the recommended uninstall procedure.

Please Help.

SteveSame here with XP Home SP2, a clean/new pc with only .Net 1.1 installed prior to installing VS (VB .Net) Express 2005.
|||Is there a workaround/fix?

BTW, I do not have IIS installed.|||

I have fixed the problem. I saw a post on the general VS 2005 setup forum that status that Norton/Symantec Anti-Virus and Firewall products may cause the hang-up on "Detecting Installed IIS". After disabling all Norton/Symantec software, the install completed sucessfully.

Problem Installing SQL Server 2005 Express

When I attempt to install the standalone SQL Server 2005 Express, the install hangs at "Detecting Installed IIS". I have reboot the PC.

I have sucessfully installed the other parts of Visual Studio Team Developers Edition.

I am running XP Pro SP2.

Previously I had Beta 2 and the Release candidate installed on my PC and I carefully followed the recommended uninstall procedure.

Please Help.

SteveSame here with XP Home SP2, a clean/new pc with only .Net 1.1 installed prior to installing VS (VB .Net) Express 2005.|||Is there a workaround/fix?

BTW, I do not have IIS installed.|||

I have fixed the problem. I saw a post on the general VS 2005 setup forum that status that Norton/Symantec Anti-Virus and Firewall products may cause the hang-up on "Detecting Installed IIS". After disabling all Norton/Symantec software, the install completed sucessfully.

Problem installing SQL 2005 Server Express

I have the beta versions installed, got an error:

Microsoft SQL Server 2005 Setup beginning at Wed Aug 16 18:14:14 2006 Process ID : 4668 c:\8c27e35b5d509dc8609c33e266\setup.exe Version: 2005.90.2047.0 Running: LoadResourcesAction at: 2006/7/16 18:14:13 Complete: LoadResourcesAction at: 2006/7/16 18:14:13, returned true Running: ParseBootstrapOptionsAction at: 2006/7/16 18:14:14 Loaded DLL:c:\8c27e35b5d509dc8609c33e266\xmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2006/7/16 18:14:14, returned true Running: ValidateWinNTAction at: 2006/7/16 18:14:14 Complete: ValidateWinNTAction at: 2006/7/16 18:14:14, returned true Running: ValidateMinOSAction at: 2006/7/16 18:14:14 Complete: ValidateMinOSAction at: 2006/7/16 18:14:14, returned true Running: PerformSCCAction at: 2006/7/16 18:14:14 Complete: PerformSCCAction at: 2006/7/16 18:14:14, returned true Running: ActivateLoggingAction at: 2006/7/16 18:14:14 Complete: ActivateLoggingAction at: 2006/7/16 18:14:14, returned true Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result. Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__4668" returned false. Running: PerformSCCAction2 at: 2006/7/16 18:14:14 Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435 Product "{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}" versioned 9.00.0981 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00 The Product Name is "Microsoft SQL Server 2005 Tools Express Edition Beta 3" Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435 Error: Action "PerformSCCAction2" threw an exception during execution. Return Code: 70032 Message displayed to user SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme. Class not registered. Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.

I ran msiexec /x "{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}" without the quotes and got the following:

The setup has encounted an unexpected error in datastore. The action is Write_CommitFlag. The error is Unable to write property into cache: "flagCommit" XmRW Error: Failure loading xmlw.dll CheckAllProcedures[] return 2

I have ran the uninstall tool and deleted everything beta, etc from the add and remove list.

I have Visual Studio 2003 installed and SQL 7 and 2000 installed as well. I have now reinstalled all the other express tools and they are not working correctly either, but it may be because I can not get SQL 2005 Server Express installed.

Please help, hindering my school work.

Dee

This indicates that some beta components (files, reg keys, etc) still exist on your machine. Check the core setup log file located at %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files, whose name should be like SQLSetup0001_%machinename%_Core(Local).log. It will tell your the version of the beta components. Try the following steps sequently to remove those beta components.

1. Uninstall any visible Beta components in Add/Remove Program.
2. Remove all registy keys related to the specific Beta version, which you can get from the core log files. You need to search the whole registry tree with regedit command.
3. Kill any Beta services (including SQL, OLAP, SQLAGENT, SQLBROWSER, ...).
4. Reboot the machine.

Thanks,
Sam Lester (MSFT)

|||Under program files\microsoft sql server I have a directory 80, is this part of the beta?|||It is using this product "{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}" and I can not find it anywhere

problem installing sp4 on msde 2000 release A

Hello,
When I try to run the setup with the parameters I need (I have a default
instance installed already) to upgrade MSDE 2000 the setup program runs with
a blue screen on background and a modal window appears showing me the
parameters (like /i /p /v etc.). It seems to me that the setup is somehow
messed (I wonder if has something to do with the Windows Installer). Can
anyone help?
Thanks!
hi Leonardo,
Leonardo wrote:
> Hello,
> When I try to run the setup with the parameters I need (I have a
> default instance installed already) to upgrade MSDE 2000 the setup
> program runs with a blue screen on background and a modal window
> appears showing me the parameters (like /i /p /v etc.). It seems to
> me that the setup is somehow messed (I wonder if has something to do
> with the Windows Installer). Can anyone help?
have you tried re-downloading the sp4 package? perhaps it' corrupted..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Problem installing SP3a

I have kind of a messed up server I think. It had two instances of SQL
Server installed and I removed one.
Now, I'm getting an error trying to schedule run a scheduled DTS job. I
looked it up in the knowledge base and the best answers were to re-install
the service pack. So...
Reinstalling the service pack failes because it looks like the service pack
wants to authenticate itself to the SQL Server but can't. My guess is it
can't find the right instance to use to authenticate.
Does anyone know where I can set this? It sees the instance and brings it
up during the installation process, but both SQL Server authentication and
Windows Authentication both fail. I get the error message "Setup was unable
to validate the logged user. Press Retry to enter another option, or Cancel
to exit setup."
I tried the resolutions in Q814844 but they were either already set or
didn't make a difference. I'm guessing it might have something to do with
the second instance throwing off the installation so it doesn't know where
to authenticate itself.
Any ideas?
Thanks,
GaryDid you use "sa" and the corresponding password for the same ?
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
http://www.extremeexperts.com
"Gary" <tuffboystl@.hotmail.com> wrote in message
news:eYlt7KjdDHA.1880@.TK2MSFTNGP10.phx.gbl...
> I have kind of a messed up server I think. It had two instances of SQL
> Server installed and I removed one.
> Now, I'm getting an error trying to schedule run a scheduled DTS job. I
> looked it up in the knowledge base and the best answers were to re-install
> the service pack. So...
> Reinstalling the service pack failes because it looks like the service
pack
> wants to authenticate itself to the SQL Server but can't. My guess is it
> can't find the right instance to use to authenticate.
> Does anyone know where I can set this? It sees the instance and brings it
> up during the installation process, but both SQL Server authentication and
> Windows Authentication both fail. I get the error message "Setup was
unable
> to validate the logged user. Press Retry to enter another option, or
Cancel
> to exit setup."
> I tried the resolutions in Q814844 but they were either already set or
> didn't make a difference. I'm guessing it might have something to do with
> the second instance throwing off the installation so it doesn't know where
> to authenticate itself.
> Any ideas?
> Thanks,
> Gary
>|||yes.
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:O%23YUONodDHA.1620@.TK2MSFTNGP12.phx.gbl...
> Did you use "sa" and the corresponding password for the same ?
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD
> http://www.extremeexperts.com
>
> "Gary" <tuffboystl@.hotmail.com> wrote in message
> news:eYlt7KjdDHA.1880@.TK2MSFTNGP10.phx.gbl...
> > I have kind of a messed up server I think. It had two instances of SQL
> > Server installed and I removed one.
> >
> > Now, I'm getting an error trying to schedule run a scheduled DTS job. I
> > looked it up in the knowledge base and the best answers were to
re-install
> > the service pack. So...
> >
> > Reinstalling the service pack failes because it looks like the service
> pack
> > wants to authenticate itself to the SQL Server but can't. My guess is
it
> > can't find the right instance to use to authenticate.
> >
> > Does anyone know where I can set this? It sees the instance and brings
it
> > up during the installation process, but both SQL Server authentication
and
> > Windows Authentication both fail. I get the error message "Setup was
> unable
> > to validate the logged user. Press Retry to enter another option, or
> Cancel
> > to exit setup."
> >
> > I tried the resolutions in Q814844 but they were either already set or
> > didn't make a difference. I'm guessing it might have something to do
with
> > the second instance throwing off the installation so it doesn't know
where
> > to authenticate itself.
> >
> > Any ideas?
> >
> > Thanks,
> > Gary
> >
> >
>

Problem Installing RS

I have a windows 2000 Ent. test server with IIS, SQL 2K Ent., ASP.NET
running. Today after I installed RS Std. version the ASP.NET stopped
working with a permission error. I chose not to install Report Designer and
asked because Visual Studio .NET isn't installed. Removing RS fixed will
fix the ASP.NET problem. I really lost here. On my XP box I tested with
SQL and RS worked fine. Don't know what's wrong here. Can you guys help?
Thx.it was a bug described in http://support.microsoft.com/kb/887787
"ME" <ME@.hotmail.com> wrote in message
news:%23zKPpsOVFHA.3184@.TK2MSFTNGP15.phx.gbl...
>I have a windows 2000 Ent. test server with IIS, SQL 2K Ent., ASP.NET
>running. Today after I installed RS Std. version the ASP.NET stopped
>working with a permission error. I chose not to install Report Designer
>and asked because Visual Studio .NET isn't installed. Removing RS fixed
>will fix the ASP.NET problem. I really lost here. On my XP box I tested
>with SQL and RS worked fine. Don't know what's wrong here. Can you guys
>help? Thx.
>