Forum Replies Created

Viewing 15 posts - 4,156 through 4,170 (of 4,477 total)

  • RE: run a console application by using SQL Server Agent

    richard.tinkler (12/14/2016)


    I am experiencing the same issue but with EPPLUS any ideas?

    Thanks

    Message

    Executed as user: WIN2016-SFD-02\SYSTEM. Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly 'EPPlus, Version=4.1.0.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1' or...

  • RE: Modifying a system stored procedure

    Senchi (12/14/2016)


    Using MS SQL Server 2014

    I am trying to modify the system stored procedure sp_addlogin, but getting the following error:

    Msg 208, Level 16, State 6, Procedure sp_addlogin, Line 8

    Invalid object...

  • RE: Find who is changing advaced options in SQL 2008

    cmc123 (12/14/2016)


    we are keep getting following alert in SQL

    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

    I have enable the trace to see...

  • RE: Need some suggestion on how to tackle DB access for users

    New Born DBA (12/13/2016)


    Experts, we have decent amount of servers and hundreds of users accessing DBs on those servers. It gets painful time to time to manage users and their...

  • RE: security access - sql

    Hi, Generaly , every user can read, write and run procedures directly from an access form.

    Every user also has installed access runtime, but if someone has full Ms Access, NOT...

  • RE: security access - sql

    Is this just tables or what else do they need to change?

    If you want them to be able to execute any DDL in the database then you would grant...

  • RE: Using windows authentication for reporting

    mortalic (12/8/2016)


    I do think that's the issue (spns) however the sql server for sure has spn's, and the ssrs server too.

    It's the service account that sharepoint/ssrs is using...

  • RE: Help with simple execution logging script.

    Also how do I grab the calling procs name. Its giving me my history procs name.

    You are setting @ProcedureName to Object_Name(@@ProcID) when you are in the ExecutionHistory procedure...so it's giving...

  • RE: SQL Licensing Question

    I've seen it work both ways with those kind of "edge" scenarios from Microsoft.

    When it comes to licensing, it's best to get the answer from MS since that's who...

  • RE: Using windows authentication for reporting

    mortalic (12/7/2016)


    My apologies.

    On a datasource in sharepoint/ssrs, I get the error, Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' for one server, but it works great on a different server.

    The spn's...

  • RE: How many megabytes is 128 GB?

    Gail Wanabee (12/7/2016)


    Thanks but it's not a math issue.

    The issue is what does Microsoft mean in its licensing agreement when it states 128 GB?

    It actually doesn't say: 128 GB

    And...

  • RE: How many megabytes is 128 GB?

    If you want to play around with converting these, just google:

    128 GB to MB

    You get a little input box thing where you can enter your numbers and whatever you...

  • RE: SQL Server SSRS - RSTempFiles

    ShuaibV (12/2/2016)


    Hi

    After installing the SQL 2014 SSRS, can we change the location temp file folder to different drive? If possible, can you please provide the steps? Or...

  • RE: SQL Server SSRS - RSTempFiles

    JasonClark (12/6/2016)


    Using SQL Server Management studio it can be changed:

    Go to Object Explorer, right-click a server and Properties then click on the Database settings page.

    Database default locations, view the...

  • RE: Using windows authentication for reporting

    mortalic (12/7/2016)


    I am unsure how to proceed.

    I've just started at a new job (predecessor isn't here).

    There is a sharepoint (I don't know anything about sharepoint.) and SSRS integrated pointed at...

Viewing 15 posts - 4,156 through 4,170 (of 4,477 total)