A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.
1
vote
1answer
942 views
sqlsrv not showing up in my phpinfo [closed]
I have just installed php 5.3 on windows server 2008 R2 running IIS7.
phpinfo() is working fine.
now I want to see if I have correctly installed the Microsoft Drivers for PHP for SQL Server.
I ...
1
vote
2answers
3k 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
795 views
SQL 2008 install failed - Could not find the Database Engine startup handle
My SQL 2008 install failed, I'm getting this error:
Could not find the Database Engine startup handle
This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ...
0
votes
1answer
847 views
Export Import error 'SSIS Data Flow Task could not be created' … registering DTSPipeline.dll, cannot create task “STOCK:PipelineTask”
I'm about to throw in the towel on this one.
Running SQL Server 2008 enterprise on Windows 7 x64. Can't get past this issue.
When I try to Import / Export Data from databases through SQL Server ...
2
votes
2answers
3k views
AclPermissionsFacet fault install SQL-2008-R2
While attempting to do an installation repair of SQL-2008R2, I'm failing the pre-check rules.
Module that is failing is AclPermissionsFacet - with this message "The SQL Server registry keys from a ...
0
votes
3answers
51 views
Increasing vCPUs for Server 2003?
I have a VM running Server 2003 and SQL Server 2008 on VMware ESXi. Can I safely assume this configuration can cope with a change to the number of vCPUs? Are there better solutions to address the ...
1
vote
1answer
2k views
How can we recover/restore lost/overwritten data in our MSSQL 2008 table?
I am in serious trouble and I am seeking professional advices here.
We are using MSSQL server 2008. We removed primary key, replaced exiting data with new data resulted losing our critical business ...
2
votes
4answers
657 views
Remote SQL server connection failure
I am trying to connect to my MSSQL server 2008 web instance and im failing horribly... i get the error 26 and before you jump on me i have done these
Check the spelling of the SQL Server
instance ...
2
votes
1answer
29 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 ...
1
vote
2answers
45 views
How do I install SQL Svr Native Client 10.1 after SQL 2012 has been installed
On a Windows Server 2012 I have SQL Server 2012 installed which has the SQL Server Native Client version 11. I am being told by a developer that he needs the SQL Server Native Client version 10.1 ...
0
votes
0answers
20 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
1answer
1k views
SQL Server 2008 R2 Transactional replication ports
http://technet.microsoft.com/en-us/library/cc646023.aspx states
Replication connections to SQL Server use the typical regular Database Engine ports (TCP port 1433 for the default instance, etc.)
...
0
votes
1answer
1k views
Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio
I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
0
votes
0answers
15 views
Proxy DMZ server to bounce data between sql server and clients
Is this feasible?
I have a sql server that is setup behind a corporate firewall. I have clients that need direct connection to that sql server via ODBC. Instead of punching holes in the firewall I ...
-1
votes
0answers
15 views
IIS Site taking long time to show [closed]
I have a website which is hosted on our internal server.
We are using
Server 2008 R2 64bits
SQL server 2008
When I tried to access the site it take 5 minutes but was timeout and in IE it was not ...
0
votes
1answer
31 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.
...
2
votes
1answer
2k 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
3answers
2k views
Disable remote access for one user/database in SQL Server 2008
is this possible to disable remote access for one user or database in SQL Server 2008?
Thanks
0
votes
2answers
3k views
Enable anonymous access to report builder in reporting services 2008
I have a 2008 reporting services server installed on windows 2003 server. I am trying to allow anonymous access to the report builder folder so that my users do not have to select the remember ...
1
vote
2answers
961 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 ...
1
vote
0answers
25 views
Failover cluster wouldn't fail over
I have an active-passive failover cluster on 2008r2 with SQL server 2008 clustered on it.
I go to fail it over for maintenance and the resource failed to come online on either node. Once I rebooted ...
0
votes
2answers
1k views
Can't Connect to (local) database
I have SQL Server 2008 and was forced to make a new windows 7 profile. I no longer can connect to my (local) databases.
Everything I try to use windows authentication to login I get
Cannot ...
0
votes
2answers
502 views
Problem with installing SQL Server 2008 SP2 on Win XP
I'm not much of an IT person but I've been struggling with this issue for hours and I hope maybe someone here will know how to assist me.
I've just installed SQL Server 2008 Developer, I've chosen the ...
0
votes
2answers
372 views
Installing SQL Server 2008 SP2 fails in 2003 cluster setup
When I try to install SP2 (or simply "repair" the SQL Server installation), the dependency check finds the following problem:
Rule "Not clustered or the cluster service is up and online." failed.
...
1
vote
3answers
236 views
SQL2005 Express Machine believes it's part of a Cluster fails to Upgrade
I have a machine where I am attempting to upgrade from Sql2005 Express to Sql2008r2 Express, but it is failing on the Rules check.
Rule Check Result
Rule "Not clustered or the cluster
...
0
votes
4answers
2k views
Merge mulitple databases into single database with multiple schemas in SQL Server 2008
I have five smallish databases all within a single SQL Server 2008 instance. The databases are related (by business entity but not by data) so I'd like to merge them into a single database and give ...
0
votes
1answer
912 views
SQL Server 2008 setup error Attempted to perform an unauthorized operation
I am trying to install SQL Server 2008 Standard Edition on windows 7 and during installation it give error:
Attempted to perform an unauthorized
operation
0
votes
1answer
1k views
Connect by Wifi to Sql Server from another computer
I try to connect by Wifi to Sql Server with Sql Server Management Studio from another computer but it failed.
I have a computer with Windows Seven & Sql Server 2008 (lets say the server ...
2
votes
2answers
2k views
SQL2008R2 install issues on windows 7 - unable to install setup support files?
I am trying to install the above but am getting the following errors when its attempting to install the setup support files,
This is the first error that occurs during installation of the setup ...
0
votes
0answers
47 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
0answers
12 views
How can I set Timeout by View, User or Role? [migrated]
I also posted this question at http://superuser.com/questions/586148/how-can-i-set-timeout-by-view-user-or-role I have searched at ServerFault for an answer and not found the question or an answer.
...
1
vote
3answers
730 views
Could SQL Server 2008 replication be used with NLB to allow unlimited scaling of reporting servers?
We are currently using transactional replication in SQL Server 2008 to keep a secondary reporting server synchronized with a primary database server. This has been working weel and keeps some of the ...
0
votes
3answers
1k views
Error when trying to open SQL Maintenance Plan - SSMS 2008
If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error:
TITLE: Microsoft SQL Server Management
Studio
Could not ...
0
votes
2answers
30 views
In sql-server, how do I give server-level permission to user to make backups on any database
I need to give a user server-level permissions, once and for all time, to back-up any existing or future database on the server instance, without making the user sysadmin. How can I do that?
I've ...
0
votes
0answers
14 views
Using SSMS, how do I add a row to when a column is read only?
How do I add a row to when a column is read only? I think this issue I am having is because I am using an ID field (column) that is automatically generated and incremented whenever a new row is added ...
0
votes
1answer
26 views
Restore backup from SQL 2008 to 2008R2 with standby
We are looking to replicate our production database to another instance so that when reports are run, it doesn't slow down the application to the point of being barely usable. I had limited success ...
1
vote
2answers
18 views
Exploring / editing SQL Server data of a runtime installation
I installed some software which has built into its installer a sort of minimal installation of SQL Server 2008 R2 Express. The software itself uses the database just fine, but I want somehow to be ...
0
votes
1answer
881 views
Unable to start SQL Server Instance 2008 R2 - DB file corrupt
I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is
" The log scan number passed to log scan in database ‘master’ is not valid. This ...
-2
votes
1answer
30 views
Creating a server for SQL Server [closed]
I need to configure an SQL Server server. I've googled it but I can't find anything (I'm probably not searching for the right keywords). Can you guys give some ideas of how to do it/what to search ...
1
vote
2answers
699 views
Setting Timeouts: SQL Server 2008/IIS 7.5
We have recently migrated from a Win 2003/SQL Server 2000 system to Win 2008 64 bit R2, SQL Server 2008 R2.
Our websites are in classic asp, and this can't be changed to another scripting language at ...
18
votes
8answers
50k views
SQL Server 2008 Express - “Best” backup solution?
What backup solutions would you recommend when using SQL Server 2008 Express? I'm pretty new to SQL Server, but as I'm coming from an MySQL background I thought of setting up replication on another ...
1
vote
2answers
1k views
How to start MSSQL Server with corrupt model db
After moving some databases around (restoring, deleting, etc) we experienced an issue creating new databases. Specifically, When trying to create a new database MSSQL Server it failed because the "The ...
1
vote
1answer
44 views
My php site cannot connect to SQL Database - SqlExpress2012
Im quite new to SQL Express 2012, but have just installed it on my server 2008 r2.
Im trying to install a CMS called joomla, which I' ve done many times before both on SQL community server and hosted ...
0
votes
0answers
32 views
SQL Server 2008 R2 Analysis services not starting
Folks,
I installed SQL server 2008 R2 on windows server 2008. During installation there was an error "MSSQLSERVEROLAPService could not start" but the installation continued and I was able to complete ...
2
votes
3answers
3k views
Can't Open Port 1433 on Window Server 2008 (attempting to connect to SQL Server 2008 Express)
I'm trying to open Port 1433 on windows firewall but not having much luck.
I've added a new Inbound Rule (attempting to open TCP 1433) which looks okay and appears to be on but when I run netstat -an ...
0
votes
1answer
135 views
SQL connection with mirroring still working after a failover
I have a windows service application that is instaled on two servers, SQL01 and SQL02. On both server there is a SQL server (X1 and X2), which have the same content. A mirroring partnership was set up ...
-1
votes
1answer
39 views
SQL server ODBC connection for Active Directory user who doesn't log in to the windows
Do you think it is possible to create a SQL server ODBC Connection for an active directory user who doesn't log in into the windows.
Ideally this type of users will be used in the batch process. So, ...
0
votes
0answers
38 views
SQL Server 2008r2 SP2 Manual Install Error
I am receiving an error I have never seen before, nor can I find any info on the net. When I try to install SP2 for SQL Server 2008r2 I receive the following error.
Cannot find the value of the ...
3
votes
1answer
769 views
Alias to SQLEXPRESS
I have developer edition from SQL Server 2008, but now I have a piece of software with a hardcoded connection string:
Data Source=.\SQLEXPRESS;Initial Catalog=db;User Id=sa;Password=1234;
Now I ...
0
votes
0answers
72 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 ...
