Questions tagged [sql-server]

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.

The tag is for general questions related to Microsoft SQL Server and its various technologies. SQL Server is a very broad topic, much of which is perfectly suited for serverfault. SQL Server programming questions involving code, however, will be generally be better suited for stackoverflow.

If you have a SQL Server question, ask yourself the following questions to determine the best site:

  • Is the goal of my question to solve a SQL Server system administration (DBA) function? If not, then it's a good bet you should head on over to stackoverflow https://stackoverflow.com/ or superuser https://superuser.com/

  • Who would use the code that my question relates to the most, a developer or a DBA? If a developer, stackoverflow is your place. If a DBA, ask away here.

For information on how to handle installation errors related to the system language versus the installation media language, see SQL Server setup media does not support the language.

4775 questions
2
votes
1 answer

apache 2.2 with php 5.3 and miscrosoft sql 2008 crash

I am using Apache 2.2 with PHP 5.3 and Microsoft SQL Server 2008 on Windows Server 2008 64-bit. Every 3 to 5 hours, I get the error in the event viewer that Apache crashed for 20 seconds and then resumed. The error is: Faulting application…
2
votes
3 answers

How can I delete SQL Server differential and log backups earlier than the earliest full backup still on disk?

When I delete a full backup, I would like to delete all the files that are rendered useless once that full backup has been deleted: specifically, the differential and log backups that occur before the earliest full backup that is still on disk. Does…
Mark Freeman
  • 131
  • 1
  • 3
2
votes
3 answers

SQL Trace for past queries

Is it possible to use SQL 2005 Server profiler to run a trace for queries that happened for example 6 hours ago? Or is trace only used for real time? I'm trying to find a way to view old TSQL queries. Is this possible with SQL 2005?
OB Wan
  • 21
  • 1
2
votes
2 answers

Windows authentication in SQL Server allows user to see ANY database

I've got a sql server instance with about 50 databases on it. A developer, call him Joe, wants access to one existing database. So I went ahead and created a new log on account in sql server 2005 management studio and in the user mapping section I…
oJM86o
  • 143
  • 8
2
votes
4 answers

Possible attack on my SQL server?

Checking my SQL Server log I see several entries like this: Date: 08-11-2011 11:40:42 Source: Logon Message: Login failed for user 'sa'. Reason: Password did not match for the login provided. [CLIENT: 56.60.156.50] Date: 08-11-2011 11:40:42 Source:…
MicBehrens
  • 173
  • 1
  • 3
  • 11
2
votes
1 answer

Database Mirroring Questions

I recently set up SQL 2005 database mirroring (synchronous with witness) on a couple of environments and enjoyed the experience but have a few questions: Does the transaction log chain get broken when a fail-over occurs? Do I need to schedule a…
SuperCoolMoss
  • 1,262
  • 11
  • 20
2
votes
1 answer

Password mismatch while logging to sql server

Alright, I have a classic asp application and I have a connection string to try to connect to db. MY connection string looks as follows: Provider=SQLOLEDB;Data Source=MYPC\MSSQLSERVER;Initial Catalog=mydb;database=mydb;User Id=me;Password=123 Now…
user194076
  • 121
  • 4
2
votes
2 answers

default PUBLIC settings

does anyone know of any security risks with the default PUBLIC settings for sql 2005/8? i ran sp_helprotect and it listed out the PUBLIC grants, and now i have an auditor telling me that i have a security risk because PUBLIC has access to system…
2
votes
1 answer

Suggested or Best practices for network architecture for ASP.net web application

Currently I have one server that runs an ASP.net web application (on IIS) and this is also running a SQL Server database. I am getting more and more traffic and soon I will need to increase the amount of traffic I can handle so the user experience…
SetiSeeker
  • 275
  • 2
  • 9
2
votes
1 answer

I am very confused with SQL Server Express Instances / what am I actually connecting to?

I am running SQL Express 2008 on my development machine with one instance. For some development, I used the AttachDB Connection string. I really can't remember the exact reason, but these are not mounted in the normal way. I think I wanted to live…
William Hilsum
  • 3,536
  • 6
  • 29
  • 39
2
votes
4 answers

How to permanently delete data off Windows 2003 server?

One of our clients requires that at the end of the contract we "securely" delete all data from the server (including SQL Server). I think I need to deal with this in two parts. 1. SQL Server Data: The client data is stored in 2 SQL Server databases,…
Dan
  • 783
  • 1
  • 13
  • 21
2
votes
1 answer

Windows Performance Monitor keeps trying to add unwanted counters

I have been running a Data Collector Set for SQL Server for a week, and everything was going just fine until I tried clicking on Action -> Save Current View and now it always tries to add the following counters automatically to my…
2
votes
1 answer

error setting up replication from mssql to mysql

I'm trying to setup replication from SQL Server 2005 to MySql 5.1.53. I am able to add the publication without any problem. However, when I go to add the subscription I get this error: OLE DB or ODBC Subscribers cannot subscribe to article…
2
votes
3 answers

Login failed when SQL Server starts

I've got a windows service that needs to connect to SQL Server databases (SQL Server 2008 R2, Windows Server 2008 R2). This service depends on SQL Server. The problem is when the SQL Server service starts: Login failed for user 'Database'. Reason:…
Morti
  • 121
  • 3
2
votes
1 answer

Cleanup Backup Files without xp_cmdshell or maintenance plans

Background: We've got a backup script which needs xp_cmdshell to run. I decided that on new servers, we are not going to enable xp_cmdshell. I enabled xp_cmdshell when the job starts and turn it off at the end. The problem is that if a full…
Sam
  • 2,020
  • 1
  • 16
  • 22