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 -...
- 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 ...
- 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 ...
- 141k
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 ...
- 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 ...
- 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 ...
- 18.5k
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 ...
- 18.5k
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-...
- 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 ...
- 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, ...
- 18.5k
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 ...
- 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 ...
- 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 ...
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 ...
- 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....
- 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 ...
- 31
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
- 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 ...
- 18.5k
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 ...
- 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-...
- 18.5k
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 ...
- 1,421
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 ...
- 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 ...
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 ...
- 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
- 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-...
- 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 = ...
- 1,038
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 ...
- 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 ...
- 50.8k
Only top scored, non community-wiki answers of a minimum length are eligible