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

0
votes
0answers
23 views
+50

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
0answers
8 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
31 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
337 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
32 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
24 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
745 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
3k 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
332 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
673 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
427 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
134 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
877 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
55 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
443 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
42 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
16 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
55 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
176 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
441 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
213 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 ...
5
votes
5answers
2k views

SQL2005 Stuck in Single Mode User

Hey currently have a database stuck in single mode after setting it to single mode to attempt to try take if offline which I wish I never did.... I tried ALTER DATABASE DB SET MULTI_USER but get ...
0
votes
1answer
1k 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. ...
3
votes
3answers
98 views

What is the standard method to keep track of the latest Cumulative updates for SQL Server?

What resources are good for keeping track of cumulative updates for SQL Server? I noticed that Windows update does provide a service for SQL Server.
2
votes
1answer
2k views

Problem accessing MICROSOFT##SSEE database (Error: 18456, Severity: 14, State: 16.)

After an unexpected server shutdown due to a power failure, I can no longer connect to the internal windows database MICROSOFT##SSEE which is hosting Central Admin for my SBS 2008 server. The log ...
6
votes
1answer
83 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 ...
2
votes
4answers
425 views

SQL Server Monitoring Packages [closed]

I'm looking into purchasing a SQL Server monitoring system. It should work with 2005/2008. We would like to monitor performance, availability, backups, jobs and various database issues (space) What ...
0
votes
5answers
3k views

How can I disable the windows authentication mode of SQL Server

How can I disable the windows authentication mode of SQL Server and restrict it to ask for username and password every time, with no windows authentication?