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

6
votes
1answer
563 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 ...
2
votes
1answer
774 views

SQL Server synchronization failed

I'm getting the error message below when trying to synchronize a SQL compact database (SQL CE 2.0) to a SQL Server 2005 database. I have double and triple checked permissions, reconfigured IIS ...
2
votes
1answer
166 views

SQL Server 2005 question about procedure cache

Server: SQL Server 2005 SP2 64 bit, 32 gigs of memory. 2 instances of SQL server running. Main instance I'm using has 20 gigs visible. We have a situation where it appears every so often our entire ...
2
votes
1answer
78 views

VM migration of SQL Server

We have two SQL Server VMs (SQL 2005 x64 on Windows 2003x64) both have RDM SAN. The SQL Servers are also clustered. My VM admin will be migrating us to different VMs using Cisco UCS solution. ...
2
votes
1answer
533 views

How to create a shared lock blocking an intent exclusive lock

As I understand it, a SELECT statement will place a shared lock on the rows that it will return. While that SELECT is running, if an UPDATE statement comes along and needs to grab an intent exclusive ...
2
votes
1answer
732 views

SQL CLR not properly enabling

We have a SQL server running SQL 2005 Workgroup 64 bit (9.0.4273), on Windows 2003 server 64 bit. We have run sp_configure and reconfigured the server which indicates that the clr is now enabled. ...
2
votes
1answer
77 views

SQL2005 reporting server: intense security activity

On my reporting server the Security log shows large numbers of Logon/Logoff events, often 10 or more, when you run pretty much any report in the Report Manager. Is this normal or is it a classic sign ...
1
vote
1answer
198 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 ...
1
vote
1answer
36 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' ...
1
vote
1answer
626 views

Can I install a 32-bit SQL Server 2005 alongside a 64-bit SQL Server 2008 installation?

The place where I work at currently runs a 32-bit SQL Server 2005 installation on its server which we work with. In addition, the systems we are developing on have not yet been tested for 64 bit ODBC ...
1
vote
1answer
529 views

Can BES 5.0 Express database be migrated from SQL Server 2005 Express to SQL Server 2008 R2 Express?

Would there be any issues for cross migration of database from SQL Server 2005 Express to SQL Server 2008 R2 for blackberry configuration database and database in general? If the database is backup ...
1
vote
1answer
162 views

Can I set MSSQL permissions for individual users with a group login?

I have a lot of SQL 2005 servers with a lot of databases and a lot of Windows users that need access to all the servers but only a few databases, and that last part changes regularly. Managing these ...
2
votes
0answers
37 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 ...
2
votes
0answers
377 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: ...
2
votes
0answers
446 views

Website loses connection to database intermittently

Every so often our website loses connection to the sql server and I receive the following errors: "The following error: A network-related or instance-specific error occurred while establishing a ...
2
votes
0answers
23k views

Cannot telnet to SQL Server on port 1433

I've been working solidly on this issue for the past three weeks. I cannot seem to find where the actual issue is. I just recently found this article on how to troubleshoot the connection. I made it ...
2
votes
0answers
159 views

Full Text Search query elapsed time varying wildly

Database Version: Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 (...
2
votes
0answers
134 views

Can encryption be disabled for the login handshake in SQL Server 2005 or 2008

When a client Application connects to SQL Server the login credentials are sent over the network in a TLS Encrypted Handshake Message. For testing purposes I would like to have the login credentials ...
2
votes
0answers
5k views

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

Web server and SQL server both are running on the different machine. The below is the connection string that we are using to connect MS SQL database from classic ASP web application. set oConn = ...
2
votes
0answers
34 views

Data access tracing but no events are logged

I am trying to trace data access. The configuration I have is based on this excellent article. http://msdn.microsoft.com/en-us/library/aa964124%28SQL.90%29.aspx#data_access_tracing_topic2 The ...
1
vote
0answers
106 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
0answers
704 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 ...
1
vote
0answers
141 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
0answers
195 views

SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express Edition

I've installed SQL Server 2008 R2 Express Edition in my Win 7 notebook. The Express Edition doesn't have SQL Profiler enabled. Thus it's hard for me to debug my SQL 2005 applications. I have a ...
1
vote
0answers
135 views

Problems with SSRS and IIS

I'm really not sure where this question would be best asked, so I'm posting this here in an IIS-specific forum, and also over in SQL Server Central for an SSRS-specific audience. The problem that I'm ...
1
vote
0answers
78 views

Server 2003 saying unlicensed

I came in this morning to our windows 2003 server - running only SQL server 2005 saying it was unlicensed. When logged straight onto the box as soon as I got past the login, it popped up the click yes ...
1
vote
0answers
86 views

Issue with MVC4 site on Windows Server 2003 causing the server to disconnect from network

I have a fairly beefy MVC4 site running on a Server 2003 box (32 bit). This box is also running our companies main ERP system (including it's SQL Server instance), so it's a pretty taxed box. ...
1
vote
0answers
478 views

SQL Server 2005 Mirror table between databases on same server

I've been using transactional replication to mirror a table from one database to another and lately it's been a pain to keep running. My goal is to simply keep an exact copy of a table in another ...
1
vote
0answers
35 views

SQL Server Logs: missing date ranges

I need to be able to export SQL Server logs into CSV files, which I can easily do with the export function. However in doing so I've noticed there's a range of dates missing from the SQL Server logs ...
1
vote
0answers
389 views

SQL Server Keeps Logging/Writing to 'Setup Bootstrap' folder

I recently got a message from windows that my system was running out of disk space. After a quick search across the file system, I found out the SQL Server had logged 10GB of info in the folder C:\...
1
vote
0answers
612 views

What does the error message “Communication link failure (SQL-08S01)” actually mean?

Our application is running on dozens of servers and only a few get this error message. What is worse, is that the SQL query that causes this error message seems to be executing. The application is ...
1
vote
0answers
45 views

SQL 2005 Named Pipes Stop Responding

We have a SQL 2005 64bit SP2 server running on Windows 2003 R2 SP2. It also has Reporting Server installed and that serves as it's primary function. Over the course of approximately a week, ...
1
vote
0answers
32 views

SQL Conntection Problem From Web Application

I have an issue whereby I have a web application installed on one of my Windows Server 2003 virtual machines that has a database held on a local copy of SQL Express 2005. This has been working fine ...
1
vote
0answers
215 views

tfs problem :TF31001Team foundation can't retrieve the list of team project from team foundation server

Q: When i want to create a new project : File ---> New ---->Team Project I get the following error , i googled it but in vain . Error: TF30224: Failed to retrieve projects from the report server. ...
1
vote
0answers
172 views

SQL server periodically gets disconnected

Our environment is: Windows Server 2003, Service Pack 2 SQL Server Express 2005 SQLServer JDBC driver 1.2 (also tried Jtds) Sun JDK 1.6 (we tried this on JDK 1.5 as well) There is no virus protection ...
1
vote
0answers
538 views

Strange Values in SYS.DM_TRAN_LOCKS table RESOURCE_ASSOCIATED_ENTITY_ID column

Strange Values in SYS.DM_TRAN_LOCKS table RESOURCE_ASSOCIATED_ENTITY_ID column I’ve been trying to understand some strange values in the RESOURCE_ASSOCIATED_ENTITY_ID column of SYS.DM_TRAN_LOCKS when ...
1
vote
0answers
417 views

How to create full-text catalog as default catalog?

This would save me the redundant ON MyCatalog phrase when I create full-text indices. For example, CREATE FULLTEXT INDEX ON MyTable ( MyField1, MyField2, MyField3 ) KEY INDEX PK_MyKey ON ...
1
vote
0answers
39 views

MSSQL server 2005 replication - article properties

When i replicate some db, my schemas, roles and user information (connected with that db) are not replicated. Moreover, if table in db is empty, replication don't create it on subscriber side. How to ...
1
vote
0answers
167 views

Installing Sql Server 2005 SP2 - Getting error on analysis services component

At first many of the components didn't install and I followed this workaround (fixing user/SID mappings in registry.) After that everything installed successfully except for analysis services. I am ...
0
votes
0answers
8 views

Sql Server 2005 Update to SP4 Issue - No Errors

I'm having trouble updating an old SQL Server 2005 SP3 Instance to SP4 in order to further upgrade it to 2008 (Requirement for new software update). Problem is, every time I run the SP4 update, either ...
0
votes
0answers
11 views

sqlserver is always mapped to nobody on samba when doing backup to UNC path

I have an issue in the configuration, I guess. Due to the fact that the user is always mapped to nobody, I have to set the chmod for the backup folder to 0666 which is the number of the beast and ...
0
votes
0answers
23 views

Merge and transactional SQL replication…database empty (SQL 2005)

Firstly, let me just say that I'm a novice at SQL in general and this might be an easy fix for someone reading, but I've been unable to find anything that would explain or help my issue online. If ...
0
votes
0answers
76 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 ...
0
votes
0answers
171 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 ...
0
votes
0answers
260 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 ...
0
votes
0answers
282 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
0answers
1k 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
1k 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, ...
0
votes
0answers
26 views

One of five services sharing an account gets logon failure

We had a recent servercrash due to power failure. Five servers went down instantly (no soft shutdown). After getting the power back, we restarted them and everything works well except that now the ...
0
votes
0answers
10 views

upgrading ACT1013..instance of SQLact7 on computer but not running

I have gone into SQL server config manager but can't get the thing to start...have some screen shots...but cant attach images since i am a newbie...it is SQL server 2005 and i can't get the instance ...