Tag Info

New answers tagged

0

Having Management Studio in the environment is not a bad thing at all, rather it will be good while monitoring your SharePoint farm/Dbs. If your SQL server version is 2008R2, then SSMS 2008 version will be fine(as i am using) But if your SQL server version if 2012 then you need SSMS 2013 version.it will work with old versions as well. As per the Codeplex ...


0

For your first part, there isn't something out of the box that can handle it. You can either Use some custom Javascript code to change the input to a dropdown, and save the value into the textbox. SPServices, http://spservices.codeplex.com/documentation, may have something that can do that Add a separate field for location that is a dropdown, keep the ...


2

The Backup-SPFarm command should use a network share where The service accounts, Farm accounts and SQL Server service accounts have Full Control access to the share. This is because SharePoint uses SQL commands for running parts of the backup and these execute in SQL Server's context. More information: Prepare to back up and restore farms in SharePoint ...


0

I would prefer the SharePoint for the tickting system, easy to use customization options Alerts, workflows etc Use BI tools to get the reports archiving the old tickets( if proper planed). Search. Only drawback for advance features you need the Enterprise License. Here are two Example of Ticketing systems, which will help you understand it. ...


0

Data in SharePoint has more advantage than storing in SQL. Search Workflow Alerts and Emails Automatic remainders Easily scale (Database or by extending farm) Powerview (SharePoint Enterprise) Export to excel and then create adhoc reports Easy form creation (Any change in fields will automatically updates the CRUD UI)


0

Yes, from my experience the best approach is synchronizing local SQL data with native SharePoint Online lists, bi-directional if required. In this way you have all well-known native SharePoint list features available without any restrictions, e.g. views, search, change notifications or workflows on item Level etc. The sync approach results in a very ...


0

Now it is posible, for use in Power BI at least. Use Data Management Gateway. You install it on premisses on a location with Access to the internet and to your database, set the security info on your SharePoint, and it automatically redirects your queries to your on premisses site, compresses the result, and uploads and updates the info on your power bi ...


0

To move the BI Center Site collection, Make Sure All services Application are created and associated to the web application which you want to move the BI Site Now backup the Content DB of the BI Site collection. Restore into the Production SQL Server. Mount the DB to desired web Application.


1

The only minimum that you actually need is exactly the answer in the old post. The top one called "Database Engine Service" for the actual SQL engine and "Management tools - basic/complete" for Management Studio. This is what most people choose to go with when setting up a development or a minimal foundation server, as the rest is just additional features ...


0

Coming back late to this but if you are still up an running is it because your services are load balanced across your two servers? The errors should tell you which machine is generating the logon attempt. It could be one of the following: Time is off - Kerberos by default requires all servers be within 5 minutes of each other, if the Auth token time ...



Top 50 recent answers are included