A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.
2
votes
0answers
54 views
SQL Server 2008 R2 Replication conflict
We have software that during the installation or updates it drop and adds all of its views, triggers, and stored procedures. This became a problem when we tried to implement a snap shot replication on ...
2
votes
0answers
183 views
ASP.MVC website production server configuration best practice
When creating a new website on a production windows 2008 r2 server which requires connection to SQL Express should I create a custom identity for the application to run under or leave it as ...
2
votes
0answers
140 views
SQL Server Reporting Services subscription creation silently fails. No error message is displayed, but the subscription does not get created
I'm trying to set up a subscription for a SSRS report. I have deployed the report to the server and I can view the report in a web browser with no problems. I have tried to reproduce this issue on ...
2
votes
0answers
153 views
Slow Connection to SQL Server using OleDB
I have a web application using an ISAPI filter (written in c\c++) and OleDB to connect to a SQL Server 2008. The application works fine on a certain number of Windows Server 2008 R2.
Recently I ...
2
votes
0answers
88 views
How to do Merge Replication?
I tried to do synchronization of database between servers to synchronize a database using merge replication. Simply I've added publication in server A and subscription in Server B by declaring ...
1
vote
0answers
25 views
Failover cluster wouldn't fail over
I have an active-passive failover cluster on 2008r2 with SQL server 2008 clustered on it.
I go to fail it over for maintenance and the resource failed to come online on either node. Once I rebooted ...
1
vote
0answers
45 views
sql server x64 access x86 COM object
I want to transfer a database from SQL Server 2000 x86 to SQL Server 2008 R2 x64 but it uses a x86 COM object that I have no inside knowledge of. I know there are some articles out there about the ...
1
vote
0answers
67 views
SSMS stuck scripting database objects
SQL Server Management Studio sits stuck, after scripting all objects in a database. Except it didn't script all objects in a database.
i scripted all the objects in an SQL Server 2008 database from ...
1
vote
0answers
44 views
Microsoft SQL Server Express 2008 access denied
I'm trying to install Target Process on a Windows 7 machine, but for that I need to install SQL Server Express 2008, but I've been hitting my head on the same problem for a while now.
I found ...
1
vote
0answers
54 views
SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express Edition
I've installed SQL Server 2008 R2 Express Edition in my Win 7 notebook. The Express Edition doesn't have SQL Profiler enabled. Thus it's hard for me to debug my SQL 2005 applications.
I have a ...
1
vote
0answers
88 views
SQL 2008 fail-over cluster---specified credentials for the SQL Server service are not valid
We had Two Node SQL 2008 fail-over cluster.
Last week one node was crashed, so we decided to re-build the passive Node(crashed Node), we reinstalled the OS and added to windows cluster successfully, ...
1
vote
0answers
27 views
ssms script wizard not working with modified tables
I'm looking for a way to get all triggers and constraint we modified in a script to migrate them to a different database or reapply to this one if necessary.
I'm using SQLServer Management Studio ...
1
vote
0answers
220 views
MS SQL 2008 R2 64bit will not use more than 1.5GB in task manager
I have the latest MS SQL 2008 R2 installed on Windows Server 2008 R2 64-bit. The SQL server process never surpasses 1.5GB in the task manager resulting in heavy disk usage. I have solve this problem ...
1
vote
0answers
101 views
single application multiple users through thin client
I am having one application built in c# winforms. In the backend i am using SQLSERVER 2008 Express. And i am using the application remotely through thin clients. and my operating system is windows ...
1
vote
0answers
53 views
Bigger ProjectServer farm is performing worse
I am using Project Server 2007 sp3 with SharePoint 2007 sp3 and SQL Server 2008 r2.
I have recently moved my farm from 2 servers (1 DB and 1 App/Web) to a very big farm having Many Servers, Clustered ...
1
vote
0answers
79 views
Deploying reports to report server
I posted this question on stackoverflow, but I think it would be better here.
I configured SSRS 2008 on a remote server running under Network Service. I can access the report manager from my local ...
1
vote
0answers
241 views
SQL Server 2008 x64 R2 SP1 - Management Studio installation language
In our production server, the hosting provider installed SQL Server and Management Studio (standard edition) in Spanish, but I would like to have them in English. It's quite difficult to find menu ...
1
vote
0answers
201 views
Unable to access SQL Server 2008 - Cannot Generate SSPI Context
I've had this problem for a few weeks but haven't had time to focus on it until now. My company has a relatively fresh installation of Windows Server 2011, which is also running Microsoft SQL Server ...
1
vote
0answers
43 views
SQL08 ConnectionString: Data Source= vs Server=
For an asp.net webapp, is there a functional difference between a connection string (in Web.config) that uses:
Data Source=[WIN-MachineName]\SQLEXPRESS
vs
Server=[WIN-MachineName]\SQLEXPRESS
Since ...
1
vote
0answers
410 views
Delete the default instance of SQL Server 2008
I'm trying to uninstall SQL Server 2008. I went through add remove programs and deleted all the SQL Server programs which didn't remove the services and the instances... I manually deleted the ...
1
vote
0answers
299 views
SQL Server Database stuck in Restoring… state
I'm trying to configure a mirror for a Test database between two SQL Server 2008 R1 SP1 Servers: A1 and A2
I'm doing a full backup of Test database on A1 and then trying to restore it on A2 with ...
1
vote
0answers
370 views
SQLServerAgent could not be started (reason: Unable to connect to server ) Error 103?
Does anyone know how to make the second SQL instance Agent working on the same MSCS SQL Server 2008 R2 cluster?
In the clustered SQL Server service instance2 i have assigned the same service account ...
1
vote
0answers
87 views
How to create an SSIS package with a Script Component
I am using Microsoft Business Intelligence Development Studio (BIDS) to create an SSIS package. Take into account that is my first attempt with SSIS.
I want to take data from a Source database ...
1
vote
0answers
852 views
Unable to authenticate proxy when starting SQL snapshot agent
I have a Windows Server 2008 R2 install running SQL Server 2008 R2 with all the latest updates etc applied,
I have restored a database from an old image (SQL 2005) and am trying to get web-sync ...
1
vote
0answers
56 views
Suggestion for encrypting database files in SQL 2008 Standard Cluster
I have an SQL 2008 Server configured as a fail-over cluster an have a requirement to have the database files (mdf/ldf) encrypted. We have tried to use EFS for this but there are a lot of issues doing ...
1
vote
0answers
52 views
Asymmetric key to import assemblies
To import the System.DirectoryServices assembly requires the following commands
create asymmetric key asmKey_DirectoryServices
from executable file = 'c:\Windows\Microsoft.NET\Framework\v2.0.5072
...
1
vote
0answers
377 views
Problems with Apache Mod_Proxy and Microsoft's ReportViewer's Reserved.ReportViewerWebControl.axd
I've configured an Apache httpd server (v2.2) as a reverse proxy (with SSL) to a Microsoft IIS website running an ASP.NET application with SQL Server Report Services.
The proxy mostly works but ...
1
vote
0answers
36 views
SQL - progmatically change refresh rate for ALL publishers in replication monitor
How can I change progmattically change the refresh rate of all the publishers in the repliation monitor ? Without going into each one to change it's publisher setttings.
MS SQL SMS 2008 R2
AHIA, ...
1
vote
0answers
95 views
SQL Reporting Server Authentication Issue
I have one web server & one DB server (running SQL SERVER 2008). Both the servers are in different domains. The web server is allowed to communicate(the communication takes place internally ...
1
vote
0answers
366 views
Event viewer filtering - MS Sql server - How to filter logins from outside?
I want to filter event log to show SQL logon that was initiated from other machines, I have thousands of logins from local machine and few ones from other machines. I want to monitor that connections ...
1
vote
0answers
275 views
Need 64bit SQL Server 2008 for Windows 7 64bit OS
I have Windows 7 64-Bit, and I have SQL Server 2008 Developer edition.
Whenever I am trying to install SQL I an error stating that I cannot install 32-Bit SQL Server on a 64-Bit OS, but in the SQL ...
1
vote
0answers
171 views
Alter Fulltext Catalog Reorganize: Any issues to run this during daytime?
I have been going thru documents on Alter Fulltext Catalog Reorganize.
But unlike Alter Index Reorganize, BOL(Books Online) documentation does not mention whether it's possible to run it without ...
1
vote
0answers
110 views
Can encryption be disabled for the login handshake in SQL Server 2005 or 2008
When a client Application connects to SQL Server the login credentials are sent over the network in a TLS Encrypted Handshake Message.
For testing purposes I would like to have the login credentials ...
1
vote
0answers
72 views
Which method of SQL Server 2005 or 2008 Replication is best for ease of field changes?
We need 15 minute warm updates from one SQL Server to another. Log Shipping looks good and appears easy to setup. We are also looking into Transactional Replication. The data only needs to copy one ...
1
vote
0answers
343 views
Strange Values in SYS.DM_TRAN_LOCKS table RESOURCE_ASSOCIATED_ENTITY_ID column
Strange Values in SYS.DM_TRAN_LOCKS table RESOURCE_ASSOCIATED_ENTITY_ID column
I’ve been trying to understand some strange values in the RESOURCE_ASSOCIATED_ENTITY_ID column of SYS.DM_TRAN_LOCKS when ...
1
vote
0answers
311 views
SQL 2008 Database tuning advisor won’t start
For some reason I can't get DTA to connect to my development machine. It connects to a remote DB just fine but when I point it to my dev machine I get an error saying:
Failed to initialize MSDB ...
1
vote
0answers
374 views
sql server using all the memory on the box and throwing timeouts on pedestrian queries
I have max memory set.
But at least 1 time a day the Sql Server hits over 95% of the ram in the box, and page faults for more. In the meantime the website is throwing very obscure timeouts on simple
...
1
vote
0answers
445 views
What side effects are there of uninstalling SQL Server Analysis Services with TFS?
I have a TFS install which I think was never really successfully installed.
I'm using it just for single-developer source control so I don't care about any analysis type functionality.
When trying to ...
1
vote
0answers
304 views
Error while starting synchronize
I'm using merge replication for database synchronization. I'm getting the folllowing error when launching the replication monitor.I can able to access both sides. Stil having the problem.
Error ...
1
vote
0answers
552 views
SSL Thumbprint Registry setting for SQL Server 2008 clustered on Windows Server 2008
I'm deploying an active/passive, two node fail over Windows Server 2008 cluster to support a SQL Server 2008 instance. I'm attempting to configure SQL Server to use a certificate issued by my domain's ...
1
vote
0answers
52 views
Can/Should I have Replication Schema on databases that don't participate in replication?
I'm dealing with several databases, some of which will participate in replication, others will not. Is it possible (or wise) to keep the replication schema on the database that do not participate in ...
1
vote
0answers
3k views
Problems with SQL Server 2008 - “The client was unable to reuse a session with SPID 62, which had …”
I'm having problems with my SQL Server 2008 installation (10.0.2531.0 - SP1 installed). It works as a database server for small hosting environment (about 500 sites).
I'm getting errors like this:
...
0
votes
0answers
23 views
I must have done something wrong installing sample database
I downloaded file SQLEXPRADV_x86_ENU.exe (version 10.00.1600.22), and used it to install SQL Server 2008 Express with Advanced Services, which I think has capabilities comparable to SQL Server 2008 ...
0
votes
0answers
20 views
Identical tables, different sizes?
I have transactional replication with updatable subscriptions going between a few SQL 2008 R2 servers (publisher is Enterprise, subscribers are Express).
I need to add another subscriber, and come to ...
0
votes
0answers
16 views
Proxy DMZ server to bounce data between sql server and clients
Is this feasible?
I have a sql server that is setup behind a corporate firewall. I have clients that need direct connection to that sql server via ODBC. Instead of punching holes in the firewall I ...
0
votes
0answers
47 views
SQL failover cluster on single ESXi host
I'm setting up a virtual environment consisting of 10 VM's with 2 primary SQL databases required. The infrastructure allocates two pairs of SQL 2008 R2 Enterprise edition (VM's). The pairs are ...
0
votes
0answers
14 views
Using SSMS, how do I add a row to when a column is read only?
How do I add a row to when a column is read only? I think this issue I am having is because I am using an ID field (column) that is automatically generated and incremented whenever a new row is added ...
0
votes
0answers
38 views
SQL Server 2008 R2 Analysis services not starting
Folks,
I installed SQL server 2008 R2 on windows server 2008. During installation there was an error "MSSQLSERVEROLAPService could not start" but the installation continued and I was able to complete ...
0
votes
0answers
39 views
SQL Server 2008r2 SP2 Manual Install Error
I am receiving an error I have never seen before, nor can I find any info on the net. When I try to install SP2 for SQL Server 2008r2 I receive the following error.
Cannot find the value of the ...
0
votes
0answers
73 views
Download SQL 2008 R2 and install remotely with key
I have the media and product key for a copy of SQL Server 2008R2, however, I can not get my CD to the server at my data center. Is there a downloadable version (or can the trial be downloaded) of the ...
