Tag Archives: SQL

Microsoft SQL Agent ist not starting

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

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

First get some information from your  SQL Server and DB. Number of Cores of one CPU (Not HT). In my case 6 Size of the existing DB. Here expected Size 70GB Data and 10 GB Log, Current Size 11GB Current … Continue reading

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

SQL Performance Tuning Windows 2012

Performance Options IIS Settings for SQL-Managemnt 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

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

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. … 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

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 path “C:\Program Files\Microsoft … Continue reading

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