New answers tagged

0

You can use the first option "Not be made with" a login mapping like below: Here's the result with the mapped login: And here's what happens with another account


0

You may be missing an important part of the puzzle or at least I didn't see it anywhere in your post... ApplicationIntent=readonly is one half of the equation... You also need to pass the parameter MultiSubnetFailover=True. For instance, in the Additional Connection Parameters tab, you want to enter the following... ...


0

Problem could also be the encryption key...If you are using IAM for security and have correctly configured your security groups, each user will have an encryption key 'certificate' that needs to be downloaded to the connecting client! Had something similar beat me up for the better part of a few hours when setting up our SQL Server RDS instance... Doh!


2

Sounds like the connection is successful but SSMS is having trouble loading metadata to populate Object Explorer. I would try opening SSMS without connecting to this server, open an empty query window, disable IntelliSense, and then change that query window's connection. Also your copy of SSMS is quite old, I would strongly consider applying SP3 + CU1 to ...


3

Unless your database is in single user mode multiple users can connect to it. The default is MULTI-USER which is exactly what it sounds like. Multiple people can connect as long as they have permission. Another possibility is that your instance is in single user mode. If this is the case only one connection can be made to the instance at a time. And ...


1

Here is a very nice script by Pavel Pawlowski to do the job: http://www.pawlowski.cz/2011/03/cloning-user-rights-database/ Main advantage: script/copy Role Memberships script/copy Object Level Permissions script/copy Database Level Permissions I'm NOT the author of this script. The script is copy-pasted from this link on Pavel Pawlowski blog, see the ...


0

@J.P Masangcay, I have gone through your Error log and find out two things which is as follows : 1) Error: 17204 2) OS error: 5(Access is denied) I would like to say that as @ypercubeᵀᴹ already comments it's related to os like OS permission issue. So, as per above errors definitely we can say that it's Windows Service Accounts based errors. The SQL ...


1

Microsoft have update the way that we do this now They do not have Deploy Database to Windows Azure any more You now back up the file and then import the backup on to the azure box I tried multiple version of SSMS and not in them any more. Was last in SSMS 2014, where you need SP1 to get the new azure dbd type as WEB etc was retired. Ref this person same ...


3

The errors have nothing to do with the fact that the database is restored (in fact they aren't even errors, just intellisense being flaky). As you can see in the dropdown top left and the status bar (in yellow) you are executing your query against the master database. Either change your database in the dropdown or execute a USE mydatabasename;. As noted ...


2

No, I don't believe there is any way to manipulate the IntelliSense dictionary. And you'll notice other T-SQL keywords are missing from the list, too: SELECT DELETE INSERT FROM GROUP ORDER JOIN WHERE HAVING UPDATE is there, but only because it is overloaded (a function you can use inside a trigger to see if a specific column was updated). Further, I'd ...


0

If using excel to get the data , you can always depend on external data link function. Create new excel 2013 and click data ribbon. Click "from other sources", click "sql server" After that follow the wizard. It is better that you create a specific view to pump the data to excel as the wizard only recognize table and view. If you want to distribute the ...


2

This restriction of 'instant file initialization' (aka. SetFileValidData) is documented: Note The file cannot be a network file, or be compressed, sparse, or transacted.


1

Its a blunder to restore a BIG database on SQL Server with no instant file initialization enabled. The amount of time taken to restore with no IFI is MUCH larger than amount of time taken to restore with IFI enabled. When IFI is enabled what it does is this permission keeps SQL Server from "zeroing out" new space when you create or expand a data file. This ...


0

Was Visual Studio installed on the laptop before installing SQL Server Management Studio 2012? Do you have another windows account on the laptop? Try logging in with the second account and starting SSMS or using 'Run As'. If it does start there may be something wrong with setting in your original windows profile.


1

Not sure if others are running into this issue still, was surprised to run in to the issue as the setup at works was essentially a clean install. Normally if/when there are errors like this it is more often older installs where you have installed multiple versions of SSMS and VS, and all associated Service and Security Patches... Okay, long story ...



Top 50 recent answers are included