how to convert excel file to pdf in web application using PDFCREATOR.

It's working in local enviorment but when i do host the application in iis.It's not working.

Please help me if u have any idea.

Edited by Santosh Yadu Friday, May 29, 2015 8:32 PM
Moved by KareninstructorMVP Sunday, June 7, 2015 2:42 AM Moved from C# forum as this is a vendor issue

Reply:

Hello,

Have you tried contacting the company who created PDF Creator?

Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my webpage under my profile but do not reply to forum questions.

------------------------------------
Reply:

Why do you need a web app to do it?! If you can live with an Excel Macro, feel free to use this . . .

Sub Convert_Excel_To_PDF()   Dim MyPath As String, FilesInPath As String   Dim MyFiles() As String, Fnum As Long   Dim mybook As Workbook   Dim CalcMode As Long   Dim sh As Worksheet   Dim ErrorYes As Boolean   Dim LPosition As Integer      'Fill in the path\folder where the Excel files are   MyPath = "c:\Documents and Settings\shuerya\Desktop\ExcelFiles\"      FilesInPath = Dir(MyPath & "*.xl*")   If FilesInPath = "" Then   MsgBox "No files found"   Exit Sub   End If      Fnum = 0   Do While FilesInPath <> ""   Fnum = Fnum + 1   ReDim Preserve MyFiles(1 To Fnum)   MyFiles(Fnum) = FilesInPath   FilesInPath = Dir()   Loop      With Application   CalcMode = .Calculation   .Calculation = xlCalculationManual   .ScreenUpdating = False   .EnableEvents = False   End With      If Fnum > 0 Then   For Fnum = LBound(MyFiles) To UBound(MyFiles)   Set mybook = Nothing   On Error Resume Next   Set mybook = Workbooks.Open(MyPath & MyFiles(Fnum))   On Error GoTo 0      If Not mybook Is Nothing Then         LPosition = InStr(1, mybook.Name, ".") - 1   mybookname = Left(mybook.Name, LPosition)   mybook.Activate   'All PDF Files get saved in the directory below:   ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _   "C:\Documents and Settings\shuerya\Desktop\PDFFiles\" & mybookname & ".pdf", _   Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _   :=False, OpenAfterPublish:=False      End If      mybook.Close SaveChanges:=False      Next Fnum   End If      If ErrorYes = True Then   MsgBox "There are problems in one or more files, possible problem:" _   & vbNewLine & "protected workbook/sheet or a sheet/range that not exist"   End If      With Application   .ScreenUpdating = True   .EnableEvents = True   .Calculation = CalcMode   End With  End Sub

Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.

------------------------------------
Reply:

Questions related to ASP.NET should be posted in the ASP.NET forums (http://forums.asp.net ). Questions related to third party products like PDFCreator should be posted in their forums.

------------------------------------
Reply:

Sorry for late reply.I did not try to connect the company..Thakns of your support.

------------------------------------
Reply:

Thanks for your suggestion of another way.

------------------------------------

[URGENT] Dying Domain Controller

Seems we have a server that is the DC that has a single disk and i can hear it clicking. It still boots and runs but i am not taking a chance. I have it offline and taking a WIM image of the drive. This DC is the only DC and has all the exchange info in AD and all the RDS info in AD not to mention all the other DC info!!! Here's my plan of attack:

take image (hopefully). Replace the single drive and apply that image to the new drive. Power it back up and good to go

BUT

if that does not work i guess i will have to rebuild it. It currently is 2008 R2 and we have 2012. So i would rebuild it as a 2012 DC. This server is an older poweredge 860 with a single CPU and 4GB RAM. So i think i would not make it a hyper-v server and just install 2012 straight with a GUI. Then on a hyper-v server, create a DC to mirror the physical DC server. That way if 1 goes down, the network is still up and running. So 2 questions, does anyone see a problem or better way with the above process? If not, what is the best way to do this? Maybe a tech document that you know of? Thanks for any help

Reply:

So according to:

https://support.microsoft.com/en-us/kb/281662

this is not supported?

It is not recommend to combine the Active Directory Domain Services role and the Failover Cluster feature on Windows Server 2003, Windows Server 2008, or Windows Server 2008 R2
It is not supported to combine the Active Directory Domain Services role and the Failover Cluster feature on Windows Server 2012

Maybe i am not searching for the correct terms? Used server 2008 r2 ha. Any ideas?

------------------------------------
Reply:

OK, so the server DID have a RAID and so i replaced the faulty drive and all is good now. Except i want to add DC redundancy. So this page says to add a secondary DC:

http://blog.hyperexpert.com/how-to-add-a-secondary-domain-controller-with-integrated-dns-in-windows-server-2012/

So the primary DC is server 2008 R2 and the secondary will be server 2012 R2. Can i do that? My end goal is top get the primary DC redundant, then take down the primary DC and rebuild with server 2012 R2. Is this possiblem with this type of setup?

------------------------------------
Reply:

To answer my own question and for anyone else who finds this thread:

Yes, server 2012 R2 as a secondary DC worked fine with a server 2008 R2 DC

------------------------------------

To use Windows Feedback, you must be registered with the Windows Insider Preview Programme , and connected to the Internet the first time you run the feedback app.

Changed type Brandon RecordsModerator Tuesday, June 16, 2015 7:25 PM No issue or question presented.
Moved by Brandon RecordsModerator Tuesday, June 16, 2015 7:25 PM Moved to more appropriate forum.

"setup can't find or validate an installation file"popup message while setup of ms-office 2013 please help me windows 7, 32bit operating system please please please help me

"setup can't find or validate an installation file.please try reinstalling..."can u please help me i have spent 5 days for fixing problem but no use,someone please help me fix my problem and give correct suggestions i downloaded 32bit 666MB ms office 2013 but it showing setup error pls help me i have spent so much of data in fixing it but no use pls replay for my question

your regards,

Arjun

Reply:

"setup can't find or validate an installation file.please try reinstalling..."can u please help me i have spent 5 days for fixing problem but no use,someone please help me fix my problem and give correct suggestions i downloaded 32bit 666MB ms office 2013 but it showing setup error pls help me i have spent so much of data in fixing it but no use pls replay for my question as soon as possible because of our projects.

your regards,

Arjun

------------------------------------
Reply:

I am getting the same error installing Project Pro 2013 and Visio 2013. I can tell you one thing for sure, it is the machine that has the problem. Both of my installs have worked on over 50 machines.

It would be nice if someone could reply to this from MS. After all this is a MS Technet website.

------------------------------------
Reply:

May be this can help?

http://answers.microsoft.com/en-us/office/forum/office_2013_release-office_install/i-cant-install-office-2013-error-setup-cant-find/6de6f3fa-9d1f-4776-b1a0-39675dc94674

But I think the easiest way to fix this is to reinstall the complete client.

regards Holger Technical Specialist UC

------------------------------------

Releasing ISOs for Windows 10 Insider Preview Build 10130

Hi everyone, today we are releasing the ISOs for Windows 10 Insider Preview Build 10130. We are not, however, releasing Build 10130 to the Slow ring due to several bugs we're looking to fix. Once we have these fixes in hand and ready to push out to Windows Update, we'll consider pushing Build 10130 to the Slow ring. I know we said we would only release ISOs if we push a build to the Slow ring but we're making a special exception today. We know that a bunch of Windows Insiders on the Fast ring are currently blocked getting to the latest build due a 0x80146017 error. With the ISOs, they can mount the image and upgrade directly from the ISO and get unblocked.

Thanks,
g

Cheers,
Drew

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

Dll file issue

we are unable to find the network sharing option in windows

Reply:

In the Search box, type: Network Sharing and the icon should appear.

Carey Frisch

------------------------------------

How to create Guage KPIs Using Excel- Power Pivot, Power BI

Hi All,

Here I am creating Guage KPIs Using SSAS(BIDS).

1. My Question is, Can I Show that Guage KPI With the same type of symbol in EXCEL.

(for this I am Accessing the data from SSAS CUBE to Excel)

2. Can I create the guage KPIs using EXCEL by importing the data from other sources.

(Means Lets assume I did not create any KPIs in SSAS CUBE. And I am importing the CUBE data from SSAS to Excel. Then, from EXCEL can I create the Guage KPI using that CUBE data)

SUPRAJA'S

Moved by Tina-Shi Friday, May 29, 2015 2:56 AM the issue is related to the Power Pivot
Changed type Michael Amadi Sunday, October 11, 2015 9:35 AM No response

Reply:

Hi SUPRAJA'S,

Thank you for posting in MSDN forum.

Since this issue is related to the SQL Power Pivot, so we will move this case to the Power Pivot forum:

https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=sqlkjpowerpivotforexcel, you will get better support.

Best Regards,

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

------------------------------------
Reply:

Supraja's, is this still an issue?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

------------------------------------

Change Power Pivot Connection String for Text files int he data model

I have about 20 test files that are all part of the data model for a power pivot spreadsheet. How can i change the directory or name of any or all of them via VBA? Tahnx

Changed type Michael Amadi Thursday, August 13, 2015 9:12 PM No response

Reply:

Warren, is this still an issue?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

------------------------------------

Replace square brackets in SQL queries against ODBC

We use PowerPivot to access an ODBC provider. PowerPivot generates queries with square brackets, which is not ANSI compliant and incompatible with this ODBC provider. In Office 2010, we had a workaround by modifying this file:

C:\Program Files\Microsoft Analysis Services\AS OLEDB\110\sql2000.xsl

and replace the '[' and ']' with double quotes.

!-- SQL Server 2000 pluggable cartridge -->

<xsl:param name="in_CanUseParams">yes</xsl:param>
<xsl:param name="in_IdentStartQuotingCharacter">[</xsl:param>
<xsl:param name="in_IdentEndQuotingCharacter">]</xsl:param>

However, this workaround does not seem to work after we upgraded to Office 2013. PowerPivot doesn't appear to read this cartridge file anymore. We are familiar with the option to manually write queries to bypass this issue, but we still like to use the generated queries. Is there another way to replace the square brackets?

Changed type Michael Amadi Thursday, October 8, 2015 8:12 PM No response

Reply:

Mike, is this still an issue?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

------------------------------------

sharepoint 2010 powerpivot 2010

Administrators have installed SSAS 2008 R2 Service pack 3. Since then in the excel power pivot reports , the slicers are not working. Also I ma unable to configure the refresh options for the power pivot reports.
When I click on Configure the the refresh link its shows unexcpeted error and when checked with logs files , here is the details.
Could you please let me know how to fix the issue?

When I try to open the report, it shows error in screenshot.

                              0x01FC Excel Services Application            Excel Calculation Services             d51n      Medium                  MossHost.GetEndpointAddress: Server endpoint Uri: http://sp-prd-pp01:32843/b491c3eba6a5438daeb3c9c66ee0ffef/ExcelService.asmx.    640ccb0f-2f18-4218-9ed1-07bdb9927df1
                              05/08/2015 08:26:30.02 w3wp.exe (0x0188)                       0x01FC SharePoint Foundation                 Topology                                      e5mc     Medium               WcfSendRequest: RemoteAddress: 'http://sp-prd-pp01:32843/b491c3eba6a5438daeb3c9c66ee0ffef/ExcelService.asmx' Channel: 'Microsoft.Office.Excel.Server.CalculationServer.Proxy.IExcelServiceSoap' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GetHealthScore' MessageId: 'urn:uuid:b59d8030-acf2-4b3c-bace-4d6628e55202' 640ccb0f-2f18-4218-9ed1-07bdb9927df1
                              05/08/2015 08:26:32.50 w3wp.exe (0x0188)                       0x01FC SharePoint Foundation                 Monitoring                                    nasq      Medium               Entering monitored scope (Request (GET:https://gohsep.net:443/rec/_layouts/PowerPivot/ManageDataRefresh.aspx?list=%7b6AE4477D-1469-4766-B8D1-2DEDC0C70227%7d&ID=8&Source=https%3a%2f%2fgohsep.net%2frec%2fGM%2520Dashboard%2fForms%2fGallery.aspx))
                              05/08/2015 08:26:32.50 w3wp.exe (0x0188)                       0x01FC SharePoint Foundation                 Logging Correlation Data                      xmnv     Medium               Name=Request (GET:https://gohsep.net:443/rec/_layouts/PowerPivot/ManageDataRefresh.aspx?list=%7b6AE4477D-1469-4766-B8D1-2DEDC0C70227%7d&ID=8&Source=https%3a%2f%2fgohsep.net%2frec%2fGM%2520Dashboard%2fForms%2fGallery.aspx)                456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:32.50 w3wp.exe (0x0188)                       0x01FC SharePoint Foundation                 Logging Correlation Data                      xmnv     Medium               Site=/rec             456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:32.53 w3wp.exe (0x0188)                       0x01FC SharePoint Foundation                 Monitoring                         b4ly                High       Leaving Monitored Scope (EnsureListItemsData). Execution Time=14.4548399307733      456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:32.55 w3wp.exe (0x0188)                       0x01FC SharePoint Foundation                 Topology                                      e5mc     Medium               WcfSendRequest: RemoteAddress: 'http://sp-prd-pp01:32843/f1e524780f8f45598b197fa12df36130/SSASMidTierService.svc' Channel: 'Microsoft.AnalysisServices.SharePoint.Integration.IGeminiServiceApplicationClient' Action: 'http://tempuri.org/IGeminiServiceApplication/GetDataRefreshSchedule' MessageId: 'urn:uuid:fac7fc8c-d793-4cab-bfaa-153ccc37c773'    456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:32.61 w3wp.exe (0x0188)                       0x01FC SharePoint Foundation                 Topology                                      e5mc     Medium               WcfSendRequest: RemoteAddress: 'http://sp-prd-pp01:32843/f1e524780f8f45598b197fa12df36130/SSASMidTierService.svc' Channel: 'Microsoft.AnalysisServices.SharePoint.Integration.IGeminiServiceApplicationClient' Action: 'http://tempuri.org/IGeminiServiceApplication/GetDatabase' MessageId: 'urn:uuid:a17e3b9f-6f53-42b0-8049-e60445fa7c10'    456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:32.66 w3wp.exe (0x0188)                       0x38D0 SharePoint Foundation                 Topology                                      e5mc     Medium               WcfSendRequest: RemoteAddress: 'http://sp-prd-apps02:32843/970d02b3d5814a54ae5bca029a178cbd/MetadataWebService.svc' Channel: 'Microsoft.SharePoint.Taxonomy.IMetadataWebServiceApplication' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges' MessageId: 'urn:uuid:ae2a33d5-fb8f-4f25-9295-490006908835'
                              05/08/2015 08:26:32.66 w3wp.exe (0x0574)                       0x0474 SharePoint Foundation                 Topology                                      e5mc     Medium               WcfSendRequest: RemoteAddress: 'http://sp-prd-apps02:32843/970d02b3d5814a54ae5bca029a178cbd/MetadataWebService.svc' Channel: 'Microsoft.SharePoint.Taxonomy.IMetadataWebServiceApplication' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges' MessageId: 'urn:uuid:bf2bffa2-b695-4871-865a-ba986b6bb640'
                              05/08/2015 08:26:33.17 w3wp.exe (0x0188)                       0x01FC SharePoint Foundation                 Monitoring                         b4ly                High       Leaving Monitored Scope (ExecuteWcfOperation:http://tempuri.org/IGeminiServiceApplication/GetDatabase). Execution Time=556.589594487568                456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17 w3wp.exe (0x0188)                       0x01FC SSAS Mid-Tier Service                    Unknown                            99                High       EXCEPTION: System.ServiceModel.Security.SecurityAccessDeniedException: Access is denied.    Server stack trace:      at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)     at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)     at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)     at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)     at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)    Exception re...   456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17*               w3wp.exe (0x0188)                       0x01FC SSAS Mid-Tier Service                    Unknown                                       99           High       ...thrown at [0]:      at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)     at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)     at Microsoft.AnalysisServices.SharePoint.Integration.IGeminiServiceApplication.GetDatabase(String loginName, String dataSource, String dataSourceVersion, DateTime fileLastModifiedTimestamp,Int32 localeId, Boolean collectHeathInfo, Boolean createLocal, String serverEndpointAddress)     at Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplicationProxy.GetDatabaseHelper(String loginName, String dataSource, String dataSourceVersion, DateTime fileLastModifiedTimestamp,Int32 localeId, Boolean collectHeathInfo, Boolean createLocal) 456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17 w3wp.exe (0x0188)                       0x01FC SSAS Mid-Tier Service                    Unknown                            15                Medium               Proxy encountered an error while trying to get the sandbox information. This request will be terminated         456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17 w3wp.exe (0x0188)                       0x01FC SharePoint Foundation                 Runtime                               tkau                Unexpected       System.ServiceModel.Security.SecurityAccessDeniedException: Access is denied.   Server stack trace:      at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)     at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)     at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)     at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)     at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)    Exception rethrown at [0...          456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17*               w3wp.exe (0x0188)                       0x01FC SharePoint Foundation                 Runtime                                       tkau       Unexpected       ...]:      at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)     at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)     at Microsoft.AnalysisServices.SharePoint.Integration.IGeminiServiceApplication.GetDatabase(String loginName, String dataSource, String dataSourceVersion, DateTime fileLastModifiedTimestamp,Int32 localeId, Boolean collectHeathInfo, Boolean createLocal, String serverEndpointAddress)     at Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplicationProxy.GetDatabaseHelper(String loginName, String dataSource, String dataSourceVersion, DateTime fileLastModifiedTimestamp,Int32 localeId, Boolean collectHeathInfo, Boolean createLocal)     at Microsoft.AnalysisServices.SharePoi...          456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17*               w3wp.exe (0x0188)                       0x01FC SharePoint Foundation                 Runtime                                       tkau       Unexpected       ...nt.Integration.GeminiServiceApplicationProxy.GetDatabase(StringloginName, String dataSource, String dataSourceVersion, DateTime fileLastModifiedTimestamp,Int32 localeId, Int64 totalLength, String& databaseId, String& databaseName, String& serverEndpointAddress)     at Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplicationProxy.GetDataRefreshSchedule(String url, Guid itemID, Boolean loadDataSources)     at Microsoft.AnalysisServices.SharePoint.Integration.DataRefreshUtils.GetRefreshSchedule(String url, Boolean loadDataSources)     at Microsoft.AnalysisServices.SharePoint.Integration.ManageRefresh.Page_Load(Object sender, EventArgs e)     at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)     at System.Web.Util.CalliEventHa...               456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17*               w3wp.exe (0x0188)                       0x01FC SharePoint Foundation                 Runtime                                       tkau       Unexpected       ...ndlerDelegateProxy.Callback(Object sender, EventArgs e)     at System.Web.UI.Control.OnLoad(EventArgs e)     at Microsoft.AnalysisServices.SharePoint.Integration.GeminiPageBase.OnLoad(EventArgs e)     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)            456d444d-1f5d-4bd3-a49a-161e45f60cb2
                              05/08/2015 08:26:33.17 w3wp.exe (0x0188)                       0x01FC SharePoint Foundation                 Monitoring                         b4ly                Medium               Leaving Monitored Scope (Request

Changed type Michael Amadi Thursday, August 13, 2015 9:11 PM No response

Reply:

When I try to open the report, it shows error in screenshot.

a few seconds ago

Quote

Delete

asritha

Points

asritha
	Joined Jun 2011

1	asritha's threads Show activity

5 Points

Merged by Charlie Liao Monday, May 11, 2015 1:20 AM duplicate thread

------------------------------------
Reply:

Asritha, is this still an issue?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

------------------------------------

PowerPivot DataRefresh Error

Hi Guys,

I´m having the following error in PowerPivot for SharePoint 2013, using SQL Server 2012 SP2, and was hoping you could give me some pointers:

Microsoft.AnalysisServices.SPAddin.DataRefreshException: Another thread has obtained the lock and this thread is no longer the owner of the execution.

(I got the error from de ULS, and from the datarefresh history screen in SharePoint)

Thanks!

Changed type Michael Amadi Thursday, August 13, 2015 9:10 PM No response

Reply:

Estanislao, is this still an issue?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

------------------------------------

Build 10130 ISO download

http://windows.microsoft.com/en-us/windows/preview-iso

Releasing ISOs for Windows 10 Insider Preview Build 10130.............

Thanks,
g

Edited by david hk129 Saturday, June 6, 2015 12:21 AM

Reply:

you should have post the source link where you got the message.

source here: Releasing ISOs for Windows 10 Insider Preview Build 10130

------------------------------------
Reply:

you should have post the source link where you got the message.

source here: Releasing ISOs for Windows 10 Insider Preview Build 10130

I should or should not do is none of your business.

I do the way I see fit.

You do yours.

------------------------------------

Copy Utility for Data Deduplication and Long Path Names

I thought I'd share a bit of information I learned from several weeks of research.

If you have data deduplication on a volume, most copy utilities will fail. Tested utilities include:

TeraCopy
Roadkil's Unstoppable Copier
FastCopy

Copy utilities are required in our environment because we have long path names (and lots of them). Windows Explorer copy works just fine on deduplicated data, but cannot handle our path names.

The one copy utility that we have tested that works to both properly re-hydrate deduplicated data and to handle long path names is:

RoboCopy

Cannot Activate Site Template "'targetwebsrurl' attribute not allowed"

I ran into an interesting problem when creating a site as a template. The original site was built in 2010 and was converted to 2013. However, one of the site columns was a lookup field, which did not transfer correctly. I was able to create a site as a template just fine (after turning off publishing and turning on the site as template checkbox in SPD), but, when I went to activate it, I got the error "'targetwebsrurl' attribute not allowed." After digging into the XML files in the .cab file, I found out that this was caused by that bad site column lookup field. So, if you are getting this error, I would check any lookup columns (especially site columns) within the site and make sure there aren't problems with them before trying to save as a template.

Add a condition to script

Dear all,

I need your help to correct this script ,which 's delete some AD groups from a liste of users .

the script is working fine I added an output to log file to indication which user is deleted from which group , The problem is I get my output message "user1 successful deletion from group2" even if user1 don't belong to group2 ...

I would like to test firt belore deletion if user belong to a group or test the output of this command (Get-ADGroup -Filter "name -like '$adgroups'" | remove-adgroupmember –members $aduser -confirm:$false)

$groups = get-content c:\grnames.txt  $names = get-content c:\names.txt     foreach ($aduser in $names) {    foreach ($adgroups in $groups)   {    Get-ADGroup -Filter "name -like '$adgroups'" | remove-adgroupmember –members $aduser -confirm:$false    echo "$aduser successful deletion from $adgroups" >> c:\logcmd.txt   }    echo "******************next user******************" >> c:\logcmd.txt   }

Thank's in advance

Edited by Med_be Friday, June 5, 2015 10:08 AM

Reply:

There is no code where you check if the delete is actually happening.

You should read and then check for the results of remove-adgroupmember and then use If..else to write log file based on success/failure.

Also i dont think you need the Get-Adgroupmember because you can pass the group name directly to the remove command (provided the group names in the input files are correct)

I dont have an AD right now to test it for you in more detail.

Sumesh P.

------------------------------------
Reply:

thank you for your replay !

wath I'm looking for is how to read before remove action or how to catch the output (if there is any output 1/true if deletion Ok 0/false if ko )of remove-adgroupmember command to add condition ......

------------------------------------
Reply:

Using "name like " will get you in trouble as has been noted in your original thread.

If you remove a member successfully there will be no error.

Try{   get-adgroup testgrp2 | Remove-ADGroupMember -member someuser -confirm:$false -ea stop   Write-Host 'user removed from group' -fore green  }  Catch{ "$_"}

\_(ツ)_/

------------------------------------
Reply:

Here is how you have to do this. You are currently doing it backwards.

$groups = get-content c:\grnames.txt  $names = get-content c:\names.txt    foreach ($group in $groups) {   if($group=Get-ADGroup -Filter "name -like '$group'"){   foreach($name in $names){   Try{   $group| remove-adgroupmember –members $name -confirm:$false -ea Stop   "$aduser successful deletion from $group" | Out-File c:\logcmd.txt -Append   }   Catch{   Write-Host "$_" -fore green   }    }   }else{   Write-Host "Group not found $group" -fore red  }

\_(ツ)_/

Edited by jrv Friday, June 5, 2015 3:23 PM

------------------------------------
Reply:

You can simply save it to a variable, you will need to add the -passthru switch.

$result = Get-ADGroup -Filter "name -like '$adgroups'" | remove-adgroupmember –members $aduser -PASSTHRU -confirm:$false

Test that out.

Also if you dont want to make changes and just check that would happenget-adgroupmember , use the WHATIF switch

Get-ADGroup -Filter "name -like '$adgroups'" | remove-adgroupmember –members $aduser -WHATIF -confirm:$false

or use Get-ADgroupmember and check FIRST if the user is added to the group.

Sumesh P.

------------------------------------
Reply:

You can simply save it to a variable, you will need to add the -passthru switch.

$result = Get-ADGroup -Filter "name -like '$adgroups'" | remove-adgroupmember –members $aduser -PASSTHRU -confirm:$false

Test that out.

Also if you dont want to make changes and just check that would happenget-adgroupmember , use the WHATIF switch

Get-ADGroup -Filter "name -like '$adgroups'" | remove-adgroupmember –members $aduser -WHATIF -confirm:$false

or use Get-ADgroupmember and check FIRST if the user is added to the group.

Sumesh P.

Sorry - that won't work.

\_(ツ)_/

------------------------------------
Reply:

hello All ,

thank's for your help :) , I get anothor working code

$groups = get-content c:\grnames.txt  $names = get-content c:\names.txt     foreach ($aduser in $names) {    foreach ($adgroups in $groups) {    Get-ADGroup -Filter "name -like '$adgroups'" | where {(Get-ADGroupMember $_).SamAccountName -eq $aduser} | foreach {   remove-adgroupmember -Identity $_ –members $aduser -confirm:$false    echo "$aduser successful deletion from $adgroups" >> c:\log.txt   }   echo "******************next user******************" >> c:\log.txt   }   }

many thank's again

------------------------------------
Reply:

hello All ,

thank's for your help :) , I get anothor working code

$groups = get-content c:\grnames.txt  $names = get-content c:\names.txt     foreach ($aduser in $names) {    foreach ($adgroups in $groups) {    Get-ADGroup -Filter "name -like '$adgroups'" | where {(Get-ADGroupMember $_).SamAccountName -eq $aduser} | foreach {   remove-adgroupmember -Identity $_ –members $aduser -confirm:$false    echo "$aduser successful deletion from $adgroups" >> c:\log.txt   }   echo "******************next user******************" >> c:\log.txt   }   }

many thank's again

Please look closely at my last scrip. Your version is not going to work as expected and will be very slow. Errors will cause it to abort.

\_(ツ)_/

------------------------------------

What to do with PS? (NOT another 'Where can I get learning resources' question)

I'm interested in learning PowerShell, but I'm not really sure what to do with it.

This isn't another "Where can I get tutorials / free books / online resources" question. It's just that six or eight various resources I've looked at don't seem to cover what I do on a regular basis. I've never had a reason to retrieve a list of services running on another system (and rarely on my own). I can't image why I'd care how long my servers have been up (as long as they're up NOW).

I'm a level-2 service desk technician in manufacturing facility, with a variety of system administration responsibilities. All my servers are running 2008. There are a domain controller, a print and file server, and an SCCM distribution point in the building. There are Lync, Exchange, and SCCM primary servers at our regional IT HQ at another site. These are the tools I deal with most of the time. Turnover here is low, and I'm having a hard time coming up with functions that would be worth automating.

I'm sure there are plenty of practical things I could do with PS, but I can't figure out what they might be. My DOS and DCL (!) experience has left me comfortable enough when using a CLI. I assume it would be best to find 'single command' uses before I tackle scripting, but maybe that isn't right either. I guess what I'm asking is, "How can I use PS to make my life easier?"

Charlie Spencer

Edited by Charlie Spencer Thursday, June 4, 2015 8:44 PM

Reply:

Hi there,

You could start or by creating scripts that are in fact just single command scripts. I've made a diskpart script for formatting all the HDD's before I image them, and I've also made scripts to add different set of icons to different category of use type. You can add users to PC's, you can migrate users, tons of things. You may want to identify some chores yo uhave that could benefit from some automation.

I'm currently reading "PowerShell in a month of Lunches v3" and it's very informative.

Cheers

------------------------------------
Reply:

Another thing that I did was start using PowerShell as my 'command line window' instead of CMD. Force yourself to start using it and try to do different things. Once you find the power of PowerShell remoting, the need to RDP into any server becomes minimal.

The only issue I see is that you are still on 2008. That does not have as much PowerShell capability. With 2012+ it gets to be much more fun.

. : | : . : | : . tim

------------------------------------
Reply:

Well,
i work with same or similar products. lets see how i use powershell

Domain controllers: no, i dont use PS on these servers. Running AD cmdlets from my notebook
Print and file servers: Only powershell. Deploying printers, drivers, shares, permissions, managing WU (deploying security patches).. over 140 servers. Also using powershell (+SCVMM) to deploy new servers.
SCCM: well, using powershell to install/uninstall clients (some nice scripts on repository could be found)
Exchange: how can u live without powershell on Exchange? Some things u can do via GUI, some u simply cant. I found myself to run EMC minimum times.

Powershell definitely made my life easier. I am still very newbie with it, but stuff I already know helped me a lot and ive much more free time than ever before - tasks which can take hours via GUI is done in minutes.

When u do some things over and over powershell really helps a lot. First tasks can take hours and hours before u figure it out (how to script them) but then.. ?

Edited by Mekac Friday, June 5, 2015 5:51 AM

------------------------------------
Reply:

Maybe I've been approaching this all wrong.

I've been taking a 'crawl, walk, run' approach. I've assumed the best way to learn this would be to first learn how to use individual cmdlets to do things on my own system; then write scripts for my own system; then scripts to run directly on servers; then remote to other servers and systems.

It occurred to me this morning that my path may be counter-productive. Maybe what I've considered starting simple is actually an incorrect approach and a completely wrong mindset. I may also be focused too much on the mechanics of PS and not enough on what to do with scripts. Am I trying to learn how to use PS by mistakenly trying to find things to do with it that it isn't really designed for? Is that why I'm having to ask what to do with it?

Silent Puma, I'll try that.

Tim, that's a good idea but PS accepts so many legacy CMD commands that I'm not learning anything new. I'm just doing the exact same commands in a different window. Maybe I should disable the aliases.

Mekac, I guess everything I've had to do with Exchange can be done from the console. Maybe my environment is so relatively small and stable that I can't think of much to automate. Someone else is the primary admin for Exchange; I only touch it every couple of weeks.

Thanks!

Charlie Spencer

------------------------------------
Reply:

Two useful functions for PowerShell are administration and monitoring. It sounds like your environment is relatively static, not much on the administration side, to automate.

The other thing role is monitoring. This a sample script to check for free space on disks. It is a basic script but it covers a lot of PowerShell concepts.

The PowerShell ISE (Integrated Scripting Environment) is a good thing to learn. It has an editor and run scripts.

Check out the Microsoft Virtual Academy.

Function Get-CompInfo{   [CmdletBinding()]   Param(   #Want to support multiple computers   [Parameter(Mandatory=$True,   ValueFromPipeline=$true,   ValueFromPipelineByPropertyName=$true)]   [String[]]$ComputerName,      #Switch to turn on Error logging   [Switch]$ErrorLog,   [String]$LogFile = 'c:\errorlog.txt'   )   Begin{}   Process{   foreach($Computer in $ComputerName){   $os=Get-Wmiobject -ComputerName $Computer -Class Win32_OperatingSystem   $Disk=Get-WmiObject -ComputerName $Computer -class Win32_LogicalDisk -filter "DeviceID='c:'"      $Prop=@{ #With or without [ordered]   'ComputerName'=$computer;   'OS Name'=$os.caption;   'OS Build'=$os.buildnumber;   'FreeSpace'=$Disk.freespace / 1gb -as [int]   }   $Obj=New-Object -TypeName PSObject -Property $Prop    Write-Output $Obj     }    }   End{}  }    # Getting information from the local computer  Get-CompInfo -ComputerName .    # Getting information from remote computers  Get-CompInfo -ComputerName comp1, comp2    # Getting information form computers in a text file  Get-Content c:\servers.txt | Get-CompInfo

Edited by Brian Nadjiwon Friday, June 5, 2015 4:54 PM

------------------------------------

For Those Who Liked the Classic Start Menu, Some Hints to Help Manage the Win 7 Start Menu

Okay, so we've mostly gotten over the missing "Classic" Start Menu. Mostly. And guess what? The Windows 7 Start Menu isn't really evil.

There are things one can do to the "new" Start menu that make it more livable. Once done, you will hardly miss the old way. A few weeks of use then when you log into an old computer you might find yourself actually disliking the Classic Start Menu. Yes, it's true!

A. You can disable the tendency to fill the first window with a hodgepodge of recently executed programs.
B. You can create a couple of shortcuts that make it easy to reorganize the menu structure.
C. You can continue to rearrange the menu structure (in an ongoing fashion) to make it easy to find things.

None of the above are the defaults. That's okay, they can be changed. See below for how.

A. To disable filling the first window with a hodgepodge of recently executed programs

1. Right-click on the Start orb and choose Properties.
2. Uncheck both [ ] Store and display recently opened... items.

Voila, you're presented with this. Not perfect (jumping directly to All Programs would be better), but livable.

Now, you might say all that blank space is a waste, and if you prefer to keep recently used programs in there, more power to you; don't make this change. I like order and I expecially like things that don't change around. I prefer to go to All Programs and its descendants to start the programs I want to run.

You may also notice I don't have the typical default items along the right side. That's all quite configurable too, via the [ Customize ] button in the Start menu Properties.

B. Create a couple of shortcuts that make it easy to reorganize the hierarchy.

In the "good ol' days" you used to be able to right-click on the Start Orb and choose Explore or Explore (All Users). Here's how to get that functionality back...

1. Open an Explorer window and navigate to this folder: C:\ProgramData\Microsoft\Windows\Start Menu\Programs

2. Create a new shortcut by Right-Clicking in the folder window and choosing New -> Shortcut.
3.  Into the Location of the Item field, enter:  explorer.exe "C:\ProgramData\Microsoft\Windows\Start Menu\Programs"
4. Press Next and into the name for this shortcut field, enter: Alter Start Menu (System)

5. Repeat steps 2 through 4 and this time enter the following for Location and Name:
        explorer.exe "C:\Users\YourUsername\AppData\Roaming\Microsoft\Windows\Start Menu\Programs"
        Alter Start Menu (User)

After doing the above you'll have two new items at the top of the list you see after clicking All Programs in the Start menu:

If you click Alter Start Menu (System) you will see the folders and shortcuts/files that make up the menus seen by all users of the computer. The other entry, Alter Start Menu (User) will show you the data that gets put into the Start Menu when YOU are logged on.

By the fact that the word "Alter" starts with A, these new entries will generally be at the top, due to alphabetic sorting (another option I have enabled in the Customize Start Menu dialog).

C. You can now easily rearrange the menu structure (in an ongoing fashion) to make it fairly easy to find things.

Keeping in mind that the Start Menu is a combination of the folders and files you see at the two locations identified by the shortcuts above, now you can open one or both of the folders we added shortcuts for in step B above, and easily reorganize your Start Menu by dragging (moving) things around and making it easy for you to find things.

If the same folder name (e.g., Applications) appears in both the System menu structure and the User menu structure, only one entry will appear in the Start Menu.

As time passes, and you install things, you'll find they often install their shortcuts and/or folders right in the All Programs menu or somewhere you don't want. No problem, just click the Start orb, All Programs, then Alter Start Menu (System) or the other one. Move the program's menu entries to where you like. Personally I like to keep the base menu clean, and move entries for newly-installed programs to the Applications subfolder.

I hope this helps you.

-Noel

Reply:

Nice article Noel, but I'd like to add one point.

You could make step 5. in B. Create a couple of shortcuts that make it easy to reorganize the hierarchy generic by using this for the shortcut:

explorer.exe "C:\Users\ %username% \AppData\Roaming\Microsoft\Windows\Start Menu\Programs" .

That would make it work for any currently logged in user, not just yourself -- which is good if you're going to add it to the System Start Menu.

Martin

------------------------------------
Reply:

Thanks, Martin. Good point, that works all the time. I can no longer edit the above to reflect the change. I'd bold the whole thing so that it is clear it should be entered as is...

explorer.exe "C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Windows\Start Menu\Programs"

-Noel

------------------------------------
Reply:

Noel and Martin,

I followed the directions to create the "Alter Start Menu" shortcuts for both the User and the System. The System shortcut works where it directs you to the proper folder, however I am having trouble with the User shortcut. I have tried both ways of entering the location...the one Martin suggested and the one Noel first suggested as number 6. I have had no luck with this shortcut as when I do utilize it, it directs to me to an explorer window for "my documents" instead of the folder with the programs in it. I have double checked and even copied and pasted the address into the item location. I am sure I might be missing something or have some settings wrong or something.

Any help would be greatly appreciated. Thank you for your time!

Lori

------------------------------------
Reply:

Or, you could just get Classic Shell from Sorceforge.net and have the classic menu back.

------------------------------------
Reply:

Lori,

I think the problem is there's some extra spaces around the "%username%" in the explorer path shown in my original reply. It should have been:

explorer.exe "C:\Users\%username%\AppData\Roaming\Microsoft\Windows\Start Menu\Programs".

--
Martin

------------------------------------
Reply:

I agree (although I'm not sure it's the same thing because it's not on Sourceforge.net).

Here's the one I use: Classic Shell

--
Martin

------------------------------------

Column missing when exporting to csv with the sqlcmd

Hello everyone,

I've this following issue:

With a query I can obtain the result I want when I execute it in que SQL Server Management Studio.

But when I want to execute the query with the sqlcmd, the last calculated column "result" is missing.

SQCLMD:

sqlcmd -S localhost -d EQCAS -i sort_info.sql -h-1 -s"," -o ExcelTest.csv

Query:

SET NOCOUNT ON;    	select  	'adjust' as 'adjust',  	'ur' as 'ur',  	new_table.name,  	new_table.test - new_table.balance as 'result'    	  	FROM  		  	(SELECT   		account.name,  		account.balance,  		account.balance + 30 as 'balance_max',  		account.hardlimit as 'minimum balance',  		account.balance - account.freemoney as 'balance paid',  		  		CASE WHEN account.balance + 30 > 60 THEN 60 ELSE account.balance + 30 END as 'test',  		--CASE WHEN 'balance_max' > 60 THEN 60 ELSE 'balance_max' END,  		account.freemoney as 'alloted'  				  	FROM cat_validation account  		LEFT OUTER JOIN cas_val_assoc ass ON ass.associd= account.id  		LEFT OUTER JOIN cat_validation dept ON dept.id = ass.mainid and dept.valtype = 'dpt'  		LEFT OUTER JOIN cas_user_ext ur ON ur.x_id = account.id  		LEFT OUTER JOIN cas_user_class uc ON uc.id = classid  		LEFT OUTER JOIN cas_primarypin_ext altp ON altp.x_id = account.id  		LEFT JOIN cas_location loc ON loc.id = account.locationid  				  		where account.valtype = 'usr'and account.expiration is null) as new_table

Is there something I miss in my query or my sqlcmd to export also the calculated column "result" ?

Reply:

I would double-check that the file on disk includes what you think it should include. Maybe you added the "result" column after you saved the file to disk? Press Ctrl-S to save and try again.

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

------------------------------------
Reply:

Unfortunately the file has the good content. Is it because the column result is a calculated column ?

------------------------------------
Reply:

Unfortunately the file has the good content. Is it because the column result is a calculated column ?

AFAIK

There are no issues with having computed column like that. SQLCMD should still execute it correctly. ARe you passing file name hardcoded or are you trying to get it using some other logic may be inside batch script or something?

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page

------------------------------------
Reply:

Unfortunately the file has the good content. Is it because the column result is a calculated column ?

Nope. It is because the query in the file you are running only produces three columns. Or that the third column is wide, and you are not looking far enough to the right. The -W option may help.

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

------------------------------------
Reply:

Good improvement when I play with the Width parameter I can see my value but I've too many empty spaces before the number.

Is there a way to avoid this empty space and having the number between the comma in CSV.

For example :

adjust, ur, administrator , 30.0000 instead of

adjust, ur, administrator,

30.0000

------------------------------------
Reply:

My apologize I put the option -w instead of -W.

It's working with the last option.

------------------------------------

Best Practice Number of DBAs

Hi all,

I am curious if anyone is aware of best practice recommendations for the number of Microsoft DBAs for an organization. This is just for Microsoft SQL Server, for a per instance, server, or DB recommendation; hoping to have it backed up by a reputable third party company like Gartner or a staffing organization, or your own experience. I do realize that this is highly dependent on many factors (i.e. what functions/technologies you use, how highly available and complex your environment is, etc.) so I am hoping I don't get that included in the response; I understand that already. Something very general and high level that we could use as a general benchmark.

Really appreciate any guidance.

Changed type Shanky_621MVP Saturday, June 6, 2015 2:23 PM its non technical question more suited as discussion

Reply:

the fact is it depends on the company's budget and that will dictate how many dba's(senior+junior) they can afford..

there are some dba who are overworked and some underworked and some work cross platform - dba\dev\operation..

it is very common to have very small dba team and bigger dev teams and some dbas do developer work as well.

Hope it Helps!!

------------------------------------
Reply:

Hello,

The following Forrester blog talks about achieving a 40:1 ratio.

http://blogs.forrester.com/noel_yuhanna/10-09-30-how_many_dbas_do_you_need_support_databases

More resources about this.

https://datatechnologytoday.wordpress.com/2011/02/21/how-many-dbas/

http://searchdatamanagement.techtarget.com/news/1174743/How-many-DBAs

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Edited by Alberto MorilloMVP Friday, June 5, 2015 1:50 PM

------------------------------------
Reply:

Like everything else in SQL Server: "It depends."

I was a PFE at Microsoft for 6 years. In that time I had been to 287 companies. Some companies are significantly understaffed and some significantly overstaffed. I once went to a job fair with a power company and they were looking for their 63rd DBA, who would do backups and that's it. I asked what the person would do the other 39 1/2 hours a week and they didn't like that. Utilities are often run like a utility (Too many). Start ups are often run like a startup (No DBA). It really just depends on the management. The market in Texas is still pretty hot right now so I know of several companies that are having problems filling their requests.

As for what you need, that depends too. Do you have a 24/7 environment? If so, 3 DBAs may be a good idea to cover all the shifts. Maybe you only need 1 and a really good overnight NOC staff? Can the DBA do all the tasks across the environment (tuning, troubleshooting, deployments, code review, ..., ...) or do you need more staff to make it happen in the timeframe that you want? A lot of tasks should be automated but who will automate them? Do you have the manpower to do the automation? It's a really tough question.

There are also many companies that offer remote DBA services. This is great for a startup but probably not so great for a well established large company. Maybe you want a DBA and remote DBA services for the overnight?

Salary can range greatly depending on your geography! In Texas, a Jr DBA will be from 80-100k and going all the way up to 150k and beyond for a Principal or Architect. Ask yourself what your budget is. Ask yourself if you can you hire a senior level position and fill the rest with lower level staff that can be trained up.

Does that help?

Edited by Daniel Janik Friday, June 5, 2015 2:01 PM

------------------------------------
Reply:

the fact is it depends on the company's budget and that will dictate how many dba's(senior+junior) they can afford..

there are some dba who are overworked and some underworked and some work cross platform - dba\dev\operation..

it is very common to have very small dba team and bigger dev teams and some dbas do developer work as well.

Hope it Helps!!

Very much so! So many DBAs wear multiple hats.

------------------------------------
Reply:

First, you need to define the roles and responsibilities of the "DBA". Many organizations use that term differently.

If you expect the "DBA" to install SQL Server and keep it running, patching, backups, etc for a few servers, that is a minimal job which may be fulfilled by a Windows Administrator.

If you expect the "DBA" to code stored procs, SSIS, etc, you may have a "developer" which can also fulfill that role.

You always need two people who can do any job, so one can go on vacation. From there, it is really up to you.

------------------------------------

SQL Query

Hi Friends,

I have one query in MS SQL server 2005.I have already install ms sql 2005 in windows 2003 Ent 64 bit server.And now my new server is Windows 2008 Std 64 bit and i had installed sql server 2005 in this server so now i gating error from restoring data

Reply:

so now i gating error from restoring data

And which error do you get (we can't guess that)?

Olaf Helper

[ Blog] [ Xing] [ MVP]

------------------------------------
Reply:

Hello - You need to tell us what error are you getting to help you better, anyway few thoughts for you:

Note:

For System Databases: Restoring System databases can fail due to Build Mismatch make sure that both Instances are on same build. Uou can use SELECT @@Version to know the same. You should see something like Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1). In this output 10.50.1600.1 is the Build Number and it should be same on both machines
For user databases: Make sure that the path you are restoring to exist on Target machine or use WITH MOVE option to move the files to correct location while restoring or you can simply copy over the files here and perform Attach operation as well

Hope this helps !

Good Luck!
Please Mark This As Answer if it solved your issue.
Please Vote This As Helpful if it helps to solve your issue

------------------------------------
Reply:

What is your SQL for restoring data and what is the exact error you are getting? If you are using UI instead of TSQL then click on the check box "Overwrite existing database" , there might be a case where you have already restored it.

Also, check "relocate all file and folders"

Image source courtesy

Hope this will help

Glad to help! Please remember to accept the answer if you found it helpful. It will be useful for future readers having same issue.

My Profile on Microsoft ASP.NET

------------------------------------
Reply:

As Olaf noted, the matter is which error occurs? BTW, please also take a look at these URLs:

Deprecated Database Engine Features in SQL Server 2008

Discontinued Database Engine Functionality in SQL Server 2008

Saeid Hasani (My Writings on TechNet Wiki ,T-SQL Blog)

------------------------------------

Ms Support forum

Tuesday, February 1, 2022