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
88 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
340 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
70 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
77 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
81 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
1answer
135 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
897 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
163 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
1answer
141 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
12 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
1answer
232 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
30 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
103 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
91 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
350 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
98 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
588 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
27 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
2answers
394 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, ...
0
votes
0answers
26 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
4k 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
94 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
34 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
1answer
770 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 ...
2
votes
1answer
84 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
697 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
291 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
134 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
83 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
2k 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
139 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 ...
0
votes
0answers
162 views

Cannot generate SSPI context and VPN

I am the developer of a time recording tool written in vb.net using odbc. Using this tool from home via vpn (cisco) everything is working for ME and one other person. My collegue could connect too but ...
1
vote
1answer
129 views

Intermittent performance issues on Azure Web Application with ASYNC_NETWORK_IO errors

Our web application is suddenly experiencing intermittently slow performance (slow page loads, slow ajax calls going from <1 sec to over 20 secs). The only clue is when the application slows, we ...
0
votes
0answers
101 views

Inconsistent server connectivity with System.Net.HttpWebRequest

I have a production database server (Windows Server 2008 / SQL Server 2008) which has a .NET CLR Assembly referenced on it with a CLR function called dbo.fnu_RequestUrl. The purpose of this function ...
4
votes
1answer
371 views

Network traffic to server keeps dropping out

I have a production server that is responsible for controlling a factory. The server runs a number of control applications and a SQL server. The problem I have is that one of the applications that ...
1
vote
1answer
124 views

Downgrade SQL Express 2008 R2 SP2 (x86) to SP1

I'm looking to update vCenter from 5.0 to 5.1U1. In order to do the update, I need to downgrade the current SQL Express 2008 R2 SP2 to SP1 according to VMware compatibility matrix. Can I just ...
0
votes
0answers
20 views

MSSQL 2008 query VERY slow on live server compared to dev server - not sure how to debug?

Running SQL 2008 R2 on both servers. When we run a fairly large query against the developer server, it takes a few seconds. The live server takes around 1.5 minutes, even with no one else connected to ...
0
votes
0answers
209 views

Error:Microsoft SQL Server Native Client 10.0 error '80040e37'

I migrated a website attached to a MSSQL database from Windows 2003 running on IIS6 to a Windows 2008 R2 running on IIS7.5 but I get the error: Microsoft SQL Server Native Client 10.0 error ...
1
vote
1answer
20 views

SQL Server 2005 DROP LOGIN syntax error

This snippet of code (it's just a repeater, not the actual code I'm going to run) throws a syntax error on the DROP LOGIN command: declare @obso_user varchar(16) set @obso_user = 'BEN_VA\20362781' ...
0
votes
3answers
60 views

Separate SQL Server Instance or just new database?

I'm going to deploy an app whose requirement is just 'db_owner' for a database. The database itself must be created separately by the DBA. Based on how the application will work (and its simple ...
0
votes
0answers
46 views

Unable to connect to SQL Server over SSL

I am unable to connect to a SQL Server over SSL. This is the current setup: A server at my location sends data to an external service (SQL Server 2008) using SSL. We are using Websense and an ASA for ...
1
vote
3answers
118 views

How to use the join statement in MSSQL correctly? [closed]

I am pretty new to SQL and I already read something about joins , but coudn't find out. I painted my scenario here : I want to update the Firstname of Table1 into Temp1 where the CreateTS of the ...
1
vote
0answers
32 views

Server network communication stalls

I'm running SBS 2008 as a file server, SQL server, IIS7 Server, and Exchange server, and very recently I am getting some very confusing stalls on it. During these "stalls," file services will cause ...
1
vote
4answers
51 views

SQL Express connection issue [closed]

I have installed a instance of sql-express for an MDT deployment solution (XYZ-Deployment) I've got to the stage where I add a database share and when I go to add it, I get the following error ...
0
votes
2answers
45 views

SQL2008R2Std Maximum RAM per instance

In this page : http://msdn.microsoft.com/en-us/library/ms143685%28v=sql.105%29.aspx It's written that SQL 2008R2 Standard supports 64GB of RAM, but is it per instance? For SQL2012 (here : ...
1
vote
1answer
28 views

32 and 64 bit MSSQL on same server

Is it possible to install a 32bit instance of SQL Server and a 64bit instance on the same 64-bit server? I have ODBC drivers that are 32bit, and need to use these as linked servers in SQL Server, so ...
1
vote
0answers
33 views

Why is $job.LastRunOutCome always “Failed”?

I am using sqlps to run a backup job "Backup Something". Set-Location "SQLSERVER:\sql\$hostname\default\jobserver\jobs" $job = Get-ChildItem | Where-Object {$_.Name -eq "Backup Something"} ...
1
vote
1answer
199 views

Licensing and Editions of Microsoft BizTalk and SQL for Development, QA, Stage vs Production [duplicate]

My question is similar to this one, but I am gearing mine more toward which edition to use. In the past places I've worked, these decisions were made by other teams, and now I'm being asked to ...
0
votes
1answer
94 views

MSSQL: Restore a DB to the latest file in a backup set

I have a MSSQL 2008R2 DB in SIMPLE recovery mode that is periodically backed up with BACKUP DATABASE MyDB to DISK = 'Z:\MyDB.cbak' WITH COMPRESSION This runs periodically, creating multiple ...
1
vote
1answer
2k views

Can pdo_sqlsrv driver be installed on Linux/Ubuntu with php 5.5.3 using pecl install pdo_sqlsrv?

In all likelihood, I have overlooked a fine print somewhere, so this question may sound stupid, but will clear my doubts. I spent hours trying to install pdo_sqlsrv PDO driver on Ubuntu 13.04 PHP ...