MS SQL DB Connection

Hi There,
Actually i am very new to MS CRM & I have a very simple question.
How should i grand a user to access CRM SQL database from the client machine.
and he wanted to run the reports.

i need the answer in details: either we need to give him access from the SQL 
Server or CRM Server.

Many thanks in advance, & Waiting for your Precious reply.
sab
 
0
Utf
8/16/2006 12:43:01 PM
crm 35858 articles. 1 followers. Follow

1 Replies
753 Views

Similar Articles

[PageSpeed] 48

By 'run THE reports' , which reports do you mean?
If you are going to use the ReportServices reports in CRM, the user needs 
access to CRM. 
If the user is going to use a SQL reporting tool, then they should still be 
a CRM user, and they should be using the 'Filtered*' views that are in the 
CRM database. The SQL Tool should pass the Windows Login credentials with the 
query.
You probably can use a SQL login as well, but this would be less secure.
-- 
Glen Howie
Microsoft CRM Product Specialist
WolfBridge Solutions
www.wolfbridgesolutions.com



"SyedAbdulbasith" wrote:

> Hi There,
> Actually i am very new to MS CRM & I have a very simple question.
> How should i grand a user to access CRM SQL database from the client machine.
> and he wanted to run the reports.
> 
> i need the answer in details: either we need to give him access from the SQL 
> Server or CRM Server.
> 
> Many thanks in advance, & Waiting for your Precious reply.
> sab
>  
0
Utf
8/23/2006 7:21:01 PM
Reply:

Similar Artilces:

MS Outlook 2007
I am running MS Outlook 2007 on a Vista home lap top. When trying to delete files (or folders) in the Deleted Items folder, I get a message that "the Folder is full" and the items remain. I "right click" on Deleted Items, select "Empty 'Deleted Items' Folder", and I get the usueal warning msg that states "Are you sure you want to permanently delete all the items and subfolders from the 'Deleted Items' folder?" I click on "Yes". I then get a second warning msg that says "The folder is full." The ite...

Query SQL Syntax
I have 2 queries that I am building another query off of. I have on query with the name of project contacts in it. I have another query with all the associated contact info in it. I made a cutom colum in the query and used this syntax. DPM Phone:(Select [Business Phone] FROM [Contacts Extended] Where [Contacts Extended]![Contact Name]=[Target_Stores_MRRS_Extended]![DPM]) This is not working. Can anyone help or point me to a good resource for how to use the syntax correctly. Thanks, On Thu, 27 May 2010 16:15:01 -0700, Rob Hamlin <RobHamlin@discussions.microsoft.com>...

Use of MS Dynamics CRM in Utility Billing
Hello Friendz, I was wondering if we can easily use Microsoft Dynamics CRM 3.0 for 'Utility Billing System and Print Presentment'. This also involves use of handheld devices for reading meters and bill presentment. In case you know about a better solution for this requirement, please share that with me. -- Regards, Dave Banerjee Cell: 0060 17331 4676 | email: IfThenElseEndIf@msn.com | IfThenElseEndIf@GMail.com That depends on what you mean by "easily" ;-) CRM out of the box will provide a great, flexible platform to quickly develop a robust business solution. Fro...

MS Office 97 to MS Office 2007
I have been running Office 97 pro on Windows XP because I do not want to loose the shortcut bar that came with 97. Thing is that I have been thinking about installing the 2007 version of Office that I have had but never installed yet for above reasons. Question is can I install the 2007 version over the 97 version and have it update the programs but keep the shortcut bar?? I know there are probably other shortcut bars or whatever out there but as I asked I would rather keep the 97 one if possible. TIA Microsoft has several Knowledge Base articles on running multiple...

How do I do word count in MS Publisher?
Mike, Publisher doesn't have a word count; the work-around wound be manually count the words or you could try copy the text and paste into Word. -- Don - Publisher 2000� Vancouver, USA "Mike Finn" <Mike Finn@discussions.microsoft.com> wrote in message news:9EBF3083-D7EC-46E9-ADA2-E4616499399E@microsoft.com... > Why not just do a "Edit Story in Microsoft Word" instead of copy and paste? -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Don Schmidt" <Don Engineer@PNB.Retired_...

how to join dynamic SQL results with another query
Hi Everybody, I'm using dynamic SQL to execute a pivot query for a sales report since the column names will change by month. The very last statement is "EXECUTE sp_executesql @query", where @query is my pivot query string. How do I join these results with another query so as to get one resulting dataset? For example, here's my "other query" results: SELECT 1 AS [CustId], 'ABC Corp.' AS [CustName] UNION ALL SELECT 2 AS [CustId], 'Microsoft' And here's my pivot query results: SELECT 1 AS [CustNum], 35.99 AS [Jan_Sales], 104.5...

Difference between MS EPM and MS Projects
What is the difference between MS EPM and MS projects Is it just project server and sharepoint added to MS projects together called MS EPM? Yes. EPM is Enterprise Project Management. Microsoft's solution is Project Professional plus Project Server which in turn uses SharePoint technology. -- Rod Gill Microsoft MVP for Project - http://www.project-systems.co.nz Author of the only book on Project VBA, see: http://www.projectvbabook.com "Project Mgt Noob" <Project Mgt Noob @discussions.microsoft.com> wrote in message news:A565E3DF-A7FC-4D2A-B2F1...

MS Exange connection
It deals with Outlook 2003, running under Win XP home: A friend has two ISPs, one with standard POP and SMTP servers, no problem there. The second is a remote MS Exchange server. He connects to both via Internet using ADSL connection. Question: how to configure the Exchange server connection such that it remembers his ID and PW? I could not find anything under just about any thinkable tab in Outlook, email accounts, etc. Any help will be greatly appreciated. -- JanAdam ...

MS Money 2005 Basics
I am new to MS Money after many years with Quicken. Money help offline and online, seems woefully short of detailed explanations o user scenarios. . Searching help for "Epay" yields nothing. Ca someone either direct me to a better help area or answer this In Bills what is the difference between Epay, APay, and Direct debit I see Apay is how i use the bill pay service of my bank. Is direc debit just my manual entry? What then is Epay? What might "Other payment type then be used for? Thanks The difference between them is this Epay is for electronic bill pay. You must have Bi...

MS CRM Certification question
Hi all, I have a question regarding the CRM certification? What, if any, certifications are there available with MS CRM? Is there anything like CRM Professional? Have I earned any certification if I passed the Applications Professional exam? T.I.A -- Kuba Skalbania [MCAD] ...

cannot connect to outlook
After configuring a fresh install of outlook 2007 to access my company's exchange 2003 server on my windows vista ultimate 64bit, I try multiple times to enter my password to access my account and it does not work. Error message is "The connection to microsoft exchange is unavailable. Outlook must be online or connected to complete this action." Clicking the ok response pops up a microsoft exchange window with a general tab with two fields, name of exchange server and mailbox. Clicking ok or cancel results in a new error message "cannot open your default e-mail folder...

Sent items downloading problem in MS office outlook 2007
Hi all, In my client pc's i have configured the Microsoft office outlook 2007 after the configuration inbox mails are visible in inbox but sent items and other folders are not getting downloaded, my mail server is squirrel mail ,so please let me know the reason . POP3 or IMAP? "xpmate" <sreekanth.chn@gmail.com> wrote in message news:41cb29fe-c615-44b3-aa86-ea3eb607e2a5@g22g2000prf.googlegroups.com... > Hi all, > > In my client pc's i have configured the Microsoft office outlook > 2007 after the configuration inbox mails are visible in in...

how to extract thumbnails from Thumbs.db
Hello, Could you tell me how to extract thumbnail images from Thumbs.db under specified directory? especially extract thumbnail for .JPG or .JPEG files? Thank you in advance for your help. Charlie A google search is always promising; it took less than 15 seconds to find http://www.experts-exchange.com/Programming/Programming_Platforms/Win_Prog/Q_20822626.html (Apparently this site has an answer, but you have to subscribe to it to see it; I'm on enough spam lists that I don't subscribe to anything any longer) and under 2 minutes to find http://www.petedavis.net/MySite/DynPag...

MS Access
Why doesn't MS support MS Access for Macintosh? Since I work in an educational environment that's mostly PC with MS Office begin the main suite, it would only be logical that since the PC version of MS Office contains MS Access for database entry, the Mac version of MS Office would also have MS Access. In article <BE09D66D.5FB8%redclawx@hotmail.com>, Red Claw <redclawx@hotmail.com> wrote: > Why doesn't MS support MS Access for Macintosh? Since I work in an > educational environment that's mostly PC with MS Office begin the main > suite, it would only ...

Restarting MS Money with a "correction" switch
This is a multi-part message in MIME format. ------=_NextPart_000_003B_01C3DDDC.D92AA4A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I currently use version 10 - 2002 Deluxe, and I need to startup MS Money = with a correction switch that I hope will correct some problems that I = have been having, but I can't seem to locate the post that talks about doing = this. Is it "msmoney.exe /s"? --=20 Russell (if replying, replace nospam with rpottharst) ------=_NextPart_000_003B_01C3DDDC.D92AA4A0 Content-Type: text/html; c...

Starting MS Outlook on startup
How can I start Outlook on startup (XP) and keep it running in the back? >-----Original Message----- >How can I start Outlook on startup (XP) and keep it running in the back? > > >. > All you need to do is move the Outlook program icon to the startup group in XP. >-----Original Message----- >How can I start Outlook on startup (XP) and keep it running in the back? > > >. >Double click My Computer, go into the C:\Documents and Settings\User\Start Menu\Programs\Startup Place an Outlook shortcut into this folder and it will automatically startup when...

Alternative to Ms sql server 2005 express edition
Hello Everyone, Our server hosting providers are saying that our web site is running slow because we are using ms sql server 2005 express edition which is a free edition and had only a capacity of handling up to 4 GB data. And our database which we are currently using is now having more than 4.5 GB. Hence they recommended us to go for a paid one that is specialized edition workgroup and gave us the following link http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx to go through the comparison. The hosting providers says that it will be around 4500 rupees per month for ...

MS Word Problem
Hello people following problem: in a MFC MDI application one also shall Being displayed Word97 document. And but not in an external program but as a one prayed OLE object. I have managed this. The following problem lets itself be seen now: if I maximize/reduce the main window the visible range of the Word document shall adapt the visible doesn't become however if I maximize the object frame of the OLE object Range of the document changed but Word zoom lens the document. To this the one prayed window is placed so for this these force Word-Scrollbalken are no longer visible. I can ...

MS Money Planner file
Hello I have a problem in MS Money 2004. Each time I open money I get the following error: "A file needed to run the Planner is either missing or corrupted. To resolve this problem, re-install money and then re open your money file". I have tried doing this but still keep getting the same error. Can anyone please advise? Thanks and a Happy New Year to all you kind souls out there. Dave Hello Glyn That seems to work for me. Thanks for taking the time and trouble to reply. Much appreciated. Hope you have a happy & prosperous New Year. Regards Dave "Glyn Simpso...

ms outlook: unable to find default email folder
on opening outlook it says;UNABLE TO OPEN DEFAULT FOLDERS. THE REQUESTED INFORMATION COULD OT BE FOUND IN THE ACTIVE PROFILE. On clicking ok it says; WOULD YOU LIKE TO OPEN YOUR DEFAULT FILE SYSYTEM FOLDER INSTEAD. Please help whats causing this. thanks "=?Utf-8?B?c2hheWFuOTk=?=" <shayan99@discussions.microsoft.com> wrote in news:CEC2AC86-64EF-4684-A6EA-C3D3AEC3A9BC@microsoft.com: > on opening outlook it says;UNABLE TO OPEN DEFAULT FOLDERS. THE REQUESTED > INFORMATION COULD OT BE FOUND IN THE ACTIVE PROFILE. > On clicking ok it says; WOULD YOU LIKE TO OPEN YOUR ...

Business Contact Manager for MS Outlook 2003
I just installed MS Office @003 Standart Upgrade and want to use the Business Contact Manager functionality. However, I cannot find it. The "Help" feature tells me I should have Business Contact Manager as an add-in but I cannot find it nor do I want to download the version with Micrrosoft Exchange Server (I think). Can anyone tell me how to get Business Contact Manager for MS Outlook 2003? Thanks, Jim BCM is available as part of Office 2003 Professional Edition, Small Business Edition, or Prefessional Enterprise Edition (requires Volume License from Microsoft). As far as I k...

Convert MS publisher to MS Word
Hello ALL, Could anyone plz tell me how to convert a publisher file to MS Word, while retaing all text, images, formatting etc. Help will be greatly appreciated. Regards, Asim Hi Asim (alatif@ultimus.com), in the Microsoft� newsgroups you posted: || Could anyone plz tell me how to convert a publisher file || to MS Word, while retaing all text, images, formatting etc. You can't. The only thing you can do is copy/paste or drag/drop between the two applications and adjust formatting accordingly. -- Brian Kvalheim Microsoft Office Publisher MVP Official Publisher MVP Site: http://www....

Can you import visio calendar to MS word
You can copy and paste but it stay an image in word. It will not be transform as a word calendar "Pauline" <Pauline@discussions.microsoft.com> a �crit dans le message de news: FE2CC56C-DB9E-4399-A2EB-56FDFAA791B6@microsoft.com... > ...

MS CRM Outlook Plugin does not reconnect
We use the MS CRM Outlook Plugin extensively but have seen that whenever the connection to the server is lost the plugin will not reconnect. We are forced to exit Outlook and re-enter. Is there a way to cause the plugin to reconnect? "Chris Bray" wrote: > We use the MS CRM Outlook Plugin extensively but have seen that whenever the > connection to the server is lost the plugin will not reconnect. We are > forced to exit Outlook and re-enter. Is there a way to cause the plugin to > reconnect? Hi Chris, Are you still having this problem? At our site, one user ru...

Direct Link from MS Project to MS Access
I'm building a database in MS Access. Currently we are dumping MS Project information into Excel and importing into MS Access. I need to determine if there is a way to link MS Access directly to tables in MS Project for automatic updates instead of export/import. ...