View Complete Post
Hi have been trying without any success to install Mircosoft Server 2008 32 Bit Trail version on my Windows Vista 32 Bit Desktop at home. Below are the error messages that I received both times.
Database Engine Services
SQL Server Replication
Can anyone out there please tell me what I am doing or not doing correctly? Any suggesti
We have SQL server 2008 installed in a virtual server and I just want to download tools for querying etc...om my pc. I downloaded the SQL Server 2008 Managemnt Express and installed the tools. My DBA is saying remove the express install and install the tools
from the full version. Is he correct or could I have used the SSME install to query the full version?
I am using Windows Server 2003. I have installed SQL Server 2005 and SQL 2008 R2 version in the machine. The sql server 2008 R2 version has the instance name as SQL2008R2
I am trying to configure "Reporting services Configuration Manager" for the SQL 2008 r2. I gave the machine name and hit the Find button, I am not able to get the Report server instance name.
But when I gave the server name, i am able to browse to the folders page in the Internet explorer. so the server is available . I gave like this in the IE, and I am able to see the page:
In the eventvwr, I found the following errror "The Drive:\Program Files\Microsoft SQL Server\MSRS10_50.SQL2008R2\Reporting Services\ReportServer\RSReportServer.config file failed to load. This error may occur if the XML is not valid. "
How to get the Report server instance name in the configuration manager.
Hello, When installing any version of Sharepoint(2007,2010) during the "Creating Configuration Database" Step it takes over 10 hours to complete. Then creating a web app takes just as long. and the sites are extreemply slow.
1) DB Server - SQL Server 2008 R2 on Windows Server 2008 R2
2) Webserver - to host Sharepoint 2010 on Windows Server 2008 R2
The Servers are on the same network and running with lots of horsepower, disk and memory. Are there any know issues with this and should we install Cummulative Update 3? Maybe that has a fix. We exhausted all our options and need justification
to apply the CU3 hotfix(s).
Thanks for your help.
now i have aSQL 2008 srv trial version i want to change it to a licensed version by using the command line tool or by other simle technique .i dont want to go for a fresh installation or upgrade.is it possible to do this.i have the license keys with me.
How do I identify if the SQL Server 2008 R2 version that is installed is 32 bit or 64 bit. I see that the are some files in Program Files directory and some others in Program Files(x86) directory on an Windows Server 2008 R2 OS.
Let me know what shall i do for this,
The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Subscriber for changes not yet sent to the Publisher. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199401)
Get help: http://help/MSSQL_REPL-2147199401
i know it was a SQL bug in 2005 but i guess it should have some work around, out of increasing the rentention Days...
Even after increasing the Days we are getting the same error message.
Our Envi settings are like:
Merge type Pull subscriptions
Publisher: Sql server 2008 Sutdio 64bit
Subscribers: 2008 Express SP1
Existing Retention Days : 14days
Please advice me i am fed up with this error, we have 1300 Subscribers its hitting some or other way.
We have a SQL Server 2008 Standard Edition. We've also installed Analysis Services and are using cubes.
Is it possible to have the Analysis Services on another server, to take some of the load of the "relation engine" server?
Do we need a relation engine on this server? Will SQL express be sufficient for this?
I am using SQL Server 2008 on Windows Server 2008 R2 and one of our servers running as a windows service (on Windows Server 2008 R2) contacts the SQL Server 2008 in a timely fashion to get some information. During one of these runs, we encountered the following
error logs in the service logs and thereby we took a hit in serving client requests. The jdbc jar that is used for database connectivity is of version 3.0 (sqljdbc.jar).
I can provide more details on this issue. Can someone please let us know why this can be occurring ? Just so you know, the set of errors repeats itself after sometime although on a different JDBC Connection (with different ConnectionID). We have a reconnection
algorithm running in case the JDBC Connection is lost for some reason (but I would be surprised if this issue relates to the re-connect algorithm).
INFO | jvm 1 | 2011/02/28 22:26:54 | Feb 28, 2011 10:26:54 PM com.microsoft.sqlserver.jdbc.TDSParser throwUnexpectedTokenException
INFO | jvm 1 | 2011/02/28 22:26:54 | SEVERE: TDSReader@4686d ( ConnectionID:25 TransactionID:0x0000000000000000): FetchBufferTokenHandler: Encountered unexpected TDS_RET_STAT (0x79)
INFO | jvm 1 | 2011/02/28 22:26:54 | Feb 28, 2011 10:26:54 PM com.microsoft.sqlserver.jdbc.TDSReade
if I want to use the Compact version?
BTW, how do I convert an Access database to an SQL Compact database? Thanks for helping a newbie.