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

2
votes
1answer
534 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
140 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
76 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
422 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
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
18 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
219 views

Why is my sa user permanently locked out?

Here's the timeline of events: I attempted to log in to the database on my local machine using Microsoft SQL Server 2005. I was informed that my sa user was locked out with the below error message. ...
1
vote
1answer
361 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
461 views

Does Sql Server Express supports MSDTC

I need MSDTC(Microsoft Distributed Transaction Coordinator) in one of my application. I am not sure whether it is available on Sql Server Express editions. I googled on MSDN and haven't got clear ...
5
votes
0answers
329 views

Database Backup and Full-Text Search

I am running SQL Server 2005 EE. When trying to perform a full database backup I recieve the error message: "Failed to pause catalog for backup. Backup was aborted.BACKUP DATABASE is terminating ...
2
votes
0answers
107 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
130 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
469 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
0answers
26 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
16 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 ...
1
vote
0answers
62 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
108 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
64 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
70 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
31 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
194 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 ...
1
vote
0answers
375 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
40 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
173 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
120 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 ...
1
vote
0answers
483 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
408 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
36 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
3k 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 = ...
1
vote
0answers
152 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
29 views

Cannot login as sysadmin (SQL Server 2005)

I am having a problem to access the SQL server with my domain account 1) I used sa account to login to a SQL 2005 server in SSMS. 2) I added my domain account (as domain\user) using integrated ...
0
votes
0answers
245 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
349 views

Very simple Update query hanged on one database but not on a mirror

A little background I am working with an ASP.NET MVC ERP-like Intranet application. It uses the Entity Framework technology for data access for a MS SQL server. We have 3 versions of the application ...
0
votes
0answers
147 views

SQL Server 2005 Express behind linux gateway with iptables

We want to access an SQL Server instance which runs on 10.12.1.2:1433 through a linux gateway machine. The gateway n205 has 2 interfaces eth0 with IP 192.168.1.205 and eth1 with IP 10.12.1.1 The ...
0
votes
0answers
164 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 ...
0
votes
0answers
21 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
9 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 ...
0
votes
0answers
68 views

sa account automatically disable itself

I am having trouble logging into SQL Server 2005 with the sa account because the account disables itself after i have enabled it. I checked the server properties ; the account is configured for "SQL ...
0
votes
0answers
230 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 ...
0
votes
0answers
20 views

way to back up sql server 2005 database to just get the data and objects

I'm trying to do a nightly backup of a SQL Server 2005 database to get the leanest, smallest file that includes all the table data, stored procedures, views, and functions. I'm downloading and saving ...
0
votes
0answers
5k 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 ...
0
votes
0answers
206 views

Unique index failed?

Recently, we've been having some kind of memory leak in SQL Server. We do have a .NET assembly running to audit our tables, but this has ran for a few years without problems, so I doubt it's the ...
0
votes
0answers
51 views

SQL Connection Error

I am getting this error while trying to access my website: Exception information: Exception type: SqlException Exception message: An error has occurred while establishing a connection ...
0
votes
0answers
183 views

sp_reset_connection

We recently moved physical database servers from our corporate office to a collocation facility, and brought up virtual servers to replace the web servers. We are now experiencing periodic system ...
0
votes
0answers
537 views

Cannot shrink log file 2(name) because all logical log files are in use

While shrinkning log file of one database on SQL 2005 instance I get below message: "Cannot shrink log file 2(name) because all logical log files are in use". I am able to shrink log files of other ...
0
votes
0answers
424 views

sql mirroring error SQL Server 2005

I have 2 db's that have been happily mirroring each other for months. Today both DB entered the state (principle, disconnected). I am unable to stop the principle(db1) from mirroring. Error Msg ...
0
votes
0answers
543 views

Importing from .mdb to sql server very slow

Environment : Windows sever 2003, SQL Server 2005 My client send me an .mdb file with tables and query that I have to import in an sql server database. So I use the "Import data" wizard to do this. ...
0
votes
0answers
153 views

Where to set permissions to all server for logon trigger on sql server 2005

I need to keep track of the last login time for each user in our SQL Server 2005 database. I created a trigger like this: CREATE TRIGGER LogonTimeStamp ON ALL SERVER FOR LOGON AS BEGIN IF EXISTS ...
0
votes
0answers
63 views

SQL 2005 SP3 long time query

I have note, that responding time for query is act like sinusoid. Once this time is very short, another time my app must wait abount 10 min for query result. Problem start when I install update my ...