Questions tagged [sql-server-2008]

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

Filter by
Sorted by
Tagged with
2 votes
3 answers
1k views

Will upgrading my database from 2005 --> 2008 make my applications fail?

We have a couple of databases on our server. We would like to upgrade these databases to sql 2008. Is there any chance that some application features won't work on 2008 that did work on 2005? I was ...
3 votes
2 answers
6k views

Problem in restoring differential backup

I tried to restore differential backup but i got a following error: Restore failed for server .(Microsoft.Sqlserver.smoextended) Additional Information: system.data.sqlclient.sqlerror:The file '...
3 votes
2 answers
11k views

The OLE DB provider "SQLNCLI10.1" has not been registered.; 42000

I have a SQL Server 2008 Analysis Services Project. In the Data Source View I have a Named Query which references a single Data Source containing three tables. The Project processes successfully and ...
0 votes
2 answers
7k views

SQL 2008 R2 replication error: The process could not connect to Distributor

I have two servers running SQL 2008 R2 Standard, each with an instance named "MAIN". I have a small test database on my primary server (one table, 13 rows) that I want to replicate to a second server ...
0 votes
1 answer
2k views

SQL Server 2008 Recovery Mode reverts from FULL to SIMPLE

Three of our SQL databases have their recovery model change every night from FULL to SIMPLE. The only jobs that I'm aware of are two BackupExec jobs that run nightly. Why would the recovery model ...
1 vote
1 answer
6k views

Exception Enumerating SQL Server Instances with SMO WMI ManagedComputer

I'm trying to use the SMO WMI API/objects in PowerShell 2.0 on Windows 7 with SQL Server 2008 R2 installed to get a list of SQL Server instances on the local computer using the Managed Comuter object. ...
0 votes
2 answers
5k views

Could not continue scan with NOLOCK due to data movement during installation

I am running Windows Server 2008 Standard Edition R2 x64 and I installed SQL Server 2008 Developer Edition. All of the preliminary checks run fine (Apart from a warning about Windows Firewall and ...
1 vote
3 answers
419 views

Can't connect to SQL server

I have SQL 2008 server installed on the local machine with the instance name "SQL2008". I'm trying to connect to it using Management Studio. I can connect with the sa authentication but am unable to ...
3 votes
2 answers
118 views

SQL Server is slamming the disk

I have a game server running on a box with Windows 2003 equipped with 4 GB of RAM. The game server is using a database installed on the same machine, managed by SQL Server 2008. About a week ago I ...
3 votes
5 answers
4k views

Enable row level compression on all tables and indexes

One of the (optional) requirements for the Works With SQL Server 2008 test is that row level compression is enabled on all tables and indexes. We have an existing database with a lot of tables and ...
6 votes
4 answers
68k views

How do I install SQL Svr Native Client 10.1 after SQL 2012 has been installed

On a Windows Server 2012 I have SQL Server 2012 installed which has the SQL Server Native Client version 11. I am being told by a developer that he needs the SQL Server Native Client version 10.1 (...
2 votes
1 answer
16k views

SQL 2008 not accepting connections

Setup: SQL 2008 Standard SP1 64Bit on Windows 2008 - one CPU, 8GB of memory The server is dedicated to SQL Server. The server memory settings were as default (min 0 max 2000GB) Connections from 8 ...
1 vote
3 answers
1k views

SQL Server Enterprise Edition: Use more than 4GB of RAM on a 32 bit Machine?

I would like to install SQL Server 2008 on a 32 bit machine. I have read that it is possible with the SQL Server Enterprise edition to increase the memory over the 4GB? Is this true? Any ...
2 votes
3 answers
1k views

I deleted the default user in SQL/Server 2008

I saw this in logins: computername/username and I deleted it! Now I cannot log into SQL/Server Management Studio 2008. Mixed mode is not enabled, so I cannot use the sa account because it's disabled ...
0 votes
1 answer
2k views

Difference SQLSERVER and MSSQLSERVER services

I have two SQL Server services in Sql Server Configuration Manager: SQLEXPRESS and MSSQLSERVER. I have no idea what the differences are. I think that SQLEXPRESS is the free version, but I don't know ...
1 vote
1 answer
2k views

Limit a database's max disk size and limit user total database size usage

Is there a way to do this in SQL Server 2008 express? I need to limit the maximum allowed size of a specific database. I also would like to limit the maximum allowed total size of databases for a ...
3 votes
2 answers
1k views

Adding anonymous IURS IIS user fails into SQL SERVER 2008 R2

I am trying to add a anonymous IIS user [IUSR] to a SQL SERVER 2008 r2 database. But I am getting the following error: 'notebook/iusr' is not a valid login or you do not have permission. I think ...
0 votes
1 answer
2k views

SSIS package hangs on Setting Source Connection

I have an SSIS package that has been executing successfully for the last 7 years. All of a sudden the package won't run and hangs at the Setting Source Connection step and has to be closed down via ...
2 votes
3 answers
1k views

SQL Server 2008 - Secure remote access

I wish to allow remote access to an SQL Server database from a Microsoft Access database to allow my client to build reports as and when they wish. I can do this without any issue by opening the ...
1 vote
1 answer
3k views

how can I change the location of Log files for SQL Server Reporting Services in sql2008?

I tried to change the location of Log files for SQL Server by using these steps but it's not working because I can not find the RTrace in two web config files. There are three files you need to modify ...
1 vote
1 answer
537 views

SQL Server 2008 has started becoming unavailable for connections at seemingly random intervals

This is happening on a server that has been in constant use for over a year, with SQL Server 2008 and the web applications all hosted on the same machine. This morning i had 100-or-so emails with ...
0 votes
1 answer
2k views

how can connect from client to sql server 2008 via proxy

I have SQL Server 2008 in dedicated server and all port of SQL Server is blocked with firewall. I have VPS with CCProxy on it. I opened all ports in dedicated server for my VPS server IP. I set proxy ...
1 vote
2 answers
3k views

How to allow TCP connection over the network to SQL Server 2008 Express?

I've installed SQL Server 2008 Express. I connected to it and created a Database with Microsoft SQL Management Studio. But I cannot connect (with same url, username and password) to the DB from my ...
0 votes
1 answer
2k views

Connecting to a SQL Server instance via connection string does not work

Why does this work to connect to my remote SQL Server database: var srvConn = new ServerConnection("sql01"); srvConn.LoginSecure = false; srvConn.Login = "...
46 votes
4 answers
67k views

How do I remove a specific bad plan from the SQL Server query cache?

We have one particular SQL Server 2008 query (not a stored proc, but the same SQL string -- executes every 5 minutes) that intermittently caches a very bad query plan. This query normally runs in a ...
1 vote
2 answers
3k views

Is it possible to determine the top users of SqlServer analysis services?

We're trying to figure out how many licenses we need of a desktop data analysis package which connects directly to our SSAS instance. I'd like know if it's possible to query the history of connection ...
2 votes
3 answers
6k views

SQL Server 2008 Database 250GB on a 250GB drive

Started a new job and there is a 2008 sql database that is 250gb in size. The developers insist that the size is about right. THe problem is that the 250gb MDF file is sitting on a 250GB drive. I ...
2 votes
1 answer
3k views

Unable to save view: "There is already an object named 'Quotes' in the database." - Error 1222

I often get the aloof error message above, after trying change a view in SQL Managment Studio 2008. I right-click on a view, select 'design', make a change (or not), and click the Save button. It ...
12 votes
5 answers
38k views

How do I restore a batch of transaction logs rather than one by one

I have a SQL Server database that backs up the transaction logs every 10 minutes, with an overnight full backup. Using SQL 2008 Management studio we seem to have to select each transaction log one ...
0 votes
1 answer
2k views

Package run on SQL Server Job Agent - Login failed for user

I created a package on my SQL Server (2012) through the import/export data wizard which exports data to another SQL Server (2008). I set up a job which runs this package but I get an error: ...
2 votes
1 answer
7k views

The windows firewall on this machine is currently blocking remote debugging

I am using MS-SQL server 2008 R2 express edition. In this when i am trying to execute my query i am getting the following error "the windows firewall on this machine is currently blocking remote ...
1 vote
3 answers
7k views

Reset the primary key column with existing data in SQL Server 2008?

I have an existing table where the first few rows have been deleted. Is it possible to reset the primary key so the existing data Id column changes back to 1,2,3..?
0 votes
1 answer
2k views

SQL Server Multiple Instances but showing the same databases

I am running SQL Server 2008 R2 Standard Edition and need to have multiple instances which I have installed. However, when I restore a database onto one instance, it is showing up on the other ...
6 votes
4 answers
16k views

Troubleshooting SQL connectivity issues after database migration

We have a just completed a migration from SQL 2000 to SQL 2008 R2 and have started to intermittently receive SqlExceptions with the following two error messages: A transport-level error has occurred ...
1 vote
1 answer
1k views

MS SQL 2008 - Can I use Windows Authentication to connect from a Mac

I have been using Navicat SQL on Mac (Snow Leopard) to connect to MS 2005 via "Basic Auth" and all is good. However the DB is now being migrated to MS 2008 and try as I might I cant get on via Windows ...
0 votes
2 answers
1k views

Copy SQL Server data from one location to another over the internet

How can I copy certain SQL server data from one server to another without opening direct access to SQL server in the firewall? I thought of things like integration services in combination with an ...
0 votes
1 answer
258 views

Does SQL Server Express 2008 R2 eliminate the need to install MS SQL Server 2008 Express then SP1?

To install SQL Server 2008 plus SP1 on Win 7 machines, you have the following options: install the deployment (runtime only - no management tools) version with SP1 built in install the pre-SP1 ...
16 votes
2 answers
82k views

Difference between "NT AUTHORITY\NETWORK SERVICE" and "NT AUTHORITY\SYSTEM"

I am installing MS SQL Server 2008 R2 and I got to the window where I have to set the service accounts. I want to know the difference between NT AUTHORITY\SYSTEM and NT AUTHORITY\NETWORK SERVICE. I ...
2 votes
4 answers
8k views

SQL Server Shrink File Fails

I have a large database 1.5 TB, which contains image data. There is an archiving process that has been implemented which has removed a large portion of the data. I want to shrink the size of the data ...
1 vote
1 answer
1k views

SQL Server Web Edtion Failover Cluster

Is it possible to run an SQL Server Web edition in a Windows 2008 R2 Failover Environment? I want to host a Website with backend database but keep it failsave with a failover cluster (install it on ...
3 votes
1 answer
1k views

SQL Server 2008 R2 Temporary Login Issue

We have a mature SQL Server 2008 R2 server, being used from many C# web applications, each with connection pooling. Last night, all web applications lost the ability to login to the database for 6 ...
0 votes
1 answer
1k views

How can I uninstall SQL Server Express from Windows Server 2008?

I installed Windows Server 2008 as my OS, but I dislike the SQL Server Express which it provided by default, so I changed to SQL Sever 2008 Enterprise. The problem is, I don't know how to remove the ...
2 votes
1 answer
4k views

SQL Database restore to different edition?

I have SQL server 2008 R2 standard in house server and want to move my database to SQL 2019 Web edition in VM in AWS cloud. Can I just backup database and restore it there? would that work? or ...
0 votes
1 answer
1k views

SQL 2005/2008 and sp_add_jobstep fails

I have a job that is being created by a non-sysadmin user. This job fails because the @database_user_name setting with the error "Only a sysadmin can specify '@database_user_name' parameter" ...
3 votes
2 answers
6k views

What is the "Microsoft SQL Server 2008 R2 RsFx Driver" and can I run SQL Server without it?

Our German hosting company complains about licensing issues with our SQL Server Express installation and demands us to uninstall (or re-license) the following components: Microsoft SQL Server 2008 R2 ...
1 vote
1 answer
3k views

Cancel/Kill SQL-Server BACKUP in SUPSPENDED state (WRITELOG)

I have a SQL 2008 R2 Express on which backups are made by executing sqlmaint from windows task planer. Several backups ran into an error and got stuck in state SUSPENDED with wait type WRITELOG. How ...
0 votes
1 answer
1k views

SQL server 2008 can't open after installing windows update

I have recently installed windows update on my windows server 2003 machine. After updates when i open sql server 2008, i'm getting a wired error: 'Failed to open connection dialog - object reference ...
0 votes
2 answers
864 views

How to encrypt data at rest

How can you encrypt data at rest on Sql Server Web Edition? TDE is apparently not an option, but I don't know what else is available. Any recommendations?
6 votes
4 answers
2k views

Storing SQL Server System Databases On A Seperate Drive

Is it worth moving the SQL Server system databases master, model and msdb from the default install path on the main OS hard drive over to their own drive? I've already moved TempDB on to 2 separate ...
17 votes
2 answers
57k views

Microsoft SQL Server login using Active Directory Credentials

Our Microsoft SQL Servers are running on Windows Servers which are part of an Active Directory domain. For easy user management, our SQL authorization is set up by using the Active Directory User ...

1
2 3 4 5
37