I am getting the below error while installing SQL Server, when I've selected the domain account for SQL server engine startup account and press next.  (11) 2020-02-16 14:58:48 Slp: Sco: Attempting to check if container 'WinNT://DOMAIN' of user account exists (11) 2020-02-16 14:58:48 Slp: Prompting user if they want to retry this action due to the following failure: (11) 2020-02-16 14:58:48 Slp: ---------------------------------------- (11) 2020-02-16 14:58:48 Slp: The following is an exception stack listing the exceptions in outermost to innermost order (11) 2020-02-16 14:58:48 Slp: Inner exceptions are being indented (11) 2020-02-16 14:58:48 Slp:  (11) 2020-02-16 14:58:48 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException (11) 2020-02-16 14:58:48 Slp:     Message:  (11) 2020-02-16 14:58:48 Slp:         Access is denied. (11) 2020-02-16 14:58:48 Slp:          (11) 2020-02-16 14:58:48 Slp:     HResult : 0x84bb0001 (11) 2020-02-16 14:58:48 Slp:         FacilityCode : 1211 (4bb) (11) 2020-02-16 14:58:48 Slp:         ErrorCode : 1 (0001) (11) 2020-02-16 14:58:48 Slp:     Data:  (11) 2020-02-16 14:58:48 Slp:       WatsonData = Domain (11) 2020-02-16 14:58:48 Slp:       DisableRetry = true (11) 2020-02-16 14:58:48 Slp:     Inner exception type: System.UnauthorizedAccessException (11) 2020-02-16 14:58:48 Slp:         Message:  (11) 2020-02-16 14:58:48 Slp:                 Access is denied. (11) 2020-02-16 14:58:48 Slp:                  (11) 2020-02-16 14:58:48 Slp:         HResult : 0x80070005 (11) 2020-02-16 14:58:48 Slp:         Stack:  (11) 2020-02-16 14:58:48 Slp:                 at System.DirectoryServices.Interop.UnsafeNativeMethods.IAdsContainer.GetObject(String className, String relativeName) (11) 2020-02-16 14:58:48 Slp:                 at System.DirectoryServices.DirectoryEntries.Find(String name, String schemaClassName) (11) 2020-02-16 14:58:48 Slp:                 at Microsoft.SqlServer.Configuration.Sco.User.LookupADEntry()   I am installing SQL server 2016 STD version on Windows Server 2016 OS which is joined to a Domain controller.  Note:  I can install by selecting Local System as the startup account. later I can change through the configuration manager.  I can't do this workaround for Cluster installation.  Anybody faced this issue?
123264
I have a SQL Server 2008 instance which I want to use to import data from an Oracle server.  I have set up a linked server that works correctly when running simple queries like SELECT * FROM table. However, if I declare a variable or loop through the rows in a table or anything else inside the OPENQUERY, I get errors.  Is it possible to do this using OPENQUERY? Do I need additional permissions?
30932
I installed Drush for the first time (so it may be a configuration error) and I'm trying to update to the latest core version of Drupal.  Drush is giving me this error - I'm on an OSX box.  dev5:clientnamedirectory my.name$ drush pm-update projects drupal-7.25 &lt;h1&gt;Additional uncaught exception thrown while handling exception.&lt;/h1&gt;  &lt;h2&gt;Original&lt;/h2&gt;&lt;p&gt;PDOException: SQLSTATE[HY000] [2002] No such file or directory in drupal_get_installed_schema_version() (line 155 of /Users/my.name/Sites/proface/includes/install.inc).&lt;/p&gt;  &lt;h2&gt;Additional&lt;/h2&gt;  &lt;p&gt;PDOException: SQLSTATE[HY000] [2002] No such file or directory in system_list() (line 165 of /Users/my.name/Sites/clientnamedirectory/includes/module.inc).&lt;/p&gt;&lt;hr /&gt;  Drush command terminated abnormally due to an unrecoverable error.
60275
What are best practices/important steps when the Windows Server machine hosting SQL Server 2008 R2 is moved to another domain?   What steps definitely/might need to be done for SQL Server before and after the new domain is joined?
68046
Following the instruction  I get:  pkexec visudo  ==== AUTHENTICATING FOR org.freedesktop.policykit.exec === Authentication is needed to run `/usr/sbin/visudo' as the super user Authenticating as: Thomas,,, (tuc) Password:  polkit-agent-helper-1: error response to PolicyKit daemon: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: No session for cookie ==== AUTHENTICATION FAILED ===  Error executing command as another user: Not authorized  This incident has been reported.   I am doing this via ssh since the box I am doing this on is used as a music server with no screen and is rather inaccessible. This happened when I upgraded from Ubuntu 14.04 to 16.04. I tried to copy a sudoers file from another recent 16.04 installation, but I can't do that because of the sudoers file:  sudo mv ~/gyrf sudoers  &gt;&gt; /etc/sudoers: syntax error near line 36 &lt;&lt;&lt; &gt;&gt; /etc/sudoers: syntax error near line 37 &lt;&lt;&lt; &gt;&gt; /etc/sudoers: syntax error near line 38 &lt;&lt;&lt; &gt;&gt; /etc/sudoers: syntax error near line 39 &lt;&lt;&lt; &gt;&gt; /etc/sudoers: syntax error near line 40 &lt;&lt;&lt; &gt;&gt; /etc/sudoers: syntax error near line 41 &lt;&lt;&lt; &gt;&gt; /etc/sudoers: syntax error near line 42 &lt;&lt;&lt; &gt;&gt; /etc/sudoers: syntax error near line 43 &lt;&lt;&lt; &gt;&gt; /etc/sudoers: syntax error near line 44 &lt;&lt;&lt; &gt;&gt; /etc/sudoers: syntax error near line 45 &lt;&lt;&lt; &gt;&gt; /etc/sudoers: syntax error near line 46 &lt;&lt;&lt; &gt;&gt; /etc/sudoers: syntax error near line 47 &lt;&lt;&lt; &gt;&gt; /etc/sudoers: syntax error near line 48 &lt;&lt;&lt; &gt;&gt; /etc/sudoers: syntax error near line 49 &lt;&lt;&lt;  sudo: parse error in /etc/sudoers near line 36     sudo: no valid sudoers sources found, quitting sudo: unable to initialize policy plugin   Should I go get the box from the attic and try pkexec visudo or is something else wrong here?
45978
SQL Server database is in suspect mode after an upgrade from developer to standard edition 2012 version. In the log file there are two errors: 933 and error 905. Following error occurred when we tried to get the database back online.     Msg 5069, Level 16, State 1, Line 1 ALTER DATABASE statement failed. Msg 905, Level 21, State 1, Line 1 Database 'VTSDB' cannot be started in this edition of SQL Server because it contains a partition function 'FNprocessedrawdata'. Only Enterprise edition of SQL Server supports partitioning. Msg 933, Level 21, State 1, Line 1 Database 'VTSDB' cannot be started because some of the database functionality is not available in the current edition of SQL Server.
119085
I get we have two options while connecting to remote SQL Servers or other domains with Windows authentication:   runas /netonly method   adding windows credentials     But doesn't Windows authentication mean that the user who logged in to Windows has authentication to use SQL Server?   So since I am not an authorized login or user in remote servers, I mean I am not a Windows user on their machine, how could I connect to their servers?   So everyone who knows my domain name and instance name can connect to my machine.   What about security? Do we have to add other Windows users or machines to connect to our SQL Server?  I believe we must add other machines to our domain or we must add other domains as trusted to our domain.  Please help; what is the point I missed?
33474
Running: SQL Server 2012, Windows Server 2008 R2  I want to test a backup by restoring onto an isolated server. The backup was taken from an Availability Group (HADR) configuration, but the target server does not have the clustering/HADR configuration and I don't want to have to set that up.  When I try to perform the restore, this following is returned:  Could not process the operation. AlwaysOn Availability Groups replica manager is disabled on this instance of SQL Server. Enable AlwaysOn Availability Groups, by using the SQL Server Configuration Manager. Then, restart the SQL Server service, and retry the currently operation. For information about how to enable and disable AlwaysOn Availability Groups, see SQL Server Books Online.   The message makes sense and I understand it, but have no way to take it out of an AG that doesn't exist on my target, and can't exist due to no cluster, etc.   Is there a way to make this scenario work?
64609
I have taken three fields from case object called AccountName, IntegrationTo__c and SfType__c (checkbox).  I have created one case record with a specific combination of three fields.  For the second time I create a record with that combination, then  display error message only if SfType__c is true in first record otherwise allow  for record creation.  trigger AvoidDuplicate on Case(before insert)  {          set&lt;string&gt; newNameSet = new set&lt;string&gt;();     newNameSet = new set&lt;string&gt;();      set&lt;string&gt; newEmailSet = new set&lt;string&gt;();      set&lt;string&gt; dbNameSet = new set&lt;string&gt;();      set&lt;string&gt; dbEmailSet = new set&lt;string&gt;();      for(Case newLead : trigger.new){          newNameSet.add(newLead.Account.Name);          newEmailSet.add(newLead.IntegrationTo__c);      }      for(Case dbLead : [select id, Case.Account.Name, IntegrationTo__c from Case where IntegrationTo__c IN: newEmailSet OR Case.Account.Name IN: newNameSet]){          dbNameSet.add(dbLead.Account.Name);          dbEmailSet.add(dbLead.IntegrationTo__c);      }      for(Case newLead : trigger.new){          if(dbNameSet.contains(newLead.Account.Name) &amp;&amp; dbEmailSet.Contains(newLead.IntegrationTo__c))              newLead.addError('You are inserting Duplicate Case');      }  }   i wrote this this not checking the account field name and integration__c values only with combination of account and integration__c shows error
43016
We have a SQL Server 2008 ENT 64bit SP3 server running Server 2008 R2 Standard SP1 64-bit.  This is also a windows/sql clustered environment.  There is the cluster alias for the server, and then we have 2 AD DNS aliases as well for the server  Suddenly I can't connect to the sql instance in Management Studio, or with a Powershell Invoke-SQLcmd IF I am doing it from that actual server, when using one of the dns alias names, or "localhost".  If I use the Cluster alias name it works and if I use the other dns alias name it works.  Using management studio with the non-working dns alias I get "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."  If I use localhost, I get "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)"    Shared Memory and TCPIP are enabled in SQL Server Config manager but named pipes is not.  But we've NEVER had named pipes enabled, and don't have it enabled on any of our other sql servers and they're set up the same (clustering, dns aliases...etc) and are having no issues.  I've Googled around and had a view people suggest listing what other SQL servers it can see (cmd prompt sqlcmd -L)  If it do it from a good server I see all other servers on my network including the "bad" one.  If I do that command from the "bad" server, I get no results at all.  Pretty much checked everything from this blog and it's all ok except the sqlcmd -L issue I just mentioned above.    Windows firewall is not enabled.  This was working just fine for a couple of years.  I'm not sure when this started happening, but I know that at some point, it was not happening.  And the other kicker...it's only happening locally to this server.  If I connect with management studio or run a powershell Invoke-Sqlcmd from another machine, or my local machine connecting to the "bad" server, it works fine no matter what alias I use.  I'm stumped.  I think it sounds like an issue with the AD alias (there are 2 ad aliases, 1 works locally the other doesn't)...but not being able to connect with localhost makes me question that.  any help is greatly appreciated.
74117
I am using SQL Server 2014. I want to execute EXEC (@remotecmd) AT [server_name]; (@remotecmd is a dynamic sql not a stored procedure) into ##eapb. My code is  insert into ##eapb EXEC (@remotecmd) AT [ADSQLDB3S\DEV];   But I get the error:     OLE DB provider "SQLNCLI11" for linked server "server_name" returned message "The transaction manager has disabled its support for remote/network transactions.".   &nbsp; &nbsp; Msg 7391, Level 16, State 2, Line 71   &nbsp; &nbsp; The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "server_name" was unable to begin a distributed transaction.   If I remove the insert into ##eapb, I have no error.  The Linked Server has the RPC Out option set to True.
109419
I have a Windows Service that makes use of a SQL Server database.  I don't have control over the installation of the service, but would like to add a dependency on the service to ensure that it starts after SQL server has started.  (SQL server is running on the same machine as the service in question)  Is there a tool to add a dependency or possibly editing the registry directly?
10196
Recently I have developed software using SQL Server 2012. Now when I try to connect, I get this error message:     Cannot connect to AAFI\SQLEXPRESSA network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)
112270
When attempting to connect to a SQL Server 2008 Instance using Management Studio, I get the following error:     Login failed. The login is from an   untrusted domain and cannot be used   with Windows authentication.   (Microsoft SQL Server, Error: 18452)   I can login using SQL Authentication without problem.  I've been getting this error all of a sudden.  I have Mixed Mode Authentication turned on.    Does anyone have any experience with this?  Additional Info: 64-bit version of SQL Enterprise Edition On Windows 2003 Server
67244
This has happened multiple times now - when I shut off my Aspire 7741G-6426 laptop (running Windows 7 and 8.1) at night, it does Updates and then shuts down.  When I fire it up the next morning, I get this msg:     We couldn't complete the updates. Undoing changes. Don't turn off your computer   Why do the updates keep failing, and why doesn't Windows stop trying to apply the updates in the first place after several failed attempts?  Or are these all different instances of updates? Last night/this morning was the most recent.  So, how can I find out what went wrong with a failed Windows update?  UPDATE  The comment reminded me that I wrote an event log viewer a long time ago. Looking at events within the last day, it gives me:  Type: Warning Source: Microsoft-Windows-ApplicationExperienceInfrastructure Time Generated: 03/20/2015 04:35:50 Message: The application (Microsoft SQL Server (2008 and 2008 R2), from vendor Microsoft) has the following problem: Microsoft SQL Server (2008 and 2008 R2) is not supported on this version of Windows. For more information, contact Microsoft. Machine Name: AcerAndroid User Name: NT AUTHORITY\NETWORK SERVICE  Type: Warning Source: Wlclntfy Time Generated: 03/20/2015 04:36:46 Message: The winlogon notification subscriber &lt;TrustedInstaller&gt; is taking long time to handle the notification event (CreateSession). Machine Name: AcerAndroid  Type: Warning Source: Wlclntfy Time Generated: 03/20/2015 04:38:46 Message: The winlogon notification subscriber &lt;TrustedInstaller&gt; took 180 second(s) to handle the notification event (CreateSession). Machine Name: AcerAndroid  Type: Warning Source: Wlclntfy Time Generated: 03/20/2015 04:38:57 Message: The winlogon notification subscriber &lt;TrustedInstaller&gt; failed a critical notification event. Machine Name: AcerAndroid  Type: Warning Source: Microsoft-Windows-ApplicationExperienceInfrastructure Time Generated: 03/20/2015 04:40:22 Message: The application (Microsoft SQL Server (2008 and 2008 R2), from vendor Microsoft) has the following problem: Microsoft SQL Server (2008 and 2008 R2) is not supported on this version of Windows. For more information, contact Microsoft. Machine Name: AcerAndroid User Name: NT AUTHORITY\NETWORK SERVICE  Type: Warning Source: Wlclntfy Time Generated: 03/20/2015 04:41:21 Message: The winlogon notification subscriber &lt;TrustedInstaller&gt; is taking long time to handle the notification event (CreateSession). Machine Name: AcerAndroid  Type: Warning Source: Wlclntfy Time Generated: 03/20/2015 04:43:06 Message: The winlogon notification subscriber &lt;TrustedInstaller&gt; took 165 second(s) to handle the notification event (CreateSession). Machine Name: AcerAndroid  Type: Warning Source: Microsoft-Windows-ApplicationExperienceInfrastructure Time Generated: 03/20/2015 04:44:37 Message: The application (ATI Catalyst Control Center *, from vendor ATI Technologies Inc) has the following problem: To function properly, ATI Catalyst Control Center * must be reinstalled after you upgrade Windows. Machine Name: AcerAndroid User Name: ACERANDROID\Clay   UPDATE 2  I tried John Ball's suggestion, and got to the "Windows Update History" screen in Windows 8.1, but it was blank. When I went back to Windows 7 mode via Windows key+D, I saw this:    UPDATE 3  The Wolverine's link seemed to have worked. This is what I saw after I ran it:    UPDATE 4  Well, that didn't work, after all: I had the same old problem this morning and starting up my laptop. The link to the zipped contents of C:\Windows\Logs\CBS is
113448
SQL Server 2016 CU2 (Enterprise) here and one of my users has requested that we get R-Services installed.  I followed what appeared to be very simple instructions from this page    When I got to the part about using the simple test  exec sp_execute_external_script  @language =N'R',   @script=N'OutputDataSet&lt;-InputDataSet',     @input_data_1 =N'select 1 as hello'   with result sets (([hello] int not null));   go     it failed with     Msg 39021, Level 16, State 1, Line 6 Unable to launch runtime for 'R'   script. Please check the configuration of the 'R' runtime. Msg 39019,   Level 16, State 1, Line 6 An external script error occurred:  Unable   to launch the runtime. ErrorCode 0x80070057: 87(The parameter is   incorrect.). Msg 11536, Level 16, State 1, Line 6 EXECUTE statement   failed because its WITH RESULT SETS clause specified 1 result set(s),   but the statement only sent 0 result set(s) at run time.   So, I started my internet searching for known problems regarding R-Services and found this article -    I made sure that R-Services had been brought up to date with the Sql Server version (2016, CU2). I read where long file names in the rlauncher.config file might cause problems, so I redirected my WORKING_DIRECTORY to C:\TEMP\R_SERVICES.  However, I left the RHOME and MPI_HOME configuration entries untouched and still using long file names. I made sure the Windows group SQLRUserGroup had full authority to that working directory folder.   After every configuration change, I restarted both SQL Server and SQL Server Launchpad.  However, every time I try to run the sample T-SQL test for R-Services, it fails and I see this entry in the rlauncher.log file     [Error] Session creation failed with: Failed with 2 to get security   for C:\TEMP\R_SERV~1\MSSQLSERVER01   I'm reaching out for help from others that might know what the problem is or any additional troubleshooting links.
37595
SMESERVER install has been working find for an age then this morning "The error that the other server returned was: 550 v=spf1 a -all", can anyone 'point' me in the right direction to resolving this issue.  There is an obvious element of urgency.  From my own mind 550 is access denied and SPF would indicate a DNS problem, am I right?  Still have no idea on how to resolve it though.  also getting a "bash: 22: command not found", when trying to SSH in.  Any guidance GREATLY appreciated  Stu
30067
I installed SQL Server 2005 sometime ago and forgot the administrator password I set during setup. How can I connect to SQL server now?  EDIT: I think I only allowed Sql Server Authentication. Login with integrated security also does not work.