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
2 answers

SQL Server 2008 Web edition - access from another IIS?

We are planning to purchase and install SQL Server 2008 R2 Web edition for our live servers. The grand plan was to install a shiny new server with this SQL Server (web edition), and change the connection strings on our various web-apps on two other…
Dan
  • 783
  • 1
  • 13
  • 21
0
votes
1 answer

Migrate SQL Server 2008 R2 Express to SQL Server 2008 R2 Web

I need to upgrade to a least expensive SQL Server variant which is SQL Server 2008 R2 Web. I'm currently using SQL Server 2008 R2 Express 64bit. Specs. say there's not direct upgrade path supported from SQL Server 2008 R2 Express to SQL Server 2008…
s_ruchit
  • 203
  • 1
  • 10
0
votes
1 answer

Adding few Sql Server Standard Edition dlls in express edition. Would this terminate li

Possible Duplicate: Can you help me with my software licensing issue? I was reading a topic in a book regarding sending database mail in sql server. But I found that in express edition DatabaseMails is not available. So I started googling and…
Shantanu Gupta
  • 219
  • 1
  • 8
0
votes
2 answers

MS SQL Server Query Timeouts

I've got a server hosted at Rackspace that is a pretty beefy machine (dual hex core, 48 GB of RAM) and our database isn't all that big (100GB or so). SQL Server 2008 R2 Standard 64 bit. Normally, this machine runs perfectly. Very little pegging of…
Matt Dawdy
  • 429
  • 1
  • 9
  • 19
0
votes
1 answer

sql script mssql express 2008 windows 2008 server R2 x64

Scenerio:I need to run an update sql script after another scheduled task. server=Windows Server 2008 R2 x64 db = Sql Express 2008 when? - Everyday buy Sunday(i know how to do this) Why? A third party exe is adding 1 in two columns where it needs to…
nkuebelbeck
  • 71
  • 2
  • 4
0
votes
1 answer

Clarrification for SQL Server Express 2008 R2 on CPU limit (CPU based on core based)

I'm aware that SQL Server Express 2008 is having few limitations on the database size and the CPU utilization. In MSDN documentation it was mentioned on the express edition would use only one CPU. I went through the following links but I'm not clear…
Nagesh
  • 103
  • 3
0
votes
1 answer

Using different ports with multiple instances on SQL Server

In our development environment, we have numerous named instances of SQL Server 2008 running. I have recently added a new one it doesn't work as expected. Here is our set up: DEFAULT on 10.2.2.48:1433 SQL1 on 10.2.2.40:1434 SQL2 on…
Carl
  • 123
  • 2
  • 6
0
votes
1 answer

Can I install SharePoint Foundation 2010 with full SQL Server 2008?

I cannot find out how do I install SharePoint Foundation 2010 with full SQL Server 2008, it seems that installation wizard forces me to use Express edition. Is there a way to use Foundation with normal SQL Server?
jpkeisala
  • 166
  • 8
0
votes
1 answer

Can't update SQL Server 2008 to SP3, it only offers the option to create a new instance

A colleague is attempting to update our server's SQL Server 2008 version 10.0.1600.22 (not R2) install up to SP3. Unfortunately, we can't work out where the "Update" button is; the installer seems to be set on creating a new instance, which isn't…
Margaret
  • 231
  • 1
  • 7
  • 18
0
votes
1 answer

SQL Server 2008 Management Studio Express: won't recognize local instance

I’m having a lot of trouble getting Management Studio Express 2008 to recognize my local instance of SQL Server 2008 (SQLEXPRESS). Background: I’ve installed SQL Server 2008 x64 a few times today; I have verified each time that I have installed the…
Rob
  • 135
  • 7
0
votes
1 answer

How do I connect to NAMED INSTANCE of SqlServer 2008 running on custom port from another network?

I have a named instance of MS SQL Server 2008 running on port 1456. TCP/IP and NamedPipes are ENABLED for the server. No Aliases created. local address: 192.168.1.123\RM - works from local computer and local subnet (no ports specified when…
roman m
  • 123
  • 1
  • 2
  • 8
0
votes
1 answer

SQL Server reporting services shutting down without log info

Using SQL Server 2008 Reporting services. Finding that the service is shutdown without anything in the windows event log or in SQL Server events. I see the log entry for the service starting when I manually start it, but nothing for the shutdown…
Christoph
  • 103
  • 2
0
votes
4 answers

Blackberry Enterprise Server 5.0 and SQL server 2008

About to install BES 5.0 and have a SQL 2008 install that I can point it to. It looks like RIM doesn't officially support SQL 2008, only 2005, so am wondering if any server fault peeps have it running and if there are any hiccups. Thanks,
Dayton Brown
  • 1,539
  • 2
  • 13
  • 23
0
votes
2 answers

Can't Connect to (local) database

I have SQL Server 2008 and was forced to make a new windows 7 profile. I no longer can connect to my (local) databases. Everything I try to use windows authentication to login I get Cannot connect to (local). Login failed for user 'MyAccount'.…
chobo2
  • 461
  • 1
  • 10
  • 18
0
votes
2 answers

New server: use for SQL Server or Windows (Web)?

I picked up a new Dell R410 2.8 Ghz 12M cache 32 GB Ram RAID-1/RAID-1 for a good year-end deal. It was purchased mainly to replace my Dell PowerEdge 2850 which is my main WEB server. I run Windows Server 2008 R2 Standard across the board (several…
Neal
  • 399
  • 1
  • 5
  • 13
1 2 3
…
99 100