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
0answers
9 views

Database Copy Fails, but nothing fishy in the logs

I am attempting to copy a database from a remote server (sql server 2008) to my local machine (running sql server express 2014). Everything looks great, right up until the job fails at "Execute SQL ...
-4
votes
0answers
14 views

Waiting on www.google.com [on hold]

I upgraded my SQL server to SQL 14 and after I did this I can no longer get online. I can ping/nslookup any valid web site no issue. DNS is working but all browsers get stuck loading the page. Any ...
-1
votes
0answers
12 views

How to connect xampp with MSSQL [on hold]

I am using xampp on a Linux server. My phpinfo() function says that I have FreeTDS. mssql Library version FreeTDS I also downloaded a moved a dblib extension to ...
7
votes
1answer
158 views

Why can NT AUTHORITY\SYSTEM create SQL Server database backups?

I have a scheduled task (in Windows Task Scheduler) that connects to SQL Server using SMO (Windows Authentication) and creates a database backup. So far, this task was running under the Administrator ...
-3
votes
0answers
12 views

sql server 2008 r2 licensing for production [duplicate]

I have a web application that work on sql server 2008 r2, I'd like to know if i will sell this application, how the client will get the sql server license, from me or he should buy a new one.
0
votes
1answer
14 views

Unable to run query in SQL Management Studio because of JIT debugging error

Recently I have built a Windows server 2008 and installed SQL Server 2008 and Dynamics CRM 2011 on it. Everything is working fine but when I open the SQL Server management Studio and try to open a new ...
0
votes
1answer
27 views

Team Foundation Server 2013 and Large SQL Tables

I have a Windows 2008 R2 virtual machine running Team Foundation Server 2013 and MS SQL Server Express. We are a small (<10 programmers) development shop and have 3-4 collections in TFS. We stood ...
0
votes
0answers
22 views

MSSQL Server 2014 Standard CAL licensing? [closed]

I have a web service that is connecting to MSSQL database. There is aprox. 30 programs that are connecting to this service simultaneously. Is it enough to have 1 CAL license for 1 web service, or do I ...
0
votes
1answer
13 views

SQL Server Virtual Network Name Change Error

I am in the process of configuring a two-node failover cluster for a migration project. We are transitioning a stand-alone SQL Server to a cluster. Environment: 2x nodes with Windows Server 2012 R2 ...
0
votes
1answer
19 views

Uninstall Older Sql Server After Upgrade

Is it ok to uninstall older versions of SQL Server after an upgrade? I have 2008/2008 R2 installed, but using 2014 since it was just upgraded.
0
votes
0answers
29 views

How do you RESET the SQL Server 2008 TCP/IP Protocol settings back to default?

We have a SQL Server with multiple interfaces and a previous admin wanted to enable TCP/IP protocol to listen on a specific port. I believe that wherever he saw a specific IP address, he replaced it ...
0
votes
1answer
21 views

Is there DDL viewer role in SQL Server?

I have a user that have db_datareader role in SQL Server 2008 I need this user to be able to see Stored Procedures, functions, table scripts, etc. What role is that? I don't want user to RUN DDL ...
0
votes
1answer
1k views

Best practice on how to update & reboot a live server [closed]

We have a business critical server that has not been re-booted in over 2 years. It is running Windows Server 2003, with SQL Server 2005 (SP3), Visual Studio 2005 and 2008R2, and has numerous versions ...
1
vote
0answers
21 views

SQL 2014 Install failed to install Data Services and SSAS, rest is installed, how to fix without uninstall?

I just installed SQL 2014 trial version, but it failed to install SQL Data Services and SSAS Services due to space issues, which have been resolved. How can I re-install only those services without ...
0
votes
0answers
10 views

SQL Server 2008 - how to set automatic ANSI to OEM conversion option

I have a product I am installing where the pre-requisite is SQL Server. The product documentation (which is quite old) talks about SQL Server 2000. However I am installing SQL Server 2008. The ...
0
votes
0answers
13 views

Typical max API call volume for shared enterprise hosting accounts? [duplicate]

We are hosting our site with SectorLink and have a shared enterprise hosting package, running on Windows with MS SQL Server. The provider will start to throttle us once we reach 10% of the server's ...
0
votes
2answers
31 views

Configure MSSQL 2008 to use kerberos authentication

I would like to set my current mssql db (2008 and 2012) to authenticate using a linux kerberos server that I have in my environment . The windows station is in a workgroup and I would like to avoid ...
0
votes
1answer
22 views

Amazon EC2 Windows with Sql Server Web, changed to an instance with just Windows no SQL Server?

If I start a windows AMI with Sql Server Web, this will include a licensed Sql Server Web installation. What will happen if I then create a Windows only AMI instance and connect the volume with Sql ...
0
votes
0answers
55 views

Error connecting to MS SQL from one server but not the other

We got a MS SQL server and two web site servers. I'm in the process of moving all the sites from one of the web site servers to the new one. My asp.net sites are not able to connect to the external ...
0
votes
0answers
18 views

Changing how tempdb log space is monitored in SCOM

We are monitoring our SQL installation with SCOM. We get an alert about once a day saying that the log file in tempdb is filling up. However, because checkpointing works differently in tempdb than it ...
1
vote
1answer
27 views

How export database from mssql by using command line

I am using windows7 os and i have a database on MSSQL server 2005 i am using following codes to import database sqlcmd -S [server instance name] -d [database name] -i [filename you want to import] ...
0
votes
0answers
9 views

SCCM DB - Client assignment with DPs

I am trying to imitate SCCM 2012's behaviour when assigning a client to a distribution point for package downloads. Please tell me if I understood it correctly or if there are any errors in my ...
0
votes
0answers
25 views

SQL Server Managament Studio 2012 / 2014 Express with Full SQL Server 2005

I am puzzled of the current licencing options and at some level even worthfullness to use SSMS 2012/2014 with currently used SQL Server 2005 Standard (x64). Do I have to or is it standard practice to ...
1
vote
1answer
33 views

How to migrate HP Service Manager?

I have built an instance of HP service manager in my Lab environment. I want to migrate the data in my old instance into this new one. It is built on top of a MS SQL-Server DB. I realize I can ...
0
votes
0answers
31 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 ...
1
vote
1answer
70 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 ...
1
vote
1answer
35 views

Connecting to a domain-joined SQL Server from a non-domain client

I struggled for some time yesterday, attempting to log into a SQL Server 2008 instance on a domain-joined server from a non-domain-joined client. The computers in question: -fhsvr is a domain-joined ...
0
votes
0answers
28 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 ...
0
votes
0answers
7 views

Is there a way in SSMS to change the default window layout in sub windows?

Over the past 10+ years, every time I open Design Table, Job History or many other windows, I have to adjust the split to show more in the bottom panel. Job Run length is just not visible in the Job ...
1
vote
0answers
31 views

Log In failed for user error 18456

I have two servers. Both of the servers have two different database that will be joined together using SQL Server Agent. However, during this activity SQL Server is throwing a Log In Failed Error. ...
1
vote
1answer
14 views

Error in cross server sqlcmd execution due to firewall issue

I have an application server with an IP of 10.107.0.100 and one database server on which SQL Server 2012 is installed, with an IP of 10.107.0.101. Remote connections are made to this server, and the ...
2
votes
0answers
29 views

Mirrored local accounts to connect to database on different server and domain

My database client and database server are on different machines and are not connected to the same domain (this is not supported with my web host). I'm not keen to send username/password details via a ...
2
votes
3answers
79 views

How should my hosting provider handle SQL Server transaction logs?

I received a support ticket today from my hosting provider (they created it), saying that my SQL transaction log had filled up and that they had truncated it, shrunk it and reset it to Full recovery ...
0
votes
0answers
61 views

SQL Server keep crashing, cannot connect with SSMS, Agent not starting

System Windows Server 2003 x64 SQL Server 2005 x64 Problems: 1) Cannot connect via SSMS - Tried both sa account and domain account (that is in sysadmin group) - If I supplied the wrong password, ...
0
votes
0answers
20 views

MSSQL: savesets in EMC Networker

When taking over an existing Networker backup system, I have found that a single MSSQL: saveset generates several savesets. I understand that these savesets relate to each of the different databases ...
1
vote
1answer
39 views

Copy User Mappings for SQL Logins using SQLCMD - MS SQL Server

Is there a way to directly copy the User Mapping from one SQL Server login to another using SQLCMD? In SQL Server Management Studio Object Explorer | (local) | Security | Logins, Right-Click a user ...
0
votes
1answer
23 views

Issue connection to SQL from PHP

I've got a Windows workstation which I am successfully able to connect to a SQL 2012 Server over ODBC using the servers IP address. When I start php 5.4 built in web server and try connect to the ...
0
votes
1answer
79 views

SQL Server 2012 Reporting Services to export CSV

I have an SQL Server 2012 Reporting Services instance, and by default, it can only export to PDF, Excel and Word. Users require CSV export as well. All I found is that there are different extensions, ...
1
vote
0answers
24 views

SQL Server 2012 licensing Downgrade [duplicate]

Our vendor is requiring us to upgrade existing accounting software db from sql 2000 to sql 2008 and my boss wants unlimited connection to db. Can i use sql 2012 per core instead of sql 2008? from my ...
0
votes
2answers
442 views

How to connect an ODBC DSN to nondefault SQL Server instance on default port?

We are migrating an SQL Server 2000 database on one server to SQL Server 2008 R2 on another server. The client application use a User DSN to connect directly to the SQL Server on the internet. I have ...
1
vote
1answer
28 views

HeidiSQL, attach/register database in MSSQL server

How to attach (or register) an existing MSSQL database to a server Using HeidiSQL
1
vote
1answer
19 views

Why does SSMS Restore Database to another database not copy the current state of the “From” database?

When copying a database by using the Restore Database functionality in SSMS, why is it not a copy of the current state of the Database? After performing the Restore From Database Bar to Database Foo, ...
2
votes
0answers
140 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 ...
1
vote
1answer
39 views

Shrinking Database using the AUTO_SHRINK ON , helpful or is it consuming to many resources?

I have multiple databases which are constantly growing. So from time to time, I truncate the log table and shrink the biggest databases. For the biggest one (>40gb) it takes quiete some time. So I ...
0
votes
0answers
124 views

Connecting to MSSQL server using sqlcmd and odbc driver on RHEL 6 fails

I spent the last hour trying to connect to a mssql server using sqlcmd through odbc driver. I was talking to the db guy but he doesn't seem to have a clue what is going on.. Maybe you can help me out ...
1
vote
1answer
53 views

MS Sql Server getting overloading with 'Suspended' queries, mostly reads. Any way to fix this?

I have a Microsoft Sql Server that handles a moderate amout of traffic for a company software suite made up of multiple clients in java and c#. It is getting overloaded with 'Suspended' queries. They ...
0
votes
0answers
39 views

IIS7.5 Not connecting to MS SQL Server 2008 with PHP5.2.9 via php_mssql driver

Ok this is going to be somewhat involved. I have three servers: First I have a box running Linux with Apache and PHP 5.2.17. We shall call this "LB" for Linux Box. Second I have a Server Running ...
0
votes
1answer
39 views

Website can not connect to ODBC (no rights?) “Error: 80004005”

Background I am trying to migrate a website using MSSQL from MS Windows Server 2003 to a Server running MS WS 2008. It's been a while since I tried the last time (because I gave up on this problem) ...
0
votes
1answer
86 views

How to get php_mssql.dll working properly on IIS 7.5 and PHP version 5.2.17?

First of all I'll give a very brief introduction of what I'm trying to make. I need the mssql php functions to work on the webserver. I know that such functions were deprecated in PHP 5.3 and above. ...
0
votes
1answer
78 views

Connectivity between Web Server and SQL Server inside Amazon VPC

I have a Webserver and a SQL Server inside an Amazon VPC. Previously, a Webserver outside the VPC could connect to the SQL Server fine. Now, sometime, when running SQL Scripts (the deployment script ...