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

learn more… | top users | synonyms

0
votes
1answer
8k views

“There are currently no logon servers available to service the logon request” when trying to remote desktop to a VM after a power failure

I have SQL Server 2008 R2 running on a virtual machine (vmware, Windows Server 2008 R2). I was connected to the SQL Server from another virtual machine via SQL Server Management Studio, then a power ...
3
votes
4answers
19k views

How do I install SQL Svr Native Client 10.1 after SQL 2012 has been installed

On a Windows Server 2012 I have SQL Server 2012 installed which has the SQL Server Native Client version 11. I am being told by a developer that he needs the SQL Server Native Client version 10.1 ...
21
votes
6answers
64k views

How to rename a SQL Server 2008 instance?

How can I rename a SQL Server 2008 instance without reinstalling? For example, if the db is referenced as "MySQLServer\MSSQL2008", how can I rename to "MySQLServer\SQL2008"?
3
votes
3answers
100 views

What is the standard method to keep track of the latest Cumulative updates for SQL Server?

What resources are good for keeping track of cumulative updates for SQL Server? I noticed that Windows update does provide a service for SQL Server.
0
votes
1answer
784 views

sql server 2008 cluster hang when a heavy load is run

we have a sql server 2008 active/active cluster running on wondows 2008R2 O/S. 14GB RAM, 4xCPU. we have set a ceiling of 12GB for sql server. We're running an agent job which loads 3 million records ...
0
votes
1answer
7k views

SQL Server instance service doesn't start

After manually stopping SQL Server instance service it can not be started both manually from a SQL Server Configuration Manager and automatically by restarting computer. If trying to do it manually I ...
1
vote
1answer
354 views

Where is my SQL Server 2008 R2 / Windows 7 install? [closed]

I ran the SQL Server 2008 R2 Install on my Windows 7 Professional (32bit) os. Everything ran fine, no errors. I ran the SP1 install, again, all green, no errors. I run the System Configuration Checker ...
6
votes
1answer
98 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
173 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
47 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 ...
2
votes
2answers
2k views

SQL 2008. I have user in a db which has no login on the server. How is it possible?

I am talking about windows authentication. I dont have access to the server adming rights but a dbadmin sent me screenshot where my user is not in the logins of the server. and also there is only one ...
1
vote
3answers
652 views

Trigger Powershell Command to Copy SQL Backups to Network Drive

I've got two servers on a workgroup and I need to transfer my SQL Server 2008 Backups from the local drive of one to a network drive on another. Ideally, I'd like to have SQL call the Powershell ...
0
votes
1answer
340 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 ...
2
votes
2answers
578 views

Perfmon for SQL Server from local machine

I'm following Brent Ozar's video on Benchmarking and Baselining, and I've got a data collector set on my local machine set up to hit a remote sql server, but I can't get the collection to start. I ...
2
votes
4answers
432 views

SQL Server Monitoring Packages [closed]

I'm looking into purchasing a SQL Server monitoring system. It should work with 2005/2008. We would like to monitor performance, availability, backups, jobs and various database issues (space) What ...
0
votes
5answers
4k views

How can I disable the windows authentication mode of SQL Server

How can I disable the windows authentication mode of SQL Server and restrict it to ask for username and password every time, with no windows authentication?
12
votes
3answers
8k views

How do I remove a specific bad plan from the SQL Server query cache?

We have one particular SQL Server 2008 query (not a stored proc, but the same SQL string -- executes every 5 minutes) that intermittently caches a very bad query plan. This query normally runs in a ...
4
votes
3answers
4k views

Tracking SQL Server 2008 Timeout Errors

we got some connections timeouts running a stored procedure in a SQL Server 2008 instance. after a while, the DB started to work as usual, and there weren't any additional timeout errors. So I'm ...
17
votes
2answers
30k views

“'' is not a valid login or you do not have permission” on sql server installation

I have tried installing SQL Server 2008 multiple times on my machine, and I always receive this error about 3/4 of the way through: '' is not a valid login or you do not have permission. I use SYSTEM ...
2
votes
2answers
4k views

SQL Server remote backup query fails “cannot open the backup device”

I am trying to configure my scheduled backups of a MSSQL database to a mapped network drive, which is on a fileserver running Server 2003 Standard. Query reads like this: BACKUP DATABASE XXXX TO ...
1
vote
2answers
1k views

Installing a new SQL Server instance fails

I've previously in my setup installed SQL Server Express 2005. Now I've switched to SQL Server Express 2008. I updated the command line parameters to those documented for the latter. If the comp ...
0
votes
1answer
417 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 ...
3
votes
1answer
3k 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 ...
3
votes
2answers
1k views

repair suspect database

My sql server 2008 told me that you database is suspect and I can't see my tables or my data or use it what should I do ?
0
votes
2answers
2k views

SQL Server 2008 Express R2 restores after restart (and fails)

Almost every time I restart the machine hosting a SQL Server 2008 R2 express server, the database goes through the restore process. Most of the time, the database will become stuck in the restore ...
0
votes
2answers
58 views

Resources for SQL Server programming?

I have tried to search from the web resources for SQL Server programming. Basically I'm trying to search good tutorial for programming SQL Server (creating procedures, triggers, cursors etc.). Can you ...
2
votes
2answers
2k 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 ...
14
votes
1answer
24k views

What can user do with VIEW SERVER STATE permissions?

In SQL Server 2008 there is a permissions VIEW SERVER STATE. What rights this permission give to user? What SQL Server mean by SERVER STATE?
0
votes
1answer
824 views

SQL Server 2008 installation (not working)

I'm trying to install SQL Server 2008, but have been unable to do so. I've tried uninstalling and even manual un-installation. I've tried following this guide ...
1
vote
2answers
3k views

SQL 2008 R2 replication error: The process could not connect to Distributor

I have two servers running SQL 2008 R2 Standard, each with an instance named "MAIN". I have a small test database on my primary server (one table, 13 rows) that I want to replicate to a second server ...
2
votes
3answers
8k views

MS SQL Server 2008 sa account locked out and Windows Authentication login is greyed out

The sa account got locked out and even though mixed mode authentication is enabled. When I select "Windows Authentication" the Username and Password fields are greyed out. The username field contains ...
0
votes
2answers
1k views

SQL Maintenance Cleanup Task Working but Not Deleting

I have a Maintenance Plan that is suppose to go through the BACKUP folder and remove all .bak older than 5 days. When I run the job, it gives me a success message but older .bak files are still ...
1
vote
2answers
92 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 ...
0
votes
1answer
4k views

SQL Server 2008 R2 Transactional replication ports

http://technet.microsoft.com/en-us/library/cc646023.aspx states Replication connections to SQL Server use the typical regular Database Engine ports (TCP port 1433 for the default instance, etc.) ...
0
votes
1answer
1k 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
667 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
78 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
2answers
88 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 ...
2
votes
1answer
378 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 ...
0
votes
1answer
99 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 ...
1
vote
1answer
340 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 ...
8
votes
1answer
3k views

Alias to SQLEXPRESS

I have developer edition from SQL Server 2008, but now I have a piece of software with a hardcoded connection string: Data Source=.\SQLEXPRESS;Initial Catalog=db;User Id=sa;Password=1234; Now I ...
0
votes
1answer
119 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
3answers
325 views

“Virtual” shared storage for SQL Server 2008 R2 Cluster

I am trying to set up a virtual test environment for a SQL Server 2008 R2 Cluster (2 nodes) running on Hyper-V. The cluster requires a shared storage to function properly, however in this test ...
0
votes
4answers
14k views

Can't access SQL Server 2008 from workstations, but can from server

We have an app that can use mssql2k or 2k8. We've been using 2k but I decided to try 2k8 to compare. I installed in on our win2k3 server alongside mssql2k. In the ODBC applet on the server, I was ...
1
vote
1answer
48 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 ...
0
votes
1answer
3k views

How do I uninstall an instance of SQL Server 2008 from my computer?

I've just set up SQL Server 2008 Express on my computer, kind of as a learning tool. Unfortunately I've seem to installed a number of instances to get it working. I would like to uninstall all but one ...
1
vote
3answers
133 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 ...
3
votes
2answers
11k views

SQL Server Trial Edition to Full Edition

I installed SQL Server 2008 R2 for the 180 day trial. We tested the system and it's working fine, and I wanted to convert it to full version. The problem is, I have a volume key licence to SQL ...
0
votes
1answer
153 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 ...