Viewing 15 posts - 2,431 through 2,445 (of 2,756 total)
2 thoughts - is the data encrypted? If so, did you bring across the decryption keys when you restored the database?
and does the account on the local copy have...
May 23, 2017 at 1:39 pm
If you have the ISO already downloaded, you can grab any zip extraction tool (winrar, winzip, 7zip, etc) and use that to extract the files to a folder and install...
May 23, 2017 at 12:20 pm
As a thought - was the dtsx file originally created in Visual Studio 2015 with the BI development tools for 2016? If not, it may be set to run in...
May 16, 2017 at 11:13 am
Not 100% sure on the back end magic of the maintenance plans, but I have a sneaking suspicion that that checkboxes and radio buttons only applies at the time the...
May 12, 2017 at 4:13 pm
I agree with Sue. It sounds like your connections are buggered up.
I had a similar issue ages back when I was doing upgrades from 2008 R2 to 2012 and...
May 12, 2017 at 8:44 am
Hmmmm.... not sure why that would be then.
Can you run a SQL script to rename the database post install? Is that an option for your method or no?
May 10, 2017 at 12:57 pm
If you have the hardware (or VM's) for a failover setup, then DH2i's DxEnterprise is a nice HA/DR solution. We don't use it for a full DR solution, but if...
May 10, 2017 at 12:32 pm
Never seen that - and the documentation doesn't mention name changes. It lists the...
May 10, 2017 at 12:13 pm
\setup.exe
/Action=Install
/QS
/SQMREPORTING=0
/IACCEPTSQLSERVERLICENSETERMS
/ERRORREPORTING=0
/Features=ADV_SSMS,BC,BOL,Conn,FullText,RS,SQL
....
/INSTANCEID="SQLPROD01"
/INSTANCENAME="SQLPROD01" will install
1.SQL instance SQLPROD01
2.Create reporting services SQLPROD01
3.on...
May 10, 2017 at 11:53 am
I was doing a bit more digging into this and I have a potentially better thought on the error:
DESCRIPTION: During restore restart, an I/O...
May 10, 2017 at 9:47 am
From checking, it sounds like the service account does have read/write permission on the backup...
May 9, 2017 at 9:50 am
Out of curiosity, when you say "running a 2012 package directly on a 2016 server" you mean that you built up the SSIS package in the 2012 BIDS and then...
May 8, 2017 at 10:39 am
I am not sure what is exactly required for SOX complaince, but we are apparently SOX complaint and don't really do a lot with respect to our ETL process.
May 8, 2017 at 10:26 am
Another thought is the error you reported:
(operating system error 5(Access is denied.))
This leads me to believe that the problem is that one of the below is...
May 8, 2017 at 8:34 am
Viewing 15 posts - 2,431 through 2,445 (of 2,756 total)