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 vote
1 answer
355 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
95 views

?Does SQL Server 2016/2019 Web Edition supports encryption

I trying to find out if SQL Server 2016 and 2019 Web Edition supports encryption (on AWS)? any help will be appreciated. Thank you, Moshe
0 votes
1 answer
137 views

Connecting to SQL Server 2008 R2 over Azure VPN

2 Windows Server 2012 VM's on MS Azure and access is via RDP over Azure Point to Site VPN using a client certificate. I can connect to the VM's fine but I need to connect to SQL Server 2008 R2 which ...
  • 151
0 votes
0 answers
609 views

SQL Server Username Length

I have a SQL Server 2008 running on Windows Server 2008. The database handles spatial data. I have a select group of users that are unable to use their domain accounts when working in the database as ...
  • 1
0 votes
2 answers
310 views

How to scrub or clean out company data before selling server

I'm looking to sell a used Dell Poweredge T310 server (Specs at the end) with Server 2008 Standard SP2 and MS SQL Server 2008 R2 on it. I'd like to sell the server as-is, with the OS and installed ...
0 votes
0 answers
325 views

Cant connect to SQL Server 2008 from Window XP SP2 But work fine with SP3 and 7 and above?

Yesterday our windows server 2008 R2 Updated after 7 years! After that our Windows XP SP2 and Lower clients reported that the ERP software cant connect to server! But Windows 7 and above clients ...
0 votes
2 answers
852 views

How can I add the server name to the subject line of a SSIS subscription email?

How can I add the server name to the subject line of a SSIS subscription email? In Microsoft SQL Server Integration Services (SSIS) RDL report files uploaded are often set with the ability to send ...
  • 109
1 vote
0 answers
51 views

Restoring SQL Database with NoRecovery stuck

We are moving from a SQL 2008 standalone instance to a SQL 2016 HA Failover Cluster Instance (FCI) with an AlwaysOn Basic Availability Group (BAG) configured to replicate to a standalone DR instance ...
  • 219
-1 votes
1 answer
71 views

Firewall refuse my connection to DB

We are working on software that require to connect to database on the server (Win2012)(LAN), after activating windows firewall, we couldn't connect to DB. I've set a rule for inbound and I Excluded ...
  • 26
0 votes
1 answer
533 views

SQL Server Sort Order to Binary Search on SQL Server 2008 SP1

I am installing an OLT Software that requires Windows SQL Server 2008. I am getting this error below; The database sort order must be "binary sort". Please run the Transact-SQL command ...
-2 votes
1 answer
6k views

sql server can't start error code 1814

My pc can't start sqlserver 2008 R2. this is my sql server errorlog 2018-05-02 16:32:47.26 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright ...
  • 11
1 vote
0 answers
96 views

SQL Merge Replication Triggers Missing

In MS SQL Server 2008R2 SP3 Standard, I'm seeing an issue where reinitializing a merge publication with a new snapshot deletes all of the merge triggers from all of the tables, and then when snapshot ...
  • 58
0 votes
1 answer
7k views

SQL 2008 on windows 2008 R2 not working when TLS 1.0 and 1.1 is disabled

I have a problem with SQL 2008 on windows 2008 R2 when TLS 1.0 and 1.1 is disabled. After I disabled TLS 1.0 and 1.1 I cannot start SQL Service. and event viewer shows these errors : i searched ...
16 votes
2 answers
46k 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 ...
0 votes
1 answer
379 views

SQL: server 2008 database stuck in Restore

I have two SQL Server 2008 R2 servers one for PROD and the other for DR. I am trying to add log shipping for a database called School. Steps so far Back up School database Restore with database ...
3 votes
2 answers
4k 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 ...
  • 311
0 votes
2 answers
105 views

Server 2008 R2 Replication Small Issue

I have two 2008 R2 Servers. When I Connect those two Servers By Name, I Can Use Replication. But When I Connect This Two Servers By IP Address, I Can't Use Replication. I Get Error Like: SQL ...
0 votes
1 answer
1k views

Programs crash after joining the server into a Domain

UPDATE: Problem solved We decided to upgrade the computer from Windows Server 2008 to Windows Server 2008 R2, after reboot, all the problems where fixed. Every app can be executed from domain users. ...
  • 15
4 votes
1 answer
118 views

Migrate SQL 2008 database to Azure

I am migrating a SQL server 2008 R2 production database to Azure SQL database service in the cloud. Is it possible to mirror/replicate the Azure database from the 2008 R2 database? So I can just ...
  • 299
1 vote
1 answer
393 views

Move SQL 2008 database to Azure

I need to move a SQL 2008 R2 on-premis database to an Azure SQL cloud database. The database is to big to script out with data and Azure SQL cloud cannot restore a standard .bak file. Trying to use ...
  • 299
3 votes
1 answer
3k views

How can I resolve CPU utilisation nearing 100% on IIS

I have a .net web API application and the required SQL server hosted on an IIS. The task manager shows 100% CPU utilization most of the time, but memory usage is fine. How can I analyze and fix what ...
0 votes
1 answer
74 views

SQL: Re-Index/Re-Build Entire DB

I am tired of re-indexing/re-building every table I have, is there any way to do this to an entire database?
0 votes
1 answer
32 views

how do i make a schema for sql server 2008

Brand new Jr. Sys Admin here, trying to wrap my head around the system in place. We've got a DB on Microsoft SQL Server 2008 and I want to get a visual on what tables & Fields are in place. Just ...
0 votes
1 answer
53 views

sqlexpress 2008 connection error 40 when connecting through internet static ip

I installed SQL Server 2008 on a workstation running windows 7 SP1. I am trying to connect to the server through the internet using a static IP address and port 1433. I can connect with this IP ...
0 votes
1 answer
361 views

SQLServer 2008 services broken after Visual Studio 2015 installation (sqlcmd shows nothing) [closed]

This is my SQL Server. MSSQL 2008 (not R2): Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Database Engine Services 1033 10.0.1600.22 After installing Visual Studio 2015 with SQL ...
  • 143
0 votes
1 answer
367 views

Cdrive out of space,How to extend from another disk

We have a Windows Server 2012 with only C drive with 278 GB space.now c drive have only 20 GB free space,here running ms sql server 2008.how can i extend volume C from another disk without data loss? ...
0 votes
1 answer
517 views

ODBC--connection to 'systemDSN' failed

We have a Microsoft Access 2010 database (ACCDB). This ACCDB file is just a front end to a Microsoft SQL Server 2008 database. Authentication to the database is accomplished by Windows integrated ...
  • 2,900
0 votes
1 answer
2k views

How to change interface language of sql server 2008? [closed]

As you can see in the image below, the SQL Server Interface language is in Spanish and I want to change to English. I tried my best to find a way to change it without uninstalling this Spanish ...
  • 1
0 votes
1 answer
132 views

SQL Server database restore to same pc

I am trying to restore sql server database bak file to same server but with different name. When i run restore original database starts showing restoring. I have changed old database Logical Name and ...
0 votes
1 answer
38 views

SQL server 2008 R2 - Hardware Requirement

I have to give SQL server hardware requirement for the below specifications Number of instances <= 5 Number of databases per instance > 50 Number of concurrent users per instance <= 2000 Daily ...
  • 101
-2 votes
1 answer
81 views

SQL Server Backup Procedure and different types of backup [closed]

Need to know perfect solution on how to backup SQL server Database Version SQL server 2008 R2.
1 vote
1 answer
34 views

MICROSOFT SQL SERVER MANAGEMENT STUDIO 2008R2, new schedule, what it does and where it goes?

I just clicked sql server agent -> new schedule -> named it thisisjustatest and scheduled it to run tomorrow at 1 am. I would like to find that schedule and delete it. I can't find it anywhere. The ...
  • 125
3 votes
1 answer
3k views

Exit code 0x84C40013 in silient installation of SQL 2008 service pack 3 installation

Following Command is utilized for installing SQL SP3 pack in Windows server 2008 R2. start /WAIT C:\Temp\SQLSP3.exe /quiet /IAcceptSQLServerLicenseTerms /Action=Patch /AllInstances This complete ...
1 vote
0 answers
114 views

Repeatedly prompted to restart the computer when installing SQL Server 2008 R2 on a x64 Win 8.1 machine

I am trying to install SQL Server 2008 R2 on a Win 8.1 x64 bit machine. When running the installer, I get the Reboot Required check failing the install. I have tried rebooting, no difference. I ...
0 votes
0 answers
185 views

Running SQL Server based Program Via VPN

I have recently set up a site-to-site VPN. Location A has a PC running windows 7 (we'll call it Computer1) that acts as a server for a point of sale program. The program uses SQL Server 2008 to store ...
1 vote
1 answer
80 views

How to handle replication post SQL Server 2000/2008 migration?

I have two servers; server A host SQL Server 2000 and server B ( a remote server) host SQL Server 2005. I replicate data between these two servers using transactional replication. I recently migrated (...
  • 11
2 votes
1 answer
318 views

Is there any gain from using multiple files in SQL server for raid-5 configuration?

We are setting up a server with five 240GB ssd as raid-5 configuration into one logical drive. We're planning to partition the logical drive into four drives on windows server. In SQL server, would ...
  • 127
1 vote
2 answers
5k views

How to free up disk space on a drive which has BiztalkMsgBoxDB_log file in it

I have been asked to analyze a issue regarding one of the biztalk servers. I was asked to free up space on a particular drive, where I found the only file BiztalkMsgBoxDB_log.bak is taking up close 90%...
  • 121
0 votes
1 answer
27 views

sql server 2008 cant insertproduct key

I am trying to install SQL Server 2008 in a Windows Server 2008, but when i have to enter the product key, all option are blocked, and I can´t put the key or select a evaluation version.
  • 101
1 vote
1 answer
205 views

Using Linked SQL Servers from a different server

I have 3 machines that are involved in running a SQL script: JumpBox - A machine that serves as a stable point for automation to run. ReportBox - A machine that holds reporting databases and logic. ...
  • 435
1 vote
1 answer
671 views

MSSQL - Can Maintenance Plan wait for Agent Job Task to be completed?

I did start a Maintenance Plan project with Execute SQL Server Agent Job Task box. I added another task on success event. I realized that I was wrong. The second task is executed in parallel, because ...
  • 151
-3 votes
1 answer
60 views

System databases are in standby...how can I make them editable?

My System Databases are stuck in a standby/read-only state. RESTORE DATABASE msdb WITH RECOVERY does not seem to have had any affect. How can I get them out of the standby state?
  • 95
-1 votes
2 answers
107 views

Database sql server Mirroring or replication

I have SQL server 2008 R1 with standard edition. I have a large database i.e. 500GB that i.e. growing rapidly 10GB a month .It is a cloud based solution. We have another data center where the ...
1 vote
0 answers
266 views

What are the limitations of using a scheduled Windows Server Backup instead of SQL Server backups?

We've taken over development and server admin for an e-commerce site, and the client has opted for a well-specced dedicated server, including a second drive for daily Windows Server Backups. However ...
  • 151
0 votes
1 answer
66 views

How to handle a large table on SQLServer

There is a database on our server that has a 120GB backupfile. The server has limited diskspace and I cant even restore a second copy of that database. There are mainly 2 tables in the databse that ...
  • 123
0 votes
1 answer
1k views

PHP Trouble Configuring SQLSRV

I am working on learning PHP, and one of my goals is to be able to connect to an SQL Server database. I am on a virtual Windows 2008 Server and have 32-bit PHP 5.6.0 installed. I have downloaded the ...
-1 votes
1 answer
195 views

Use reporting service configuration to configure the database source name

So im upgrading to R2. When i get to the Reporting Services Authentication step i get the error: There are validation errors on this page. Click ok to close this dialog box. Review errors at the ...
  • 131
0 votes
1 answer
860 views

SQL Server 2008: Delete database while Rollback is in progress

I am trying to remove a test database in which a database modification failed. The resources being consumed by the rollback action in SQL are affecting production databases (users reporting slow ...
  • 101
1 vote
1 answer
355 views

Does the SQL Server 2008 Recovery Model and Log Size Impact Memory Usage for sqlservr.exe process?

Problem We have a SQL Server instance (2008) running our software with what we consider a small number of users (about 30 concurrent connected to the server at any given time) As a vendor, we're not ...
  • 191
0 votes
1 answer
167 views

SP with xp_cmdshell gives an error in the MessageQueue, but executes successfully in Management Studio

I have a SP, which calls xp_cmdshell in it. This SP is being used in a MessageQueue. The SQL server and Agent services are configured using a Domain service account, and this service account has a ...

1
2 3 4 5
37