Tag Archives: SQL

Microsoft SQL Agent ist not starting

Posted on 2014/05/06 by maoeh

Problem sql Agent start error 5 “Access is Denied” This might happen when you use other directories than the default installation. Solution Apply the rights for the service user of SQL to the path where the agent executable is located. … Continue reading →

Posted in Fix IT | Tagged , | Comments Off on Microsoft SQL Agent ist not starting

SQL Services event ID 7000 and 7009

Posted on 2014/03/12 by maoeh

Problem: Reporting Services and Integration Services do not start any more . Error :A timeout was reached (30000 milliseconds) while waiting for the SQL Server Reporting Services (SQL1) service to connect. Error: The SQL Server Reporting Services (SQL1) service failed … Continue reading →

Posted in Fix IT | Tagged , | Comments Off on SQL Services event ID 7000 and 7009

SQL DB Splitten – aktive DB

Posted on 2013/12/16 by maoeh

First get some information from your  SQL Server and DB. Current Situation There is one file for Data and one file for Logs. Create a Backup of your DB Don’t work without backup. Create new Files The new Files have … Continue reading →

Posted in Information Technology | Tagged | Comments Off on SQL DB Splitten – aktive DB

SQL Performance Tuning Windows 2012

Posted on 2013/12/12 by maoeh

Performance Options IIS Settings for SQL-Management Console Network Card Nic Teaming Bios Setting Hyper-Threading off, SQL ist not yet really working with it

Posted in Information Technology | Tagged , | Comments Off on SQL Performance Tuning Windows 2012

SQL alias connection refused from remote system

Posted on 2013/10/08 by maoeh

Situation: There is an SQL 2012 server and a view remote Server requiting Connection to to this SQL  database Server. Problem / Error: No connection could be made because the target machine actively refused it. SQL Server with alias shows an … Continue reading →

Posted in Fix IT | Tagged | Comments Off on SQL alias connection refused from remote system

SQL Security : Restore User Mapping Database & SQL Management relation

Posted on 2013/09/30 by maoeh

To detect orphaned users, execute the following Transact-SQL statements per database: USE <database_name>;GO;sp_change_users_login @Action=’Report’;GO; Possible Response The output lists the users and corresponding security identifiers (SID) in the current database that are not linked to any SQL Server login. For … Continue reading →

Posted in Fix IT, Information Technology | Tagged | Comments Off on SQL Security : Restore User Mapping Database & SQL Management relation

TempDB SQL 2012 splitting

Posted on 2013/09/30 by maoeh

Open SQL Management Studio.Disconnect all server connections.Leave GUI open as we need the Query Analizer stop all SQL services open services by running service.msc open properties of the sql instance and copy the sql executing pathC:\Program Files\Microsoft SQL Server\MSSQL11.SQL1\MSSQL\Binn\sqlservr.exe -c … Continue reading →

Posted in Fix IT, Information Technology | Tagged | Comments Off on TempDB SQL 2012 splitting