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 (4)

0
votes
1answer
56 views

Periodically run an MS SQL query on multiple sites

I have been tasked with pushing Google Analytics data periodically to SQL Server 2005 running on a different server from various websites (about 450 of them) grouped on various servers. I understand I ...
4
votes
2answers
5k views

Can I tell the last modified date on an SSIS package from Integration Services

Using SQL Server 2005 (and 2008) With a DTS package, I can open it, and it lists the date that the package was last modified. I have some SSIS packages, and I need to know if they have been modified ...
-1
votes
1answer
51 views

Connect to SQL Server from different network (remote) [closed]

I am new to SQL server stuff and recently thought of creating a Database for my website. I would like to stop things like comments, blog post, stuff like that. But I am trying not to pay for SQL ...
2
votes
4answers
840 views

Transferring data between SQL Server and MySQL

We host a couple of SQL Servers where we are planning to upgrade the environment (still classic asp). We are looking whether to move to a LAMP (or WAMP) environment instead of just following the ...
2
votes
2answers
867 views

Can I replicate data between mySQL and SQL Server/SQL Azure?

I have a replicated mySQL setup running happily on Amazon AWS, making user data available locally in various regions. Now I'm faced with an app that needs to go up on Microsoft Azure and I need to ...
0
votes
0answers
11 views

DPM Protection Groups & SQL Server

I've been tasked with moving our backup solution from standard sql backups to DPM backups. We have a fairly standard setup. Transaction logs backed up every 15 minutes. Daily backups which expire ...
1
vote
1answer
16 views

SSRS Failing with error on App_global.asax

Our SSRS server has started failing. The Logs are currently showing the following error: System.BadImageFormatException: Could not load file or assembly 'file:///C:\Program Files\Microsoft SQL ...
2
votes
1answer
123 views

MSSQLSvc Service Principal Names, Kerberos, and NTLM

Was recently helping a DBA with an issue that appeared to be related to an invalid SPN. Discovered that a good number of SQL service accounts simply don't have an SPN set, resulting in NTLM ...
0
votes
1answer
25 views

Old SQL installation media

We have MSSQL Server 2008 R2 licenses. We have an Action Pack subscription, which provides us SQL 2014. But we just need the installation media for 2008 R2 so that we can install Reporting Services. ...
0
votes
0answers
107 views

Getting Error: “Cannot open database \”DB PATH“ requested by the login. The login failed.\r\nLogin failed for user 'ACTADMIN' ”

Overview: OS: Tried on both win 7x64 and win8.1x64 Visual Studio version: Tried on VS 2013 (.net version 4.0 and 4.5), and VS 2010 (.net version 4.0) DB used: ACT2014Default Act version: Act! Premium ...
1
vote
1answer
60 views

SQL 2012 -> SQL 2014 upgrade failure

I did a SQL 2012 to SQL 2014 upgrade using the upgrade wizard. The install failed for the DB, Full-Text, Replication, AS and SSRS components, and the error reported was due to a backup location no ...
2
votes
1answer
32 views

Does an SQL Server instance allow both secure and non-secure connections at the same time?

we have an application running MS SQL Server 2012. For one specific use case we'd like to SSL protect the jdbc connection. I've checked the following links: How to enable SSL encryption for an ...
0
votes
1answer
4k views

SQL Server instance service doesn't start

After manually stopping SQL Server instance service it can not be started both manually from a SQL Server Configuration Manager and automatically by restarting computer. If trying to do it manually I ...
0
votes
1answer
76 views

SQL Server database backup to Windows Azure Recovery Service

I have some VMs on Windows Azure and IIS and SQL Server 2012 is installed on them. I also created a Backup Vault on Windows Azure and installed the Windows Azure Backup Agent on the VMs. It works ...
-1
votes
1answer
51 views

Cannot access my database, it says database inaccessible

I am hositng my application on a server but runs my Sql server in windows mode as application is still bieng developed. But suddenly when today I opened my Sql Management Studio, it is not allowing me ...
1
vote
1answer
46 views

What happens to active connections to my SQL Server DB if I back up the transaction log with the NORECOVERY option?

Some background: I'm migrating my SQL Server DBs to a new machine and I wrote a few Powershell scripts to send/apply full backups and transaction logs asynchronously to the new server, but my question ...
2
votes
1answer
457 views

SQL Server Connection Timeout after load brought onto IIS web server

We have MSSQL 2008 R2 running on windows 2008 r2 it's being hit by 2 server 2008 r2 webservers running asp.net. Both are joined to an active directory domain and use integrated authentication to ...
0
votes
1answer
50 views

Upgrade from SQL 2008 to SQL 2012: do we need to change connection string?

We are seeing some terrible performance degradation having just upgraded our MVC4 application from SQL 2008 to SQL 2012. Queries run directly in management studio on the database server run somewhat ...
0
votes
1answer
32 views

SQL Backup very slow

I takes like an hour to backup my 24GB database. I put the backup on the same disk as the location of the actual SQL database, but I dont think thats the cause. When I execute exec sp_who2, here is ...
1
vote
0answers
25 views

Issue while setting up a DSN while creating a linked server

I am trying to set up a linked server to my sql from sql server. However I am encountering problems while setting up the dsn. Reffering this link for help. My MySQL database resides on Amazon ec2 ...
0
votes
0answers
13 views

I got an error like this when run aprogram [duplicate]

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that ...
1
vote
1answer
18 views

SQL Server 2012 Backups Not Compressing

We recently upgraded from SQL Server 2008R2 to SQL Server 2012 Enterprise. After doing this I noticed that our DB backups were barely compressing at all. Our 22gb DB was compressing down to about 4gb ...
3
votes
4answers
17k views

Cannot login to SQL Server 2008 R2 with Windows authentication

When i try to connect to SQL Server (2008 R2) using Windows authentication: i cannot: Checking the Windows Application event log, i find the error: Login failed for user 'AVATOPIA\ian'. ...
0
votes
1answer
70 views

Can Ping but Cannot Telnet directly to SQL Server 2012 Cluster Nodes

We have a monitoring tool (Solarwinds Orion) that needs to connect to a 2-node failover SQL Server Cluster. For reasons outside of our control -- we cannot monitor the CLUSTER IP directly at this ...
0
votes
2answers
73 views

Add an Excel file as a linked server in SQL 2012

I'm trying to add a linked server to an Excel 2010 file from SQL Server 2012. Every reference I've found online for doing this is using older versions of SQL Server, and the driver that they tell you ...
2
votes
2answers
2k views

SQL 2008. I have user in a db which has no login on the server. How is it possible?

I am talking about windows authentication. I dont have access to the server adming rights but a dbadmin sent me screenshot where my user is not in the logins of the server. and also there is only one ...
-2
votes
1answer
227 views

Is Dell Poweredge 2950 faster than Dell Poweredge R820? [closed]

I have a 10 year old Dell Poweredge 2950 that will be replaced with a Dell Poweredge R820. Both of these machines are set up as a Virtual Machine Host Running Hyper-V. Both Operating Systems are ...
0
votes
1answer
94 views

How to resolve SSPI context error without changing Service Account from MSSQL

There is a issue while connecting from new Windows 8.1 Clients to SQL Server 2008 running on Windows Server 2008 R2. The SQL Service running under account Domain\mssqlservice on a machine thats works ...
0
votes
1answer
41 views

Determining Azure SQL Database requirements

I'm looking into moving an SQL Server database project to the cloud using Azure SQL Database. I'm just wondering what metrics I can use from SQL Server to help determine what my needs will be on ...
1
vote
3answers
169 views

Vmware cpu allocation for a spiking database server

I have a database server with many poorly written queries that causes the sql server to spike then drop constantly ( a massive start from scratch is happening). I need to know if the cpu allocation on ...
0
votes
1answer
42 views

SQL Reporting service unable to start after restoring on new hardware

I have a SQL server that the hardware is failing. As a solution we restored the image of the server on a multicore (more less new) server. The problem is that SQL 2000 cannot be started if number of ...
0
votes
2answers
788 views

How to setup Database Permissions on SqlServer Express 2008

I'm using a code-first approach of using the Entity Framework. When I first run the application it will try to create the database matching my MVC models. However, it doesn't have permission to ...
0
votes
1answer
22 views

Hide a SQL server table partition

Is it possible on SQL Server Enterprise to hide a specific table partition from users including admins? encrypting the data is not an option for us.
1
vote
1answer
618 views

Failover Cluster Client Access Point Only Responds to Pings on the Owner Node

Background We're running two VMs (Windows Server 2012 R2) on Azure with SQL Server installed, set up as an availability group. We also, of course, have another VM as a dedicated DC. These are all ...
0
votes
0answers
38 views

Intermittent telnet connection issues on 1433

I have several windows server boxes running on the same subnet at a co-lo. I have a few sql servers instances running and some of the machines can talk to it just fine, but at least two of my web ...
0
votes
0answers
59 views

Cannot access Cluster Shares via Cluster Name

I got a serious problem here (thinking like so), the problem is I have a Windows 2012 R2 Cluster and I have the Disks shared to cluster nodes via Share the VHD option that is available in 2012 R2 ...
0
votes
0answers
34 views

Amazon EC2 SQL Server Connection Timeouts

I am currently having a problem with SQL server timeouts. I am running Windows Server 2008 R2 w/IIS and SQL 2008 R2 (Express) on an m1.small instance in EC2. We have custom services that monitor the ...
5
votes
3answers
16k views

How to duplicate MSSQL database on the same or another server?

It is perhaps a bit stupid question, but I must admit I have very limited experience with MSSQL and yet has to accomplish this: Take a snapshot of the database and create and exact duplicate on ...
2
votes
0answers
39 views

Failover_Partner connection in file DSN not working

I have an application which uses file DSNs to connect to a central database server. This database server is mirrored onto a secondary server, and in the event of a failover, it is my understanding ...
0
votes
1answer
154 views

can't connect to Sql Sever Management Express 2012

i installed Sql Sever Management Express 2012 , but when i try to connect in Sql management studio enviroment , i have this error . > TITLE: Connect to Server Cannot connect to .. ADDITIONAL ...
0
votes
3answers
296 views

SQL Server Monitoring [closed]

I am looking for some open source software which I can use to monitor Microsoft SQL server 2005 & 2008. The features that I would like include: Graphing Recording of CPU usage Recording of Disk ...
2
votes
4answers
409 views

SQL Server Monitoring Packages [closed]

I'm looking into purchasing a SQL Server monitoring system. It should work with 2005/2008. We would like to monitor performance, availability, backups, jobs and various database issues (space) What ...
1
vote
0answers
80 views

Make other VMs show in Network on windows server in Azure

I'm deploying a desktop app that connects to a remote database. standard 2-tier setup, but it's not a web app. People will log in via RemoteApp. But I'm having trouble getting the app instances in ...
1
vote
4answers
1k views

Why upgrade from SQL 2005 to SQL 2008 R2?

have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a time and there are ...
2
votes
2answers
2k views

Can't Start SQL Server 2005 Agent - Start/Stop Are Not Enabled

We have a brand new install of SQL Server 2005 on a Windows 2008 Server. When using the SQL Server Management Studio (2005 or 2008) from my Windows XP Professional workstation, if I right click on the ...
0
votes
2answers
286 views

Why is my DB read-only when attached to SQL Express, but not with SQL Web?

I have an .mdf/.ldf pair, originally created in 2008 R2 Standard, and well under 10GB, with ACLs: d:\db snapshot\DB_NAME.mdf SERVERNAME\SQLServerMSSQLUser$ACCOUNT$MSSQLSERVER:F OWNER RIGHTS:F ...
12
votes
3answers
4k views

How do I remove a specific bad plan from the SQL Server query cache?

We have one particular SQL Server 2008 query (not a stored proc, but the same SQL string -- executes every 5 minutes) that intermittently caches a very bad query plan. This query normally runs in a ...
0
votes
4answers
311 views

SQL Database is in Suspected Mode

I found that database is in Suspected Mode ...... How Can I Recover it from this Mode.
0
votes
1answer
302 views

How can I get SeSecurityPrivilege enabled?

I'm trying to install a hotfix for SQL Server 2008 and failing on the Rule Check with "Setup account privileges" failed. I am running SQL Server 2008 Standard on Windows Server 2008 R2. Searching on ...
1
vote
1answer
393 views

Red Hat 6 connect to MS SQL server 2005 using freetds; pdo_dblib and php

I'm having a problem connecting to my Microsoft SQL Server 2005 from a Red Hat box using freetds. My end goal is to be able to connect using php's PDO, but I don't appear to be able to connect when ...