Tagged Questions

A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

learn more… | top users | synonyms

1
vote
0answers
13 views

SQL 2008 over the internet replication

Please excuse me for the (probably) stupid question, but SQL Server is not my main proficiency here... I have 2 SQL Server 2008 R2 servers, one in an AzureVM and another one in my local datacenter. ...
0
votes
0answers
16 views

Cannot add Domain Users to SQLServer security

I installed a win2008 server (WSQL) Its has successfully joined another Win2008 server which is the domain controller. Now back to WSQL machine, I connect it to the domain... And I install ...
0
votes
0answers
12 views

Unable to view SQL Server Agent while logged in as user

I apologize for asking with insufficient information. I have granted SQLAgentUserRole permission to one of the user in SQL server on msdb database, but when user login in to SSMS using his ...
1
vote
0answers
16 views

MSSQL Server 2008R2 Replication stall, no latency, no errors, missing data on subscriber

This morning after performing a routine database deployment of two new tables I noticed that transactional replication had stopped for more than 3 hours. When replication resumed it picked up 3+ hours ...
0
votes
0answers
11 views

How to determine if insert or update [migrated]

Whenever INSERT is happened in the CUSTOMER table,I need to call the "StoredProcedure1"and UPDATE is happend in the CUSTOMER table,I need to call the "StoredProcedure2" in the Trigger. How to ...
0
votes
1answer
53 views

Sql Server Transaction Log Backup Fails

I have a Sql Server 2008 Standard version. Mirroring is set up on the server in full safety mode. Its been working fine till today. The transaction log back-up fails every-time with an error "Error: ...
1
vote
0answers
78 views

Why does RDP freeze on Windows Server 2008 R2 in a virtual machine during high load?

We have noticed a problem where remote desktop sessions to a server will freeze when the server has high CPU load. Environment: VMWare ESX 4.0u1. Guest OS is Windows Server 2008 R2 (this is the ...
2
votes
1answer
51 views

Error on CMDEXEC job step even with proxy account defined

I’m not yet used to managing permissions on SQL Server 2008. I’m currently trying to create a SQL Server job directly from SQL with a user that isn’t sysadmin (but has the role SQLAgentUserRole). ...
1
vote
0answers
47 views

Unable to apply CU 13 to SQL Server 2008 R2

I am running version 10.50.4033 and would like to apply cumulative update 14. However, I get an error that basically says I'm not at the correct version to apply this patch. I assume I have to ...
0
votes
1answer
34 views

Taking a disk image with Windows Server Backup while SQL Server is running

I'm using Microsoft's Windows Server Backup tool on a Windows 2008 R2 Server running SQL Server 2008. I want to take a disk image of a drive on which SQL Server is running (databases are on the drive ...
-1
votes
2answers
30 views

SQL Mirroring on Live System? [closed]

My project has a SQL 2008 database with production data on it in use at all times. We need to move our entire production network from one hosting environment to another. We've already stood up the ...
0
votes
1answer
40 views

Manipulate SBSMonitoring Database

Our SBSMonitoring database has reached its limit (10GB). I've worked with databases in a previous job and I'm familiar writing SQL queries. Is it safe to delete entries from tables in that database? ...
0
votes
0answers
16 views

SQL 2008 R2 says access denied when logging in remotely

I have an SQL 2008 R2 server and a monitoring server both on the same physical network (but different VLANs). The monitoring server is always connecting to the SQL server to run a query and check the ...
0
votes
1answer
74 views

Backup and restore vCenter 5.5 in a Lab.

I need to take a copy of our production vCenter and run it in a lab for testing purposes. This part isn't my strong point.How do I go about this and is there any official documentation pertaining to ...
0
votes
0answers
38 views

Why is MSSQL 2008 saying @filter_clause is invalid and that articles do not exist when creating a new publication from a script?

I have a snapshot publication on a test server with a pull subscription set up on another test server (both SQL Server 2008 R2). This publication takes a snapshot of a few columns in a few tables for ...
-2
votes
1answer
34 views

0.5 TB SQL Server Database, is it possible to store in a standalone server? [closed]

We are facing the task of storing of 0.5 TB of data in a SQL Server 2008 Server. Is it possible to do it in a standalone server? Later we also want to query for generating statistics of the data (a ...
0
votes
0answers
23 views

SqlServer 2008/2014 different Collation on column names and data?

We're trying to migrate an third party application from DB2 to SqlServer. DB2 seems to be case insensitive when it comes to column names. The problem is that the application for some reason uses ...
0
votes
1answer
50 views

How do I know which node in a cluster answers?

I have set up an NLB with two servers (nodes) which are running the same service. The filtering is single host, because I don’t want them to run at the same time, because there is data in the cache ...
-1
votes
1answer
101 views

Moving SQL Server 2008 R2 Logs Causing Access Denied Error

I have just tried moving the log location for the SQL server 2008 R2 logs as I have a fairly small System disk due to the massive size of the Winsxs folder, and now I am getting the following error in ...
0
votes
0answers
46 views

SQL DATABASE USING VPN

I have a very simple classic asp site on a Windows 2008 Server with an IIS 7.5 that connects to an Sql database on a Sql 2008 r2. the site works perfectly when accessing it both locally from the ...
0
votes
0answers
16 views

SSA sending false job failure emails MSSQL(10.0)

We have a job runs every 3 minutes. We have set up email failure notifications as we are not located at the site. Every few days or so we will receive a number of job failure emails regarding the job ...
0
votes
1answer
56 views

How to locate the cause of a excessive memory in ms sql

We are experiencing memory issues with MS Sql 2008 R2. There appears to be a memory leak that is consistently increasing in memory usage until it gets to about 1.5 gb and then stops. We have used ...
0
votes
0answers
141 views

Removing Orphaned user from MS SQL Server 2008 database fails

I am dealing with an issue where a User is not able to logon with the database Username & Password all of a sudden. In the past I have reported orphaned users by running these 2 commands: USE ...
0
votes
1answer
66 views

Is an HP Proliant 350e Gen8 server appropriate for Primevera and Sage applications? [duplicate]

I want to buy a server to accommodate both the Primevera and Sage applications? Would a HP Proliant 350e Gen8 do? Are there any concerns about this platform?
6
votes
1answer
71 views

Copy SQL Server Databases

I am looking to "move" databases to different servers with minimal disruption to data and service. These databases vary in size from 5GB to 140 GB. I've seen and even used some of the various data ...
0
votes
1answer
37 views

SQL Backup very slow

I takes like an hour to backup my 24GB database. I put the backup on the same disk as the location of the actual SQL database, but I dont think thats the cause. When I execute exec sp_who2, here is ...
0
votes
1answer
57 views

Upgrade from SQL 2008 to SQL 2012: do we need to change connection string?

We are seeing some terrible performance degradation having just upgraded our MVC4 application from SQL 2008 to SQL 2012. Queries run directly in management studio on the database server run somewhat ...
0
votes
1answer
773 views

How can I get SeSecurityPrivilege enabled?

I'm trying to install a hotfix for SQL Server 2008 and failing on the Rule Check with "Setup account privileges" failed. I am running SQL Server 2008 Standard on Windows Server 2008 R2. Searching on ...
3
votes
1answer
1k views

Windows 2008 R2 services not working

EDIT I spawned the Windows events logging service won't start issue to a separate question here I have a strange problem: SQLAGENT won't start Windows events logging service won't start Today I ...
2
votes
2answers
956 views

Windows Server 2003 r2 vs 2008 r2 - Performance for SQL Server [closed]

First off, I'm not a sys admin, just a programmer frustrated by poor server performance… We’re currently running a VM (I believe the host is Win Server 2008) on a newer E5-2650 CPU, 24 GB RAM, at ...
0
votes
1answer
188 views

Database Copy Fails, but nothing fishy in the logs

I am attempting to copy a database from a remote server (sql server 2008) to my local machine (running sql server express 2014). Everything looks great, right up until the job fails at "Execute SQL ...
0
votes
1answer
528 views

Unable to run query in SQL Management Studio because of JIT debugging error

Recently I have built a Windows server 2008 and installed SQL Server 2008 and Dynamics CRM 2011 on it. Everything is working fine but when I open the SQL Server management Studio and try to open a new ...
0
votes
1answer
444 views

SQL Server Virtual Network Name Change Error

I am in the process of configuring a two-node failover cluster for a migration project. We are transitioning a stand-alone SQL Server to a cluster. Environment: 2x nodes with Windows Server 2012 R2 ...
0
votes
0answers
216 views

How do you RESET the SQL Server 2008 TCP/IP Protocol settings back to default?

We have a SQL Server with multiple interfaces and a previous admin wanted to enable TCP/IP protocol to listen on a specific port. I believe that wherever he saw a specific IP address, he replaced it ...
0
votes
0answers
62 views

Remote SQL Server Connection works from SSMS but not from Application

We are troubleshooting a weird issue with our SQL Server 2008 server. The application server runs a windows service that makes a DB connection via a connection string in its config file, and we end ...
0
votes
0answers
81 views

SQL Server 2008 - how to set automatic ANSI to OEM conversion option

I have a product I am installing where the pre-requisite is SQL Server. The product documentation (which is quite old) talks about SQL Server 2000. However I am installing SQL Server 2008. The ...
0
votes
2answers
52 views

Configure MSSQL 2008 to use kerberos authentication

I would like to set my current mssql db (2008 and 2012) to authenticate using a linux kerberos server that I have in my environment . The windows station is in a workgroup and I would like to avoid ...
0
votes
0answers
78 views

Replicate SQL Server to Amazon RDS

I have a SQL Server in a dedicated hosted facility that we would like to have DR for. Is it possible such that the database is replicated out to a SQL Server instance in Amazon RDS? Or would I have ...
0
votes
1answer
65 views

Windows XP Service Dependency Order and SQL Express

Several years ago I built and deployed a system on XP that involved a custom written service that talked to a local 2008 SQL Express instance (that also had a CLR dependency). At the time I set up ...
0
votes
1answer
137 views

How to resolve SSPI context error without changing Service Account from MSSQL

There is a issue while connecting from new Windows 8.1 Clients to SQL Server 2008 running on Windows Server 2008 R2. The SQL Service running under account Domain\mssqlservice on a machine thats works ...
1
vote
1answer
169 views

Connecting to a domain-joined SQL Server from a non-domain client

I struggled for some time yesterday, attempting to log into a SQL Server 2008 instance on a domain-joined server from a non-domain-joined client. The computers in question: -fhsvr is a domain-joined ...
0
votes
1answer
39 views

SQL Server 2008: Host name did not change

I have a SQL Server 2008 installation and I want to upgrade it to R2. During the upgrade process, in the Reporting Services Authentication window, the host name that appeared for the instance name is ...
0
votes
0answers
51 views

Weird issue in RDL on SSRS 2008

I'm the admin for our project's SQL Server 2008, with SSRS Standard Edition. We've encountered 2 issues with one recurring which we suspect it's a bug but we can't find any information on it. These ...
2
votes
1answer
220 views

Software crashing randomly and frequently. MS SQL error

So I just start this job at a small business and they have this software (lets call it "GDB") that crashes. The employees said this software did not have this issue three months ago but until ...
1
vote
1answer
41 views

Unable to connect to MSSQLServer 2008 R2

I have setup SQL Server 2008 R2 on a desktop (Windows 7). All the client protocols are enabled. I am trying to connect to this instance from my laptop. The laptop and the desktop are on the same ...
1
vote
2answers
43 views

Is this the correct way to wait for an idle database catalog before restoring a log (for Sql Server log shipping)?

I want to have a separate instance of Sql Server dedicated to a "reporting" role. I've decided to populate that server via Log Shipping (since mirroring won't work, and Availability Groups is ...
1
vote
3answers
118 views

How to use the join statement in MSSQL correctly? [closed]

I am pretty new to SQL and I already read something about joins , but coudn't find out. I painted my scenario here : I want to update the Firstname of Table1 into Temp1 where the CreateTS of the ...
0
votes
1answer
87 views

SQL Server 2008 R2 Databases “Suspect” after Logs Moved

We have a client using our software with MSSQL and we are trying to solve a problem for them. We work more with MySQL so pardon my ignorance in the ways of MSSQL Server. They have 3 volumes on that ...
0
votes
1answer
116 views

Is an ms-sql/excel connection two way?

When I connect to an external data source on my MS-SQL server using Excel, is it solely an import, or can I edit the data residing on the MS-SQL server right from Excel? I have a user (the DBA, funny ...
0
votes
1answer
109 views

IIS/SQL Server showing RAM is 100% utilized but Processes add up to less than 15% usage

I have a Windows Server 2008 system running IIS 7 and SQL Server 2008 R2 with 64gb of RAM which is showing 100% of the available physical RAM being used at all times. However, when you look at the ...