Advice MSDE/ACCESS

I wrote an app that uses MSDE. IT is VB.NET, and there are only 10 users
tops.
To make an MSDE installation and get the database working requires me, which
makes it not really a commercially distributable product.
Would I be better just using an MDB file? Seems like MSDE is really nice
and basically SQL but I need something that installs easy--i.e. my users can
install. I know I can easily install an MDB file.
Would the MDB file be sufficient for 10-20 users tops?
thanks,
Shane
On Sat, 12 Jun 2004 02:36:37 -0500, SStory
<TheStorys@.TAKEOUTTHISSPAMBUSTERsofthome.net> wrote:

> Would the MDB file be sufficient for 10-20 users tops?
That depends on the complexity of your queries and the level of your
requirements. If you're only doing some SELECT statements and occasional
updates/inserts, an .mdb file is certainly enough. You could run into
troubles with locking mechanisms in MS Access though, so take care.
Installing MSDE is not a big deal, you just have to care for populating
the database yourself (ie: from your application) to make it easier for
your users.
Using SECURITYMODE and DBPWD(?) as setup parameters can even set up a
version of MSDE that runs similar to MSDE 1.0 (speaking of access to it)
Stefan
Give a man fire and he is warm for a day.
Set him on fire and he is warm for the rest of his life.

AdventureWorks OLAP Cubes samples missing

Hi there,

I am setting up a demo with Scorecard Manager 2005. After days of struggle, the installation seems to be fine, I can publish all the two dimensional scorecards. But the sample AdventureWorks OLAP cubes do not seem to be accessible or they don't exist - to be more exact, Scorecard Manager is able to log on to the SQL Server database called AdventureWorksDW, but cannot find any cubes.

I downloaded the latest SQL Server 2005 samples here and followed all the instructions to the letter. I did not get any errors while deoplying the AdventureWorks solution in the Business Intelligence Development Studio. One concern related to the samples is that the AdventureWorksAS sample is not available. I thought that the DW database is used there, am I wrong?

I think that I'm missing some key element in deploying the sample OLAP cubes. Is there a way to check that they are made correctly? What application do I best use to peform this check?

I am running Server 2003, SP1, SQL Server 2005 SP1 with Analysis/Reporting/Integration services installed, SharePoint Server 2003 SP2 (all applications are running fine so far on it).

Thank you very much, Radu

PS: I just discovered and error posted by the Event Viewer. It seems that the system admin does not have authority to view ADOMD sources. How can I debug this error? This is a demo setup on a virtual PC so I gave all authorities to Admin from the initial setup and the AdventureWorksDW database exists (the Scorecard Manager app. does find the database, but cannot see any cubes and this is when the error shows up in the Event Viewer).

Here are the error details:

Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Either the user, NT AUTHORITY\SYSTEM, does not have access to the Adventure Works DW database, or the database does not exist.
at Microsoft.AnalysisServices.AdomdClient.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection+IXmlaClientProviderEx.Discover(String requestType, IDictionary restrictions, Boolean throwOnErrors, Boolean sendNamespaceCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetProperty(String propName)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.SetProperty(String propertyName, String propValue)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ChangeDatabase(String database)
at Microsoft.PerformanceManagement.Scorecards.Server.OlapUtils.GetCubeNames(String databaseName)
at Microsoft.PerformanceManagement.Scorecards.Server.PmServer.GetCubeNames(DataSource dataSource)

I figured it out: there seems to be a mistake in the Scorecard Manager 2005 OLAP cubes samples' settings (the Adventure Works DW samples available here). If you open a scorecard's Data Source (in the Scorecard Builder), you need to erase any Database Roles. The samples come with 'All Users' set, but trying 'Reader' only for example, which is what is needed based on installation instructions, does not work.

Thanks to Ian Tien's site; I downloaded his Adventure Works DW samples, which are based on the 10 Analysis Services' tutorial cubes, and looked at his scorecard's configuration.

I guess this message is more for a Scorecard Manager 2005 board, but I couldn't find one on this MSDN forum site. But Analysis Services are inseparable from Scorecard, so I hope it helps someone.

adventureworks installation

I downloaded and installed the .msi from codeplex. After installation I open SQL Server Management Studio but don't see AdventureWorksDB in the list of databases. How is this possible? Should I not be seeing this new database? Do I have to do something else?

From within the sql server studio, right click on the databases entry. The task you are looking for is "attach database".

Grab the .mdf file for the adventure works db. ( It may try to grab a .log file that is in the wrong directory, if so, delete the reference to it on the screen. It will create another log file in the same directory as the .mdf file.)

sql

Adventure Works DW databases INSTALLATION

In SQL Server April 2006 Books Online (BOL)

ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/instsql9/html/8c4c2af8-f2ed-4559-b5d2-984a9f7ce5ca.htm

... near the bottom, the following is said ...

To deploy the Adventure Works DW analysis services project

1. Make sure that the AdventureWorksDW and Adventure Works DW databases have been installed.

Where do I install/find the "Adventure Works DW database?" I can not find this other database anywhere?

Thanks.

AIM

During product installation make sure you install Samples.

After product is installed go to the Start->Programs->Microsoft SQL Server 2005->Documentation and Tutorials->Samples and run Setup for "Microsoft SQL Server 2005 Samples (English)"

You AdventureWorksDW Analysis Services sample project should be installed into C:\Program Files\Microsoft SQL Server\90\Tools\Samples. There you would also find relational database for it.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

Hi,

We can also install the default database in another way right from the very beginning. When we are installing the MSAS2005 After selecting the components that we want to install and click on the Advance button. Select "Entire feature will be installed on local hard drive" for the "Books Online and Samples" category.

Your AdventureWorksDW Analysis Services sample project should be installed into C:\Program Files\Microsoft SQL Server\90\Tools\Samples

Please let me know if I am wrong

Thanks

|||

I have been sending forum questions about setting up the Analysis services samples.

I finally figured this out: "Adventure Works DB" database and "AdventureWorksDW" are the same.

In the Analysis Services sample solution "Adventure Works DW," I was recieving Process errors on cubes. I right clicked the solution. I chose properties. I changed the database from Adventure Works DW (that does not exist) AdventureWorksDW. Next, I processed and did not get any errors.

This is from the latest April Samples collection. Maybe someone can tell the people at Microsoft to make this fix.

AIMDBA

sql

Adventure Works DW databases INSTALLATION

In SQL Server April 2006 Books Online (BOL)

ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/instsql9/html/8c4c2af8-f2ed-4559-b5d2-984a9f7ce5ca.htm

... near the bottom, the following is said ...

To deploy the Adventure Works DW analysis services project

1. Make sure that the AdventureWorksDW and Adventure Works DW databases have been installed.

Where do I install/find the "Adventure Works DW database?" I can not find this other database anywhere?

Thanks.

AIM

During product installation make sure you install Samples.

After product is installed go to the Start->Programs->Microsoft SQL Server 2005->Documentation and Tutorials->Samples and run Setup for "Microsoft SQL Server 2005 Samples (English)"

You AdventureWorksDW Analysis Services sample project should be installed into C:\Program Files\Microsoft SQL Server\90\Tools\Samples. There you would also find relational database for it.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

Hi,

We can also install the default database in another way right from the very beginning. When we are installing the MSAS2005 After selecting the components that we want to install and click on the Advance button. Select "Entire feature will be installed on local hard drive" for the "Books Online and Samples" category.

Your AdventureWorksDW Analysis Services sample project should be installed into C:\Program Files\Microsoft SQL Server\90\Tools\Samples

Please let me know if I am wrong

Thanks

|||

I have been sending forum questions about setting up the Analysis services samples.

I finally figured this out: "Adventure Works DB" database and "AdventureWorksDW" are the same.

In the Analysis Services sample solution "Adventure Works DW," I was recieving Process errors on cubes. I right clicked the solution. I chose properties. I changed the database from Adventure Works DW (that does not exist) AdventureWorksDW. Next, I processed and did not get any errors.

This is from the latest April Samples collection. Maybe someone can tell the people at Microsoft to make this fix.

AIMDBA

Advantages of SQL Server 2005 named instance?

The installation of SQL Server 2005 (Express) has an option
for default instance or named instance (SQLExpress as default)
What are the advantages of setting up named instance and default instance?
Thanks for answering...
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1"pedestrian via SQLMonster.com" <u16758@.uwe> wrote in
news:64c9478703e41@.uwe:
> The installation of SQL Server 2005 (Express) has an option
> for default instance or named instance (SQLExpress as default)
> What are the advantages of setting up named instance and default
> instance? Thanks for answering...
There can only be one default instance, but multipe named instances with
different names. Advantage of the default instance is that you (or the
user) do not have to remember an instance name.
One of the major reasons for using multiple instances will be complete
separation of database solutions. Each instance has it's own service, and
thus you can set memory constraints per instance. Furthermore, remember
that logins are defined in the master database, so logins are only
available within that instance, which can be a good security measure.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||Thanks for replying... I'm currently using SQL Server 2005 Express...
I have set up with Named Instance = SQLExpress, that is, the default name.
So, does that mean I can still set up another copy of Express server
using Default Instance?
Ole Kristian Bangås wrote:
>> The installation of SQL Server 2005 (Express) has an option
>> for default instance or named instance (SQLExpress as default)
>> What are the advantages of setting up named instance and default
>> instance? Thanks for answering...
>There can only be one default instance, but multipe named instances with
>different names. Advantage of the default instance is that you (or the
>user) do not have to remember an instance name.
>One of the major reasons for using multiple instances will be complete
>separation of database solutions. Each instance has it's own service, and
>thus you can set memory constraints per instance. Furthermore, remember
>that logins are defined in the master database, so logins are only
>available within that instance, which can be a good security measure.
>
--
Pedestrian, Penang.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1|||> So, does that mean I can still set up another copy of Express server
> using Default Instance?
Yes. There can be one default instance on a machine and a number of named instances (each need a
unique name, of course). Installation order doesn't matter (excluding prior versions of SQL
Server/MSDE).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"pedestrian via SQLMonster.com" <u16758@.uwe> wrote in message news:64d4235358c63@.uwe...
> Thanks for replying... I'm currently using SQL Server 2005 Express...
> I have set up with Named Instance = SQLExpress, that is, the default name.
> So, does that mean I can still set up another copy of Express server
> using Default Instance?
> Ole Kristian Bangås wrote:
>> The installation of SQL Server 2005 (Express) has an option
>> for default instance or named instance (SQLExpress as default)
>> What are the advantages of setting up named instance and default
>> instance? Thanks for answering...
>>There can only be one default instance, but multipe named instances with
>>different names. Advantage of the default instance is that you (or the
>>user) do not have to remember an instance name.
>>One of the major reasons for using multiple instances will be complete
>>separation of database solutions. Each instance has it's own service, and
>>thus you can set memory constraints per instance. Furthermore, remember
>>that logins are defined in the master database, so logins are only
>>available within that instance, which can be a good security measure.
> --
> Pedestrian, Penang.
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1
>|||I haven't tried to install two SQL Server 2005 Express instances on the
same computer, but since multiple applications may install their instance
of MSDE I cannot see any reason why this should not work.
"pedestrian via SQLMonster.com" <u16758@.uwe> wrote in
news:64d4235358c63@.uwe:
> Thanks for replying... I'm currently using SQL Server 2005 Express...
> I have set up with Named Instance = SQLExpress, that is, the default
> name.
> So, does that mean I can still set up another copy of Express server
> using Default Instance?
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||Thanks to Tibor and Ole... I shall try it out.
--
Pedestrian, Penang.
Message posted via http://www.sqlmonster.com

Advantages of SQL Server 2005 named instance?

The installation of SQL Server 2005 (Express) has an option
for default instance or named instance (SQLExpress as default)
What are the advantages of setting up named instance and default instance?
Thanks for answering...
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200608/1"pedestrian via droptable.com" <u16758@.uwe> wrote in
news:64c9478703e41@.uwe:

> The installation of SQL Server 2005 (Express) has an option
> for default instance or named instance (SQLExpress as default)
> What are the advantages of setting up named instance and default
> instance? Thanks for answering...
There can only be one default instance, but multipe named instances with
different names. Advantage of the default instance is that you (or the
user) do not have to remember an instance name.
One of the major reasons for using multiple instances will be complete
separation of database solutions. Each instance has it's own service, and
thus you can set memory constraints per instance. Furthermore, remember
that logins are defined in the master database, so logins are only
available within that instance, which can be a good security measure.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||Thanks for replying... I'm currently using SQL Server 2005 Express...
I have set up with Named Instance = SQLExpress, that is, the default name.
So, does that mean I can still set up another copy of Express server
using Default Instance?
Ole Kristian Bang?s wrote:
>There can only be one default instance, but multipe named instances with
>different names. Advantage of the default instance is that you (or the
>user) do not have to remember an instance name.
>One of the major reasons for using multiple instances will be complete
>separation of database solutions. Each instance has it's own service, and
>thus you can set memory constraints per instance. Furthermore, remember
>that logins are defined in the master database, so logins are only
>available within that instance, which can be a good security measure.
>
Pedestrian, Penang.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200608/1|||> So, does that mean I can still set up another copy of Express server
> using Default Instance?
Yes. There can be one default instance on a machine and a number of named in
stances (each need a
unique name, of course). Installation order doesn't matter (excluding prior
versions of SQL
Server/MSDE).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"pedestrian via droptable.com" <u16758@.uwe> wrote in message news:64d4235358c63@.uwe...[vbco
l=seagreen]
> Thanks for replying... I'm currently using SQL Server 2005 Express...
> I have set up with Named Instance = SQLExpress, that is, the default name.
> So, does that mean I can still set up another copy of Express server
> using Default Instance?
> Ole Kristian Bang?s wrote:
> --
> Pedestrian, Penang.
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200608/1
>[/vbcol]|||I haven't tried to install two SQL Server 2005 Express instances on the
same computer, but since multiple applications may install their instance
of MSDE I cannot see any reason why this should not work.
"pedestrian via droptable.com" <u16758@.uwe> wrote in
news:64d4235358c63@.uwe:

> Thanks for replying... I'm currently using SQL Server 2005 Express...
> I have set up with Named Instance = SQLExpress, that is, the default
> name.
> So, does that mean I can still set up another copy of Express server
> using Default Instance?
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||Thanks to Tibor and Ole... I shall try it out.
Pedestrian, Penang.
Message posted via http://www.droptable.comsql

Administrative question for SQL Server 2000

Hello gentlemen,

I would like to ask a question, more like to verify something that I know myself.
I have an installation in SQL Server 7.0 (SP4), that hosts a database of 70gb with an average growth of 5 gb a month, that is being 'hitted' with an average of 600 clients, (about 50 to 90 concurrent hits). My question is :

Given the fact that I wish to upgrade my server to an SQL Server 2000 Enterprise Edition, how much RAM should I fit to the new machine?

I do have my suspicion, and I would like to keep it to myself for now, I would like also to ask if there's a formula for ram calculation. Mind you I don't ask for MINIMUM RAM, but more like OPTIMUM RAM, being that this Server hosts a critical system.

Thank you in advance.Given the fact that I wish to upgrade my server to an SQL Server 2000 Enterprise Edition, how much RAM should I fit to the new machine?

You want as much as you can afford. RAM is cheap in the grand scheme of things. Get the 8 gigs (I'm assuming you don't have data center) if you can afford it. RAM is probably the single most important factor in SQL Server performance.|||I know that, actually, I 've suggested that myself to the IT Management, but let's just say they're 'stingy' (to say the least (!)). So I was looking for a rule of the thumb kind of thing.

Thank you tho for the reply :)

Administrative Install

I am looking at attempting to create a deployable installation of the SQL client tools only. anyone know an easy way to do this?
Steve
"STEVE SCHNEIDER" <SSCHNE@.NOSPAM.millerwelds.com> wrote in message
news:evweJL6KEHA.3932@.TK2MSFTNGP10.phx.gbl...
> I am looking at attempting to create a deployable installation of the SQL
client tools only. anyone know an easy way to do this?
I do not know about an easy way, however, you could use a product like WISE
to create an installation package.
Steve
|||As far as I know there is not away to deploy an installation of the SQL
Server client tools, except by running setup from the SQL Server CD or
using the sqlcli.bat on the CD.
Rand
This posting is provided "as is" with no warranties and confers no rights.