Another Newbie Question (about queries)

I'm moving things from Access to SQL Server. What do I do with queries? I'm
using Access 2000 to access Sql Server, and there doesn't seem to be
anything for queries.

Does SQL Server have queries, or are they just done in the page code (to
access data on a website)?

I also have a trial version of Enterprise Manager, but I can't figure out
how to connect. If that would show queries.

Thanks

JAQueries would be either Views or Stored Procedures in your SQL database.
Normally Views are for select statement and the rest you would use Stored
Procedures.

When you open SQL Enterprise Manager you need to expand on the left
pane until you open your local server, databases and access your database.

SQL Query Analyzer is where you can execute SQL code for example
SELECT statements and see the result there.

> I'm moving things from Access to SQL Server. What do I do with queries?
I'm
> using Access 2000 to access Sql Server, and there doesn't seem to be
> anything for queries.
> Does SQL Server have queries, or are they just done in the page code (to
> access data on a website)?
> I also have a trial version of Enterprise Manager, but I can't figure out
> how to connect. If that would show queries.

Analysis Services Deployment Security Issue

We have been working on moving our database from SQL2000 to 2003 the last couple of months. We are now working on our cube migration and have attempted a few deployments. The problem is, every time we try to process the deployed cube it gives us the following error:

The following system error occurred: Logon failure: unknown user name or bad password.

We only have one connection in this deployment and have tried with various cubes all the way down to one dimension.

Our connection always tests successfully on the dialog box itself, we have attempted both, windows and SQL authentication, and both always yield the same error.

Up to this point we have not able to process any cube we have attempted.

As far as I can tell our SQL and Analysis services both are set to the same instance name, but I’m thinking this may be a configuration issue, since it seems that internally Analysis services just cant contact SQL services.

Anyone has an idea of what may be wrong with the configuration?

Have you tried setting the Impersonation Information to Default, and including the user name and password in the connect string?|||Hmm, I had not tried that. Attempted it now and it worked.

This solves my problem but now I question why would the other settings not work?