Tag Info

New answers tagged

0

We ended up solving the issue in our environment by removing Integrated Security, and went with specifying user id and password in the connection string. Never did find the root cause.


4

Actually you shouldn't need to do anything. As long as the computer accounts still exist in AD, the servers should initiate a machine account password change when they boot up. The machine account password change is initiated by the client, not the domain controller. If for some reason you have problems (error messages regarding the trust relationship), you ...


1

Unfortunately there's no BI licensing, but you have some of the BI features in Standard images. SQL Server Business Intelligence in Azure Virtual Machines https://msdn.microsoft.com/library/azure/jj992719.aspx/#bkmk_supported_features There's also a few enterprise images optimized for DataWarehouse and Transactional Workloads.


0

I got around this by cancelling the upgrade. Uninstalling the Reporting Service feature. When i reran the upgrade it didnt have this step.


0

First check and see if the SQL Server User have proper permissions, database mappings. If yes then try the following: Open SQL Management Studio Login in with windows authentication Change SQL server authentication username/password Now Try logging in using the newly changed sql server credentials if this fails repeat the process by signing it first ...


0

I just realized that after taking snapshot, I can use vssadmin to find details about shadow storage This is simpler and easy as we won't have to install anything else. C:\Windows\system32>vssadmin list shadowstorage vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool (C) Copyright 2001-2013 Microsoft Corp. Shadow Copy Storage ...


1

I figured out that we have this cool tool called vssagent. This comes from windows SDK. I installed it and ran vssagent. This generates a xml file which gives all the information needed. In my case it was using C:. However, we can use vssadmin to define where we want to take snapshots and diskshadow would honor that. Pasting below is an excerpt from the ...


1

If it is disabled, go to Control Panel->Administrative Tools->Services, and look for the SQL Server Agent. Right-click, and select "Properties." From the "Startup Type" dropdown, change from "Disabled" to "Automatic".


0

In my personal experience this is usually caused by problems with SPN (server principal name) registration on the SQL Server. Microsoft has a free tool called "Kerberos Configuration Manager" (available for download here) If the tool fails to fix an issue, you may need to register SPN manually. But in some AD configurations the problems could not be fixed ...


0

I would recommend Ola's solution for backup and specifying the number of files like so : DECLARE @DBFiles INT SET @DBFiles = (SELECT total_size_mb = CAST(SUM(size) * 8. / 1024 / 1024 AS DECIMAL(8,2)) FROM sys.master_files WITH(NOWAIT) WHERE database_id = DB_ID() -- for current db GROUP BY database_id )/4 + 1 and then execute Bla's script with the ...


0

If you can't restart the instance, you can schedule a log cleanup with sp_fulltext_recycle_crawl_log. More info: http://www.ruben-j.com/microsoft/t-sql/sql-fulltext-crawl-log/ or https://social.msdn.microsoft.com/Forums/windowsapps/en-US/b9420843-666e-4f33-b987-2624cdfa7acd/sql-server-2008r2-fulltext-logfile-sqlftlog-maintenance?forum=sqlkjmanageability or ...


0

I have the exact same problem and I managed to solve it! This is what I learned. If you have installed a named instance. You cannot change the name to default. You can however: make the named instance listen to the default port. Which help connect from Management Studio without specifying an instance name but doesn't help for ODBC. You can create aliases ...


0

No, it is not: https://support.microsoft.com/en-us/kb/969052/en-us I ran into something similar on a Windows XP machine when deleting Windows Update files, and essentially broke my .NET installation in a way that required a full reinstall to correct. I saw another person on the Microsoft forums who was planning to offload the files to a SAN for day-to-day ...


0

Ok so I don't know the exact issue but here is my work around. Reset the System Password UPDATE DYNAMICS..SY02400 SET PASSWORD = 0x00202020202020202020202020202020 Access the users Create a dummy user and copy the access from the target user delete and recreate the target user and copy access from the dummy user


0

I got this error when I mistakenly exceeded the number of characters that a field could hold. In Visual Studio, I had mistakenly inserted a field with its datatype as nvarchar(1) and was trying to save a word with 6 characters to that field. Once I changed to nvarchar(50), it worked fine. Hope this helps someone.


0

The solution to this issue was a feature called TCP Offloading. I'm not sure if this is because I am running in a virtualised environment or not, but TCP Offloading was causing the packet drops. When this feature is disabled the drop packets do seem to disappear. TCP Offloading removes the burden of processing network I/O on the CPU by offloading it onto ...


1

The script is loosely based on this one in the accepted answer. It has been updated for SQL 2014, with exception handling, atomic transactions, and a few other improvements. -- Script for SQL 2014 DECLARE @JobID UNIQUEIDENTIFIER declare @servername sysname set @servername = @@SERVERNAME SELECT @JobID = job_id FROM msdb_old.dbo.sysjobs WHERE name='My ...


0

Would it work for you to create a user for the login and assign them a read-only role? <!-- language: lang-sql --> CREATE USER hello FOR LOGIN hello GO EXEC sp_addrolemember 'db_datareader', 'hello' They shouldn't be a member of the db_owner role after this, unless it's set somewhere by default to add any new users to the db_owner role. This should ...



Top 50 recent answers are included