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
187 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
44 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
57 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
245 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
43 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
46 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
125 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
98 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
167 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
148 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 ...
0
votes
1answer
73 views

Migrate existing database to mirrored database on Azure

I have setup 3 Sql VM's on Azure for database mirroring as described in this link with the idea being that we move our current database, which is currently on a single VM outside of Azure. Everything ...
0
votes
2answers
2k views

Offline database can't be restored: Exclusive access could not be obtained

I'm practicing a SharePoint 2010 to 2013 migration and having trouble restoring a database. After backing up a database on a SP2010/SQL 2008 server, I'm trying to restore it to a database I've freshly ...
1
vote
1answer
30 views

SQL Server 2008 - Difference between server and database permissions

And I think I'm almost there conceptually. I think I just need a few example/confirmations to bring it home. 1) My understanding is that server permissions ...
-2
votes
1answer
69 views

Processing data faster using ssis and an ssd drive

We have a new local server that processes data using sql server 2008 and ssis. in this server i have dedicated drive to do different things. the c drive is for the os and software. the d drive is for ...
0
votes
1answer
1k views

SQL server databases are stucked in restoring state

I have a single server in my SharePoint 2010 server farm. Today some of users complained about that some of Infopath forms can not be opened. When I checked the SOL Server Management Studio I saw that ...
1
vote
3answers
71 views

Restore MS SQL 2008 Database from files

is it possible to restore a MSSQL server by copying its directory/data files? I have a damaged hard disk and was able to salvage the C:\Program Files (x86)\SQL Server 2008\MSSQL\MSSQL10.MYDATABASE ...
2
votes
1answer
119 views

SQL Named Pipes across Site to Site VPN

Running into SQL issues and I can find the exact problem already posted here on SF. I have a SQL server running on a 192.168.16.x subnet on one side of a site to site VPN. I have a workstation on a ...
1
vote
3answers
208 views

SQL Backup Is Taking All My Hard Drive Space

I have a job that I run every day to backup my SQL database. I just bought a band new server and was going to transfer the database backup over to the new serer and restore it. Our database isn't as ...
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
203 views

How to create a new sql server instance without installation media

I'm relatively new to SQL Server installations ( however I use extensively the Management Studio), the situation is that I have a server (machine) where the SQL Server has been installed ( not by me ...
0
votes
2answers
85 views

Possible to take a backup of SQL Server 2012 DB and restore on 2008?

I want to take a backup of SQL 2012 and restore on 2008, is that possible ? I have this options which I can't change on DB. Thank you
1
vote
1answer
624 views

SQL Server 2008 R2 error: 18456, state 1: login failed for “domain\username”

I can't seem to authenticate to my SQL server using the following command: sqlcmd -S myserver -d mydatabase -U user -P password It always says, error: 18456, state 1: login failed for ...
0
votes
0answers
726 views

SQL Server Error - HRESULT E_FAIL has been returned from a call to a COM component

I have a huge 200MB .SQL file. When I try to open this in SQL server management studio 2008, I get the error -Error HRESULT E_FAIL has been returned from a call to a COM component. What could the ...
1
vote
1answer
78 views

SQL Server does not enforce encryption rules

I am forcing encryption on my MS SQL server. My intention is to reject any client connection that does not use SSL to connect. Here are my detailed steps : makecert -r -pe -n ...
1
vote
1answer
234 views

Cannot Connect to MsSql2008 R2 Database Engine, While Connecting to Other Services

I have installed MsSQL 2008 R2 on my computer as I have installed always before. But unfortunately this time, I cannot connect to Database Engine while I can easily connect to the other services like ...
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
252 views

The timeout period elapsed prior to obtaining a connection from the pool

I have a WPF application which I want to use on multiple machines. I can connect to it on the same machine but I can't connect from another machine. I know I have to enaple TCP/IP connection and I ...
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
0answers
47 views

Dummy transaction to check if a system is up

We want to send a dummy transaction through our system (Application - DB) to ensure it is still up every minute. If the transaction fails we are alerted - Thereby knowing within a minute if there is ...
-1
votes
2answers
1k views

Can there be two machines with the same server name (SQL SERVER) in the same network? [closed]

I have a program in excel that connects to several sql servers using servername and instance. My question is, what would happen if there are two servers (machines) with the same servername in the same ...
3
votes
1answer
2k views

dbcc checkdb('XYZ', REPAIR_ALLOW_DATA_LOSS) indicating that XYZ is already open and can only have one user at a time

I have a DB, XYZ, that had a corrupt log file and now since the log file is totally unusable this is rendering this specific DB unusable and I need to be able to rebuild it. I've already done a lot ...
0
votes
2answers
28 views

SQL 2008 Failure after compressing HDD

I've absent-mindedly let Windows Server 2003 compress a HDD to try and save some space. That same drive contains an instance of SQL Server 2008. Since compressing, all the Databases have taken ...
-2
votes
1answer
57 views

Is is safe to upgrade SQL server 2008

I have a windows vps with sql2008 express r2 (with tools) installed, one of my clients require full-text search feature. Sql 2008 with advance services has that feature. So my question is, is it ...
0
votes
1answer
50 views

Restore From Database not showing database I want to pick

In Management Studio I want to restore to a point in time from an existing database. However, the databases that I can choose from in the drop down list don't include the one I want to choose. And ...
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 ...
2
votes
2answers
2k 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
0answers
1k views

SQL Server 2008 R2 Express connection error

Hi I'm having issues with SQL connection for a client PC We have software that uses SQL database, and I have just updated from SQL2005 to SQL2008 We have 5 pcs: 2 x vista (32 bit) 2 x win7 (64bit) ...
-1
votes
1answer
47 views

SQL Server 2008 R2 memory consumption for no usage [closed]

I have a application that uses SQL Server 2008 R2. I have a problem of memory consumption on the client side. Whenever the client runs the application, the SQL server starts consuming memory even if ...
0
votes
1answer
2k views

MSSQL: "Could not allocate space for object 'dbo.SORT temporary run storage in database because 'PRIMARY' filegroup is full

I have been around the block with this issue several times today checking blog posts everywhere and nothing has helped me to fix and resolve this issue. I'm trying to add a non-clustered index to a ...
5
votes
5answers
1k views

Using SAN Replication/Snapshots for SQL Server disaster recovery?

We have a web application that utilizes SQL Server 2008 on a single database server. All storage is local. For the past year we have been trying to get any form of SQL Server Replication to work ...
0
votes
1answer
34 views

SQL Server datafile growths

For SQL Server 2008 what is the maximum number of growths? And which view do I query to find that information for a datafile in my database?
1
vote
1answer
141 views

SQL Databases get stuck in Unavailable State daily

Every day I notice several of my project DBs on SQL 2008 R2 (v. 10.50.2500) get into a limbo state where they are unavailable. They're not technically offline in this case. In Management Studio, ...
1
vote
1answer
887 views

SQL 2008 Reporting Service SSL certificate chain not trusted

I got a SQL Server 2008 Standard Edition installed on a Server 2008 R2, OS and SQL Server got newest Service Packs and updates installed. The SQL Server is up and running but I cant connect to the ...
1
vote
2answers
3k views

How do I find the root cause of Memory pressure failure on an SQL server 2008?

One of the servers I have been performance monitoring started throwing the following warnings from the Resource-Exhaustion-Detector: Windows successfully diagnosed a low virtual memory condition. ...
0
votes
1answer
279 views

SQL Server 2008 side-by-side with SQL Server 2012, possible issues with SAP Business One 8.81 PL:07?

We have a Windows Server 2008 R2 Enterprise system running SQL Server 2008 Enterprise (x64) version 10.0.4067.0 and SAP Business One 8.81 PL:07. We would like to install a named instance of SQL Server ...
3
votes
1answer
227 views

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple ...
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
5k 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 ...
0
votes
1answer
594 views

Backing up database fully from remote server, and restoring to another remote server

I currently have three copies of my website (Live, Staging, and Development), with the database for each on three separate servers. More often not, a bug will appear that requires an up-to-date ...