Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the sql-server tag link on the line below.

learn more… | top users | synonyms (3)

0
votes
8answers
8k views

SQL Server slowly hogging RAM, where do i start to optimise? [duplicate]

Possible Duplicate: SQL Server memory constantly going up, from 1GB RAM used to 7GB in a week. Hi There, We have a fairly new 2008 server with 4gb ram and SQL Server 2008. We're currently ...
0
votes
1answer
1k views

Installing both SQL 2000 and SQL 2008 on the same machine

Is it possible to install BOTH 2000 and 2008 on the same machine (and have them as different instances) Ideally, I want the 2008 to be default instance, with 2000 named "legacy" or something... We ...
0
votes
2answers
524 views

Running ASP.NET Website and Exchange Server on same machine?

At the moment I only have one machine available to me that is already hosting Exchange Server 2003 on it. I am going to be developing an ASP.NET website (possibly using MVC framework) which is going ...
0
votes
1answer
277 views

Monitor network drops between Windows Server 2003 servers

This is probably a ridiculously simple question, but here goes... I'm troubleshooting an issue where an application (SQL Server Analysis Services) becomes unavailable for anywhere from 30 to 60 ...
0
votes
2answers
160 views

Sql 2000 and AWE

I have a weird problem. I enabled AWE on a Sql 2000 sitting on a Windows 2003 server. The server has 20 gigs of memory but when i enable AWE sql process is showing as having only 128 MB. From perfmon ...
0
votes
2answers
1k views

Problem authenticating with SQL server 2008 server from IIS 6 server

I have 3 seperate physical servers: Old Webserver (IIS6; Windows Server 2003) New Webserver (IIS7; Windows Server 2008) DB Server (SQL 2008; Windows Server 2008) These are all non-domain ...
0
votes
5answers
2k views

MSSQL 2005 on port 1433 gets DOS from infected servers

I have a SQL Server 2005 server hosted outside my firewall at a data center. It is fully up-to-date on patches, etc. There's some old MSSQL worm (Slammer?) that STILL infects thousands of servers ...
0
votes
1answer
229 views

Installing Team Foundation Server on a shared database instance

Would you use a database instance used for development work to store TFS Data Layer ? If that's not the case, what kind of separation would you use ? Setup : we have ONE server for all common dev ...
0
votes
6answers
4k views

Connecting remotely to an SQL server inside a LAN

I am using SQL server 2008 inside my home lan. I've configured it to accept remote connections and I can now connect to the server from other pcs inside the lan. The problems rises when I try ...
0
votes
1answer
646 views

SQL Server 2005 on 2008 DC - Cannot change service user

I cannot start SQL Server 2005 transactional replication after I promoted my 2008 Server to a DC. A required privilege is not held by the client. This site suggests that I need to change the ...