Thursday, March 14, 2013

[SQL Server] What is a User without a login that cannot login but can be granted permissions used for?

[SQL Server] What is a User without a login that cannot login but can be granted permissions used for?

What is a User without a login that cannot login but can be granted permissions used for?

Posted: 14 Mar 2013 01:04 PM PDT

I presume Integrated Security is required since there is no login in a connection string as I understand this type of SQL login but what is it generally used for and what kind of permissions are then generally granted?Would this type of login for example be typical for creating a User that gets logged in by Integrated Security but must only be granted permissions to create and edit data in a table but not be allowed to delete any data?

Do Users based on logins in master have access to other databases?

Posted: 14 Mar 2013 12:58 PM PDT

When I create a user and select master as the default database does that mean or imply that user can login to other databases on the same instance of SQLExpress 2012? If so how is a user created that can only login to a specific database? I understand a User can be mapped to a specific database but in certain circumstances the User must be created manually --before the database-- because the database the User is logging into is being generated by a sql script generated by a tool; Visual Studio LightSwitch 2012 to be specific.Lots of generation going on except in my brain. lol

union two tables with different columns.

Posted: 14 Mar 2013 07:24 AM PDT

I have one current table and one history table. current table has three additional columns. Is it possible to join these two tables using union statement. I can not add columns to the history table. How to do it?

DBMail fails to send email to Group Account

Posted: 14 Mar 2013 03:57 AM PDT

We've installed database mail for two SQL Server 2008 instances. We have job notifications failures and database alerts going out to a group email account. Installation is fine.We now installed database mail on a few more 2008 instances - test emails will not send the same group account. Individual accounts test fine. I tried stopping and starting dbmail - no difference. What am I missing?When I test send to the group account via outlook - there are no issues. The groupaccount is not the issue.Mail Log: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2013-03-14T11:04:21). Exception Message: Cannot send mails to mail server. (A recipient must be specified.).)It almost sounds that DBMail install failed except that it will send to indiviual user emails. Does the group account need permission for each SQL Server instance?Any comments / URLs would be appreciated...thanks.

SQL 2K8 Installation quest

Posted: 14 Mar 2013 12:58 AM PDT

Hello Team,We have created some new sql server, and have installed evalution version (SQL 2K8 Enterprise Evalution), we did created many DB on that and have also installed sharepoint too, now everything is working fine and we get green signal from our management to have this systems on production. Now we have licence version of Enterprise as well as Standard version licence on some machine. MMy doubt are as below :1. Could we install SQL 2K8 STD on SQL 2K8 Enterprise version, vice versa ? If yes, is it going to affect my current settings and databases ?2. Is it possible, without reinstalling we can input product key on evalution version to make it licence version ?Thanks in advance,Jitendra

powershelling against cms - problems in test

Posted: 14 Mar 2013 12:28 AM PDT

Hi All - I'm a new DBA. Trying to create a sql job that evaluates policies against our cms. I have it working locally going against our test cms. When I move the job up to a test server, the first step of the job bombs on the first line of the powershell script:--Error MessageThe corresponding line is 'import-module sqlps -DisableNameChecking'. Correct the script and reschedule the job. The error information returned by PowerShell is: 'The term 'import-module' is not recognized as the name of a cmdlet, function, script file, or operable program.--I am using a proxy for this step and I have researched it trying several different solutions. Any suggestions or hints on how to get sqlps imported successfully within a powershell job step? I cannot run scripts from steps, so that is out.Thanks in advance.
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog