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

Access rights with Views

I'd like to be able to create a View in one database (let's call this Database A) that is comprised of selected fields from a particular table in another database (Database B). However, I'd like this view to be accessible by a user that has…
Kyle
  • 165
  • 2
  • 6
0
votes
1 answer

Diagnosing SQL Server 2008 Timeout After Prolonged Use

After every few days of faultless operation, the following information event pops up in my database server's event log: Process 0:0:0 (0x890) Worker 0x5C55A0D8 appears to be non-yielding on Scheduler 0. Thread creation time: 12945965386972. Approx…
Petrus Theron
  • 1,601
  • 5
  • 17
  • 24
0
votes
1 answer

SQL join between two tables in different databases

I'm new to SQL, so need a little help. I have to join two tables which are in two different databases which are on different servers. Can someone please tell me how can I do that?
sharepoint99
  • 1
0
votes
1 answer

Sharepoint Foundation License Costs

Possible Duplicate: Can you help me with my software licensing question? This question keeps getting asked however I could never get a straight answer. So I'm asking it clearer: If I have Windows 2008 R2 Web edition and I'm using Sharepoint…
user61925
0
votes
1 answer

SQL Server 2008: Mirroring: Threshold Alerts at Database-Level

Testing I have completed to date seems to indicate that the following Threshold Alerts need to be defined for the Database Name rather than a single named database: Unsent Log Threshold (Error Message 32042) Oldest Unsent…
EngineeringSQL
  • 275
  • 1
  • 2
  • 8
0
votes
1 answer

SQL database login failed for Windows Sharepoint Services 3 with TFS 2010

I had to restore a TFS 2010 virtual machine and am having trouble getting WSS running. When I try to go to the Sharepoint Admin portal localhost:17012 it fails. In the event viewer I see a bunch of SQL database login failed. Addition error…
kenwarner
  • 265
  • 2
  • 5
  • 16
0
votes
1 answer

Setting up individual accounts to a SQL Server

I am attempting to setup a MS 2008 sql server that would allow many users access to there own private databases. I would like the adventure works databases installed on all of these as well. My question is there an easy way to script this task of…
Pieces
  • 145
  • 6
0
votes
1 answer

upgrade to SQL Server 2008 R2 failed

I am trying to upgrade my SQL Express to SQL Server 2008 and it gives me the following warnings. It always says that a previous installation exists but I already uninstall all things related to SQL Server 2008. I also tried doing a repair from the…
EquinoX
  • 367
  • 3
  • 11
  • 27
0
votes
1 answer

Can't uninstall Reporting Services on SQL 2005 (SBS 2008)

I am running SBS 2008 and have just installed SQL 2008 alongside SQL 2005. My understanding is that the default instance created in SQL 2005 is not needed and only the SBSMONITORING instance is needed. I have removed the default instance (as i want…
mwillmott
  • 242
  • 2
  • 8
0
votes
1 answer

FAIL_VIRTUAL_RESERVE on SQL 2008 SP2

My environment is SQL 2008 Standard x86 with SP2 running on Server 2008 Standard, with 4Gb ram and AWE enabled. I also have -g1024 set as a startup parameter. I am getting the following error in the SQL error log: Failed Virtual Allocate Bytes:…
Craig
  • 103
  • 4
0
votes
1 answer

SQL Server 2008 is not accessible from Windows Server 2008?

I have successfully configured Windows Server 2008 Enterprise SP2 with SQL Server 2008 Enterprise SP2 all 64 bit, however when I tried to access this particular SQL Server 2008 DB instance from another SQL Server 2008 SSMS in another Windows Server…
Senior Systems Engineer
  • 1,275
  • 2
  • 33
  • 62
0
votes
2 answers

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 present. I've tried the step at the following question:…
Alex
  • 103
  • 1
  • 4
0
votes
1 answer

How to configure SSL on an instance of SQL Server to allow dedicated users to remotely access it?

I have configured the instance of SQL Server to allow dedicated users to access it remotely. Connection string Data Source = 192.168.1.2,1433\sqlexpress;etc... has been tested and works. However, I have not configured the SSL to secure the…
LaTeX
  • 111
  • 1
  • 2
  • 11
0
votes
1 answer

Can't Mirror Database on Sql-Server 2008

I'm running two MS-SQL instances to create a mirrored-database environment, I have an instance in a Virtual Machine and another instance, alongside the witness, in the physical machine. I know this isn't the best configuration but this is for…
PedroC88
  • 131
  • 3
0
votes
1 answer

SQL server port is blocked on client machine

Possible Duplicate: SQL server port is blocked on client machine I have a client machine on which sql server is installed. This machine is using the internet though a proxy machine. On the proxy machine wingate is installed. I could not connect…
Tassadaque
  • 101
  • 3
1 2 3
…
99
100