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
1answer
14 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. ...
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 ...
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
1k 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 ...
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 ...
6
votes
1answer
59 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
404 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
2k 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?
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
2answers
2k views

Some rows giving “String or binary data would be truncated” error when editing in Management Studio

When trying to add data to a newly created column using SQL Server Management Studio (edit rows), I am getting the following error: No row was updated. The data in row 1 was not committed. ...
3
votes
4answers
6k views

MSSQL error: consistency-based I/O error - can it be caused by an MSSQL or OS problem?

This is what I saw in the windows error log: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x19fedd20; actual: 0x19fed5e3). It occurred during a ...
1
vote
0answers
34 views

Periodic SQL Server connection drop due to domain configuration? [closed]

An application of ours, running on a customers computer, reported an SQL Server connection error sporadically (4 times in a week). This connection error freezes our application for a few seconds and ...
0
votes
0answers
25 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
168 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, ...
1
vote
2answers
4k views

Add SSH host key to another user's PuTTY cache

I have written a PS1 script that 7-zips a file and uses PuTTY's SCP to store it at my back-up server. I have tested it and it works perfectly. Then I log into my SQL Server Agent and add an extra ...
0
votes
1answer
71 views

SQL Server 2005 Linked Server using SSMS from laptop vs RDP

I connect to work network via Cisco VPN from my work laptop, which is on AD. Edit I am using SQL authentication to connect from Server A to B; in scenario #1 I can connect. I can even connect from ...
2
votes
1answer
113 views

How to hide a connection string in the DMZ

We are setting up an IIS Server on Windows Server 2012 in a DMZ, running off-domain. This server requires access to SQL Server 2005 on the other side of the firewall, inside our domain. We plan to ...
1
vote
1answer
17 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
0answers
14 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
88 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: ...
-1
votes
1answer
839 views

How to configure a trusted connection between IIS 7 and SQL Server 2005?

How do configure a trusted connection between IIS 7 and SQL Server 2005? My webapp was working fine with Windows Authentication enabled in IIS. Now, in order to solve a problem, we need to use a ...
0
votes
2answers
87 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 ...
0
votes
1answer
1k views

Why does this login fail for user 'Servername\Guest'?

I install SQL Server 2005 EXPRESS edition on one computer, Computer Name = 'MyServe' and Database name='MyDB',take it as database server. it is configured as both Database and Windows Authentication ...
0
votes
3answers
53 views

SQL Server 2005 features in comparing DB schema /tables

Is it possible to create or do it from SSMS to compare two different schema ? I need to compare database table in my current production DB to see which one is different in order to generate delta ...
1
vote
1answer
34 views

Can not move SQL Primary File

In the process of moving/upgrading old SQL server 2005, I need to move some sharepoint PWA datafiles. After detaching the database from the files, I am trying to copy/move the DB files from their old ...
0
votes
1answer
164 views

Error after moving WSUS DB from one server to another

I have a WSUS 3.2 Installed on a Windows Server 2003 R2. SQL Server 2005. I want to move the WSUS DB from this server, to our new SQL Server 2008 R2 on a new Windows Server 2008 R2 Machine. After ...
1
vote
4answers
208 views

Sql Server Backup Compatibility - 2008 with 2005

I'm hoping to restore a backup from SQL Server 2008 into a Sql Server 2005 instance. Is there a way to have Sql 2008 back up in a format that 2005 will understand?
0
votes
4answers
2k views

Database planning - Multiple Schemas vs Multiple Databases vs Single large database vs Partitions

We design websites for Realty companies. The websites are used only to display the information and all the websites share a common template. We have around 150 websites for different customers. Some ...
-1
votes
1answer
111 views

MS SQL Express is not enough - whats to do?

I now have my first bigger project of my own. I invested around 500 working hours and the project is done. It's actual ASP.Net with C# and Linq to SQL, the platform is an MS SQL Server 2005 Express ...
0
votes
0answers
305 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 ...
2
votes
7answers
2k views

“top” style activity monitor for SQL Server?

I am not thrilled with the Activity Monitor that ships with SQL Server 2005, though I suppose it is trying to be the same thing. A snippet of the query, username, database name, from table name, CPU ...
0
votes
1answer
28 views

SQL Server Hardware Config

i am an IT Consultant and take up projects for my clients for setting up complete IT infrastructure. I have a client who has been facing problem with their DATABASE, he is a retail distributor for ...
-1
votes
2answers
318 views

Can there be two machines with the same server name (SQL SERVER) in the same network? [closed]

I have a program in excel that connects to several sql servers using servername and instance. My question is, what would happen if there are two servers (machines) with the same servername in the same ...
0
votes
1answer
52 views

How can I troubleshoot an application connecting to SQL Server

I'm trying to get ASP.net StoreFront to Connect to SQL Server Express 2005, on Windows Server 2008. I followed This Microsoft Support article without success. Below is the error. [SqlException ...
0
votes
3answers
124 views

Best raid configuration for my sql Server 2005

I have SQL SERVER 2005 database running on windows server 2008 with following configuration SERVER:HP Proliant ML380 G7 CPU: 1 RAM: 10 GB of RAM HHD: 3*300 GB HHDs with RAID 5 configuration. It has ...
3
votes
2answers
2k views

When successfully configured SQL Server for database mirroring, got an error saying it's not configured for database mirroring

I need to replace the old database in our test environment with a fresh copy of the production database. The test environment is actually comprised of two instances of the test database, on 2 ...
0
votes
0answers
138 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 ...
1
vote
3answers
57 views

SQL Server 2005 Issue

I am stuck. I've just taken over maintenance on a SQL Server...that has not been backed up in quite a while...The log file has grown to over 1.61TB...Yes, 1.61TB. It has swallowed all available disk ...
3
votes
4answers
656 views

Why does Sql server write 100's of files to System Volume Information (all with the same name)

I noticed that SQL Server has a surprisingly large number of writes to \System Volume Information\{guid1}{guid2} What is Sql Server doing when something like this happens? In the above image half ...
1
vote
3answers
1k views

SQL Server Backup problem when browsing to the directory

I want to allow a group (eg. 'BackupManagers') who can only preform backup and restore operations on certain databases. When creating the BackupManagers user account I checked db_backupoperator. When ...
1
vote
1answer
38 views

What are the correct permissions for service account to run databasemail?

I setup database mail on a SQL Server 2005 instance and kept getting this log message whenever an email was tried: Message 1) Exception Information Exception Type: System.NullReferenceException ...
2
votes
4answers
3k views

What is causing a vm to exhibit packet loss?

We have a pretty nice piece of hardware set up to run multiple virtual machines in vmware and one of the vm's is an instance of Windows Server 2003 running SQL Server 2005. For some reason we ...
1
vote
6answers
753 views

Transfer a 200 GB MDF file

Any ideas-quickest way, how to transfer a 200GB mdf file from one server to another?
1
vote
1answer
964 views

SQLVDI error - attempt to release mutex not owned by caller

I've started getting some errors in the App event log of one of our database servers (Windows 2003 & SQL Server 2005). The nightly full database backups are completing successfully however ...
0
votes
0answers
138 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
2answers
339 views

Is there a download available for SQL Server 2005 Replication Components?

I'm trying to install SQL Server Compact 3.5 Server Tools. I'm getting an error saying I need to install SQL Server 2005 Replication Components in order to proceed. From searching online it appears ...
0
votes
1answer
475 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 ...
4
votes
5answers
6k views

How to find when the stored procedure was deleted and who deleted it?

Actually, one of the critical jobs failed while executing. In the error message it was found that the failure is because it was missing a stored procedure. Now how do I find out when was the stored ...
3
votes
3answers
1k views

What is the best practice for the database owner in SQL Server 2005?

What is the best practice for the database owner in SQL Server 2005? I have already searched this page... http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx and didn't find what I was ...
0
votes
1answer
2k views

SQL Server linked server: “Cannot start more transactions on this session.”

i am trying to perform an INSERT operation against a linked server: DBCC TRACEON (3604, 7300) BEGIN TRANSACTION INSERT INTO LIVE.Contoso.dbo.Events (EventGUID, EventDate, LoginGUID, UserGUID, ...