Tagged Questions
2
votes
1answer
24 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
19 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 ...
1
vote
2answers
41 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
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 ...
-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
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
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
1answer
102 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 ...
0
votes
1answer
65 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
145 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
44 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
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
65 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
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
1answer
74 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 ...
2
votes
2answers
344 views
Install SQL CLR types & Report Viewer 2012 on Sql 2008 server
I'm in the process of installing a client's ASP.net site on a Windows Server 2003 box running Sql 2008.
The site uses Report Viewer 2012, but when I attempted to install it on the server, I got the ...
0
votes
1answer
27 views
Backing PDF files and SQL server DB
I have my own Windows Server an Asp.Net application hosted live. The application allows users to upload CV PDF files and I have the DB also on that server. Which steps should I take to ensure that all ...
0
votes
1answer
94 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
0answers
78 views
How to rectify FDQN error in mirroring?
While establishing mirroring without witness at last step i am getting an error:
One or more of the server network addresses lacks a fully qualified domain name (FDQN). To start mirroring without ...
2
votes
1answer
80 views
Cannot access SQL 2008 or 2012 R2 Express server remotely
I have tried to remotely access two different servers on two different machines, one 2008 the other 2012, and have had zero luck with either machine.
I have followed the steps in: How to enable ...
0
votes
1answer
36 views
Microsoft SQL Server 2008 Replications [closed]
I`m trying to setup two servers in my company to be synced, I know that SQL Replication is the best way, but I have a lot of problems with that, I saw some video clips about that but still there are ...
0
votes
1answer
49 views
Does the disk space used by this database seem normal (MSSQL 2008)?
The Disk Usage report is showing lots of unused transaction log space (seems normal, there are hourly log backups). However the data file is mostly indexes and there is very little unused space. Is ...
0
votes
0answers
16 views
Didn't found the Sql server name for MS sqlserver 2008 [duplicate]
Possible Duplicate:
I cannot connect to my local SQL Server 2008?
i installed Sql server 2008 express edition on windows 8,
i didn't find the server name to connect.
i used the different ...
0
votes
0answers
25 views
How does SSMS and SQL Server Licensing work? [duplicate]
Possible Duplicate:
Can you help me with my software licensing issue?
Could not get a efficient enough answer from MSFT or some of their vendors.
Trying to determine exactly how the ...
1
vote
1answer
97 views
Adding anonymous IURS IIS user fails into SQL SERVER 2008 R2
I am trying to add a anonymous IIS user [IUSR] to a SQL SERVER 2008 r2 database.
But I am getting the following error:
'notebook/iusr' is not a valid login or you do not have permission.
I think ...
-2
votes
1answer
77 views
Set password for SQL Server 2008 R2 Account
I have just been given access to a new Windows Web Server 2008 R2 which has SQL Server 2008 R2 installed on it. When I open up SQL Server Management Studio and try to connect, it does so with Windows ...
0
votes
0answers
609 views
Fatal error 9001 on shared SQL Server 2008
I've asked this same question on StackOverflow, but I might actually have a better chance for an answer here so am posting here as well.
I know this question has been asked here before, but none of ...
0
votes
4answers
171 views
Two MS SQL Instances, one database file
Is it possible to have one database file attached to two different instances of SQL?
Consider that the MDF is located on a NAS and I want a primary and secondary instance of MS SQL on two different ...
0
votes
0answers
45 views
All partitions in one filegroup
Recently, I was asked a question about partitions in SQL Server 2008. I have two tables with the same schema and the same data in it, and I create clustered index on one the first table, and ...
1
vote
1answer
85 views
Is there a negative impact to using SQL Server with a lower compatibility level
We have SQL Server 2008 R2 which we are using for a database with a compatibility level set as 2005 (90).
We will by upgrading it to 2008 at some point, but in the meantime I would like to know if ...
1
vote
1answer
90 views
Will more memory help my CPU-peaking SQL Server 2008 R2
I'm supporting a system running against a SQL Server 2008 R2. The server is a single-CPU box with 8 GB of memory. As traffic has increased, the server has started saturating, peaking to 100% CPU ever ...
0
votes
1answer
73 views
Sql Server 2008 Create Foreign Key Manually
I have inherited an old database which wasn't designed very well. It is a Sql Server 2008 database which is missing quite a lot of Foreign Key relationships. Below shows two of the tables, and I am ...
0
votes
1answer
879 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 ...
1
vote
1answer
238 views
What's the importance of restoring SQL Server system databases (model, master, etc.)?
I had to restore some production databases to a different drive on the same Microsoft SQL Server 2005 machine. That worked fine and the application using the databases is back online.
However, i have ...
0
votes
1answer
177 views
SQL Server 2008 R2: starting SQL browser failed
During troubleshooting of the failed connection to sqldb in my testsystem I've tried to start sqlbrowser via command line. This results the following error message "failed starting SSRP redirection ...
0
votes
3answers
754 views
Linked server issue. Can't use windows authentication as remote login account
I tried to set up linked server. The target server is MS SQL 2008R2.
It works fine if I set Remote login by sa account.
However, if I use a windows account, it will popup an error.
And I get the ...
0
votes
1answer
61 views
Unable to install SQL Server 2008 Express SP1
I am facing difficulties installing the MS SQL Server Express 2008 Service Pack 1. I already have MS SQL Server Express 2008 installed and all I want to do is to install the SP1 however I get ...
2
votes
2answers
405 views
When adding second processor to SQL Server, will it automatically balance the load?
We have a SQL Server 2008 R2 (10.5) on a dedicated box with a single 2.4Ghz processor, which regularly runs at 70-80% CPU. We are going to be adding a significant number of users to the application ...
2
votes
1answer
115 views
Existing tables with binaries to use filestream
I've got a few tables for which I want to use filestream storage.
These tables already contain binary data and have rowguids. However at the time they were were created, the tables were not added to ...
0
votes
0answers
131 views
Can't Connect SQL server - process being used by another process. Conflict with IIS?
I'm having problem connecting to MS SQL Server (2012 Express) after accessing a database through IIS (web site). I can access the data through web site no problem, but I can't access the data from any ...
0
votes
1answer
432 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
1answer
62 views
Difference between having two filegroups and having two databases
I have a thousand web servers writing their logs to a SQL Server 2008 database. The log information can be up to 100 GB per day, and we keep 1 month’s worth of logs.
Each day, we run queries on the ...
1
vote
1answer
44 views
Sql Server - Minimum rights to be able to grant other people similar rights
I would like to grant someone on our web dev team the ability to grant other users (other web developers as well as application users they create) datareader, datawriter, and exec sproc in our Dev and ...
0
votes
2answers
156 views
Configuring SQL Server 2008 log shipping
I am trying to configure log shipping from a cluster of two Windows Server 2008 R2 x64 machines running SQL Server 2008 R2 to a single machine running the same OS and DB. Setup appears to go okay (no ...
0
votes
0answers
157 views
CHECKDB fails with 'failure detected while collecting facts' but cannot find cause
I am trying to execute the following command on MS SQL Server 2008 R2:
alter database main_db set single_user with rollback immediate
alter database main_db set single_user
dbcc checkdb (main_db, ...
