restrict local cube

Does anyone know how can we prevent users from creating offline/local cube (in Excel) from our OLAP/Analysis Service server ?
Thank you.I'm almost certain that this isn't possible. There are ways that you can make it a bit more difficult, but those will only annoy your users.

If you find some way to do this, please let me know how you went about it.

-PatP|||Deny them access to the cubes ?|||Deny them access to the cubes ?
No, users still allowed to perform live access but must be prevented from creating local (offline) cube which they can bring home.

I'm aware of a new property introduced on SQL 2000 SP3a named RESTRICTED CLIENT but not sure if it has anything to do with our need nor how to set it up.sql

Restoring SQL 2005 Analysis service database backup on SQL 2000

Hello
I think the subject line says it all.
Is there any way to import my cubes, measures from SQL 2005 Analysis
service to SQL 2000 Analysis service database.
Madhur> I think the subject line says it all.
> Is there any way to import my cubes, measures from SQL 2005 Analysis
> service to SQL 2000 Analysis service database.
I do not think so. If you have a data warehouse, you can create a fresh OLAP
2000 cube. If not, you have problems. What you could do is you could
regenerate a SSAS 2005 project with BI Dev Studio, then generate the DW
schema in a relational database from the project, and finally generate the
OLAP 2000 cube from the DW. You have to export the data from the SSAS UDM to
the DW and then process the OLAP 2000 cube.
maybe I am wrong, but at the moment, I cannot imagine an easier process.
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

Restoring SQL 2005 Analysis service database backup on SQL 2000

Hello
I think the subject line says it all.
Is there any way to import my cubes, measures from SQL 2005 Analysis
service to SQL 2000 Analysis service database.
Madhur> I think the subject line says it all.
> Is there any way to import my cubes, measures from SQL 2005 Analysis
> service to SQL 2000 Analysis service database.
I do not think so. If you have a data warehouse, you can create a fresh OLAP
2000 cube. If not, you have problems. What you could do is you could
regenerate a SSAS 2005 project with BI Dev Studio, then generate the DW
schema in a relational database from the project, and finally generate the
OLAP 2000 cube from the DW. You have to export the data from the SSAS UDM to
the DW and then process the OLAP 2000 cube.
maybe I am wrong, but at the moment, I cannot imagine an easier process.
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

restoring master database

Hi,
the problem I have is that my master database file is corrupted.
Therefore MSSQLSERVER service does not start.
I tried to start it in single user mode, but it still wants to start up the
master database.
I tried to substitute my master database with another one, just to start up
the service, but still have problems. It reads the master database and only
master not other databases.
What exactly to do, that I could restore my backup of master database?
regards,
AndrejDid you start SQL Server using the -m switch?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Andrej Hudoklin" <andrej.hudoklin@.add.si> wrote in message
news:uiWog0gmDHA.3732@.tk2msftngp13.phx.gbl...
> Hi,
> the problem I have is that my master database file is corrupted.
> Therefore MSSQLSERVER service does not start.
> I tried to start it in single user mode, but it still wants to start up the
> master database.
> I tried to substitute my master database with another one, just to start up
> the service, but still have problems. It reads the master database and only
> master not other databases.
> What exactly to do, that I could restore my backup of master database?
>
> regards,
> Andrej
>|||Yes.
I tried to start the service using sqlservr -c -m on the binn directory of
my instance.
But then, if I use osql to connect on, it says that server does not exist or
just to list all the running SQL servers, mine is not among them.
How can I start the service and then restore my backup of master database?
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:ujckL3gmDHA.1656@.tk2msftngp13.phx.gbl...
> Did you start SQL Server using the -m switch?
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Andrej Hudoklin" <andrej.hudoklin@.add.si> wrote in message
> news:uiWog0gmDHA.3732@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > the problem I have is that my master database file is corrupted.
> > Therefore MSSQLSERVER service does not start.
> >
> > I tried to start it in single user mode, but it still wants to start up
the
> > master database.
> > I tried to substitute my master database with another one, just to start
up
> > the service, but still have problems. It reads the master database and
only
> > master not other databases.
> >
> > What exactly to do, that I could restore my backup of master database?
> >
> >
> > regards,
> > Andrej
> >
> >
>|||I've solved my problem.
The thing is if you have corrupted file of master database, the MSSQLSERVER
service wont start.
Then you have a backup but you can not start the service.
Everyone says just start the service in single user mode in command prompt
by using sqlservr.exe and switch -m.
It would be great if that is true.
To start the service you need a good .mdf and .ldf file of master database,
my suggestion is to copy that 2 files from SQL server installation CD.
The try to start the service in single user mode. Still doesn't work. Why?
Becasue it still wants to raise all of your databases. That's why you have
to copy all the rest of files databases from the CD to the path c:\program
files\Microsoft SQL server\MSSQL\Data\
and then you can start the service using file sqlservr.exe in the binn
directory of you SQL servere instance.
use: sqlservr -m
the service will start
open another command prompt window and use osql utilltiy to restore your
backup of master database
then just restart you computer and it should work
Hope that this will help anyone.
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:ujckL3gmDHA.1656@.tk2msftngp13.phx.gbl...
> Did you start SQL Server using the -m switch?
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Andrej Hudoklin" <andrej.hudoklin@.add.si> wrote in message
> news:uiWog0gmDHA.3732@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > the problem I have is that my master database file is corrupted.
> > Therefore MSSQLSERVER service does not start.
> >
> > I tried to start it in single user mode, but it still wants to start up
the
> > master database.
> > I tried to substitute my master database with another one, just to start
up
> > the service, but still have problems. It reads the master database and
only
> > master not other databases.
> >
> > What exactly to do, that I could restore my backup of master database?
> >
> >
> > regards,
> > Andrej
> >
> >
>|||Andrej,
I think Tibor merely missed the part that the master db file is corrupt.
Good to see you post how you fixed the problem.
For anyone interested, there is a section in BOL about this situation.
Search for "Rebuilding the master Database" in BOL.
Quentin
"Andrej Hudoklin" <andrej.hudoklin@.add.si> wrote in message
news:uWURfWjmDHA.3316@.tk2msftngp13.phx.gbl...
> I've solved my problem.
> The thing is if you have corrupted file of master database, the
MSSQLSERVER
> service wont start.
> Then you have a backup but you can not start the service.
> Everyone says just start the service in single user mode in command prompt
> by using sqlservr.exe and switch -m.
> It would be great if that is true.
> To start the service you need a good .mdf and .ldf file of master
database,
> my suggestion is to copy that 2 files from SQL server installation CD.
> The try to start the service in single user mode. Still doesn't work. Why?
> Becasue it still wants to raise all of your databases. That's why you have
> to copy all the rest of files databases from the CD to the path c:\program
> files\Microsoft SQL server\MSSQL\Data\
> and then you can start the service using file sqlservr.exe in the binn
> directory of you SQL servere instance.
> use: sqlservr -m
> the service will start
> open another command prompt window and use osql utilltiy to restore your
> backup of master database
> then just restart you computer and it should work
> Hope that this will help anyone.
>
>
> "Tibor Karaszi"
<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:ujckL3gmDHA.1656@.tk2msftngp13.phx.gbl...
> > Did you start SQL Server using the -m switch?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "Andrej Hudoklin" <andrej.hudoklin@.add.si> wrote in message
> > news:uiWog0gmDHA.3732@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > the problem I have is that my master database file is corrupted.
> > > Therefore MSSQLSERVER service does not start.
> > >
> > > I tried to start it in single user mode, but it still wants to start
up
> the
> > > master database.
> > > I tried to substitute my master database with another one, just to
start
> up
> > > the service, but still have problems. It reads the master database and
> only
> > > master not other databases.
> > >
> > > What exactly to do, that I could restore my backup of master database?
> > >
> > >
> > > regards,
> > > Andrej
> > >
> > >
> >
> >
>

Restoring encrypted databases between different servers

Hello:

I'm working with two sql servers instances, ServerA and ServerB, which run under two different service accounts on different machines. They both have a database, DatabaseA, that has some encrypted fields.

If I take a backup of DatabaseA on ServerA and restore it on ServerB, I need to re-encrypt the Database Master Key (DMK) with the Service Master Key (SMK) as follows:

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'pwd used to encrypt DMK'

ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY

However, if I again take a backup on ServerB and then restore it on ServerA, I can use the DMK on ServerA without re-encrypting it with the SMK.

Shouldn't I have to re-encrypt the DMK with the SMK everytime I restore from a backup that was generated from a different server?

Thanks,

Cyndi

After the initial RESTORE and ALTER MASTER KEY … ADD ENCRYPTION BY SERVER MASTER KEY on ServerB, a redundant copy of the DBMK (protected by ServerB SMK) will be stored in the mater DB; and as long as the DBMK is the same, the copies should be synchronized. This redundant copy is there to minimize the DBMK management after the initial setup (via RESTORE).

I hope this information helps. Please let us know if you have any additional questions and/or if you have any additional feedback.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

Restoring DB

Hi,

I have created a DB on my local machine.
Now I would like to copy this on to another machine.
I stopped the service and then copied both the MDF file and the
log files into the same folder as in Data folder of the second machine.

When I run theStudio express I cannot find the MDF file.It does not show up in the
the DB folder or window.
When I try to create one it says that the DB exists.

What am I missing?

I tried doing a backup and restore but then the DB is not created on the second machine and
hence wont work.

Tnx

How are you looking for the file in Management Studio? Are you using the Attach functionality? If there is more than one SQL Server running on the computer, there will be more than one Data directory, so it's possible that you've put the files in the wrong directory.

Let us know the exact steps you're using to attach the database on the new machine.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||Hi Mike,

>>How are you looking for the file in Management Studio? Are you using the Attach >>functionality?

I stoped the service on the first machine and then went into the folder:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
and copied both the DB and the Log files on to my CD.

I stoped the service on the second machine and then went into the folder.
copied them both into the second machine's :
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

There is only one SQL server installed on both the machines'.

Tnx

|||

Hi,

great you found the button for making fonts real big ! :-)

As Mike said you have to attach the database for before you can see it, use the Sp_attach procedure for this or use the graphical UI (SQL Server Management Studio Express) for that, I don′t know if there is a possibility to use this function for attaching otherwise sp_attachdb is quite easy to code in TSQL, there are samples on the BOL for that.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Restoring database on my localhost

Hi there,

I am using VWD and have my production website hosted elsewhere. The hosting company provides a backup service that allows me to download a something.bak file as the backup of my website. My query is: how to export or copy the data in the something.bak file into the database on my own computer? Can anyone helps please?

Thanks in advance.

Why you want to use .bak file. Just connect you sql server to remote database using enterprise manager and import the database from remote server to your server.

Please let me know if you have any doubt.

|||

Thanks for your response.

I am not familiar with SQL server. I am using .bak because the backup service provided by my hosting company uses this method. BTW, what I have is just a VWD. Where can I get the enterprise manager?

Regards.

|||

you can download SQL Management studio expresshere. You need external database access from your hosting company, I suggest contacting your hosting company for more information.

Regards Frederik