Forum Replies Created

Viewing 15 posts - 781 through 795 (of 3,366 total)

  • RE: Just SQL Auth

    I noticed a post from an ISV awhile back asking if there was a way to remove Windows authentication. Most of us know that we can't remove it, and it...

  • RE: Just SQL Auth

    The real problem starts showing up when you need to give access to potentially the world when your database starts supporting an Internet facing web-site/service. You don't want to have...

  • RE: Just SQL Auth

    Irish Flyer (11/20/2009)


    You want to explain why there are no roles in Windows and there is roles in SQL Server from the time I have been using it which is...

  • RE: SSIS job success but not quite

    johnsonchase7 (11/20/2009)


    I have a package that loads data into a table from a flat file and it runs fine, when scheduled as a job it also runs fine. The problem...

  • RE: What service account is running what?!

    llevity (11/20/2009)


    Okay, confused even more now. You're saying the domain account that runs the SQL Agent service has to be domain admin? Or the share has to have...

  • RE: SQL 2008 to Oracle Performance

    Nicholas Cain (11/20/2009)


    Pretty simple scenario...

    • Windows 2003 x64 EE
    • SQL Server 2008 EE
    • Oracle clients 10.2xxx for both 32 and 64 bit
    • Linked Server with dynamic parameters, allow in process, non transacted updates, connecting...

  • RE: Is there integration of TFS 2008 source control with SQL Server 2008 Management Studio / Client tools for Database versioning???

    You are missing the GDR2 download and install when you install it you will see SQL Server 2005 and 2000 for development but at the point of connection VS2008 still...

  • RE: What service account is running what?!

    llevity (11/20/2009)


    Okay, confused even more now. You're saying the domain account that runs the SQL Agent service has to be domain admin? Or the share has to have...

  • RE: Just SQL Auth

    mzak (11/20/2009)


    I'm not sure if anyone else has played around with the extensibility model provided with IIS 7 but it is really cool and could be a method MSFT could...

  • RE: Displaying Reports on Web site without ReportServer access

    Steve Irwin (11/20/2009)


    Okay, I'll play around with a sample report in local mode and see if the route you suggested is appropriate. I'll likely have more questions along the...

  • RE: Just SQL Auth

    DoD is not wasting anything here. I did not go into all steps to secure, only those that are easy. By the way, when creating a new login in SQL...

  • RE: Just SQL Auth

    There are numerous password hacker tools out there that can be used to gain access. Simply speaking, SQL Server authentication is not very secure, although using very strong passwords can...

  • RE: Script to Change Collation of User Database

    Paul Smith-221741 (11/20/2009)


    Dear All

    Maybe 2008 has a mechanism for doing this but 2005 certainly does not.

    These scripts All assume that the Collation of the SERVER is set to what you...

  • RE: What service account is running what?!

    llevity (11/20/2009)


    Makes sense, but my Agent account has admin already, and the errors I'm getting are OS access denied issues. It lacks the permissions to open the file on...

  • RE: Displaying Reports on Web site without ReportServer access

    I think you can use the local mode because if your reports are not SSRS features dependent then you can use the Visual Studio ReportViewer control. Check below for...

  • Viewing 15 posts - 781 through 795 (of 3,366 total)