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
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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: ...
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 ...
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 ...
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 ...
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-...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
...
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 ...
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 ...
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 ...
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'...
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 ...
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:
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
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. ...
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.
...
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 ...
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 ...
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 = "...
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?
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 ...