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)

0
votes
0answers
236 views

Could not create AppDomain manager: ''

Launching an i2.2xlarge instance using AWS, we sometimes run into an issue where SQL server 2008 does not start up correctly (about once every ten tries). The SQL server error log contains the ...
2
votes
1answer
45 views

Kerberos Error APP_MODIFIED when using a CNAME DNS record

I have a production server, which I'll call CONTOSO\MachineA, running SQL Server. I have a development server, which I'll call CONTOSO\MachineB, running IIS. Both servers are running Windows Server ...
2
votes
0answers
81 views

Constrained Delegation between IIS, SQL Server, SSRS and File System

First of all, not sure which site is best suited for this question be it SO, SF or SU so please feel free to suggest migration! I have a requirement to constrain delegation between several machines ...
0
votes
0answers
478 views

[S1090][unixODBC][Driver Manager]Invalid string or buffer length

I'm getting the error above when issuing isql 'odbc:Driver={ODBC Driver 11 for SQL Server};SERVER=<redacted>;DATABASE=<redacted>;' username password -v as root on my Linux CentOS 6.7. ...
1
vote
1answer
941 views

SQL Server 2014 Install Failed with The computer must be trusted for delegation and the current user error

I'm attempting to install SQL Sever 2014 newly installed Windows Sever 2012 R2 Standard edition OS. During the GUI portion of the installation it fails with the following error: There was an ...
0
votes
1answer
567 views

Cannot connect to SQL Server from local machine to virtual machine hosted on another PC

I have installed SQL Server Express 2008 R2 on a Windows 7 virtual machine - this virtual machine is hosted on another PC on our network. I would like to connect to the server using SQL Server ...
0
votes
2answers
57 views

SQL Server performance

I created a simple website (using C#) that import 70k rows data from a text file to my database but I got this problem: It takes 3 minutes to import 70k rows data to database on my desktop (DELL ...
0
votes
3answers
58 views

Changes to data ordering between SQL Server 2000 and 2012

My company recently migrated a .NET 1.1/SQL Server 2000 web application to SQL Server 2012. We've had a couple of support calls relating to unusual behaviour - particularly with stored procedure ...
0
votes
1answer
43 views

Dynamics AX Synchronization Errors

I have an issue when synchronizing my Dynamics AX 2012 data dictionary with the SQL Server. It is giving errors on a variety of tables/views, complaining of no valid runable code. The problem is, ...
0
votes
2answers
247 views

Centos, PHP encrypted connection through freeTDS/ODBC to Microsoft SQL Server

I would like to connect from PHP to a Microsoft SQL Server through an encrypted connection. PHP scripts will run from a CentOS release 6.7 (Final) I want to connect to a Microsoft SQL Server 2014 ...
-1
votes
1answer
22 views

SQL 2008 developers edition functionality [duplicate]

I'm trying to find out if SQL developers edition will support windows 2008 HA / clustering. According to this link https://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).ASPX#High_availability ...
1
vote
2answers
103 views

How to free up disk space on a drive which has BiztalkMsgBoxDB_log file in it

I have been asked to analyze a issue regarding one of the biztalk servers. I was asked to free up space on a particular drive, where I found the only file BiztalkMsgBoxDB_log.bak is taking up close ...
1
vote
0answers
102 views

Error when viewing database mirroring monitor in SQL Server with non-default port

I have database mirroring set up (with witness) on SQL Server 2014 Standard. Both servers use default instance on a non-default port (not 1433). Mirroring works perfectly fine. However, when I try to ...
1
vote
1answer
52 views

Coldfusion Server with MS SQL 2008 R2 - Database permissions

I have a Coldfusion server with a lot of websites and an MS SQL Server 2008 R2 connected with the webserver. The issue is that all datasources are connected to SQL with the sa which is wrong. So I ...
-2
votes
1answer
92 views

Server 2012 Cluster - Second Node Can't Ping Items

I've got a server 2012 SQL Cluster and all of the processes failover and run properly. The only odd behavior is that when I fail over to the secondary node, there are certain items on one NIC that ...
0
votes
0answers
8 views

Is CAL licen for SQL Server [duplicate]

We have build a web application in asp.net and sql server 2014 but i was searching around and found that any who uses sql server requires a CAL. How are SQL Server CALs counted?. But what if non of ...
-1
votes
1answer
26 views

Stop SQL default instance

I have installed SQL Server 2014 named instance and configured to connect on static port 1433(Default SQL port). For example: db.mycompany.com\SQL2015,1433 But it's able to connect to the default ...
2
votes
3answers
94 views

RAID versus Storage Pools

I'm currently developing a requirements specification for a new server and am trying to weigh benefits & pitfalls with available technologies. Our current server uses a RAID-5 disc layout which ...
0
votes
0answers
13 views

Login Failed from IIS website

I have a two servers in a lab not using ActiveDirectory, ServerA holding a website and ServerB holding the SQL Server DB. The website C# code is trying to connect to the DB and is getting a strange ...
0
votes
0answers
14 views

Conservative Azure Windows VM to Run SQL Server 2008 R2 [duplicate]

For testing purposes I need to set up three Azure Windows VMs to each run an instance of SQL Server 2008 R2 each holding one DB of approx 100GB. There will be quite a few complex stored ...
-1
votes
1answer
20 views

SQL Server restore operation reliability

I have a simple backup scheme on my SQL Server 2008 R2 that performs a weekly full backup and a daily incremental backup. Backups are retained for two weeks and everything works fine albeit there are ...
0
votes
2answers
64 views

Non Azure VPS connecting to an Azure SQL Server

Ive got a VPS running a web application where its performance is being slowed incredibly by the SQL Server that is installed alongside it. I want to use Azure SQL Server to host the database there and ...
0
votes
0answers
224 views

Connection to MS SQL Server instance through SSH SOCKS proxy fails

I use a local ssh socks proxy (localhost:7070) on my Linux Laptop to connect to my company's intranet over my company's Windows+cygwin laptop, which has intranet access: Linux --(ssh -N -D 7070 -p ...
0
votes
0answers
80 views

SQL Server Express 2014, Windows Authentication problems

I am using SQL Server Express 2014, and I currenly have a (probably) very stupid problem with Windows Authentication. I have a AD server, a MS-SQL server and a Client, where everything was installed ...
1
vote
1answer
271 views

Windows Server slow shared folder access

We have a Windows Small Business Server 2011 which acts as an Active Directory, DNS, Exchange and File server. (Update: and SQL server as well) More than 2 times a day the server becomes slow to ...
0
votes
1answer
2k views

Connecting to MSSQL db (PDO, FreeTDS, ODBC)

I have an Ubuntu 12.04 server and I'm trying to establish a connection to a MSSQL database. I've managed to connect using tsql and isql, but osql doesn't work and connecting with PHP using PDO also ...
1
vote
3answers
149 views

Do SQL backups run faster if you set the databases to read only first?

I have to do a backup of all databases back to back (3.25 GB of data for all .BAK files combined). Will it go faster if I configure the script to set the database to read only first before backing it ...
0
votes
1answer
18 views

sql server 2008 cant insertproduct key

I am trying to install SQL Server 2008 in a Windows Server 2008, but when i have to enter the product key, all option are blocked, and I can´t put the key or select a evaluation version.
0
votes
0answers
52 views

SQL Server 2014 SSIS job fails

I have an SSIS project that runs perfectly when I run it right off of the Microsoft Visual Studio editor. I need it to be a job in SQL SERVER 2014. I have created a proxy for it so that the same ...
0
votes
0answers
29 views

MSSQL Server 2008 - Allow One Outside IP with Windows Firewall

We have a MSSQL Server that has localhost connections, but need to have one connection to another machine. The other machine needs to login to MSSQL server. We added an Inbound Windows Firewall rule ...
0
votes
0answers
433 views

How to export SQLCMD output to Excel

I am using SQLCMD command in powershell to run SQL scripts. When i pipe the output to TXT ,the formatting is all messed up. i want to export the results to excel file. how can i do that. My command ...
1
vote
0answers
46 views

SQL Server Windows authentication - username not changed

I've recently changed my PC name and Windows user account as well. Before: OLDPCNAME\oldusername After: NEWPCNAME\newusername When I log in to my SQL Server management studio using Windows ...
0
votes
0answers
88 views

What format does commvault restore to for SQL server backups?

I have a pretty challenging task that I need to figure out. I have 6TB of data in New Hampshire that I need to move to Texas. It is all SQL Server data. The data is backed up to tape via Commvault as ...
0
votes
0answers
14 views

Sql Server recovery

We installed a POS system onto a pc which we used for an expo. Before we could create a backup and print the reports we had a SQL server connection error and had to re-set up the database. Is there ...
0
votes
0answers
40 views

SQL Activity monitor doesn't show information

i am using SQL Server 2014 Management studio, it seems there is some problem with my activity monitor when connecting to the local SQL server. I am not able to see any information in that [User SA]. I ...
2
votes
1answer
77 views

Manage SQL Agent Jobs On Multiple Servers

Is there a way to deploy/modify/remove//manage SQL Agent Jobs across multiple servers within a domain without third-party software?
0
votes
1answer
111 views

Can I use SQL Server Enterprise Edition on VM Azure for production use

I have Microsoft BizSpark subscription in which I received Azure credits as well. I created a Virtual machine on it and I am planning to install SQL Server Enterprise edition which I see available ...
1
vote
1answer
685 views

install sql server driver on ubuntu

I want to connect to sql server database which is placed on a remote server while my php code has been installed on an ubuntu server. I found that it needs to install sqlsrv driver or mssql driver ...
-5
votes
2answers
129 views

Create a domain on server to have all users on it + shared SQL Server 2012 [closed]

I'm new to Active Directory Domain Services and to Windows Servers in general. I created a domain on Windows Server 2008 R2 using AD DS and I joined all company's PCs to this domain. Now what I want ...
0
votes
0answers
261 views

SQL Server 2012 Microsoft-Windows-Perflib Error Message Event Code 1010

I am seeing the below error message occur every 15 minutes on a Hyper-V guest running Server 2012 R2 with SQL Server 2012 with SP2 (DB, SSIS, SSRS). I am wondering how to diagnose what this error ...
1
vote
0answers
36 views

Installing SSDT on Windows Server 2008 R2 SP1

I'm trying to install SQL Server Data Tools on a Windows Server 2008 R2 SP1 machine. I'm getting the following error: I've tried using both the .exe file and the ISO. I'm getting my files from ...
0
votes
0answers
113 views

Cannot add NT Authority login into SQL Server

I installed SQL Server 2014 on a Windows 2012 R2 instance. I named the instance SQLExpress. After installing SQL Server, I joined this machine to an Active Directory domain and logged in using the ...
0
votes
1answer
355 views

Importing bacpac file with 25000 tables on SQL Server fails with timeout

I'd like to import a bacpac file that was exported from an 500MB DB that however has around 25000 tables. The bacpac itself is around 18MB. Importing through the UI of SQL Server Management Studio ...
1
vote
0answers
98 views

Is it safe to back up SQL Server data directly if using VSS?

I have a client with a very basic single server setup that includes a small SQL Server Express database. I recently configured Symantec Backup Exec 2010 Quickstart edition for them. This is the ...
0
votes
1answer
108 views

How to record/log query execution stats for long running SQL Queries?

I work on a system that comprises of a SQL Server 2012 DB server that is queried frequently with complex queries. Sometimes these queries take more than 2 or 3 mins to return. How can I record or ...
0
votes
1answer
635 views

Bring back to restoring state an online database

I configured logshinging for a database. I did some tests and tried a controlled failover. During log shipping secondary db is in restoring state. To have a controlled failover i stopped the primary ...
0
votes
2answers
38 views

Restarting sql servers

Ok I am our only IT guy here and all this was set up by the previous guy. I know pretty much nothing about databases. We have some software called E2 that keeps track of all our inventory. We also ...
0
votes
1answer
101 views

MSDE 2000 database size limit workaround

We have an application that came with MSDE 2000 version (yeah, quite a while ago) that is no longer supported, but we have not replaced it with something else. It works for us just fine, and ...
2
votes
2answers
32 views

SQL Server 2005 repair

I have a SQL Server (on Windows XP) where I have published reports using Report Manager and a bunch of databases. Within the SQL Server, I have jobs scheduled to run updates on tables, etc. I came ...
0
votes
0answers
396 views

Running SQL Server under “NT Service\MSSQLServer” caused “Object or Property not found”

I have a server called "server.domain.com" which was a Windows Server 2008 R2 domain controller This server also ran SQL Server 2008 R2 I renamed the domain controller (using the instructions on ...