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)

1
vote
0answers
93 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
49 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
81 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
25 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
91 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
12 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
60 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
210 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
75 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
268 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
144 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
412 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
82 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
37 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
76 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
103 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
602 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
235 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
21 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
107 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
322 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
89 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
101 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
543 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
37 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
95 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
378 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 ...
0
votes
2answers
120 views

SQL 2012 Availability Group Doesn't Failover When Shutting Down Service

I am having an issue with SQL 2012 Availability Groups where it does not fail over when shutting down the service. When you shut down the service you will get an error: A network-related or ...
0
votes
1answer
118 views

SQL Server 2012 AlwaysOn Availability Groups Server Logins Fails When Switching Between Nodes

I am setting up a 3 node cluster as part of an availability group. Initially I tested failover between nodes using SQL Management Studio and everything failed over successfully when I stopped a node, ...
0
votes
0answers
124 views

What does the sqldumper_errorlog file contain?

The SQL Server error logs are continually showing (along with many more messages) BEGIN STACK DUMP. * User initiated stack dump. This is not a server exception dump. Followed by External dump process ...
-1
votes
1answer
170 views

Why are server authentication mode options are greyed out in Sql server 2005

I tried to search for the solution but couldn't find any. Please help me understand why the server authentication mode options are greyed out in Sql server 2005. I want to allow SQL Server login mode ...
0
votes
0answers
50 views

MSSQL - Can Maintenance Plan wait for Agent Job Task to be completed?

I did start a Maintenance Plan project with Execute SQL Server Agent Job Task box. I added another task on success event. I realized that I was wrong. The second task is executed in parallel, because ...
-3
votes
1answer
28 views

System databases are in standby…how can I make them editable?

My System Databases are stuck in a standby/read-only state. RESTORE DATABASE msdb WITH RECOVERY does not seem to have had any affect. How can I get them out of the standby state?
-1
votes
2answers
64 views

Database sql server Mirroring or replication

I have SQL server 2008 R1 with standard edition. I have a large database i.e. 500GB that i.e. growing rapidly 10GB a month .It is a cloud based solution. We have another data center where the ...
0
votes
0answers
118 views

SQL 2012 AlwaysOn Availability Groups Failover Successfully But Application Complains About Login Failed for User

I am trying to get SQL 2012 AlwaysOn Availability Groups working for an application. The cluster has 2 SQL nodes and 1 witness server. Everything appears to be failing over successfully when I do ...
0
votes
1answer
68 views

SQL Server 2014 Backups not inheriting NTFS permissions

I am running a script I run on all my SQL servers however on this specific server I have run into the problem where the script fails to make a copy of the DB backups in an external location because ...
0
votes
0answers
263 views

Repairing corrupt MS SQL master database - no SQL client access

Apologies for any duplication but I feel like I'm falling at the first hurdle. I have a MS SQL 2005 Server which is refusing to start and for which I don't have a password (including the 'sa' ...
1
vote
1answer
264 views

Import IIS Advanced Logs into SQL

I'm using IIS 8.5 Advanced Logging and also logging some custom HTTP headers. How can I import the raw logs into SQL on a regular basis (i.e. every minute)? I want to avoid the overhead of ODBC ...
0
votes
2answers
1k views

Copy DB table across 2 different MSSQL servers

I have 2 MSSQL servers running, with more or less the same data set. It is really a production/development setup. Now, my workflow is like this. Every day backups are made of each one of the ...