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)

1
vote
4answers
1k views

SQL connection is too slow

We have a business web application in ASP.NET + SQL Server 2008. In the beginning, SQL Server and IIS were on the same machine. Now we bought another machine. Current configuration is IIS machine ...
1
vote
2answers
822 views

PHP 5.2.11: Unable to load dynamic library complaints

I installed PHP 5.2.11 and upon enabling the php_mssql.dll module (and the obligatory restart of the services) started receiving warnings about not being able to load the dynamic library. The ...
1
vote
3answers
3k views

Restore SQL Server 2005 backup db on SQL Server 2000

I created a backup of a database on SQL Server 2005 and I wanted to restore the backup file on a SQL Server 2000. However, I am getting this error The media family on device [path] is incorrectly ...
0
votes
1answer
314 views

RAID 10 Cluster Size for SQL Dynamics AX Database

Many article read and many websites visited yet still no closer to a firm or concrete answer. We have created all our Arrays for our SQL 2012 installation with the appropriate LUN's and understand ...
0
votes
1answer
35 views

Does 2012 R2/TFS/SQL need limits set so it doesn't eat up disk space with logs?

Setup: Hyper-V 2012 R2 host, primary guest is TFS single server installation w/ SharePoint (includes SQL for TFS ops) This question was posted on StackExchange SharePoint WRT the SharePoint aspect ...
0
votes
1answer
550 views

what is the difference between SQL and ANSI SQL?

what is the difference between SQL and ANSI SQL?
0
votes
3answers
2k views

Failover clustering: tempdb on SAN?

We are considering clustering our SQL Server 2008 EE instances. The storage is on SAN. Can we put tempdb data/log files on SAN? What are the pros and cons on this solution? For optimal performance, ...
0
votes
2answers
219 views

Replication keeps popping up on SharePoint databases

My typical discovery scenario: We receive an alert that the transaction log is growing quickly. We are in Simple Recovery so I go to check it out. Log is already sized to 100GB and is at 80% capacity....
0
votes
1answer
7k views

SQL Maintenance Cleanup Task 'Success' But not deleting files

I have a maintenance plan setup for a databases on a server. As part of the backup is a Maintenance Cleanup Task. SQL Version 2008 The task that 'succeeds' is setup as: Delete backup files Correct ...
0
votes
2answers
185 views

The Transactional Log is Full

I am getting below error. The transaction log for database 'CRM_QA_V6' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases likely ...
0
votes
1answer
941 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
218 views

A utility to backup single tables on MSSQL?

Are there any Windows utilities that allow you back up single MSSQL tables? Having a lot or trouble finding any. I hear sqlbackupandftp is good, but as far as I can see, it doesn't back up single ...
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
2answers
164 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
709 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
1answer
660 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 ...
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
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
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
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
2answers
563 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
235 views

Can't access SQL Server 2008 with anything but 'Windows NT Integrated Security'

In Management Studio, if I go 'Security' --> 'Logins' --> 'New Login' --> something simple like username='test' and password='test', I am still unable to use this login - why? Is there something ...
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
288 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
92 views

SQL server connecting issue

We recently installed SQL server 2000 Std. edition on my new windows server 2003 R2 server which is the additional domain in our existing windows 2003 server domain. Now i am unable to connect this ...
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
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
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
3answers
2k views

Why cannot connect to SQL Server by the full server name with instance name?

For some reasons, I cannot connect to my SQL Server with full name + instance name (e.g. server_name\MSSQLSERVER) by SMSS. However, I can connect by simply using just server_name or localhost. When I ...
0
votes
2answers
3k views

SQL server performance over long distance

Is it reasonable to expect decent performance from a SQL server connected via fiber private WAN - 5000 km's away. The carrier is telling us that this network is the 'best' possible, and will ...
0
votes
1answer
6k views

SSIS DSN Not Showing as ODBC Data Source

I have been following the directions here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/05ccd778-b78c-4a83-a10a-c4ae412cc6e4 And ran into a problem where my System DSN ...