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

Login failed for user DEV\xxx (Microsoft SQL Server, Error: 18456)

Brand new installation of SQL2008 R2. My user, xxx, is a domain admin. I am attempting to connect via management studio while directly logged onto the SQL box. If I specifically add that user to SQL Logins then I can connect OK. However, if I add…
BIDeveloper
  • 187
  • 10
0
votes
1 answer

SQL Server - Scripting data for only rows in query

I love the "new" feature to script data as well as schema from SQL Server 2008 and forward. However, I would like to script only a few 100 rows of a gigantic table (ie rows that match a query). Is that possible?
Kjensen
  • 1,039
  • 10
  • 28
  • 39
0
votes
1 answer

Cannot Access SQL2008 R2 instance over TCP

I have enabled Named Pipes and TCP/IP for this instance and restarted the service. I have also made sure the the port on the server is open on the firewall. I have also made sure that I have the correct credentials, I can access the server fine if I…
StevenMcD
  • 101
  • 3
0
votes
1 answer

Connect to SQL Server using Windows Group Authentication

I've got this SQL Server 2005 Express installation that's got a Database I'm trying to connect to through a software that gives me the error "cannot connect using the user 'mydoimain\myuser'. Meaning, it's trying to connect using my domain user as a…
Kenny Bones
  • 119
  • 2
  • 3
  • 14
0
votes
1 answer

SQL 2008 Performance Reports

Does anybody know of DMV's or reports that will show the historical performance of the stored procedures on the server? Also if that data is stored in a table or tables, what is the retention period and can it be adjusted? Thanks for your time...
Dave
  • 1
0
votes
1 answer

SP2 install on A\P fail-over cluster for SQL2008 & Win2008 - How to?

Any recommendations and any known issues with installing SP2 for SQL2008 on Win2008 fail-over Active\Passive Cluster? And the best procedure to get this done with minimum downtime? Replication and Service-Broker also running and Distributor is…
Nico Botes
  • 1
  • 1
0
votes
6 answers

MS ReportServer refuses to work with domain account

I have installed SQL Server 2008 ReportServer on dozens of servers, all virtually identical. It was always possible to configure it to use a domain account (the same one on all those servers). However, on MYSERVERNAME I get the following…
Andrew J. Brehm
  • 1,611
  • 7
  • 37
  • 57
0
votes
1 answer

SqlServer doesn't allow other users to login from other computers

I have a server running MS SQL Server 2008 Express. Windows Authentication is used to authenticate the accounts to determine what they can and cannot access. I have no problems accessing the server from any computer under my username (say,…
Malfist
  • 807
  • 3
  • 10
  • 22
0
votes
2 answers

Windows Server 2008 does not recognize .NET 4.0

I installed the .NET Framework 4.0 in my Windows Server 2008. I also created and deployed applications that use MVC3 in the server using VS2010 and they work without any problem. Now I need to install the WCF LOB in the server in order to install…
CiccioMiami
  • 209
  • 1
  • 3
  • 14
0
votes
2 answers

SQL Server 2008 login failed

I have a virtual machine (vmware) with Windows Server 2008 R2 x64 and SQL Server 2008 R2 installed. I see 2 SQL Server services on this vm : sqlexpress, mssqlserver. Both of them are use the default Network Service account to login. And both of them…
yaron
  • 3
  • 1
0
votes
2 answers

Backup SqlServer to a FTP-folder

Is it possible to let SQL Server 2008 make a backup to a FTP-folder. I know it's possible to specify as the backup target in SSMS an UNC-path. But is there also the possibility to specify an FTP-Folder (inclusive user name an pwd)? If yes, what is…
HCL
  • 137
  • 5
0
votes
2 answers

MVC2 Application Performance on Windows Server 2008 R2 with IIS7.5

I originally posted this on StackOverflow but I feel as though the problem lies with the hardware / OS configuration. I'm hoping that someone here has had a similar experience and can offer some advice. I have deployed a MVC2 application to IIS7.5…
JohnyD
  • 1,614
  • 3
  • 20
  • 29
0
votes
1 answer

Shrink a DB and Log File in SQL after a database clear

We have a script that we use for client conversions that deletes all date from almost every table from a database. We do this so that we can clear out any data not related to the application configuration, so that we can start to import data again…
Chad
  • 1
0
votes
1 answer

Add index to very large SQL Server table

I've got a table with 9 million rows (just received it from our underwriting provider). 4 columns -- leadid (guid), RawLeadXML (nvarchar(max) that contain an xml doc in each row that is 2-3kb), LeadStatusID (int), and id (autonumber int, I just…
Matt Dawdy
  • 429
  • 1
  • 9
  • 19
0
votes
1 answer

SQL Server Service Starting Itself?

I have several SQL 2008 boxes that are exhibiting a strange problem. Whenever I do a reboot on any machine, I make sure all the services are set to 'Manual' startup. After the boxes come back up, the SQL Server Service manages to start…
Upstart
1 2 3
…
99 100