-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
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
1answer
188 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
0answers
63 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
68 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
1answer
63 views

Is my server lacking storage space?

Looking for some help here. I have two ASP.Net web applications using SQL Server 2005 hosted on a dedicated Windows 2003 server. One of the applications only receives around 100 unique hits a day, ...
1
vote
1answer
240 views

Restoring Microsoft SQL databases to a different disk partition on the same server

We have a SQL Server 2005 box running Windows Server 2003 R2 Std 64bit. We have two production databases residing on one partition (which is an iSCSI software target), that partition got apparently ...
1
vote
1answer
167 views

sqlserver 2005 sp3 poor performance and scheduled job failing

When executing the Microsoft SQL Server 2005 best practices analyzer, I am getting some reported as follow: The Outdated system driver [C:\WINDOWS\system32\ntoskrnl.exe] of System that can cause ...
1
vote
1answer
40 views

SQL 2005 Server missing memory

We have a sql 2005 x64 database running on Windows 2003 SP2 x64 on a virtual machine (I know this isn't ideal, but it's a business requirement). The server has 26GB of RAM allocated and we have set ...
0
votes
1answer
52 views

SQL Server Expensive Select Queries from unknown source

When viewing Queries by CPU usage with Performance Dasboard, I notice a great deal of queries like "Select * from dbo.sometable". What is the best way to go about tracking the source of these queries? ...
1
vote
0answers
357 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 ...
0
votes
1answer
118 views

Automate install of SQL Server 2005 Express Service Packs

Is it possible to perform an unnattended install of service packs (SP4 is the latest) on SQL Server 2005 Express? The only way I have found is to download the SQLEXPR32.EXE containing SP4 and run it ...
1
vote
1answer
308 views

sql server peer to peer replication - have the agents running as NT AUTHORITY\NETWORK SERVICE?

On a test rig, I'm trying to get SQL Server 2005 peer to peer (transactional) replication working, with the replication agents running under the NT AUTHORITY\NETWORK SERVICE account. Before this I ...
0
votes
1answer
153 views

how to set up an production environment with .net 3.5, iis6, sql server express 2005 on windows server 2003?

I have a clean installation of windows server 2003. This will be my production environment. I need to deploy an asp .net 3.5 project on this production environment. But I don't know the installation ...
1
vote
1answer
926 views

How to use AWE for Windows Server 2003 (32-bit) and SQL Server 2005 (32-bit)?

The server is Windows Server 2003 SP2 (32-bit), running SQL Server 2005 SP3 (32-bit). I believe the server has 4 GB of physical RAM. The machine has crashed twice in the last week and it is a ...
0
votes
2answers
354 views

Native SQL logins timing out at login validation phase

The default SQL Trace of my instances shows the following issue for native SQL logins (non-domain accounts): Network error code 0xe8 occurred while establishing a connection; the connection has ...
2
votes
3answers
81 views

MS SQL 2005 - Backup “being used by another process”

I'm trying to create a backup file of a database in SQL 2005. When I try to execute the backup operation I get an error saying "cannot access this file, it is in use by another process". Any advice ...
0
votes
1answer
95 views

SQL server 2005 Slow access

I got reports from users that the access speed has dramatically slowed down, when they try to access the database. Perfmon states: Cpu ~20% usage. RAM (3,5gb) 2.1gb in usage, 1.7GB for SQL HDD ...
0
votes
1answer
154 views

How was the MSSQL Server database erased in the production server (that is a different version? )

I'm asking for help understanding what happened in my situation or what and if I did something wrong. I have production server running on a Windows 2003 server with MSSQL Express 2005 with an app ...
0
votes
1answer
152 views

SS 2005 SP4 install giving vsJitDebugger events

Windows Server 2003, SQL Server 2005 (9.00.3080) I installed SS2005 SP4 without a problem and immediately started getting vsJitDebugger 'unhandled win32 exception' messages in the application log ...
0
votes
2answers
293 views

Configure SQL-SERVER without running service

Is it possible to change the location of the temp.mdf or other files without starting SQL-Server? I wanted to reactivate an old server but one of it's USB hard disk was been already used somewhere ...
0
votes
1answer
81 views

ms sql remote connection shows all db

I've a db called "abc" against login "cde". When i access this db remotely MSSQL Server 2005 shows me all the databases however User "cde" can only access db "abc". How can i disable view of all ...
0
votes
1answer
307 views

reporting services Unable to connect to the remote server

I've got reporting services and sql server 2005 installed on a windows server 2003 enterprise sp2 server. Reporting services was working just fine until yesterday it started saying "Error- Unable to ...
2
votes
3answers
938 views

How can I speed up SQL Server queries on Amazon EC2?

Our SQL queries sometimes take too long. We have a Windows Server 2003/SQL Server 2005 setup. We have already created indexes everywhere that's possible. Can we get quicker disks? Any ideas from ...
0
votes
3answers
218 views

Batch file function

I need to create a batch file that will purge data from an existing file. Basically SQL server management studios does not overwrite backup data; therefore after the backups have been run and the data ...
0
votes
1answer
207 views

Error on creating job SQL Server 2005

Error on creating job: Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo) ...
0
votes
1answer
43 views

SQL 2005 Server memory requirements and performance

What is the risk involved in running on 91% RAM usage on Windows Server 2003 32 SP2 and SQL Server 2005 in terms of SQL Server performance? Server has 3GB and mostly sits at around 80% mark with ...
0
votes
2answers
187 views

Why does the MSSQL stay at “restoring… ” even after 2 hours?

I have backed up a database at my old server and restored it at the new server. I am totally new to MSSQL 2005 Server Express, so it took me quite a while. I spent 30 minutes to find out back-ups are ...
1
vote
2answers
62 views

SQL Server Job Question

In our project, we have two SQL Server Jobs- one to run on every night 12 AM (let’s call it “JobA”) and another one to run on every month ( 1st of every month 12AM. And let’s call it “JobB”). These ...
0
votes
2answers
1k views

Windows 2003 Enterprise Server becomes unresponsive occasionally

We're experiencing issues with our Windows 2003 server, which runs SQL Server 2005 SP1. We notice that sometimes the entire server becomes unresponsive and I captured a screenshot of the task manager ...
0
votes
2answers
47 views

Is it possible to change a cluster that is dependent on a domain?

Recently we received (2) Poweredge 6850 and (2) PowerVault 220s from our managed server company. These two servers hosted SQL Server 2005 with our SQL database on it. The cluster was dependent on ...
3
votes
2answers
129 views

What could cause mirrored databases to both become the principal database?

We use SQL Server 2005 in a high-availability configuration: 1 principle server, 1 mirror server, 1 witness server. This morning we found that several databases were listed as the principle database ...
2
votes
2answers
407 views

SQL-Server 2005 default trace log file not inherits directory permissions

I need to backup the SQL-Server 2005 default trace log files (%sqlserverpath%\MSSQL\LOG\log_*.trc) and when it is created it isnt inheriting the directory file permissions (Windows 2003 Server) so I ...
2
votes
1answer
182 views

Configure SQL Server 2005 to take advantage of 32GB of RAM on 64-bit version of Windows Server 2003

I'm looking for recommendations/best practices for configuring SQL Server 2005 to take advantage of a recent memory upgrade to 32GB of RAM. The OS version is Windows 2003 64-bit Enterprise Edition. ...
1
vote
2answers
72 views

Windows 2003, SQL 2005 - What is server tasking and where do I find it?

I've been reading up on how to tune SQL Server 2005 for a machine in a test environment. I came across this article on technet which suggests how to configure "server tasking" and says I should refer ...
2
votes
3answers
208 views

HA suggestions for geographically separated sites

I have 6 instances of sql server that I need to be highly available by being hosted on two sites (one as principal, one as DR). Transparent automatic failover is required. Most are fairly boring and ...
1
vote
1answer
36 views

SQL 2005 32Bit on 64Bit OS?

UPDATE: My fault, i misread X86 and X64. We don't have a 64bit OS. Hey all, Quick question, our IT Dept have installed a 32bit version of SQL Enterprise on a 64bit OS. This works, quite well in ...
0
votes
1answer
186 views

How to do full computer backup and restore on Windows 2003 running SQL Server 2005?

This is a question for someone who has had hands-on experience with this. Mainly I'm wondering whether this is a straight-forward process that can be achieved with the backup utility included with ...
2
votes
1answer
160 views

Sql server backups best practices. Too many files created?

I know this has been asked before, but I'm trying to understand this better. I traditionally used Backup exec to backup sql servers, but I now have two sql servers that are off-site and of course I ...
2
votes
1answer
89 views

Move clustered SQL from one network to another

We have a clustered SQL server (2k5 Std) that's currently being hosted on 1 of 2 subnets on the server. We'd like to retire the subnet the SQL cluster is on as we're experiencing default gateway ...
1
vote
1answer
49 views

Failover Config for SQL Server 2005 Professional on Win2k3 64x Standard (2 machines available)

I have MS SQL Server 2005 Standard on Win2k3 64x Standard (on 2 separate machines) How to setup fail over cluster on this solution? I don't have neither SQL or Win Enterprise and it's too expensive ...
2
votes
7answers
313 views

24/7 IT Support Cover [closed]

Hope this isn't off topic but do any of you provide 24/7 cover with a colleague and how much would you expect to be paid? Say once every 3 weeks or possibly every other week? 6K+ per year? Would be ...
0
votes
2answers
299 views

Can't connect remotely to database on SQL Server 2005

I am new to managing servers but I have just been given full access to set up an MS SQL Database on win server 2003. I have created a Database successfully and can connect locally (via remote desktop ...
0
votes
1answer
176 views

SQL Server 2005 Lock Pages in Memory on 32-bit system

On a 32-bit Windows Server 2003 Standard Edition SP2, I'm debating the pros and cons of /3gb + AWE + Locked Pages for SQL Server 2005 Standard SP3 CU4. The system only has 4GB of physical memory, ...
1
vote
2answers
45 views

Difference of speed if SQL Server is on one server and website is on another, rather than both on same server

We have db and website on same server. I would like to know that what would be the pros and cons of dedicated server for db (SQL Server 2005) and for website (webserver is IIS). Same db is also ...
3
votes
2answers
654 views

Why does my server lose SQL connection every 2-3 days (reboot fixes)?

Every 2-3 days, my Windows Server 2003 R2 Enterprise box which is hosting a .NET web app will start having an issue. The .NET app stops being able to connect to the SQL server with this error: An ...
1
vote
2answers
508 views

Remove PWA Site that has Missing Database

Okay, so, we did something bad. :-\ When we were first learning about SharePoint and MS Project, we created a 2 or three 'training'/'test' sites (say, PWA_Test and PWA_Train). These, of course, ...
0
votes
2answers
100 views

Migration Windows 2003->2008, SQL2005->2008

We have some servers with Windows 2003 and SQL Server 2005 and would like to upgrade them to Windows 2008 and SQL2008 because of the new cool features. How can that be done? Anything in particular to ...
3
votes
1answer
3k views

How to get permission to create full-text index?

I tried to create a full-text index on my new full-text catalog and got this error: Msg 9967, Level 16, State 1, Line 1 A default full-text catalog does not exist in database 'foo' or user does not ...
2
votes
1answer
455 views

Is ODBC on Windows 2003 slower than on Windows 7?

I am seeing some MSSQL 2005 performance issues, and I am trying to diagnose the cause. I am using SQL profiler to gather query execution times. Both the client (using ODBC), and the SQL server are ...