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
-1
votes
1answer
1k views

SQL Server 2008 No process is on the other end of the pipe

I've recently been having some issues with SQL Server 2008 on our server. We only have one website running at the moment, but it seems at random that the following error occurs. A connection was ...
3
votes
2answers
8k 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
1answer
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 ...
0
votes
1answer
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 = "...
0
votes
1answer
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" ...
0
votes
1answer
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 ...
16
votes
5answers
34k views

Should I install 32-bit database or 64-bit database?

(I've read a lot about 64-bit versus 32-bit OS/Apps, but this question is specifically in regards to databases.) I'm trying to understand the pros and cons of 32-bit versus 64-bit databases, and ...
0
votes
2answers
6k 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
2answers
2k 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 ...
3
votes
1answer
4k views

SQL Server instance shuts down

I'm currently developing a new ASP.NET project hosted on a Windows Server 2008 RC2 with an SQL Server 2008 Express database. I have three SQL Server instances (for different purposes) running which ...
1
vote
1answer
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 ...
0
votes
1answer
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: ...
1
vote
1answer
4k 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. ...
8
votes
3answers
48k views

SQL Server 2012 with account NT Service\MSSQLSERVER access is denied in domain

A few months ago we installed SQL Server 2012 in Windows 2008 R2 under the virtual account "NT Service\MSSQLSERVER", all good. A few days ago, one of the admins of the IT dept installed Full Text ...
0
votes
1answer
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 ...
0
votes
1answer
1k views

How to execute rskeymgmt utility silently in windows server 2008

When i run reskeymgmt.exe - to create a backup copy of the encryption key, it responses "Are you sure want to extract the key from the Report Server? Yes (y)/ No (n)?" I found this link which ...
1
vote
1answer
1k views

sql server 2008 cluster hang when a heavy load is run

we have a sql server 2008 active/active cluster running on wondows 2008R2 O/S. 14GB RAM, 4xCPU. we have set a ceiling of 12GB for sql server. We're running an agent job which loads 3 million records ...
-1
votes
2answers
1k views

Unable to shrink the transaction log file in Sql Server 2008

Am using the below to script shrink the transaction log *USE AVPC GO BACKUP DATABASE AVPC TO DISK = 'H:\DBBackup\AVPC\FullBackUp\AVPC.bak' USE AVPC GO BACKUP LOG AVPC TO DISK = 'H:\...
7
votes
6answers
67k views

How to recover the database which is accidently deleted using sql server 2008

How to recover the database which is accidently deleted using sql server 2008?
0
votes
3answers
3k views

SQL Server 2008 - Error starting service - model.mdf not found?

my SQL server 2008 was running fine. About an hour ago, it suddenly stopped - the MSSQLSERVER service had stopped I right clicked, clicked start, and it said the service had started, and stopped I ...
9
votes
9answers
12k views

What should I do about someone trying to brute force attempt to login to our SQL Server 'sa' account?

Looks like someone or something is trying a brute force attempt at logging into our production SQL Server instance with the 'sa' account. They haven't been successful because our 'sa' account is ...
0
votes
1answer
1k views

How to add linked Oracle server to SQL 2008 Express?

I have tried to download Oracle Client 11g both 32 & 64 packages to Windows 2008 R2 with SQL server 2008 Express. However, I still cannot see Oracle provider in SQL server by using sa log in. Not ...
0
votes
1answer
1k 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 ...
0
votes
1answer
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 ...
0
votes
0answers
8 views

EC2 Windows 2008 & SQL Server 2008 Instance Not Reading New Disks

I have a Windows Server 2008 instance running SQL Server 2008 in AWS. I attached an existing volume (previously attached to a different server running windows 2012) to this 2008 server. The volume ...
4
votes
1answer
1k views

Allowing a specific IP Address through a blocked port in Windows Server 2008 R2 Firewall

I have created an Inbound rule to block port number 1433 however I need to allow my static ip address to access this as I use SQL Management Studio to connect to databases on the server. I have ...
1
vote
1answer
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 ...
3
votes
2answers
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
1answer
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 ...
0
votes
1answer
1k 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 ...
0
votes
2answers
3k views

Index rebuilding on mirrored database sql server 2008

I have a mirrored database in full safety mode on sql server 2008 R2 Standard Edition. I want to create a maintenance plan to rebuild and reorganize the indexes on a weekly basis. Maintenance plans ...
-1
votes
1answer
2k views

Sql Server Transaction Log Backup Fails

I have a SQL Server 2008 Standard version. Mirroring is set up on the server in full safety mode. It has been working fine till today. The transaction log back-up fails every-time with an error Error: ...
1
vote
1answer
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
1answer
1k views

Connecting to SQL Server Express 2008 behind a NAT

First off, apologies in advance for any misuse of networking terminology - I'm definitely not a networking guy. I'm renting an instance from Amazon's cloud and want to have it connect to my SQL ...
0
votes
1answer
1k 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 ...
1
vote
2answers
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 ...
0
votes
2answers
805 views

SQL service log on account

I installed SQLServer 2008 Express and pretty much took all the defaults. After about a week of running an app that hits this database I changed the administrator password for the server. About a day ...
0
votes
0answers
71 views

Schannel connect / MS SQL Server 2014 SP 3 / Win 2008 R2 / PHP sqlsrv_connect -> TLS Error

I have updated from Ubuntu 19.10 to 20.04 and all had gone well other than the following issue, possibly caused by 20.04 requiring TLS 1.2(?). I have updated MS SQL to the latest service pack with ...
20
votes
11answers
74k views

Diagnosing Microsoft SQL Server error 9001: The log for the database is not available

Over the weekend a website I run stopped functioning, recording the following error in the Event Viewer each time a request is made to the website: Event ID: 9001 The log for database 'database name' ...
0
votes
2answers
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 ...
1
vote
1answer
1k views

SQL Server VSS Writer, Hyper-V and SQL Server 2008 backups

I have a virtual server running SQL Server 2008 R2. On the server I have configured two maintenance plans, one that takes differential backups every day except Saturday and a job that takes full ...
0
votes
1answer
2k views

Error while installing sql server 2008 - “the collation was not found” [closed]

In the server configuration page of my Microsoft sql server 2008 setup, the database engine field in the collation tab is empty. I think it should be having "SQL_Latin1_General_CP1_CI_AS" written ...
0
votes
0answers
86 views

How to use variable in column names in sql query

I want to use variable value in my column names. Following is an example of my query CREATE TABLE mytable ( Items VARCHAR(1) NOT NULL PRIMARY KEY ,as_on_date_stock INT NOT NULL ,...
12
votes
4answers
29k 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 ...
6
votes
1answer
2k views

How to backup/restore excluding filestream varbinary in SQL Server 2008?

There is an application used in a production site that uses SQL Server 2008 as its DBMS. The database schema uses Filestream Varbinary to save binary data on the filesystem instead of directly into ...
2
votes
1answer
72 views

SharePoint 3.0 service account

We have a SharePoint 3 site that is currently configured to run under a admin account. I have been tasked with reconfiguring it to run under a service account. Unfortunately, when I update the ...
1
vote
1answer
439 views

System Center Operations Manager 2007 R2 install error 25154

While installing SCOM 07 R2 Database component on our DB server I get this error... I've gotten the same error on the following configurations. Windows Server 2003 & SQL Server 2008 SP1 Windows ...
1
vote
2answers
1k views

SQL Server Snapshot Replication Subscriber (Editable or Read-Only)

I need to create a copy of my SQL 2008 R2 Enterprise database and have it located on the same server as the original. I will be using this second copy of the database as the target of a mostly read-...
36
votes
6answers
69k views

How to check progress of DBCC SHRINKFILE?

Is there a way to find out the progress of DBCC SHRINKFILE statement? Here is how I was running it dbcc shrinkfile('main_data', 250000) I am running above statement on both SQL Server 2005 and ...
28
votes
5answers
143k views

Adding an administrator user to SQL Server 2008

How do you add an administrator user to SQL Server 2008?

1
2 3 4 5
37