Mirror database and users

We are mirroring to a server used to generate reports and datamarts. Is
there a technique of synching up the database users with the principle
server?
We use snapshots to generate reports and datamarts off of.Best approach is to make sure the logins on that other SQL Server has the co
rrect SID in the first
place. Search KB for sp_help_revlogin and check it out. If that isn't an opt
ion for you, you need to
do something with sp_change_users_login, something you run after the failove
r has taken place...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kevin Jackson" <kjackson@.powerwayinc.com> wrote in message
news:ekB9rBEeGHA.1320@.TK2MSFTNGP04.phx.gbl...
> We are mirroring to a server used to generate reports and datamarts. Is t
here a technique of
> synching up the database users with the principle server?
> We use snapshots to generate reports and datamarts off of.
>

Mirror database and users

We are mirroring to a server used to generate reports and datamarts. Is
there a technique of synching up the database users with the principle
server?
We use snapshots to generate reports and datamarts off of.Best approach is to make sure the logins on that other SQL Server has the correct SID in the first
place. Search KB for sp_help_revlogin and check it out. If that isn't an option for you, you need to
do something with sp_change_users_login, something you run after the failover has taken place...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kevin Jackson" <kjackson@.powerwayinc.com> wrote in message
news:ekB9rBEeGHA.1320@.TK2MSFTNGP04.phx.gbl...
> We are mirroring to a server used to generate reports and datamarts. Is there a technique of
> synching up the database users with the principle server?
> We use snapshots to generate reports and datamarts off of.
>sql

Mining Structures

I am using the wizard to create a new mining structure and getting the error at the time of selecting the datamining technique like either microsoft decision tree or microsoft timeseries etc.,

"Unable to retrieve a list of supported data mining algorithms. Make sure you are connected to the correct Analysis Services server instance and the Analysis Services server named localhost is running and configured properly. You can continue with a default list of data mining algorithms."

What is that means?

Thanks in advance,

Got it. I need to start the AS from Control Panel/Administrative tools etc etc., before doning this.

I think the default is Manual to start the service.

|||Right-click on the Analysis Service project and select Properties - under Configuration Properties->Deployment, check what you have under Target->Server. The value of the Server property should be the name of the Analysis Services instance that you want the project to connect/deploy to. When you try to select a data mining technique, we try to connect to the Target Server to fetch the list of supported techniques. If you have "localhost" in this property, check Control Panel->Administrative Services->Services to confirm that the "SQL Server Analysis Services" service is running. If you specified a named instance (servername\instancename), check that the corresponding instance (SQL Server Analysis Services (instancename)" as well as the "SQL Server Browser" service is running.sql