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
1answer
935 views

long access times and errors in iis application

I am having an issue with an IIS application (details of environment at the end of the message). The web site works great most of the time and I cannot reproduce any error in our test system. On the ...
0
votes
1answer
451 views

How can be cout \Process(sqlservr)\% Processor Time over 300 %

The counter, Process(sqlservr)\% Processor Time, is hovering around 361% on one of my database servers. This counter reflects the percent of total time SQL Server spent running on CPU (user mode + ...
0
votes
2answers
2k views

Remote MS SQL 2008 connections

Hello i am having problems setting my MS SQL server up so i can connect to it remotely. I have enabled remote access in the SQL Server itself, and enabled TCP connections in the config manager. And i ...
0
votes
2answers
684 views

Tools to manage sql 2008 database mirroring?

We are going to be moving about 20 databases that live on a single instance of sql 2000 to a sql 2008 r2 environment with database mirroring. What I'm looking for is a tool or scripts that will help ...
0
votes
3answers
4k views

MS SQL Server Firewall Ports

I've recently found myself in the position of quickly deploying a production app on SQL Server 2008 (EXPRESS), and I've been having some issues with configuring firewall rules between our web server ...
0
votes
1answer
3k views

Can I setup a link SQL server connection between servers on different networks?

We have a production SQL server hosted offsite at a hosting company, and we have a staging environment within our own network. We want to be able to setup a SQL job that copies content from a table ...
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
545 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
284 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
162 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
230 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
653 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 ...