Forum Replies Created

Viewing 15 posts - 2,056 through 2,070 (of 6,401 total)

  • RE: Problem with SQl connection

    Sorry I missed something glaringly obvious.

    Your using Windows Authentication, the server isn't on the domain so you cant use windows auth, you need to use SQL auth.

    But the error message...

  • RE: Looking for SQL Server Monitoring tool

    Depends on your requirements.

    Take a look at

    Red-Gate's SQL Monitor[/url], also can give it a try on SSC, up in the right hand corner

    Spotlight on SQL Server Enterprise[/url]

    ApexSQL Monitor

    SQL Sentry...

  • RE: Problem with SQl connection

    Whats putting the \ at the beginning of the servername?

    The servername should be TTDEV\TEKNOTRANS_DEV or 192.168.0.12\TEKNOTRAVS_DEV (assuming that IP is the IP for the machine called TTDEV) not \TTDEV\TEKNOTRANS_DEV

    Have you...

  • RE: Today's Random Word!

    djj (10/14/2015)


    anthony.green (10/14/2015)


    Ed Wagner (10/13/2015)


    ZZartin (10/13/2015)


    Ed Wagner (10/13/2015)


    anthony.green (10/13/2015)


    crookj (10/13/2015)


    anthony.green (10/13/2015)


    Ed Wagner (10/13/2015)


    anthony.green (10/13/2015)


    eccentricDBA (10/13/2015)


    Crystal

    Maze

    Labyrinth

    Goblin King

    Power (of the Babe)

    struggle

    Wrestle

    Cage

    Fight

    Flight

    Plane

    Snakes

  • RE: Licensing AlwaysOn

    Depends on the licenses you can purchase. If your vendor can supply 2012 licenses then your bound by the 2012 licensing rules, if they can only supply 2014 licenses...

  • RE: Problem with SQl connection

    The servername in the last picture doesn't look right, there shouldn't be a \ at the beginning.

    Just TTDEV\TEKNOTRANS_DEV, asuming that the hostfile on the remote box has been updated to...

  • RE: Assigning Multiple Role Assignments

    The main thing I would say is to get a group created and get all the users in the group, but if your AD team are reluctant to do that...

  • RE: Today's Random Word!

    Ed Wagner (10/13/2015)


    ZZartin (10/13/2015)


    Ed Wagner (10/13/2015)


    anthony.green (10/13/2015)


    crookj (10/13/2015)


    anthony.green (10/13/2015)


    Ed Wagner (10/13/2015)


    anthony.green (10/13/2015)


    eccentricDBA (10/13/2015)


    Crystal

    Maze

    Labyrinth

    Goblin King

    Power (of the Babe)

    struggle

    Wrestle

    Cage

    Fight

    Flight

  • RE: High Availability Reporting Services

    Reading this https://msdn.microsoft.com/en-us/library/hh882437.aspx it details at the bottom that after the ReportServer database recovers it recreates the jobs for subscriptions, so looks like you can stick SSRS on an AG...

  • RE: Maintenece plan has been failed for transaction backup

    Get the job / step to log to file to get the full error message written to file, this is only a snippet of the error due to the size...

  • RE: Behavior of sysadmin fixed role

    The value of DEFAULT_SCHEMA is ignored if the user is a member of the sysadmin fixed server role. All members of the sysadmin fixed server role have a default schema...

  • RE: configuration manager ssrs

    Does reports_dmb have the same tables as ReportServer?

    If not then its not a SSRS databases, its probably the source for all of the data the reports use.

    Check the data sources...

  • RE: Maintenece plan has been failed for transaction backup

    Get the job to log to a file to get the full error message dumped out so that we can see the actual error.

  • RE: Today's Random Word!

    crookj (10/13/2015)


    anthony.green (10/13/2015)


    Ed Wagner (10/13/2015)


    anthony.green (10/13/2015)


    eccentricDBA (10/13/2015)


    Crystal

    Maze

    Labyrinth

    Goblin King

    Power (of the Babe)

    struggle

  • RE: Today's Random Word!

    Ed Wagner (10/13/2015)


    anthony.green (10/13/2015)


    eccentricDBA (10/13/2015)


    Crystal

    Maze

    Labyrinth

    Goblin King

Viewing 15 posts - 2,056 through 2,070 (of 6,401 total)