A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.
0
votes
0answers
14 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
0answers
16 views
How to improve the performance for SQL Server Count(distinct()) and Sum() functions? [closed]
The below one is my query. It's taking 12 seconds for the execution process. The count(distinct()) and SUM() functions are taking long time for execution. I tried it after create the non-cluster index ...
0
votes
3answers
52 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 ...
2
votes
1answer
35 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 ...
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
0answers
16 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
vote
2answers
49 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 ...
-1
votes
0answers
16 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.
...
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
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.
...
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 ...
-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 ...
0
votes
0answers
35 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 ...
-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 ...
0
votes
0answers
73 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
0answers
39 views
SQL server replication, subscription to remote server : issue while choosing the publisher
I am trying to create a subscription to a remote server having SQL 2008 R2
the client PC is connected through VPN to the server and can discover it successfully.
I can even connect to the database ...
0
votes
0answers
17 views
Web application expansion with added workload
I was wondering what would be the route for expansion in this case?
Let me explain. I wrote an ASP.NET web application that acts as an API server for a client program that runs on all types of ...
1
vote
1answer
45 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
58 views
MS SQL 2008 - Can I use Windows Authentication to connect from a Mac
I have been using Navicat SQL on Mac (Snow Leopard) to connect to MS 2005 via "Basic Auth" and all is good.
However the DB is now being migrated to MS 2008 and try as I might I cant get on via Windows ...
0
votes
1answer
66 views
Cannot Connect to SQL Server 2008 R2 from Sharepoint Server
I have installed SQL Server 2008 R2 on dbserver and Sharepoint 2010 on webserver. When trying to configure Sharepoint to use the database installed on dbserver, it says it cannot connect. Then I ...
0
votes
0answers
58 views
Remove person from Active Directory Group but he still have access to webapplication even after the 15min AD Replication
First here is the setup.
SQL Server 2008, c# . net webapplication, ADGroups in same domain.
I have an AD Group named "FirstAD" and users inside.
SQL under Users have the ADGroup added and its ...
0
votes
1answer
34 views
Problems restoring local instance in SQL Server 2008 R2 Express
I have set up a local instance in SQL Server 2008 R2. I have a database (called GD_LOCAL_TC) that I need to restore so I can begin working in it (right now it's empty).
When I right click on ...
0
votes
0answers
22 views
SSRS 2008 R2 Scale-Out Deployment
I am working on configuring a scale-out deployment of SQL Server Reporting Service 2008. Everything thing I read requires Windows Network Load Balancing. Is that required for scale-out deployment of ...
0
votes
1answer
57 views
Best Practices Analyzer for Microsoft Dynamics AX 2009
We recently uncovered a potential issue with our Dynamics AX setup whereby Receive Side Scaling (RSS) was not enabled on our AOS servers, which we believe is limiting their performance (currently ...
0
votes
0answers
38 views
Login failed for user 'domain account name'. Reason: Failed to open the explicitly specified database. [CLIENT: ######
I am seeing this error in my SQL Server Logs (2008 R2). The server gets rebooted every month and this message appears in the logs during the reboot process. The message is repeaded dozens of times ...
0
votes
1answer
105 views
SQL 2008 R2 Clustering AND DB Mirroring (Async)
I've got a MS SQL 2008 R2 Fail-Over Clustered Instance running between two Windows 2008 R2 servers using the inbuilt Windows Clustering features, that is working with a DTC and Quorum with a disk ...
5
votes
1answer
91 views
32-Bit SQL eating up RAM on 64-bit OS until SQL is brought to it's knees
This may be related to other threads I've seen, but I need a solution to this specific situation. The SQL instance continuously consumes more and more RAM until after about a week it's grabbed over ...
0
votes
1answer
68 views
Can I move all DB files on SQL server 2008 to a different logical drive and then change the drive letter?
I've got a SQL Server 2008 (std) with 19 DBs. Because I'm replacing my SAN, I need to move all the DB files to a different volume. I've moved individual DBs before using MS's recommended method: ...
0
votes
0answers
148 views
Creating database from Entity Framework and Code First create database error
This got kicked off of Stackoverflow as off topic. I was told to post here so hoping you guys can help me out.
I'm running on MSSQL 2008 Express, EF5 and MVC4
My web.config file looks a bit like ...
0
votes
1answer
45 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
0answers
114 views
How to configure MSSQL Database Mail to send attachments [closed]
I previously had Database Mail configured to send out e-mails and it was working without any issues. I now need to be able to send attachments and I am getting an error. This is what I've done:
...
1
vote
0answers
45 views
sql server x64 access x86 COM object
I want to transfer a database from SQL Server 2000 x86 to SQL Server 2008 R2 x64 but it uses a x86 COM object that I have no inside knowledge of. I know there are some articles out there about the ...
0
votes
0answers
61 views
Merge Replication fails on some tables (multiple publishers, single subscriber)
We had set up merge replication with multiple publishers and a single subscriber. The articles are four tables (similar across all four publications).
The problem is that 1 of the tables has been ...
1
vote
0answers
67 views
SSMS stuck scripting database objects
SQL Server Management Studio sits stuck, after scripting all objects in a database. Except it didn't script all objects in a database.
i scripted all the objects in an SQL Server 2008 database from ...
0
votes
1answer
31 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. ...
0
votes
0answers
22 views
configure sql server tcpip with 2 instances
I have 2 instances of SQL Servers: SQL Server 2008 and SQL Server Express 2012 on the same computer.
I'm trying to configure them both to use TCP/IP and I've noticed that changing the port number for ...
0
votes
1answer
91 views
SQL Server reliance on Domain Controller
Just have had an interesting situation with a remote database server which I did not think happened.
The setup is server A is a domain controller in the main network, and server B is on a remote ...
0
votes
1answer
39 views
How to un-install sql server 2008 analysis service only?
Initally I installed SQL server 2008 R2 Evaluation version. Then we bought licence key for SQL server 2008 R2 Web and wanted to update my licence, but unfortunately I installed analysis service when I ...
-1
votes
1answer
35 views
MS SQL Express - Memory limitation vs. web application [duplicate]
I have web application that will be similar to forums. I plan to have few thousands+ users on this application, and i wonder if i can use MS SQL Express - here is the list of it's limitations:
...
0
votes
0answers
33 views
SELECT query not returning all rows in SSMS [closed]
I have a table in MSSQL 2008 Express. I manually added a record to a table this morning via SSMS. To the best of my knowledge, there should be 24 records in the table. This afternoon, if I execute
...
0
votes
0answers
45 views
How can I Grant permissions to a database for the IIS App Pool account?
I'm getting this error:
Cannot open database "AdventureWorks" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\ASP.NET v4.0'
My simple SiLverlight App (hosted in IIS 7.5) ...
1
vote
1answer
137 views
Trouble Publishing an MVC4 site on HostGator
I have been working on a C# MVC4 website and trying to publish it to a Host Gator shared Windows hosting account. They are running both MSSQL 2008 and mySql. We have run into some trouble when trying ...
0
votes
1answer
88 views
opening firewall 1433 port to IP address that require a direct connection
We are upgrading from sql server 2005 to sql server 2008 and windows server 2008 R2.
New server is behind a firewall, we have 30 or so windows XP machines, that will require the port 1433 to be ...
0
votes
0answers
27 views
Instant File Initialization Turned on but file grows slower in sql server 2008r2
What are the reasons a data file (8 GB) could take a long time to grow even if Instant file initialization is turned on in sql server 2008r2?
The sql service account has admin access to "Perform ...
