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

learn more… | top users | synonyms

3
votes
3answers
2k views

Simplest way to shrink transaction log files on a mirrored production database

What's the simplest way to shrink transaction log file on a mirrored production database? I have to, as my disk space is running out. I will make a full database backup before I do this, so I don't ...
1
vote
0answers
17 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 ...
2
votes
2answers
2k views

How to undo assigning ownership of db_datareader/db_datawriter schema?

i meant to assign an SQL Server login to the db_datareader db_datawriter database roles. But if a moment of sore tummy and tiredness, i accidentally give that user schema ownership of them ...
1
vote
2answers
31 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 ...
2
votes
1answer
5k views

Can't see all catalogs on a MSSQL Linked Server

On SqlServer 2000 I have created a Linked Server to a SqlServer 2005 machine, with "Server type" set to "SQL Server" (first radio button), and the linked server name set to the remote machine's ...
1
vote
1answer
57 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 ...
0
votes
2answers
367 views

How do I change the Web Service Account for SQL Server Reporting Services?

I am trying to configure a Report Server on SQL Server 2005 and need to change the ASP.NET Web Service Account. Can anyone point me in the right direction of how to do this. Thanks Andy
0
votes
3answers
57 views

How can one use Reporting Services against a log shipped database?

Using MS SQL SERVER 2005. I have log shipped the ReportServer database to the secondary server in Standby/Readonly. I seem to be unable to use Reporting Services on the secondary database because it ...
0
votes
0answers
14 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 ...
0
votes
0answers
45 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 ...
0
votes
3answers
3k views

Access to the remote server is denied because no login-mapping exists

I've got a Linked Server in my SQL Express install that is using SQL Server Authentication. I've created a SQL Server login-mapping and it's using Impersonate. I've confirmed that the account exists ...
1
vote
1answer
5k views

SQL Server 2005 Reporting Services - Configuration Manager & Management Studio Problems

When I open Reporting Services Configuration Manager on my server, an error message appears that says: Reporting Services Configuration Manager An unknown error has occurred in the WMI Provider. ...
0
votes
2answers
357 views

Can not connect to SQL server with SQL Authentication. But can using Windows Authentication

The server authentication is set to: SQL Server and Windows Authentication mode I can connect using Window authentication but not SQL authentication. Login failed for user 'sa'. (Microsoft SQL ...
0
votes
3answers
3k views

How to move SQL Server 2005 Instance “root directory” without re-installing the instance?

Does anyone know a way to change the SQL Server 2005 default instance "Root directory" without re-installing the instance? I just installed a RAID5 SAN drive and I want the backups of the SQL ...
1
vote
1answer
1k views

Can't rebuild master DB on MS SQL Server 2005 Express after power failure

There has been a power loss on our server and I cannot start the SQL service because the master DB is corrupted (as the log states). I found many articles recommending running the setup.exe with ...
0
votes
1answer
41 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 ...
0
votes
1answer
2 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 ...
0
votes
0answers
27 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 ...
0
votes
1answer
40 views

Automatic log truncation when scripting from SQL 2008 to 2005

I have to convert a sql server 2008 database to a sql server 2005 database. As far as I understand it, the only reliable way to do this is by scripting the database to an earlier server version. Now, ...
1
vote
4answers
1k views

Why upgrade from SQL 2005 to SQL 2008 R2?

have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a time and there are ...
1
vote
1answer
767 views

How to filter columns in SQL Server replication?

I need to replicate some data from two tables in one database to another databases. I used snapshot replication. The issue is that I would like to replicate only some selected columns and the others ...
1
vote
3answers
4k views

Is it safe to restart Sql Server Agent?

I've found myself in the tenuous role of a developer tasked to manage a SQL server. I've set up some jobs to run on a schedule, but would like to receive email notification on completion. I've set ...
2
votes
5answers
5k views

SQL Server 2008 - 2005 Compatibility

I want to use SQL Server 2008, but I'd also like to maintain a fall back position of switching back to SQL Server 2005. I know I cannot backup 2008 to restore 2005 and detach/attach won't work - what ...
0
votes
2answers
353 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 ...
3
votes
2answers
676 views

How do I recover a dropped table from SQL Server Express 2005?

Something disastrous happened to me. I accidentally dropped my important table from SQL Server 2005 Express DB. Is there any way to recover that table with all records? Can DB Log file help? I have a ...
6
votes
5answers
14k views

Calling sp_start_job from a stored procedure

Our developers need to be able to start a SQL Server Agent job from their .Net code. I know I can call msdb..sp_start_job to do just that, but I don't want to give general user accounts direct access ...
1
vote
2answers
5k views

Can I view my MSSQL connection string from within SQL Server Management Studio?

I'm using SQL 2005, and was helping someone debug a connection issue today. I thought that I could view my current connection string from inside SQL Management Studio, but can't seem to figure out ...
6
votes
0answers
441 views

Database Backup and Full-Text Search

I am running SQL Server 2005 EE. When trying to perform a full database backup I receive the error message: Failed to pause catalog for backup. Backup was aborted.BACKUP DATABASE is terminating ...
3
votes
4answers
14k views

How can I detach a database that is in use?

Even though nothing is using it I am unable to detach a database because it is use. Cannot detach the database 'DEMO' because it is currently in use. I have tried rebooting and get the same ...
4
votes
1answer
135 views

List of things to check before turning on SQL Server CLR?

I am trying to deploy a CLR function (which computes a hash of a text or a file, not available from SQL Server) for the first time on a production server. I was able to test the function on a ...
2
votes
2answers
2k views

Determine Who Dropped a Database?

I have a SQL Server 2005 database that has been deleted, and I need to discover who deleted it. Is there a way of obtaining this user name?
4
votes
2answers
1k views

How to create aliases without installing SQL Server 2005 Client Tools

I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so ...
0
votes
3answers
881 views

SQL Server Migration Assistant for Oracle

I've recently installed SSMA and after connecting to both the Oracle instance (which holds the database to be converted) and the SQL Server I've mapped the necessary schemas from Oracle to MSSQL. The ...
1
vote
1answer
329 views

MSSQL 2005 Snapshot Agent Uses 100% CPU

When setting up a new subscription to a publication (transactional replication) from 64-bit SQL Server 2005 to 64-bit SQL Server 2005 the Snapshot Agent on the publisher consumes 100% of the CPU. I am ...
-1
votes
1answer
61 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 ...
0
votes
4answers
2k views

Backup single table MS SQL SERVER

How to take a back up of single table and restore it back when I required. I mean,I need back of single table with all the indexes,constraints and data associated with that table. because I want to ...
3
votes
3answers
7k views

DBCC CheckDB The operating system returned error 21(The device is not ready.)

The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x0000000001c000 in file 'E:\SQL Database\S***d\NewAdvWorks.mdf'. Additional messages in the SQL ...
2
votes
2answers
4k views

Change Windows Authentication user for Sql Server Management Studio

We're using Sql Server 2005 with Windows Authentication setup. So normally, when you log in using e.g. Sql Server Management Studio, it forces you to log in at MACHINE_NAME\Username. Anyways, on this ...
0
votes
0answers
459 views

Microsoft ODBC SQL Server Driver [DBNETLIB] error from client desktops connecting to SQL Server 2005 databases

Problem We have a program installed on numerous client computers making database connections to SQL Server 2005 databases running on a Windows 2003 Server. Client computers are Windows 7. Recently ...
0
votes
0answers
44 views

Can't connect our ERP Database to MSSQL Server 2005

We have a Windows Server 2003 R2 using SQL Server 2005 Within the server are Two Lan Workgroup (IP Add 192.168.1.33 and 192.168.2.33) Neither IP has a problem connecting to the Server, their ping is ...
1
vote
5answers
2k views

DBCC: The database could not be exclusively locked to perform the operation

I run DBCC CHECKDB ([MyDb]) WITH NO_INFOMSGS, ALL_ERRORMSGS, PHYSICAL_ONLY And after 20 seconds it fails with an error: Msg 5030, Sev 16, State 12, Line 1 : The database could not be ...
0
votes
0answers
17 views

SharePoint Services 3.0 stops same time and day weekly

We have SS3 running on a Windows Essential Business server and weekly at the same time & day, SharePoint will go down with a trail of error messages. At first glance it appears to be an issue ...
1
vote
0answers
56 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 ...
1
vote
3answers
195 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 ...
0
votes
1answer
488 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. Its been working fine till today. The transaction log back-up fails every-time with an error "Error: ...
3
votes
1answer
30 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 ...
3
votes
2answers
2k views

Combining failover clustering and database mirroring

When you combine failover clustering and database mirroring in SQL Server, you need to change the mirroring partner timeout value so that the local cluster gets a chance to fail over before database ...
1
vote
3answers
4k views

Recovering a specific job definition from an MSDB backup?

We've been asked to recover a specific SQL 2005 job from how it existed at a certain time in the past. We have MSDB database backups from that time period, but I can't overwrite the current MSDB ...
0
votes
2answers
1k views

Added a custom SQL Server login to Microsoft Dynamics CRM 4.0, getting empty resultsets

At work we have Microsoft Dynamics CRM 4.0 installed and employees use their LAN login to log into CRM's web interface. We've added a SQL Server-based custom login (to the server and db *_MSCRM) with ...
1
vote
1answer
221 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 ...