Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql-server]

Tag with [sql-server] the question related to each database server that implements SQL (Structured Query Language) and not related with the specific Microsoft one. For the latter use the specific tag [ms-sql], or if related with a specific version with the relative tag [sql-server-2012], [sql-...

-1
votes
0answers
22 views

Can I specify an application that isn't currently installed for a firewall rule?

Essentially, We deploy machines to clients. I want to know if I can pass through a firewall rule for a program that isn't currently installed. At the moment, my preparation script does not work unless ...
0
votes
0answers
9 views

Unable to run WAS Service in WINDOWS SERVER 2012 r2

I have a problem when I try to run websites in IIS, it tells me that the W3SVC service could not be started. I was looking for information and this address me to review the services of the server ...
0
votes
0answers
28 views

How to block sql server port only to don't allow to connect the sql server?

I tried to block SQL server TCP port 1433 in Kaspersky endpoint security 10 for certain range of user's IP. But I cannot block by that port number 1433. If I try to block all Inbounds for that ...
0
votes
0answers
16 views

SQL Compare 13, copy & paste from differences SQL View doesn't copy carriage return/newline?

I'm using SQL Compare 13 to compare a test and production database. Sometimes there are tiny differences and I just copy & paste it from the differences SQL View and run it in the target database. ...
0
votes
0answers
34 views

How access SQL Server “Backup” folder via FTP with IIS

I have on Azure VM an IIS running several websites. I can access those sites files using the FTP server feature of IIS. My problem is I am unable to add a new site to access de "Backup" folder of the ...
0
votes
0answers
25 views

Restore a database in clustered SQL Server instances

I have two Dell boxes and a SQL Server (2014 Enterprise) instance runs on each box. They are clustered through Always On. Now I have a new database on my laptop and I need to restore it into the ...
0
votes
0answers
46 views

How to copy read only database?

I'm using SQL Server 2012. I have a read-only database and I have to create a replica from it and a new database should be read-write I tried to copy but it failed Then someone told me it's because ...
0
votes
0answers
19 views

Create Backwards Compatible SQL Server data connection in Excel 2016

I've recently been upgraded to Excel 2016. However I'm now finding that data connections I create to our SQL Server database cannot be refreshed by users with Excel 2013 - an error occurs. Is this a ...
0
votes
0answers
11 views

Export attached(type) files from MS Access to SQL

I want to export database from MS Access database to SQL server. The problem is that when it comes to attached files than sql doesn't recognize it, because there is no such type of data in SQL. I ...
0
votes
0answers
73 views

Batch Error SQL Server BULK INSERT

I am attempting to have a script in my batch file that runs a SQL Server Stored Procedure. The Stored Procedure bulk inserts data from a .CSV file into a SQL Server table. When I run the Stored ...
0
votes
1answer
77 views

SQL Server 2012 repair/installation fails

We have a Windows 2012 R2 server and want to run MS SQL Server 2012. It seems like someone attempted installation a while back but it is not installed properly since SQL Server does not show under ...
0
votes
0answers
43 views

How to do I make NPS properly create its SQL database?

NPS (Windows Server role) natively supports writing authentication logging events to a SQL database. Running through the wizard is supposed to create the database, the table, and the stored procedure(...
0
votes
0answers
36 views

SSRS Generating Large Log Files, Filling Drive

I've installed SSRS (v14.0.6681.5121) and configured it with my SQL Server 2017 instance. I noticed that my drive was filling up very quickly and tracked it down to this SSRS log as well as a 200MB ....
0
votes
0answers
51 views

What is the correct SQL command to use when “?” doesn't work as a parameter reference to a spread sheet in Excel?

When I changed the hard coded date (highlighted) to ? It returned conversion error message. What is the fix? Appreciate all the helps i can get. SET NOCOUNT ON DECLARE @lastdayofweek DATETIME ...
0
votes
0answers
18 views

All INSERTs done through MS Access old untouched forms now fail after creating new unrelated forms

I'm fairly new to MS Access, and the following issue has me completely stumped. I modified an existing .accdb MS Access project by creating new forms via the Form Creation Wizard that allow you to ...

15 30 50 per page
 Microsoft office activator |  windows activation crack |  windows product key |  windows 10 product key |  windows 7 ultimate product key |  windows 7 keygen |  activate office 2010 |  office Project keys |  project professional product key |  office 365 office 2016 office 2013 key |  office 2016 office 2013 key |  windows 7 professional product key |  windows 8 professional product key |  windows 10 professional product key |  office 2016 professional product key |