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

Filter by
Sorted by
Tagged with
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 ...
Omarico7's user avatar
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 ...
user1030135's user avatar
0 votes
2 answers
248 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'...
curious87's user avatar
0 votes
1 answer
86 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 ...
Charlotte's user avatar
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 ...
Rohit Tarang's user avatar
0 votes
1 answer
131 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 ...
Matt The Ninja's user avatar
3 votes
2 answers
5k 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 ...
Ian Boyd's user avatar
  • 5,373
3 votes
3 answers
528 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 ...
NaOH's user avatar
  • 411
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. ...
Ravinder Singh Gill's user avatar
-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 ...
mgrenier's user avatar
  • 123
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....
user337113's user avatar
1 vote
1 answer
65 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 ...
Tlaloc-ES's user avatar
  • 113
1 vote
1 answer
113 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 (...
augie's user avatar
  • 11
0 votes
1 answer
96 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 ...
Scott Leis's user avatar
0 votes
0 answers
593 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 ...
Mohammad Javahery's user avatar
0 votes
0 answers
2k views

Reducing the initial size of the transaction log

We have a database (in production) where the initial size of the database was set inappropriately large (28GB). If I right click on the database in SQL Server management studio and attempt to shrink ...
Brad's user avatar
  • 619
0 votes
2 answers
103 views

Database log file corruption in SQL Server 2005

I've been going through data corruption from last 2 days in row that .ldf getting corrupted and I've to fix it. I did my research that I need new server and management studio because whatever we used ...
user2755462's user avatar
0 votes
1 answer
9k views

Why are server authentication mode options are greyed out in Sql server 2005

I tried to search for the solution but couldn't find any. Please help me understand why the server authentication mode options are greyed out in Sql server 2005. I want to allow SQL Server login mode
hanzo's user avatar
  • 13
0 votes
0 answers
1k views

Error 29503. The SQL Server service failed to start

I'm trying to install SQL 2005 onto a 2012 R2 server. The install is failing at the end when it is trying to start the database service. I have looked in the install logs and I'm getting the following ...
Richard's user avatar
  • 133
1 vote
1 answer
2k views

SQL/SSMS read only user who can only view a single database

I'm currently using SQL Server 2005 which has a number of databases on for individiaul clients. I need to create a single read only login for each of my clients, however I cannot allow them to see ...
lethalMango's user avatar
1 vote
0 answers
1k views

SQL Server 2005 SP2 install Support files failed

I'm racking my brains trying to apply service pack 2 to a recently installed SQL Server 2005 installation on a Windows Server 2K3 64-bit The error message from the installation is unhelpful: MSP ...
Gareth's user avatar
  • 111
1 vote
2 answers
2k views

Automaticaly export Jobs and stored procedure from mssql server

I have MS SQL server with several jobs. Sometimes I and my colleagues change task. I want to export jobs, like at automaticaly so that put in mercurial and store version of jobs. I would also like ...
Arty's user avatar
  • 141
0 votes
1 answer
1k views

T-SQL Code to backup database with multiple files failed

I'm trying to write an automated script that will allow me to backup the database to a NAS with multiple files. I just started to use T-SQL. My objective is to automatically calculate the size of the ...
Blake Zero's user avatar
2 votes
4 answers
2k views

Sql Management Studio 2014 wont connect to clustered instance

I am experiencing an issue where my instance of SQL Server Management Studio 2014 will not connect to any of our production clustered SQL 2000 and 2005 instances. It will however connect to non-...
Dib's user avatar
  • 71
1 vote
0 answers
1k views

Windows Server 2003 x64 Rebooting - PAGE_FAULT_IN_NONPAGED_AREA (50)

Windows Server 2003 x64 R2 Standard Edition it's rebooting by itself. I originally thought it wast Paragon Hard Disk Manager Premium 15. After uninstalled Paragon HDM 15 it stopped rebooting but it ...
Blake Zero's user avatar
0 votes
1 answer
708 views

I cant change sa password in mssql 2005 "Could not find stored procedure 'master.dbo.sp_password'. (.Net SqlClient Data Provider"

We have an old ms sql 2005 server and for some reason, most of the features in sa account settings are grayed out.. Even I cant change sa password It will though this error "Could not find stored ...
Aravinda's user avatar
  • 1,111
0 votes
1 answer
13 views

Helm3 Panel Database Login Error

I have an old Windows 2003 server using the Helm3 control panel (now owned by Parallels). Today it suddenly started displaying the following error when accessing the panel: Cannot open database "...
Ynhockey's user avatar
  • 219
0 votes
1 answer
48 views

Transferring 3 SQL databases from both SQL Express 2005 and Standard to a new physical server

I am trying to figure out the best method for transferring SQL 2005 databases from 2 different physical servers to a new server running windows server 2008 64bit. I own a fully registered copy of ...
Dixie Admin's user avatar
-1 votes
1 answer
297 views

SQL Server Express 2005 cannot accept connection (but ODBC working from external and local server)

I'm having a problem with SQL Server Express 2005 edition; it's unable to be contacted from an application (3rd party monitoring utility software). I have perform the following tests, all of which ...
Senior Systems Engineer's user avatar
1 vote
0 answers
250 views

Why does ADFS have too many SQL connections open?

I'm running ADFS 2.0 in Windows 2008r2, connected to a SQL Server 2005 database server. Right now the ADFS server has 5623 TCP connections open to the SQL server (checked via netstat - counted with ...
Thomas's user avatar
  • 880
-1 votes
1 answer
2k views

Sql Server Transaction Log Backup Fails

I have a SQL Server 2008 Standard version. Mirroring is set up on the server in full safety mode. It has been working fine till today. The transaction log back-up fails every-time with an error Error: ...
kishore's user avatar
  • 882
1 vote
3 answers
752 views

Window Server 2008 R2 dropping 2GB of hard disk space per day

I have a Windows Server 2008 R2 virtual machine running MS SQL 2005 on top of a VMWare ESXi 5.5 host on a SAN datastore. Consistently it has been "losing" 2GB of hard disk space per day and I can't ...
Travis's user avatar
  • 870
3 votes
1 answer
45 views

SQL Server 2005 global slowdown

Two days ago our production server suffered a massive slowdown where the primary symptom was that an extraordinarily high number of requests were suffering SQLTimeouts. I will quickly describe our ...
CWilliams's user avatar
1 vote
1 answer
734 views

Password case sensitivity when upgrading from SQL Server 2000 to 2005

Anyone please help! Today is 3rd day that I'm banging my hand to solve this problem. So the situation is, I've inherited a project which worked on SQL Server 2000, later client decided to upgrade the ...
Vahe Shadunts's user avatar
0 votes
1 answer
6k views

Time-out occurred while waiting for buffer latch type 3 for page (1:401831), database ID 8

I'm getting the below error while insert record into a SQL 2005 SP3 DB. Msg 845, Level 17, State 1, Line 1 Time-out occurred while waiting for buffer latch type 3 for page (1:401831), database ID 8. ...
Jacques Thomas's user avatar
6 votes
1 answer
131 views

Copy SQL Server Databases

I am looking to "move" databases to different servers with minimal disruption to data and service. These databases vary in size from 5GB to 140 GB. I've seen and even used some of the various data ...
Black Dynamite's user avatar
0 votes
0 answers
2k views

SQL Server keep crashing, cannot connect with SSMS, Agent not starting

System Windows Server 2003 x64 SQL Server 2005 x64 Problems: 1) Cannot connect via SSMS - Tried both sa account and domain account (that is in sysadmin group) - If I supplied the wrong password, ...
elty123's user avatar
  • 101
0 votes
1 answer
562 views

SQL Server 2005 Linked Server using SSMS from laptop vs RDP

I connect to work network via Cisco VPN from my work laptop, which is on AD. Edit I am using SQL authentication to connect from Server A to B; in scenario #1 I can connect. I can even connect from ...
AbeP's user avatar
  • 135
3 votes
1 answer
829 views

How to hide a connection string in the DMZ

We are setting up an IIS Server on Windows Server 2012 in a DMZ, running off-domain. This server requires access to SQL Server 2005 on the other side of the firewall, inside our domain. We plan to ...
Mr Black's user avatar
  • 133
1 vote
1 answer
241 views

SQL Server 2005 DROP LOGIN syntax error

This snippet of code (it's just a repeater, not the actual code I'm going to run) throws a syntax error on the DROP LOGIN command: declare @obso_user varchar(16) set @obso_user = 'BEN_VA\20362781' ...
RonJohn's user avatar
  • 223
2 votes
0 answers
59 views

How much memory / processors will cause SQLCLR to fail to load?

I'm considering enabling SQLCLR on our SQL2005 production server, however technet states: Computers configured with large amounts of memory and a large number of processors may fail to load the ...
Alex KeySmith's user avatar
2 votes
0 answers
648 views

MSSQL Database Mail Log is flooded with errors (20-30 per second) when mail server goes down

We're using SQL Server 2005. Every so often our mail server goes down, and when this happens, as soon as our SQL code tries to send dbmail, the Database Mail Log has an item which looks like this: ...
Nat H's user avatar
  • 21
0 votes
2 answers
2k views

SQL Agent started with local user account can't run job with domain user account

I have SQL Agent running under a local user account. Jobs runs well if I used Local account credentials for the cmdExec step. If I try to use a domain user account (created previously in proxies ...
Patrick Pellegrino's user avatar
2 votes
1 answer
444 views

Can not move SQL Primary File

In the process of moving/upgrading old SQL server 2005, I need to move some sharepoint PWA datafiles. After detaching the database from the files, I am trying to copy/move the DB files from their old ...
Saariko's user avatar
  • 1,801
0 votes
2 answers
3k views

Error after moving WSUS DB from one server to another

I have a WSUS 3.2 Installed on a Windows Server 2003 R2. SQL Server 2005. I want to move the WSUS DB from this server, to our new SQL Server 2008 R2 on a new Windows Server 2008 R2 Machine. After ...
Saariko's user avatar
  • 1,801
-1 votes
1 answer
427 views

MS SQL Express is not enough - whats to do?

I now have my first bigger project of my own. I invested around 500 working hours and the project is done. It's actual ASP.Net with C# and Linq to SQL, the platform is an MS SQL Server 2005 Express ...
PassionateDeveloper's user avatar
0 votes
1 answer
51 views

SQL Server Hardware Config

i am an IT Consultant and take up projects for my clients for setting up complete IT infrastructure. I have a client who has been facing problem with their DATABASE, he is a retail distributor for ...
Mohammed Tabrez Pasha's user avatar
0 votes
2 answers
13k views

Can there be two machines with the same server name (SQL SERVER) in the same network? [closed]

I have a program in excel that connects to several sql servers using servername and instance. My question is, what would happen if there are two servers (machines) with the same servername in the same ...
ia.solano's user avatar
  • 119
0 votes
1 answer
137 views

How can I troubleshoot an application connecting to SQL Server

I'm trying to get ASP.net StoreFront to Connect to SQL Server Express 2005, on Windows Server 2008. I followed This Microsoft Support article without success. Below is the error. [SqlException (...
xenoterracide's user avatar
0 votes
3 answers
496 views

Best raid configuration for my sql Server 2005

I have SQL SERVER 2005 database running on windows server 2008 with following configuration SERVER:HP Proliant ML380 G7 CPU: 1 RAM: 10 GB of RAM HHD: 3*300 GB HHDs with RAID 5 configuration. It has ...
rashy's user avatar
  • 3

1
2 3 4 5
22