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
552 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
143 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
77 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
425 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
228 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
376 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
489 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 ...
1
vote
1answer
284 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
159 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 ...
1
vote
1answer
556 views

Help with SQL Server 2008 permissions

Today I migrated a database from SQL Server 2005 to SQL Server 2008 R2 using the backup/restore method which went fine and did not generate any errors. I can log into SQL Server 2008 through the SQL ...
1
vote
1answer
377 views

SQL 2005 Cluster - How to move MSDTC

We currently have a 2 node (Win2003) SQL 2005 Cluster running 2 instances. We need to move all drives to a new SAN but are pondering over how to move the DTC that is currently 'logging' te Quorum ...
1
vote
1answer
47 views

Troubleshoot DBMail in SQL Server 2005

On a SQL Server 2005 machine, I have DBMail setup and correctly configured. I am able to use "Notify Operator" and EXEC msdb.dbo.sp_send_dbmail to queue emails. But the problem is the queued mails ...
1
vote
1answer
207 views

Can you use a relatively expensive filter on transactional replication?

I'm trying to replicate (transactional, push) a relatively small table (50K rows), subject to several different filters, which are rather expensive (each taking at least an hour long to complete, ...
1
vote
1answer
113 views

What could be causing my locally running IIS website to take so long to connect to SQL Server?

I am running a local web server for doing development. Right now the website connects to a local SQL Server running on my machine which is obviously fast. When I instead point the web app to connect ...
1
vote
1answer
457 views

Reorganize indexes screen seems to hang

Trying to reorganise an index, the reorganise indexes dialog seems to hang. Which scares me a bit. I'm running SQL Server Standard 2005. The screen has been like this for about 9 hours. The animation ...
1
vote
1answer
476 views

Secure communication between linked SQL Servers

Is the data transferred between two linked SQL Servers protected (encrypted) by default? If not, is there a way to accomplish this? I have two SQL Server 2005 databases running on separate servers, ...
5
votes
0answers
343 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
122 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
131 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
483 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
27 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
17 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
198 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 ...
1
vote
0answers
65 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
109 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
67 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
72 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
213 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
6k 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 ...
1
vote
0answers
395 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
175 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
122 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
494 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
409 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
37 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
155 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
32 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
312 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
22 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
72 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
251 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
214 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 ...