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

-1
votes
1answer
27 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
0answers
93 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
13 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
33 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 ...
0
votes
1answer
114 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: ...
1
vote
3answers
118 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 ...
3
votes
1answer
26 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 ...
1
vote
1answer
154 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 ...
0
votes
1answer
894 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. ...
6
votes
1answer
75 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 ...
0
votes
0answers
36 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
443 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
1answer
144 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
212 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
21 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
20 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
181 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: ...
0
votes
2answers
250 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 ...
1
vote
1answer
49 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
517 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
votes
1answer
161 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
1answer
30 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
1k 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
62 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
170 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 ...
1
vote
3answers
68 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 ...
1
vote
1answer
45 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 ...
1
vote
0answers
235 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
624 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 ...
1
vote
1answer
1k 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 ...
1
vote
1answer
3k 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, ...
0
votes
1answer
334 views

SQL Error When Running My “Find All Unused Packages” in SCCM 2007 Report Console

SQL Error When Running My "Find All Unused Packages" in SCCM 2007 Report Console Asked by: the_ratzenator I am trying to run an SCCM 2007 Report to find all unused Pacakges in my environment and I ...
1
vote
1answer
44 views

SQL Server doesn't archive logs

I was just looking over one of oure less monitored databases and noticed that it hasn't archived any logs for over a month. This is what it looks like now. The current log has over 700 000 events and ...
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
1answer
253 views

What happens if a stored procedure is run in SSMS and it crashes?

What happens if a stored procedure is run in sql server management studio (SSMS 2012 to 2005 server) and it crashes? I'm guessing the stored procedure continues to run? On the other hand I have read ...
0
votes
1answer
116 views

SQL Server 2005 clustered - set maximum concurrent connections to 1

On a SQL Server 2005 clustered - I set the maximum concurrent connections to 1 and now the SQL server cluster cannot start. I guess it needs at least two connections (one for each node). Can I ...
0
votes
1answer
88 views

How to best move system DBs from SQL 2005 to SQL 2008 R2?

I'm in the process of moving from SQL 2005 to SQL 2008 R2. Moving the production DBs and logs is straightforward, through either detach/attach or backup/restore. (new hardware, so I have the old ...
1
vote
1answer
388 views

Can't connect to SQL Server 2005, even with local Server Management Studio

After setting up a second network adapter in the process of adding some SSL'd sites to ISS, my instance of SQL Server 2005 is no longer accessible - including through SQL Server Management Studio. ...
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 ...
1
vote
1answer
157 views

SQLServer 2005 Select statements work, Update statements don't

I would appreciate any ideas on this. It has us really confused. The issue seems to be environmental so we are going to host this one process elsewhere, but it is driving me crazy that I don't know ...
0
votes
0answers
86 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
2answers
144 views

SQL services wont start due to incorrect drive letter after windows restore

SQL services wont start due to incorrect drive letter after windows restore Had a server crash, was successfully able to reinstall windows and restore the server SQL and all the necessary services ...
0
votes
1answer
229 views

VB6 application backup using SQL 2005 suddenly failing

We have a windows server 2003 R2 machine running MSSQL 2005, and our XP workstations all run a VB6 application which calls the SQL backup utility to backup a 700 Mb database. A couple of weeks ago all ...
1
vote
1answer
45 views

migrate old MS SQL 4.2 (circa 1992) db dump to MS SQL 2005

I have a cusotmer who sent me their database dump, which I'm supposed to import into MS SQL 2005 and have a look at. Unfortunately, it is (I am told) from MS SQL 4.2 (circa 1992), (which apparently ...
1
vote
1answer
423 views

Removing service from Windows 7

I had installed and later uninstalled SQL Server 2005 . I used registry cleaner tools and deleted all files related to SQL Server . Still the services console shows entry for previous installed ...
1
vote
0answers
138 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 ...
0
votes
2answers
283 views

Best way to upgrade Hard Disks holding SQL Data Files?

We have an SQL 2005 Server we need to upgrade the Hard Disks on. The most efficient way I can think of to do this is the following; Run a backup using Backup Exec on the D:\ Partition (This ...
1
vote
0answers
116 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
51 views

My server is slower than the average user's computer, should I still offload Access queries to SQL Server? [duplicate]

Possible Duplicate: How do you do Load Testing and Capacity Planning for Databases I have a database set up with MS Access 2007 front ends and an SQL Server 2005 back end. At the moment, ...
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 ...