Monday, June 6, 2011

SYSDBA User Fix Script:

When restoring a SalesLogix SQL database backup from one server to another, you must synchronize the database’s sysdba user to the new SQL server’s sysdba user.  If you skip this step, you will not be able to see the new database in Connection Manager and/or you will receive an error: "Connection Failed becuase of an error in initializing the provider.  Cannot open database "your database name" requested by the login. The Login Failed."

The Knowledgebase will provide the following:

Description:

When attempting to create a connection to a new SalesLogix database via Connection Manager, the name of the new database is not listed.

Possible Resolution:

If the database was recently attached or restored, run the sysdba_fix script against the database via SQL Query Analyzer. For information, see How to run the Sysdbafix_script.sql script on a database.

Clicking the how to run link will provide the following:

Description:

How to run the Sysdbafix_script.sql script on a database.

Possible Resolution:

To run the Sysdbafix script against the database:
  1. Open SQL Enterprise Manager
  2. Open Query Analyzer
  3. Select File / Open
  4. Browse to the SalesLogix CD(s)
    The sysdba script can be found in different places depending on the CD set you received.
    It can be in the Databases folder or the Upgrade folder.
  5. Select the Sysdbafix_script.sql script
  6. Execute it against the database
SYSDBA User Fix Script:
Run this script in SQL Server Management Studio/Query Analyzer for the new (or database with a problem) database.

 sp_change_users_login 'Update_One', 'sysdba', 'sysdba'

Monday, May 16, 2011

Put Your Mac to Sleep Now!


From Mac|Life see the article here (Put your Mac to Sleep Now!)
screen shot of Expose and spaces of options
Active Screen Corners can put your display to sleep, but not your Mac.
Is there a way to put my Mac to sleep with a series of keystrokes, instead of going to the Apple menu and selecting Sleep? 
Absolutely! For a quick-sleep keyboard shortcut, hold down Command-Option-Eject for two seconds. If you’re looking for a keyboard shortcut to put all displays—but not your Mac itself—to sleep, press Control-Shift-Eject. To get that handy Restart/Sleep/Shut Down/Cancel dialog (the same one you got by pressing the Power button on older Mac keyboards), just press Control-Eject.
It’s also possible to put your display (not your whole Mac) to sleep in an instant whenever you drag your mouse cursor to one corner of the screen. Go to System Preferences > Exposé and Spaces > Exposé, and set one of the Active Screen Corners to Sleep Display

10 Coolest Keyboard Shortcuts You Never Knew About

10 Coolest Keyboard Shortcuts You Never Knew About from Mac|Life.com...

Keyboard shortcuts are the lifeblood of many productive Mac users. Not only can keyboard shortcuts make for a nicer user experience and cut down on the time needed to do a task, they can also just be plain cool. Mac OS X has many shortcuts ready and willing to do your bidding, but also has many hidden and unknown shortcuts. That's why we've compiled a list of 10 of the coolest keyboard shortcuts you never knew about.




1.Control + Option + Command + Eject

Use the keyboard combination of Control + Option + Command + Eject to instantly shut down your Mac. This is a great time saver because it bypasses the shut down counter that you get when using Apple menu > Shut Down. As an alternative, you can also press Option + Command + Eject to sleep your Mac.

2. Command + Shift + A/U/D

These keyboard shortcuts are used to navigate around the Finder. To open the Applications folder on your Mac, press Command + Shift + A in an opened Finder window; press Command + Shift + U to open the Utilities folder; and, press Command + Shift + D to open your Desktop folder in the Finder. These keyboard shortcuts can also be used when in an opened save dialog to navigate to these folders.

3. Shift + Command + I

When used inside of Safari, this keyboard shortcut (Shift + Command + I) will automatically generate a new email message inside of Mail.app and paste the link of the web page you were browsing in the body text. This shortcut is great for quickly sharing a website address with a friend via email.

4. Control + D

To the bane of many Windows to Mac switchers, the Mac's "Delete" key doesn't actually function as the delete key does in Windows. The "Delete" key on the Mac instead functions as a backspace. To remedy this, you can instead use Command + D in any text area on your Mac to delete from the front of the cursor.

5. Control + Option + Command + 8

Use this keyboard shortcut to invert the colors on your Mac's screen. This high contrast display is used by individuals with visual impairments needing high-contrast screens, but can also provide a cool effect. Warning: this keyboard shortcut may be useful when doing April fool's pranks, but Mac|Life will not be responsible for any damages resulting from the prank recipient trying to beat their Mac back into shape.

6. Control + Command + D

When writing, we often need to quickly look up the meaning of a word; however, it can be a pain to open Dictionary.app and type in the word we want to look up. Instead, we prefer this nice way to quickly look up a word. With your mouse cursor over top of the word you'd like to look up, press Control + Command + D. A dialog will then pop up with the word defined by the built-in Mac OS X dictionary. While holding down the keyboard combination, you can mouse around to different words in the document.

7. Command + Shift + 4 + Space bar

At Mac|Life, we deal with a lot of screenshots on a daily basis, and this little-known keyboard combination allows us to capture a screenshot of only the window we need. To grab just a one-window screenshot, press Command + Shift + 4, then when the cross hairs appear, press the space bar. The cross hairs will change to a picture of a camera that can be placed over top of the window to be captured and clicked. The resulting window-only screenshot will appear on your Desktop.

8. Option + Command + M

Sometimes when you're working on a large task, you lose track of just how many windows you've opened on your Mac. To minimize all of your opened windows and de-clutter your screen, just press Option + Command + M to have all of the windows minimized to the Dock.

9. Option + Shift + Command + Esc

Mac applications can sometimes get unruly and crash. When this happens, you can press and hold Option + Shift + Command + Esc to instantly Force Quit the application, and bypassing the Force Quit app.

10. Command + `

Exposé and Command + Shift is a great way to cycle through all of the different applications and windows opened on your Mac, but what if you only want to cycle through the current application's opened windows? In that case, use Command + ` (the ` is located on the key above tab and next to the number 1 key). This keyboard combination will cycle through all of the opened windows in the currently active application.

Do you know of another time-saving keyboard shortcut that you use? Let us know about it in the comments section below.

Monday, May 9, 2011

Insight 6.5.X Support Being Discontinued

Are you using a Supported Version of Scribe Insight? If not, you are at risk of not being able to receive help when you have an issue. The Scribe Insight 6.5.x platform will be discontinued the end of June 2011. What does this mean to you? If you are running on Scribe Insight 6.5.x or older, you will not receive support for your installation.

Scribe Online RS is ready to purchase

We’re excited to announce that the first service built on the Scribe Online platform has been released and is ready to sell. Scribe Online Replication Services (RS) significantly simplifies the data extraction and replication of Dynamics CRM 2011 Online and Dynamics CRM 2011 on-premise data. Contact your Scribe Regional Business Manager if you are interested in selling Scribe Online RS, and be sure to ask them about our Scribe Online RS webinar series.

Welcome to extreme 2011 Las Vegas

extreme is the premier partner event focused exclusively on Microsoft Dynamics CRM and dedicated to advancing best practices and strategies for Microsoft Dynamics CRM organizations.

Prepare for Microsoft Dynamics CRM 2011
Technical Readiness: Extreme provides a unique opportunity to gain deep technical readiness on Microsoft Dynamics CRM 2011 in a face-to-face environment - with content delivered by Microsoft product team, technical support and MVP technical experts within the channel.
Evolve Your Business
Business Readiness: You’ll also learn best practices from professionals who are subject matter experts in marketing, sales and business leadership, providing a well-rounded approach to building your practice. You’ll gain insights on how to evolve your business to take advantage of the transforming Microsoft Dynamics CRM strategy including the new marketplace and how to build a successful cloud practice along with growing their current business.
Connect with the Channel
Business Connections: extreme provides a great multi-day opportunity to connect with other successful CRM partners, creating important business relationships to help your business grow.