Questions tagged [sql-server-2005]
Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This tag is for questions on the 2005 version
1,071
questions
0
votes
0
answers
2k
views
MSSQL server hacked by ANONYMOUS LOGON
My server was hacked with the Mirai Botnet, we cleaned the system, Disabled the Server Agent completely and the system is stable and clean BUT...
If I re-open that sql server PC to the internet ( port ...
2
votes
1
answer
2k
views
Can SQL Server 2005 Use TLS 1.2 for Web Apps?
Hoping for some help as this is a bit new to me.
We have a legacy app running ASP with a separate SQL Server 2005 running on Server 2003 instance. I'd like to required TLS 1.2 for all web app ...
0
votes
2
answers
270
views
how to execute clearing of the procedure cache for one database
I have made a maintenance plan for my db. This plan contains several tasks, i can choose that every task is for specific db.
But dbcc freeproccache does not have any mentioning about specific db. I'...
0
votes
1
answer
93
views
Every MSSQL transaction log backup increases in size, but the log is being truncated
A client's database is used at a steady pace, the number of transactions should be roughly the same from hour to hour. I ran DBCC SQLPERF (LOGSPACE) immediately after a log backup and the space used ...
0
votes
2
answers
111
views
Server 2008 R2 Replication Small Issue
I have two 2008 R2 Servers.
When I Connect those two Servers By Name, I Can Use Replication.
But When I Connect This Two Servers By IP Address, I Can't Use Replication.
I Get Error Like:
SQL ...
0
votes
1
answer
134
views
SQL 2005 SP4 Maintenance Plan Not Saving
I am using SQL 2005 SP4 specifically version 9.00.5000.00 it is the Standard Version and I am accessing it using SQL Server 2014 Management Studio.
I am trying to create a rebuild index tasks from ...
3
votes
2
answers
6k
views
How to encrypt connections to SQL Server with IPSec?
The SQL Server OLEDB provider can use SSL encrypted connections to SQL Server with an option in the connection string:
Use Encryption for Data
Specifies whether data should be encrypted before ...
3
votes
3
answers
538
views
MSSQL I/O performance degraded after SAN consolidation?
Recently I have consolidated all our Dell Equallogic SANs into the same group; previously each SAN was in its own group. They are all populated with 15k RPM SAS drives in RAID 6 so I haven't bothered ...
0
votes
1
answer
1k
views
i am getting the following error MSSQL$SQLEXPRESS Application log on my server
TDSSNIClient initialization failed with error 0x80092004, status code
0x1. Reason: Initialization failed with an infrastructure error. Check
for previous errors. Cannot find object or property.
...
-3
votes
3
answers
87
views
Notify User When DB Autogrows [closed]
I am having some issues with my DB autogrowing because of transaction log sizes. I have implemented a DB maintenance procedure where the transaction logs will be truncated regularly so this should ...
1
vote
0
answers
1k
views
DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
After moving a package to another server, I am unable to run it from a stored procedure using xp_cmdshell or from a job. The package exists in the file system, and I added it to the SSIS Package Store....
1
vote
1
answer
69
views
Export data from Microsoft SQL Server
I have an application that uses a database Microsoft SQL Server running on PC1.
I set up that application on another PC (PC2):
I installed the application on PC2
The application creates the database ...
1
vote
1
answer
122
views
How to handle replication post SQL Server 2000/2008 migration?
I have two servers; server A host SQL Server 2000 and server B ( a remote server) host SQL Server 2005. I replicate data between these two servers using transactional replication. I recently migrated (...
0
votes
1
answer
153
views
How to obtain all (or last few) messages for a failed job in SQL Server 2005?
In the SQL Server Agent for SQL Server 2005, I have a job that only has one step, which runs a stored procedure.
When the stored procedure runs to completion, it produces about 500 messages (not ...
0
votes
0
answers
609
views
SQL Server 2005 setup unexpected failure during setup
I'm trying to install SQL Server 2005 Enterprise on Windows 2003 R2 SP2 (ESXi 5.0.0 guest). After installation of backward compatibility files and prior to MSXML6, I receive this error:
There was an ...