Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008]

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

SQL Server 2008 is Microsoft's version of SQL Server following SQL Server 2005. A list of the new features can be found here

1806 questions
0
votes
1 answer

How was the MSSQL Server database erased in the production server (that is a different version? )

I'm asking for help understanding what happened in my situation or what and if I did something wrong. I have production server running on a Windows 2003 server with MSSQL Express 2005 with an app (production server). I was told to prepare a test…
Feiticeir0
  • 434
  • 3
  • 11
0
votes
6 answers

SQL 2008 install on Windows Server 2008 Permission Denied errors

When trying to install SQL 2008 on W2K8 I get about 6 permission denied errors even though I'm installing logged on as a domain admin? Any one else experienced this? Thanks John Overall summary: Final result: SQL Server…
John
  • 343
  • 2
  • 6
  • 13
0
votes
2 answers

Change SQL Server FileStream Path

I would like to change the path for a SQL Server Filestream but I can't find any information on this. I know how to change the mdf and ldf filenames, but can't seem to find how to change the folder name where the FileStream stores the data.
Lieven Cardoen
  • 517
  • 2
  • 8
  • 17
0
votes
1 answer

Does SQL Server 2008R2 Express come with the reporting services?

I can't find any reference anywhere to it. If so, how do I enable it and access it? The only application that I could find that was related was the Reporting Services Configuration Manager. If Express does come with it, how do I activate and use it?…
Sam
  • 171
  • 2
  • 8
0
votes
2 answers

downgrade SQL Server 2008 R2 to SQL Server 2008

I want to downgrade SQL Server 2008 R2 to SQL Server 2008. I am using Window Server 2008. Any reference documents? thanks in advance, George
George2
  • 1,137
  • 6
  • 22
  • 41
0
votes
1 answer

Upgrading 32-bit SQL Server cluster to 64-bit

Here is my situation. $WORK has a trio of three clustered database servers (64-bit Server 2003) that are currently running two SQL Server instances. Unfortunately, when the cluster was set up a couple years ago my organization did not have 64-bit…
Nathan
  • 3
  • 1
0
votes
2 answers

The Transactional Log is Full

I am getting below error. The transaction log for database 'CRM_QA_V6' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases likely created by IncludeExceptionDetailInFaults=true When I…
sachin kulkarni
0
votes
1 answer

Connect to SQL Server from web application doesn't work?

I'm trying to connect to my SQL Server express instance from my ASP.NET web application but it doesn't work. The generic error message given to the application is: Cannot open database 'xxx' requested by the login. The login failed. Login failed…
Ropstah
  • 205
  • 5
  • 11
0
votes
2 answers

Remote connections allowed, firewall off, SSMS still can't find SQL Express

My remote server running 08 R2 can connect to it's SQLExpress instance via SSMS. db Properties has 'Permit remote connections ticked'. Firewall off doesn't help. Another thread here shows 'sqlcmd -e -s ip\instance' as a suggestion - i'm not familiar…
justSteve
  • 859
  • 1
  • 7
  • 19
0
votes
2 answers

How to backup a remote SQL Server, and apply the backed up data?

I have a SQL Server 2008 running on a remote host (I bought it through a webhosting company). My website is ready for testing, and I need to backup the database, so I can reset everything that I wrote in the tables, when testing is finished. What I…
Nanek
  • 1
0
votes
1 answer

Transactional Replication from SQL Server 2008 to 2000

I has transactional replication from my server1 (MS SQL 2000) to server2 (MS SQL 2000) in another company (and on different network) and it worked OK. Instead of using real name of server2, I used alias referring to IP address of server2. Now, I…
YG100
  • 1
0
votes
1 answer

Error installing SQL Server 2008

I keep getting the following error when trying to install SQL Server 2008 R2, during the Server Configuration Screen: The full-text service account must be a domain account on windows 2003 domain controller. I have tried putting in a active…
xrum
0
votes
1 answer

SQL Server Express 2008 R2 with old Management Studio?

On the same machine with SQL Server 2008 R2 Express installed, can the last stand-alone version of the Management Studio be installed? That would be SQL Server 2008 Management Tools. Or does it have to be the latest version that comes with the R2…
Nicholas
  • 245
  • 1
  • 4
  • 12
0
votes
1 answer

Microsoft Dynamics 2011 and SBS2008

Got a question for anyone with Microsoft CRM 2011 experience. According to this page I can run Microsoft Dynamics CRM 2011 on a Small Business Server 2008 Standard as long as I install SQL Server 2008 R2. Well, i've installed SQL Server 2008 R2 but…
Tom
  • 745
  • 3
  • 9
0
votes
2 answers

Is it possible to set up multiple named instances running on a SQl Server 2008 R2 Active/Passive Cluster?

I'm trying to plan a SQL Server 2008 R2 2 node Active/Passive failover cluster. Is it possible to set up multiple named instances running on the cluster? e.g. sqlcluster sqlcluster\demo sqlcluster\dev And could demo and dev share the same SAN…
Kenny
  • 520
  • 1
  • 9
  • 24
1 2 3
…
99 100