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
1answer
109 views

Remote restore of DB in MSSQL 2008

I have a remote MSSQL server meant to centralize SQL for development projects. I hand out DB's and access to developers as they need it. I do not want to give them access to filesystem in any way ...
1
vote
1answer
322 views

NHibernate won't connect to SQL Server

I have 3 SQL Server instances running on our server (dont ask why)! 2xSQL Server 2008 Workgroup (Default and MSSQLServer2) 1xSQL Server Express 2008 R2 (sqlexpress) Now I have a Windows Service/App ...
1
vote
1answer
292 views

what instance name in connection string for Dynamic management Views

I want to run the following query :: SELECT S.* FROM sys.dm_exec_requests S JOIN sys.dm_exec_sessions R ON r.session_id = s.blocking_session_id It works when i run it in SQL Server Console. ...
1
vote
1answer
656 views

SQL server 2008 can't open after installing windows update

I have recently installed windows update on my windows server 2003 machine. After updates when i open sql server 2008, i'm getting a wired error: 'Failed to open connection dialog - object reference ...
1
vote
1answer
77 views

Setup SQL Server replication for schema only or schema + nightly data

We have 2 offices that we would look to keep our databases in sync with. Unfortunately one of our officers has a really poor connection and doing live SQL replication of the data probably isn't ...
1
vote
1answer
181 views

SQL 2008 R2 3rd Party Peer-to-Peer Replication, Global Site Distribution

We are looking at hosting 3 globally distributed SQL Server installations at different data centers. The intent is that Site A will serve web traffic and data for a specific region, same with Site B ...
1
vote
1answer
109 views

SQL Server 2008 Audit Service

I'm designing an application that will run on SQL Server 2008 R2. There's a requirement to audit any updates to a customer table. The new Audit service that was release as part of SQL Server 2008 ...
1
vote
1answer
440 views

SQL Server VSS Writer, Hyper-V and SQL Server 2008 backups

I have a virtual server running SQL Server 2008 R2. On the server I have configured two maintenance plans, one that takes differential backups every day except Saturday and a job that takes full ...
1
vote
1answer
287 views

Database maintenance plan fails to run everytime

I currently setup a DBMP for SS2008 and i explicitly set it to run under a user that is the the serveradmin role. Also in the job (under sql server agent) generated from the above plan is set in the ...
1
vote
1answer
56 views

How do I see processes from all users in SSMS2008?

I only see my own connections/processes in the new activity monitor... whereas in the earlier versions of SSMS you could see everyone's. Do I need to change a setting or something?
1
vote
1answer
127 views

Best database structure for an Admin Portal to a web service

I am primarily a web developer, not a DB admin, so hence this question! We have a webservice that we have created which has a Database on our SQL 2008 server. We are currently creating a web portal ...
1
vote
1answer
137 views

SQL Server Authentication vs Windows Authentication

I am a SQL Server newbie and would really appreciate any help. I have created a new login (test2) with sql server authentication and granted select & vierw definition permission on another schema ...
1
vote
1answer
150 views

Is there a convenient way to manually copy the Log Shipping *.trn files from one SQL 2008 server to another?

We have a remote SQL 2008 server (ServerB) that needs to keep a warm (15 minute interval is OK) copy of production data (ServerA). ServerA is also SQL 2008. Log Shipping looks like it will do the job. ...
1
vote
1answer
557 views

How to setup certificate authentication for MS SQL server 2008 R2?

I have to connect an (ADO) application running on a standalone Windows 2003 R2 server to a SQL 2008 R2 database that is a member of the domain. I have setup an SQL authentication account for this and ...
1
vote
1answer
233 views

Need help with setting up MS-SQL on EC2

I have a large MS-SQL database that i need to send to the aws cloud. The issue is how do i persist my sql data and how to setup MS-SQL cluster using windows AMI. The real issue is that for ...
0
votes
1answer
40 views

SQL Server Multiple Instances but showing the same databases

I am running SQL Server 2008 R2 Standard Edition and need to have multiple instances which I have installed. However, when I restore a database onto one instance, it is showing up on the other ...
0
votes
1answer
113 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: ...
0
votes
1answer
77 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
1answer
655 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
73 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
52 views

SSIS Execute from Job on server - Show Colors on package

We are running SSIS on SQL Server 2008 R2 I have a SSIS package that gets executed from a job on the server ever morning and it can take a few hours to complete. When you execute the package from ...
0
votes
1answer
349 views

Login failed for user 'sa'. … [CLIENT: 59.48.47.215]

I have an Amazon EC2 instance and i don't have anything running on it yet but my event log is full of below error "Login failed for user 'sa'. Reason: An attempt to login using SQL authentication ...
0
votes
1answer
204 views

SQL 2008 R2 User Connections and Total Server Memory counters spike at the same time on multiple servers

We use SolarWinds SAM software to monitor servers and applications. We started using it to monitor our SQL servers through the performance counters. We started getting alerts two to three times ...
0
votes
1answer
82 views

sa account not working anymore on SQLServer2008

I have been running SQLServer 2008 for some years now on my laptop. At a certain point I cannot login anymore with my sa account (mixed authentication turned on). I get the error message 233. This ...
0
votes
1answer
128 views

SQL Port 1433 needed in SQL Server2008 IP Field for remote connection

I just installed SQL Server 2008 on my server. I do it often enough to forget what to do so I read through a couple of MS installation instructions. I installed with no issues. I tried to remote ...
0
votes
1answer
131 views

Real trouble for opening port in SQL Server 2008

I'm having trouble trouble opening port in SQL Server 2008 R2 Express Edition (http://www.microsoft.com/en-us/download/details.aspx?id=30438) even by disabling the Firewall. I also installed the ...
0
votes
1answer
40 views

How to allow a SQL Login to see only ONE database

i have a SQL Server server 2008 r2. I wish to create a two new Login for a client who wishes to have access to their one database. But I don't want to give them access to the other my databases. ...
0
votes
1answer
547 views

Cannot Connect to SQL Server 2008 R2 from Sharepoint Server

I have installed SQL Server 2008 R2 on dbserver and Sharepoint 2010 on webserver. When trying to configure Sharepoint to use the database installed on dbserver, it says it cannot connect. Then I ...
0
votes
1answer
41 views

Problems restoring local instance in SQL Server 2008 R2 Express

I have set up a local instance in SQL Server 2008 R2. I have a database (called GD_LOCAL_TC) that I need to restore so I can begin working in it (right now it's empty). When I right click on ...
0
votes
1answer
159 views

Best Practices Analyzer for Microsoft Dynamics AX 2009

We recently uncovered a potential issue with our Dynamics AX setup whereby Receive Side Scaling (RSS) was not enabled on our AOS servers, which we believe is limiting their performance (currently ...
0
votes
1answer
88 views

How to best move system DBs from SQL 2005 to SQL 2008 R2?

I'm in the process of moving from SQL 2005 to SQL 2008 R2. Moving the production DBs and logs is straightforward, through either detach/attach or backup/restore. (new hardware, so I have the old ...
0
votes
1answer
34 views

MS SQL - syncronising “a view” to another MS SQL server

Let me open by saying that I am no MSSQL expert. I'm a linux admin, so please forgive me if I should know this. I've been asked to syncronise a view or a table from one MSSQL database to another. ...
0
votes
1answer
244 views

SQL Server 2008 intermitent error 40 running parallel queries

Here's our setup : We are using Red Gate SQL Multi-Script to run queries on our ~1000 databases which reside on a single SQL Server 2008. SQL Multi Script can be configured to run queries in ...
0
votes
1answer
181 views

HA Options for Windows Servers

We are looking at different options to allow us to stay up and running when our primary datacenter (DC1) goes down for any reason. What is the main difference in having a offsite server updated all ...
0
votes
1answer
561 views

Package run on SQL Server Job Agent - Login failed for user

I created a package on my SQL Server (2012) through the import/export data wizard which exports data to another SQL Server (2008). I set up a job which runs this package but I get an error: ...
0
votes
1answer
26 views

installing a second instance of SQL Server 2008

I am trying to install second instance of SQL Server 2008 enterprise edition in my window 7 machine using network server, local service, and my admin account. However I keep getting the below error. ...
0
votes
1answer
624 views

Error in install sql server 2008 rn

When running the SQL Server 2008 setup, I receive the following error message: TITLE: Microsoft SQL Server 2008 R2 Setup The following error has occurred: Unable to open Windows Installer file ...
0
votes
1answer
200 views

Create Report in Microsoft Excel - Permissions Issue in Team Foundation Server 2010

I am trying to use the feature "Create a Report in Microsoft Excel" for Visual Studio TFS 2010. I am being prompted for a username and password in Excel for any given Team Project when right clicking ...
0
votes
1answer
650 views

How can I uninstall SQL Server Express from Windows Server 2008?

I installed Windows Server 2008 as my OS, but I dislike the SQL Server Express which it provided by default, so I changed to SQL Sever 2008 Enterprise. The problem is, I don't know how to remove the ...
0
votes
1answer
82 views

SQL Server 2005 connection to SQL Server 2008 R2

I having trouble with SQL Server 2008 R2 Express. I installed it and the service is running but SQLexpress, but without success. I even tired to uninstall SQL Server 2008 R2 and I could it said that I ...
0
votes
1answer
29 views

Login Failure issue - SQL Server 2008 SETUP on Windows Server 2008

Hi I am trying to upgrade Edition on SQL server 2008 on Windows Server 2008 and while the Setup it checks all the system requirements and When in the end i click Upgrade It gives me error that ...
0
votes
1answer
509 views

How to add linked Oracle server to SQL 2008 Express?

I have tried to download Oracle Client 11g both 32 & 64 packages to Windows 2008 R2 with SQL server 2008 Express. However, I still cannot see Oracle provider in SQL server by using sa log in. Not ...
0
votes
1answer
113 views

Data transfer between servers extremely slow

I have an application running on a Live environment with a Web Server which is running Windows Server 2008 R2 with a QuadCore Xeon processor with 8GB of ram and a Database Server with the same ...
0
votes
1answer
52 views

SQL Server NIC Power Saving

We have a server running Windows Server 2008 which is dedicated to hosting a SQL Server 2008 Database. Whilst auditing the server OS we have noticed that the NIC Power saving feature is enabled. ...
0
votes
1answer
287 views

SQL Server filestream access from another computer using system account

I have a SQL Server 2008 set up to use filestream. SQL Server runs under a domain account with SPN set and delegation enabled. Accessing filestream from another computer using a domain account works. ...
0
votes
1answer
445 views

how can connect from client to sql server 2008 via proxy

I have SQL Server 2008 in dedicated server and all port of SQL Server is blocked with firewall. I have VPS with CCProxy on it. I opened all ports in dedicated server for my VPS server IP. I set proxy ...
0
votes
1answer
378 views

sql server 2008 r2 can connect with connection manager but noway else

I have installed (3 times on 3 machines) sql server 2008 r2 can connect with connection manager but other program cannot connect. I can connect to remote sql servers with heidisql or with my ...
0
votes
1answer
661 views

Connecting to a SQL Server instance via connection string does not work

Why does this work to connect to my remote SQL Server database: var srvConn = new ServerConnection("sql01"); srvConn.LoginSecure = false; srvConn.Login = ...
0
votes
1answer
1k views

Unable to save view: “There is already an object named 'Quotes' in the database.” - Error 1222

I often get the aloof error message above, after trying change a view in SQL Managment Studio 2008. I right-click on a view, select 'design', make a change (or not), and click the Save button. It ...
0
votes
1answer
300 views

how can I determine that I am consuming SQL CAL license?

assuming I have bought 5 User CALs and now I need to tag these licenses, can some tell me how to determine this?