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
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 ...
0
votes
0answers
87 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 ...
0
votes
0answers
103 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 ,...
0
votes
1answer
46 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 ...
0
votes
0answers
332 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 ...
0
votes
2answers
114 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
0answers
69 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
2answers
385 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 ...
1
vote
0answers
39 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 ...
-1
votes
1answer
44 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 ...
0
votes
1answer
336 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
1answer
3k 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 ...
1
vote
0answers
77 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 ...
0
votes
1answer
5k 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 ...
15
votes
2answers
30k 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
1answer
357 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
1answer
3k 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 ...
0
votes
2answers
102 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
1answer
959 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. ...
4
votes
1answer
105 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 ...
1
vote
1answer
315 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 ...
3
votes
1answer
2k 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
1answer
71 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
1answer
29 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
1answer
47 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
1answer
330 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 ...
0
votes
1answer
327 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
1answer
478 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 ...
0
votes
1answer
1k 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 ...
0
votes
1answer
116 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
1answer
37 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 ...
-2
votes
1answer
79 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
1answer
30 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 ...
3
votes
1answer
2k 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
0answers
81 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
0answers
135 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
1answer
72 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 (...
2
votes
1answer
194 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 ...
1
vote
2answers
4k 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%...
0
votes
1answer
22 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.
1
vote
1answer
198 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. ...
1
vote
1answer
534 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 ...
-3
votes
1answer
58 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?
-1
votes
2answers
94 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
0answers
237 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 ...
0
votes
1answer
62 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 ...
0
votes
1answer
939 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
1answer
182 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 ...
0
votes
1answer
737 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 ...
1
vote
1answer
329 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 ...

1
2 3 4 5
37