View Complete Post
I had the CSS friendly adapters working great on our old server (windows server 2003 - 32bit) and now we have moved to a 64 bit environment and now I can not get the CSS friendly adapters to work.
We are using SharePoint 2007.
Is there another work thru for 64bit environment.
I notice windows server 2008 has a directory C:\Windows\Microsoft.NET\Framework64 would I be using the browser file in this directory???
I Installed SQL Server 2008 R2 and it is side by side with SQL Server 2005 (64bit)
Here my version
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 5.2 <X64> (Build 3790: Service Pack 2) Hypervisor).
I am able to create Jobs and able to modify the Jobs with out appling any hotfix.
old post which is recomended to applu hotfix
1. Why my server not given gives error while creating /modifing Job ?
2.From wizard/mantenancePlans Iam creating Jobs it is correct test.
2.Is it because of SQL Server 2005
Please some suggest me..why I a
Hello, I have been researching this issue and it seems if I have created a report using 2008, I cannot upload it to a 2005 report server.
I just wanted to check and see if I have any other options than to re-create the report using 2005? Would copy/paste of the XML from 2008 to 2005 work?
I have set the <WorkingSetMinimum> property to 2.4GB in my reportserver 2008 config file.
By defintion, <WorkingSetMinimum> setting means,
See this link for definition:
I'm trying to create a linked server from SQL Server r2 to SQL Server 2005 (both 64 bit Enterprise) using the following script
@server = N'TestLS'
I verified that the Kerberos is working.
When I try to run a four part query as below it gives me the error
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
OLE DB provider "SQLNCLI10" for linked server "TestLS" returned message "Invalid connection string attribute".
If I try to set up the linked server against localhost (i.e. SQL 2008 R2, it works just fine).
Hi. I have had an issue trying to get distributed transactions to work in SQL Server 2008 using a linked server. The error message I get is
OLE DB provider "SQLNCLI10" for linked server "pod1" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "pod1" was unable to begin a distributed transaction.
Windows Server 2008 Enterprise 64 bit, SQL Server 2008 Enterprise 64 bit
Problem occurs with multiple different builds of SQL Server 2008 - I have been able to reproduce the problem with 10.0.1600.0, 10.0.1779.0 (CU 2), as well as 10.0.2531 (SP1)
I am aware that other people have had this issue and have reviewed all existing posts. I have verified that the MSDTC is configured correctly on both machines. I have also used DTCTester to verify that DTC is working correctly on all machines in question.
None of the mentioned resolutions has solved this problem for me.
I am not seeing this problem occur on my 32 bit test machines - it is only occurring if at least one of the two machines is 64 bit.
I am running SQL Server 2008 R2 (version info below) and IntelliSense is not working. I am connected to a
SQL Server 2008 Edition database.
IntelliSense is enabled, SQLCMD mode is turned off. I refreshed the local cache. I am accessing simple table objects for which I have access rights. All of the usual suspects are covered and still I have no IntelliSense functionality.
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Analysis Services Client Tools 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework &
On Windows server 2008 R2 Enterprise Edition, we have installed SQL server 2008 R2 Reporting services and SQL Server 2008 database with Reporting services. Both have different instances.
Now, we can work with Report manager of SQL server 2008 R2 without any issue. i.e. assignment of new user role etc. is working fine, but when we try to do same thing with report manager of sql server 2008 then its not working. No error message is being shown
by the report manager when we try to assign new user a role and press OK button it doesn't show any message.
What could be the problem?
Hi, I have a server with Windows Server 2008 R2 Standard Edition English and when I try to install
SQL Server 2008 R2 Standard Spanish the installer give to me:
"SQL Server 2008 R2 Setup has stopped working
A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available."
Previously I changed the Current Format in Regional and Language Options to Spanish to solve a problem with OS Local. The mentioned error appears during the step of install the Setup Support Files, the step stop and show me the error with a "Close program"
button, after press the button the installation finish. Thanks in advance.
DELL PowerEdge T710
2 Intel Xeon CPU E5502 1.87GHz
32 GB RAM
Windows Server 2008 R2 Standard 64bit ENU (english)
SQL Server 2008 R2 Standard 64bit ESN (spanish)
I have a problem inserting Unicode text into sql server database table.
Field type is NVARCHAR, selecting works fine, but not insert
Here is my code:
MyQuery->SQL->Add("INSERT INTO R_HISTORY([NAME]) VALUES(:NAME)");
I use TntMemo1 to ensure the parameter is unicode.
Result is question marks.
A swiggly red line shows up, but I cannot get the list members e.g table.____ does not show the list of fields to that table. The intellisense is enabled , I did a refresh for the local cache but this has not helped at all.Is there anything else that
I can do to make this work???