24 votes

Trying to add a new SQL Server user throws the error "is not a valid login or you do not have permission”

Before adding a user one must first create a login. Logins can only be created in the servers Security-folder (not in the databses Security). So the login can be created under <server>/Security -...
user avatar
  • 551
19 votes

What is SQL Server Core Edition?

Sorry to necro here, but just in case someone else hits this page with a similar question, and since there's so little documentation about this... Short: The regular "Enterprise" (non-"core") edition ...
user avatar
  • 191
8 votes
Accepted

Does an SQL Server instance allow both secure and non-secure connections at the same time?

I suspect that this article will help you out: Understanding SSL Support The protocol still uses TCP port 1433, by default, irrespective of SSL being used. The client can request SSL and, if the ...
user avatar
5 votes

What is SQL Server Core Edition?

Not only do they NOT tell you the difference between Enterprise and Enterprise Core. They have continued this practice of misnaming the downloads into SQL Server 2014. It is very easy to make a ...
user avatar
  • 51
5 votes
Accepted

How much memory does my SQL need?

SQL Server will hold on to the RAM it allocates, so since it doesn't seem to go above 6-7 GB, I would allocate 8GB for SQL and keep 2-4 GB extra for the OS in this case (SQL always does some tasks ...
user avatar
  • 17.7k
5 votes
Accepted

Changes to data ordering between SQL Server 2000 and 2012

SQL Server 2012 does not guarantee the order of rows returned in SQL 2012. Neither did 2000, for that matter. (The citation I found for that is actually 2005, but close enough.) Essentially, the ...
user avatar
5 votes
Accepted

SQL 2012 Transaction Log backup does not truncate the logs

Your transaction log backup is truncating the logs in the sense that it's making room in the existing log file for more transactions. If you want to shrink the log file, you need to choose the "shrink ...
user avatar
4 votes
Accepted

Azure network latency between VM and Cloud Service

Since you're using a web role, I would assume that it is connected to your VNet by means of using a VPN gateway and a Point-to-Site tunnel, as stated here: https://azure.microsoft.com/en-us/blog/azure-...
user avatar
  • 3,789
4 votes

How do I move an entire SQL instance for SQL Server 2012 to a different server?

SQL DBA here. I think you are misunderstanding how sp_help_revlogin works: http://support.microsoft.com/kb/918992 It is a set of scripts you run on the source server, the output will be a big long ...
user avatar
  • 2,200
3 votes

prevent replace sql database files with old one

If I understand your question, it sounds like you're looking for something like Transparent Data Encryption, in hopes of preventing a user detaching the database, attaching it to their own server, ...
user avatar
3 votes

PowerShell 'get-ClusterQuorum' output is not showing 'QuorumType' column

Copying my answer from your StackOverflow question: That is just the normal output for that cmdlet. To see QuorumType, you can use these methods: $quorum = Get-ClusterQuorum -Cluster CLUSTER $quorum ...
user avatar
  • 2,535
3 votes

SQL Server Debugging: "Unable to Step. Invalid operation"

I had the same problem. After some research I found this page which suggests that this is caused by a race condition. Although the workaround given there wasn't applicable for me, after stopping every ...
user avatar
  • 131
3 votes
Accepted

deploy ssis 2012 packages on 2008r2 server

You cannot run SSIS package on a release that is below the developed level of the package, so it is not possible to deploy from SQL Server 2012 to SQL Server 2008 since SSIS packages are not backwards ...
user avatar
3 votes

Automatic failover in SQL server alwayson availability group

If the failover is not happening, the first thing to check is whether AlwaysOn is really enabled. Perhaps the simplest way to test this is by looking in SQL Management Studio at the AlwaysOn ...
user avatar
  • 45
3 votes

What is SQL Server Core Edition?

The answer provided by Cmosq seems more valid i.e. Core-Based Licensing and Server/CAL Licensing This link provides some more info about the licensing related to major editions: http://www....
user avatar
  • 131
3 votes

destination directory for SQL Server 2012 is greyed out

This is poor design limitation, and it is still the case for SQL Server 2014. The SQL Server installer should be able to move everything! However, you can work around it by creating folders where you ...
user avatar
3 votes

How do I install SQL Svr Native Client 10.1 after SQL 2012 has been installed

this is the link to SQL Native Client 10.0 (2008 R2) x64 http://go.microsoft.com/fwlink/?LinkID=188401&clcid=0x409
user avatar
  • 31
3 votes

In MS SQL 2012 Database how to insert a very large table data in chunks

How to do it the way you're asking: Create your second table, exactly like the first. Find a column--something date-based, perhaps?--and use this to copy reasonable quantities of data into the ...
user avatar
3 votes

ADSI Linked Server: Why can I query AD in VBA, but not as a Linked Server?

This may happen if you use "Be made without using security context" option in the Security settings page of the Linked server. This results in making an anonymous LDAP call. These days (Server 2008 or ...
user avatar
  • 622
3 votes
Accepted

Manage SQL Agent Jobs On Multiple Servers

Yes. Go to View -> Registered Servers. Go into Database Engine -> Local Server Groups and create a new server group. Add all the servers you want to that group. Highlight the group, then right-...
user avatar
3 votes
Accepted

Unattended installation of MS SQL Server (2008|2012) EXPRESS?

Wrong Installer? I think this is going to come down to the wrong installer. I downloaded the SQL Server 2012 Express Advanced Edition installer from the link you mention and was able to follow your ...
user avatar
2 votes

SQL 2012 server alias works locally but not remotely

TO avoid having to install the ALIAS on every client machine you can created a computer object in Active Directory and assign it the IP address of the server where SQL is installed. Then go to the ...
user avatar
  • 21
2 votes

Getting "error: 26 - Error Locating Server/Instance Specified" all of a sudden

Ensure that the SQL Server Browser service is set to automatic and Running. If this isn't running, then outside sources can't view the client information. Once that is running, Open sQL Server ...
user avatar
2 votes

AWS RDS (SQL Server): SSL Connection - The target principal name is incorrect

Originally we were using the short name which seemed to work for awhile. However, for some reason later it stopped working throwing this error message. When we changed it to the FQDN it seemed to ...
user avatar
  • 21
2 votes
Accepted

Can SQL server 2012 Service Pack 2 be applied to an Express Edition instance?

Yes. SQL Service packs cover all editions, including express editions
user avatar
  • 11k
2 votes

Add an Excel file as a linked server in SQL 2012

It could be that you are running the 64-bit edition of SQL Server but only have the 32-bit Jet provider installed. If this is the case you will need to remove the 32-bit provider and install the 64-...
user avatar
  • 37.5k
2 votes

Trying to add a new SQL Server user throws the error "is not a valid login or you do not have permission”

If you are trying to create a user under the Contained database user model (so no global login for it), you have to provide a password during creation like this: CREATE USER user_name WITH PASSWORD = ...
user avatar
2 votes
Accepted

Windows Server Failover Clustering with two servers

There is some ambiguity in your question, but the following presumes you are talking about setting up a high-availability MS SQL environment on a Hyper-V failover cluster. You are correct in so far ...
user avatar
  • 2,588
2 votes

Migrate MSSQL 2008R2 to 2012 (new hardware)

Assuming I don't want any new features of 2012 is it as easy as restoring the 2008 databases on the new server? It is - plus setting trace flags for the server to force the old behavior of the ...
user avatar
  • 50.8k

Only top scored, non community-wiki answers of a minimum length are eligible