Questions tagged [sql-server-2008]

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

231 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0 votes
0 answers
620 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 ...
Morteza's user avatar
0 votes
2 answers
111 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 ...
Rohit Tarang's user avatar
0 votes
1 answer
60 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 ...
Nour Medical's user avatar
0 votes
1 answer
143 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 ...
user3773802's user avatar
0 votes
1 answer
44 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 ...
rafidheen's user avatar
  • 101
0 votes
0 answers
236 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 ...
user3841709's user avatar
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 ...
missscripty's user avatar
0 votes
1 answer
913 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 ...
vice's user avatar
  • 101
0 votes
1 answer
300 views

Sql server 2008 - server name changed

I have changed the computer name of the server where sql server 2008 r2 is installed. Old name is WIN-OUJEKRMGXXX and new server name is KASURDYYY When i configure replication following error occurs: ...
user1543848's user avatar
0 votes
0 answers
270 views

Application logs an INSERT into database but data is not there. Where to look for debug info?

I have a PHP shell application which essentially moves data from a MySQL table to a REMOTE MS SQL Server (2008 R2) server based on a number of business rules. This routine has been working flawlessly ...
Pbal's user avatar
  • 76
0 votes
0 answers
399 views

EMC AVAMAR Compatibility with SQL Server 2008 R2 in Active/Passive Clustered Mode

We are currently using EMC AVAMAR as part of our backup policy for backing up all our servers. We also have a SQL Server 2008 R2 active/passive setup. Does anyone know if EMC AVAMAR is compatible in ...
AshesToAshes's user avatar
0 votes
0 answers
128 views

Clients Unable To Connect To Server Or Database

We recently moved several of our servers and VMs from one location to another. We have already go through and set up DNS and given all the correct IPs for all the machines we needed but we have one ...
CalebB's user avatar
  • 101
0 votes
0 answers
811 views

Cannot add Domain Users to SQLServer security

I installed a win2008 server (WSQL) Its has successfully joined another Win2008 server which is the domain controller. Now back to WSQL machine, I connect it to the domain... And I install SqlServer-...
Stef's user avatar
  • 592
0 votes
0 answers
86 views

SQL 2008 R2 says access denied when logging in remotely

I have an SQL 2008 R2 server and a monitoring server both on the same physical network (but different VLANs). The monitoring server is always connecting to the SQL server to run a query and check the ...
blizz's user avatar
  • 1,154
0 votes
0 answers
165 views

SQL DATABASE USING VPN

I have a very simple classic asp site on a Windows 2008 Server with an IIS 7.5 that connects to an Sql database on a Sql 2008 r2. the site works perfectly when accessing it both locally from the ...
user234033's user avatar
0 votes
1 answer
1k views

How to locate the cause of a excessive memory in ms sql

We are experiencing memory issues with MS Sql 2008 R2. There appears to be a memory leak that is consistently increasing in memory usage until it gets to about 1.5 gb and then stops. We have used ...
Frosty's user avatar
  • 233
0 votes
0 answers
3k views

How do you RESET the SQL Server 2008 TCP/IP Protocol settings back to default?

We have a SQL Server with multiple interfaces and a previous admin wanted to enable TCP/IP protocol to listen on a specific port. I believe that wherever he saw a specific IP address, he replaced it ...
tresstylez's user avatar
0 votes
0 answers
323 views

Remote SQL Server Connection works from SSMS but not from Application

We are troubleshooting a weird issue with our SQL Server 2008 server. The application server runs a windows service that makes a DB connection via a connection string in its config file, and we end ...
tresstylez's user avatar
0 votes
1 answer
136 views

Windows XP Service Dependency Order and SQL Express

Several years ago I built and deployed a system on XP that involved a custom written service that talked to a local 2008 SQL Express instance (that also had a CLR dependency). At the time I set up ...
Peter M's user avatar
  • 1,036
0 votes
0 answers
2k views

SQL Server Error - HRESULT E_FAIL has been returned from a call to a COM component

I have a huge 200MB .SQL file. When I try to open this in SQL server management studio 2008, I get the error -Error HRESULT E_FAIL has been returned from a call to a COM component. What could the ...
Steam's user avatar
  • 101
0 votes
1 answer
868 views

Login failed for user 'sa'. ...... [CLIENT: 59.48.47.215]

I have an Amazon EC2 instance and i don't have anything running on it yet but my event log is full of below error "Login failed for user 'sa'. Reason: An attempt to login using SQL authentication ...
Parham's user avatar
  • 101
0 votes
1 answer
510 views

SQL 2008 R2 User Connections and Total Server Memory counters spike at the same time on multiple servers

We use SolarWinds SAM software to monitor servers and applications. We started using it to monitor our SQL servers through the performance counters. We started getting alerts two to three times ...
blizz's user avatar
  • 1,154
0 votes
1 answer
178 views

sa account not working anymore on SQLServer2008

I have been running SQLServer 2008 for some years now on my laptop. At a certain point I cannot login anymore with my sa account (mixed authentication turned on). I get the error message 233. This ...
Tom's user avatar
  • 1
0 votes
0 answers
231 views

Dummy transaction to check if a system is up

We want to send a dummy transaction through our system (Application - DB) to ensure it is still up every minute. If the transaction fails we are alerted - Thereby knowing within a minute if there is ...
Axle's user avatar
  • 33
0 votes
2 answers
41 views

SQL 2008 Failure after compressing HDD

I've absent-mindedly let Windows Server 2003 compress a HDD to try and save some space. That same drive contains an instance of SQL Server 2008. Since compressing, all the Databases have taken ...
Ben Ford's user avatar
  • 101
0 votes
1 answer
323 views

SQL Port 1433 needed in SQL Server2008 IP Field for remote connection

I just installed SQL Server 2008 on my server. I do it often enough to forget what to do so I read through a couple of MS installation instructions. I installed with no issues. I tried to remote ...
Steve Mansfield's user avatar
0 votes
1 answer
337 views

Real trouble for opening port in SQL Server 2008

I'm having trouble trouble opening port in SQL Server 2008 R2 Express Edition (http://www.microsoft.com/en-us/download/details.aspx?id=30438) even by disabling the Firewall. I also installed the ...
Guillaume Néry's user avatar
0 votes
0 answers
64 views

I must have done something wrong installing sample database

I downloaded file SQLEXPRADV_x86_ENU.exe (version 10.00.1600.22), and used it to install SQL Server 2008 Express with Advanced Services, which I think has capabilities comparable to SQL Server 2008 ...
Frank Bruno's user avatar
0 votes
0 answers
799 views

Identical tables, different sizes?

I have transactional replication with updatable subscriptions going between a few SQL 2008 R2 servers (publisher is Enterprise, subscribers are Express). I need to add another subscriber, and come to ...
happydba's user avatar
0 votes
1 answer
79 views

How to allow a SQL Login to see only ONE database

i have a SQL Server server 2008 r2. I wish to create a two new Login for a client who wishes to have access to their one database. But I don't want to give them access to the other my databases. ...
Pritesh's user avatar
0 votes
0 answers
103 views

SQL failover cluster on single ESXi host

I'm setting up a virtual environment consisting of 10 VM's with 2 primary SQL databases required. The infrastructure allocates two pairs of SQL 2008 R2 Enterprise edition (VM's). The pairs are ...
alex9183's user avatar
  • 105
0 votes
0 answers
252 views

Download SQL 2008 R2 and install remotely with key

I have the media and product key for a copy of SQL Server 2008R2, however, I can not get my CD to the server at my data center. Is there a downloadable version (or can the trial be downloaded) of the ...
HumanBacon's user avatar
0 votes
1 answer
149 views

How to best move system DBs from SQL 2005 to SQL 2008 R2?

I'm in the process of moving from SQL 2005 to SQL 2008 R2. Moving the production DBs and logs is straightforward, through either detach/attach or backup/restore. (new hardware, so I have the old ...
RickNZ's user avatar
  • 150
0 votes
1 answer
40 views

MS SQL - syncronising "a view" to another MS SQL server

Let me open by saying that I am no MSSQL expert. I'm a linux admin, so please forgive me if I should know this. I've been asked to syncronise a view or a table from one MSSQL database to another. I'...
Mister IT Guru's user avatar
0 votes
1 answer
478 views

SQL Server 2008 intermitent error 40 running parallel queries

Here's our setup : We are using Red Gate SQL Multi-Script to run queries on our ~1000 databases which reside on a single SQL Server 2008. SQL Multi Script can be configured to run queries in ...
MaxiWheat's user avatar
  • 237
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: ...
Rivka's user avatar
  • 353
0 votes
2 answers
78 views

Installing a second instance of SQL Server 2008

I am trying to install second instance of SQL Server 2008 Enterprise Edition on my Windows 7 machine using a network server, local service, and my admin account. However I keep getting the error ...
user avatar
0 votes
1 answer
222 views

How to configure Reporting server on SQL Server 2008, Windows 7

I want to configure reporting server on sql server 2008.I m using Windows 7 Operating System . I configure reporting manager using Reporting Services Configuration Manager and provide Service ...
user avatar
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 ...
Stallman's user avatar
  • 101
0 votes
1 answer
103 views

SQL Server 2005 connection to SQL Server 2008 R2

I having trouble with SQL Server 2008 R2 Express. I installed it and the service is running but SQLexpress, but without success. I even tired to uninstall SQL Server 2008 R2 and I could it said that I ...
user avatar
0 votes
2 answers
80 views

using multiple schemes in a clustered sql server 2008 Database

I have a SQL server 2008 R2 database with 2 schemas, i need to enhance the performance of the server so we plan to cluster the DB, we will have 2 nodes . is it possible to separate each scheme so each ...
Amr Monjid's user avatar
0 votes
1 answer
971 views

Data transfer between servers extremely slow

I have an application running on a Live environment with a Web Server which is running Windows Server 2008 R2 with a QuadCore Xeon processor with 8GB of ram and a Database Server with the same ...
Sabry's user avatar
  • 1
0 votes
1 answer
55 views

SQL Express 2008 uninstall not complete

How do I get rid of SQL Express 2008 after it's been uninstalled. It's all over my file system and all over the registry on 2008 R2 server sp1.
Steve's user avatar
  • 1
0 votes
1 answer
68 views

SQL Server NIC Power Saving

We have a server running Windows Server 2008 which is dedicated to hosting a SQL Server 2008 Database. Whilst auditing the server OS we have noticed that the NIC Power saving feature is enabled. ...
user1256582's user avatar
0 votes
1 answer
880 views

SQL Server filestream access from another computer using system account

I have a SQL Server 2008 set up to use filestream. SQL Server runs under a domain account with SPN set and delegation enabled. Accessing filestream from another computer using a domain account works. ...
Andrew J. Brehm's user avatar
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 ...
Meh Man's user avatar
  • 131
0 votes
1 answer
665 views

sql server 2008 r2 can connect with connection manager but noway else

I have installed (3 times on 3 machines) sql server 2008 r2 can connect with connection manager but other program cannot connect. I can connect to remote sql servers with heidisql or with my ...
JJvP's user avatar
  • 1
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 = "...
rboarman's user avatar
  • 237
0 votes
1 answer
711 views

how can I determine that I am consuming SQL CAL license?

assuming I have bought 5 User CALs and now I need to tag these licenses, can some tell me how to determine this?
Devinder's user avatar
0 votes
1 answer
147 views

sql script mssql express 2008 windows 2008 server R2 x64

Scenerio:I need to run an update sql script after another scheduled task. server=Windows Server 2008 R2 x64 db = Sql Express 2008 when? - Everyday buy Sunday(i know how to do this) Why? A third party ...
nkuebelbeck's user avatar