Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• db_datareader user cannot connect to read-only routed AlwaysOn SQL cluster

  I have set up a 2-node SQL AlwaysOn cluster and configured read-only routing for requests to be ans…

  goftari

  2 replies

  2 years, 10 months ago

  By: goftari

• Replacing Physical Server

  Hi We are going to update our old SQL physical servers to brand new machines. In the planning in my…

  krypto69

  7 replies

  2 years, 10 months ago

  By: EdVassie

• DB in Recovery Pending

  Hi Guys/Gals I thought I'd just come straight to the experts. I have a important DB in a Recovery P…

  SQL Bandit

  11 replies

  2 years, 10 months ago

  By: Techno-Umesh

• Windows Account getting wrong SID when added to SQL Server

  I have a truly odd one and wonder if anyone else has even seen this. I have a situation where multi…

  Stamey

  6 replies

  2 years, 10 months ago

  By: Stamey

• Saving transaction backup logs off the DB server

  Hi everyone, I would appreciate your comments/suggestions/points on the following question. Please …

  jellybean

  11 replies

  2 years, 10 months ago

  By: jellybean

• Mirroring transport endpoint error:8474

  I see several posts regarding this error. I feel I don’t need to stop and start the endpoint. We ar…

  ramana3327

  1 replies

  2 years, 11 months ago

  By: ramana3327

• Probleme With Access to Reporting Services SSRS

  Hi I have a problem when i try tio display Report, (Win Server 2008R2 And SQL 2014 ) i can access o…

  atsushi

  2 replies

  2 years, 11 months ago

  By: atsushi

• Get ID from Analysis Server cube.

  I am fixing an issue with our automated Analysis Server backups. We use SELECT * FROM $SYSTEM.DBSCH…

  Leonard Rutkowski

  2 replies

  3 years ago

  By: Leonard Rutkowski

• Restore Stumper - Metadata error

  I am attempting to restore a database from a server in one domain to another. The Source server is …

  Stamey

  2 replies

  3 years ago

  By: Steve Jones - SSC Editor

• The permissions granted to user 'domain\abc' are insufficient for performing this operation. (rsAccessDenied)

  ok, so I know there are tons of forums on this,but none are helping. I'm using SQL server 2014 and …

  mes1982

  6 replies

  3 years ago

  By: ferd

• Need to extract the index schema from few dbs and need to apply them to target d

  Hello, Is there any handy script available to extract the index schema from a few dbs and need to a…

  SQL_Hunt

  2 replies

  3 years ago

  By: SQL_Hunt

• cannot create new database - profile name is not valid

  I just found out in one of my SQL servers, when I create any new database, it will show an error: C…

  sqlfriend

  3 replies

  3 years ago

  By: krypto69

• Combining log shipping and regular Transaction log backups

  Hi there, This is more of a confirmation question really. We perform Full backups weekly and transa…

  SQL Bandit

  5 replies

  3 years ago

  By: Michael L John

• Performance degradation - Help troubleshooting

  We have a server. App team has noticed performance degradation from 1-2 months. We don’t think ther…

  ramana3327

  31 replies

  3 years ago

  By: ramana3327

• Strange failed login isssue

  Hello, From past few days, users are receiving failed login issue from the application. Although, u…

  EasyBoy

  4 replies

  3 years ago

  By: Ant-Green