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
16 views

Can connect to MSSQL 11 with SQL Auth, but can't connect with the same credentials to “import and export” wizard

I'm connecting to a MSSql 11.0.2100 server named "server" with a user named "user" via SQL auth. When I try the exact same credentials in the "import and export" wizard, the connection fails with: ...
0
votes
1answer
1k views

Connecting to SQL Server with PHP on Mac

I'm trying to connect to my local SQL Server 2008 R2 (have also tried it with 2005, same result exactly) with PHP. I'm using PHP 5.1 which still supports php_mssql and mssql_connect(). for some ...
0
votes
0answers
20 views

Unable to Change SQL Server 2012 Service Account When Using AlwaysOn Availability and TDE Encryption

I am unable to successfully change the service account in SQL Server 2012. Whenever I attempt to change the service account, the service starts up but the databases in the cluster are not ...
0
votes
1answer
34 views

SQL Server 2012 event ID 18487

Good morning guys. We have a SQL 2012 instance we use to store data on the parts we create. We have software that goes and pulls data out of the PLC on the machine and dumps the data into the SQL ...
0
votes
3answers
57 views

Moving SQL 2012 Enterprise license from physical server to Azure VM

We purchased a 4-core license for SQL 2012 Enterprise back in mid-2012, without Software Assurance. At this point we would like to move the license to a VM in Azure but I can't figure out if that's ...
8
votes
3answers
3k views

Automating the rename of a SQL Server

We're in the process of replacing our SQL Server and have decided that renaming the server itself is going to be much easier than changing everything else to point to a new name. We found instructions ...
1
vote
2answers
433 views

Is it possible to store a credential for Windows Authentication to an Analysis Services server?

SQL Server Analysis Services uses Windows authentication for server connections. Typically, you assign your domain account to a role (or the server administrator list), and then connect to the server ...
0
votes
2answers
100 views

SQLServer Configuration - How to refute 1 drive on a SAN is same as multiple physical drives

I inherited a performance investigation problem where a SQLServer 2008( and also 2012 ) database has its Data, Indexes and Log files all on a single drive D: The D: drive is actually part of a SAN. I ...
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 ...
0
votes
1answer
55 views

What carries out SQL Server Mirroring?

I'd like to know what service(s)/process(s) carries out Mirroring in SQL Server. For example, we have various Agents carrying out the different steps for SQL Database Replication. Similarly, what is ...
3
votes
1answer
2k views

How to setup an TCP/IP proxy with traffic interception, for MS SQL traffic in this case

I would like to setup an MS SQL proxy server. It should forward all requests 1:1 and make it possible to log them, and modify some of the requests or answers according to some replacement rules I ...
0
votes
1answer
127 views

Windows server 2012: MSSQL missing .NET 3.5 Framework. Unable to install

The MSSQL installer does not go through - it's missing .NET 3.5 framework to complete. Unfortunately I've been unable to solve this, what I've tried: Manually download and transfer the /sxs ...
0
votes
1answer
267 views

Cannot see linked server properties in SQL Server 2008 R2

I configured a linked server in SQL Server 2008 R2; mirroring what currently exists in SQL Server 2000. When viewing the properties of an existing linked you, you cannot see (or edit) any ...
4
votes
2answers
5k views

How to undo assigning ownership of db_datareader/db_datawriter schema?

i meant to assign an SQL Server login to the db_datareader db_datawriter database roles. But if a moment of sore tummy and tiredness, i accidentally give that user schema ownership of them ...
0
votes
0answers
16 views

How to deploy database and blob storage in sql express 2014

this is my first time deploying my application (ASP.net MVC 5) in local environment and I had a lot of problems doing so. My first problem is deploying the database, I used entity framework which ...
1
vote
2answers
760 views

SQL Server express - Management studio installation hangs at native images installation

I've been trying to install SQL server express edition (2014) with management studio and consistently failing to do so because installation stalls at step 'Install_sql_common_core_Cpu64_Action : ...
4
votes
5answers
1k views

mysqldump for sql server [closed]

I have used mysqldump on a mysql database lots of times and am familiar with how it works. Does anyone know if there is a similar tool that could be used on a sql server database. I know sql server ...
4
votes
6answers
4k views

Is there a Microsoft document on “Why SQL DBA’s need Local Windows Administrator Privilege”?

I'm looking for a Microsoft Document or Article or Whitepaper on What OS level permissions are needed for SQL DBA (not SQL Service Account). There is a general assumption that SQL DBA's need Local ...
0
votes
0answers
9 views

AWS which MS SQL server EC2 type should be used for MS Navision ERP backend database [duplicate]

I am trying to host Microsoft Navision ERP on AWS Cloud, currently it is on local data center. The licensing is based on number of cores with unlimited users. Which type of EC2 instance should be ...
1
vote
1answer
55 views

Using Perfmon to determine which service consuming all CPU

I have written a windows based webserver service which uses Sql Server Express as the back-end database. Every couple days CPU will spike to 100%. Inspection of my webserver logs reveal my service ...
0
votes
3answers
674 views

SQL Server 2005 - Oracle Linked servers stop working

[URGENT - PRODUCTION ISSUE] All of a sudden, on a SQL Server 2005 instance, all the Linked Servers to Oracle stopped working. All other instances can connect to the linked servers without a problem ...
7
votes
4answers
46k views

How to duplicate MSSQL database on the same or another server?

It is perhaps a bit stupid question, but I must admit I have very limited experience with MSSQL and yet has to accomplish this: Take a snapshot of the database and create and exact duplicate on ...
10
votes
2answers
77k views

What is a SQL Server instance?

When I install SQL Server 2008 Express in prompts me to create an instance and aborts if I don't. Then I see that information in an entry in Sql Server Configuration Manager on SQL Server Services. ...
0
votes
1answer
316 views

sqlsrv not showing up in phpinfo.

I'm using Win server 2k12, php 5.5.12, on wamp. Edited php.ini (both on apache dir and php dir) to add php_sqlsrv_55_ts.dll and the php_pdo_sqlsrv_55_ts.dll, and configured the extension dir path ...
5
votes
2answers
4k views

March 10th Patch Tuesday appears to cause SQL Server client connection problems

Since applying the full set of patches on a Win 7.1 Pro desktop and a Windows 2012 R2 Datacenter Azure server running SQL 2014, SQL Management Studio (2008 and 2014 versions) won't connect to the SQL ...
15
votes
8answers
2k views

When is the right time to introduce high availability for web site?

When is the right time to introduce high availability for web site? There are many articles on High Availability options. It’s not that obvious however WHEN is the right time to switch from single ...
0
votes
1answer
3k views

SQL Server replication pending transactions

I'm having a problem with a transactional replication. I have the publisher in my server and there is a subscriber in another server. In my server, if I go to the details of the subscription I can ...
1
vote
0answers
243 views

Cannot connect to sql server by IP Address but using the hostname works

After upgrading to the newest version of windows (windows 10 build 10586) I am no longer able to connect to a remote sql server by ip address. Here is the error I see: [SqlException (0x80131904): ...
2
votes
3answers
2k views

Change SSL Protocol in MSSQL 2012

Is there a way to change the SSL Protocol support in MSSQL express 2012 on windows 2008R2 ? I want to change the protocol from SSL3 to TLS (1.0,1.1,1.2), after hours of looking I cant find ...
7
votes
7answers
15k views

T-SQL Script to copy a database

I would like to find a T-SQL script-based way to copy my "PROD" database (which is read-only and consists of several filegroups) to a read/writable "EDIT" database, which I can use and edit data in. ...
2
votes
1answer
14k views

How do I determine what database WSUS on my Windows Server 2012 is using?

I installed WSUS on a fresh installation of Windows Server 2012 (I assume this is WSUS 4 as it is bundled with Server 2012 with no option to download it anywhere online) I did not install any ...
1
vote
1answer
113 views

SQL Server Connection Issue with New Router But Works With Old Router

I have an issue that really has me stumped. I have a router that is overheating and needs to be upgraded. When I connect the new router and configure it with the same DHCP settings and IP ranges as ...
2
votes
2answers
5k views

SQL Server 2012 and 2014 memory limits

We're in the process of building a new server with 128GB of RAM. We would like to utilise as much of this as possible and my understanding is that 2008, 2008R2 and 2012 (all STANDARD) are all limited ...
1
vote
2answers
47 views

How to connect to sql server to take backup of a database from powershell

I am new to powershell. I got requirement to take the backup of MS sql database backup from the other machine and not within the server. Can you please let me know what possible utilities required to ...
3
votes
1answer
86 views

How to find out who / what is hammering SQL Server TempDB

I am using SQL Server 2012 Enterprise. The server has one availability group configured. There are several databases for different tools on the instance. The tools all belong together and therefore ...
2
votes
3answers
49 views

Regular backup and archival options for a client device that runs MS SQL Express including restores

In the current environment, a client application has been deployed on a single endpoint device e.g. laptop. The client application records & retrieves information that is needed for regulatory and ...
1
vote
2answers
97 views

Google Cloud with SQL Server Express - add database permissions

I've recently setup a google cloud server for the first time and I installed the asp.net framework which is marketed as "Windows dev stack featuring IIS, SQL Express and ASP.NET". I'm familiar with ...
0
votes
1answer
261 views

Cannot execute job in MSSQL Agent

Executed as user: NT SERVICE\SQLSERVERAGENT. Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)". [SQLSTATE 42000] (Error 7303) OLE DB ...
0
votes
0answers
10 views

MySQL 5.5 performance settings [duplicate]

We are using server this theses parameters: 8 cores CPU 18GB RAM MySQL version 5.5 We would like to get the best performance. The DB is InnoDB type. I would like to know your experience and maybe you ...
3
votes
4answers
2k views

What happens to my SQL Server logins if I change a windows domain username

My question is very similar to this question Changing Windows Domain UserName but the original question doesn't explicitly answer my slight variation. If I change a windows users username (if they ...
24
votes
10answers
255k views

How do I get this SQL Server ODBC Connection working?

Note: I've obviously changed the server names and IPs to fictitious ones. Here's what's going on. I've got a server, which I'm calling MYSERVER, running Microsoft SQL Server Express 2005. Right on ...
2
votes
0answers
1k views

SSMS stuck scripting database objects

SQL Server Management Studio sits stuck, after scripting all objects in a database. Except it didn't script all objects in a database. i scripted all the objects in an SQL Server 2008 database from ...
0
votes
1answer
539 views

FIPS 140-2 on Windows 2012R2 with SQL 2014

I'm attempting to set my Microsoft SQL 2014 instance to use FIPS 140-2 complaint encryption as described in this KB article for SQL 2012, but it does not appear to be working. I do not see "FIPS" ...
3
votes
5answers
10k views

Login failed--password of account must be changed--error 18488

I failed to connect to a production SQL server. My administrator reset my password, and told me what it was. SQL Server Management Studio gives me this error: Login failed for user 'Bill'. Reason: ...
0
votes
1answer
28 views

Web application access permission

I have a web application that uses SQL server . SQL server is hosted on a server and accessed using port 1433 . My question is will the user who is accessing my application required to be able to ...
3
votes
3answers
10k views

MS SQL Server 2008 sa account locked out and Windows Authentication login is greyed out

The sa account got locked out and even though mixed mode authentication is enabled. When I select "Windows Authentication" the Username and Password fields are greyed out. The username field contains ...
-1
votes
1answer
70 views

CentOS7 mysqlserver download error

[root@localhost bin]# rpm -qa httpd httpd-2.4.6-31.el7.centos.x86_64 [root@localhost bin]# rpm -qa php php-5.4.16-36.el7_1.x86_64 [root@localhost bin]# rpm -qa mysql [root@localhost bin]# I am a ...
0
votes
0answers
480 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. ...
0
votes
1answer
105 views

Restoring a differential database file “the backup set holds a backup of a database other than the existing”

I am trying to test restoring a SQL database using a full/differential approach to a different server than it was backed up from. The database is in simple recovery mode as it is a test data ...
1
vote
0answers
13 views

SQL Server Table Partitioning & Impact of Raid Levels

How does SQL Server Table partitioning get impacted by the DISK RAID level ? We have a SQL Server with 8 data disks . The main table in the database has over 200 million rows partitioned by day of ...