Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the sql-server tag link on the line below.

learn more… | top users | synonyms (4)

1
vote
1answer
35 views

Setting up access to one table

I just set up access for a SQL server user to a single table. I did this by putting giving the user the db_datareader role. Then I set the permissions for all the tables I didn't want this user to ...
0
votes
2answers
48 views

How to allow domain groups access to SQL server?

I'm sure this is a simple problem, bu I've looked for days... I have a SQL server that is part of a domain. The domain has many many users. I want to allow select permissions to anyone within a ...
0
votes
1answer
93 views

Error on collection_set_2_upload [closed]

The following error appears in the Job history Log in SQL Server An error occured while trying to access the cache directory: "D:\". Inner Error ------------------> Access is denied. Process Exit ...
0
votes
1answer
79 views

Are there speed and resource allocation differences between 1x 300 GB Azure VM data disk vs 3x 100GB Data disks (and striping those)

I'm researching playing around with a Sql Server VM on Azure. Our DB is around 30-40GB. So i was thinking about making a 300GB data disk to put the 1 Database on it (or a few more, later). I ...
1
vote
1answer
92 views

SQLIO IOPS Explanation

OK. We have a few PowerEdge Rack servers that we use for MSSQL. I have one server that has 3 raid arrays of RAID 1 that are SATA. I can run SQLIO and get close to 6,000 IOPS. How is this even remotely ...
0
votes
0answers
45 views

Azure SQL Reporting Services - cost and options

At the moment, it costs $119 per month to use Azure SQL Reporting services. We want to make the move to Azure SQL Reporting/SSRS as our reporting capabilities are expected to grow quite dramatically ...
0
votes
1answer
40 views

SQL Server normalizing for performance

I have a table create table Objects ( ObjectID bigint not null primary key, ObjectRef1 varchar(50) not null, ObjectRef2 varchar(50) not null, ObjectRef3 varchar(250) not null ) All ...
0
votes
1answer
29 views

MS SQL 2005 Client excessive memory usage

Hi I inherited the support of an MS SQL 2005 server on a Windows 2003 server and its client XP workstations running MS SQL 2005 Native client. The database is appox. 1GB in size and some of the tables ...
2
votes
1answer
154 views

SQL Server remote backup query fails “cannot open the backup device”

I am trying to configure my scheduled backups of a MSSQL database to a mapped network drive, which is on a fileserver running Server 2003 Standard. Query reads like this: BACKUP DATABASE XXXX TO ...
-1
votes
1answer
36 views

SQL Server 2008 R2 memory consumption for no usage [closed]

I have a application that uses SQL Server 2008 R2. I have a problem of memory consumption on the client side. Whenever the client runs the application, the SQL server starts consuming memory even if ...
0
votes
1answer
37 views

Two SQL Failover Clusters in two-node failover servers

I need 2 SQL Failover clusters: Core Database Cluster: this contains all of my core application databases Analytic Database Cluster: this contains my web analytic database Now, I only have 2 ...
2
votes
1answer
113 views

Upgrade Expired SQL Server 2008R2 Evaluation to SQL Server 2012

We have been working on developing several SharePoint sites as a POC using the evaluation versions of SharePoint 2013 and SQL Server 2008R2 Enterprise Evaluation. POC worked, went into limited ...
0
votes
1answer
498 views

MSSQL: "Could not allocate space for object 'dbo.SORT temporary run storage in database because 'PRIMARY' filegroup is full

I have been around the block with this issue several times today checking blog posts everywhere and nothing has helped me to fix and resolve this issue. I'm trying to add a non-clustered index to a ...
5
votes
5answers
340 views

Using SAN Replication/Snapshots for SQL Server disaster recovery?

We have a web application that utilizes SQL Server 2008 on a single database server. All storage is local. For the past year we have been trying to get any form of SQL Server Replication to work ...
1
vote
2answers
588 views

VMWare NUMA Node Boundary Configuration

I have been trying to find out what the best VM configuration would be for our SQL Server 2012 on VMware 5.1 would be. The VM host(s) has 2 sockets with 4 cores running hyper threading (total of 16 ...
2
votes
1answer
42 views

Windows Server grindingly slow due to disk bottleneck caused by SQL Server

Doing anything on my Windows Server box is unbearably slow to the point of the system nearly being unusable...Looking into it I can see CPU isn't being used and there's plenty of RAM free. However SQL ...
0
votes
1answer
789 views

Connecting to MySQL & MS-SQL yields “Access denied for user” error message

I am trying to connect to both of my database servers, however when using some interfaces (web and some apps), I get the error message: Connection cannot be established with database. Authentication ...
0
votes
1answer
31 views

SQL Server 2012 Management Studio Connect after some time (File not found error)

I've a root server with Window Server 2008 R2 where MS SQL Server 2012 is installed. Get a error while connecting. Management Studio Error Message File not found This error only occur directly after ...
0
votes
1answer
137 views

No file access permissions after restore database

I have a strange phenomon. When I restore a SQL-Server 2012 database to a folder on my D-Drive, it gets restored just fine. I can access the database and basically it works fine. But when I check the ...
0
votes
0answers
41 views

Access violation on inline function with CTE

Heh, that's weird. I have simple table type and inline table-valued function. When I try to run or compile this batch, I got c0000005 EXCEPTION_ACCESS_VIOLATION ! create type M1List as table (ID ...
1
vote
2answers
158 views

My hosting provider allows me to see the names of all other databases on their servers, is this bad practice? [closed]

I've got MSSQL DB functionality set up with a hosting provider, and recently logged in for the first time. When I added the connection, it then listed (apparently) every single MSSQL database on ...
-1
votes
2answers
51 views

Is one required to convert any database used with previous SQL server version when using with newer one i.e 2012

I am setting up a dev environment on a my local PC, however when deployed the project I am working on will be using SQL Server 2008. Could I install SQL server express 2012 for local testing and not ...
1
vote
1answer
53 views

Issues connecting to SQL Server

I'm trying to boot up a sitecore application. Got the source code, set up my local IIS, but for some reason I'm getting the following error: A network-related or instance-specific error occurred ...
1
vote
1answer
593 views

How do I determine what database WSUS on my Windows Server 2012 is using?

I installed WSUS on a fresh installation of Windows Server 2012 (I assume this is WSUS 4 as it is bundled with Server 2012 with no option to download it anywhere online) I did not install any ...
0
votes
2answers
200 views

Weird behavior using Active Directory group mapped to SQL Server user/login

I've run across a very odd behavior on SQL Server 2008R2. I have a third-party application which acts as a SQL Server client. I have a subset of my users who should have access to this application. ...
0
votes
1answer
32 views

SQL Server datafile growths

For SQL Server 2008 what is the maximum number of growths? And which view do I query to find that information for a datafile in my database?
1
vote
4answers
66 views

Muliplte logical drives on a single EVA

SQL Server best practice recommends separate drives for the the data and log files. Do you really get a speed increase if both logical drives are located on the same EVA?
1
vote
1answer
44 views

Changing TFS Service account

I have an installation of TFS that was installed incorrectly and the account that the services run under is a developers account! Not great. I have created a domain account called TFSService to run ...
2
votes
1answer
102 views

MSSQL Server 2012 Scheduled PowerShell Job fails

I have a simple PowerShell script that runs fine from the console (PSVersion 2.0). $psftpPath = "C:\Program Files (x86)\PuTTY\psftp.exe" $sftpHost = "foo.baa.com" $userName = "myusername" ...
0
votes
1answer
61 views

Sharing LINUX NFS Folder on Windows Server

I have some CSV files on Linux. I would like to load them into my SQL Server with a stored procedure. I'm looking for a way to share the files via NFS with my Windows Server. I was wondering if ...
2
votes
1answer
80 views

Excluding a SQL File Group from DPM Backup

I have numerous SQL 2012 databases that are being backed up by Microsoft's Data Protection manager (DPM) 2012. However, in each of these databases there is a specific file group that contains a large ...
0
votes
1answer
38 views

SQL for duplicating parent and children records

I'm trying to figure out the best way to create a SQL statement (in SQL Server) to duplicate a parent record and all the children records. I have the below as an example; -- duplicate the order ...
0
votes
1answer
81 views

Seperate SQL databases for Web Applications? Or host both web apps on same SQL?

Ok, my Hyper-V Server 2012 looks like this: we currently have 2 VM's in production, one is running SharePoint 2010, and the other is hosting the SQL Server 2008 R2 for SharePoint. We're getting ...
1
vote
1answer
424 views

SQL 2008 Reporting Service SSL certificate chain not trusted

I got a SQL Server 2008 Standard Edition installed on a Server 2008 R2, OS and SQL Server got newest Service Packs and updates installed. The SQL Server is up and running but I cant connect to the ...
3
votes
2answers
144 views

SQL Server supports a maximum sector size of 4096 bytes

I am trying to install SQL Server 2012. It fails with message Cannot use file 'D:\SQL\tempdb.mdf', because it is on a volume with sector size 8192. SQL Server supports a maximum sector size of ...
0
votes
1answer
31 views

Project Server 2012 Setup Claims there is a Previous Version - it's not

I have set up a test environment with this software on the Server: Windows Server 2012 Standard SQL Server 2012 SharePoint Server 2012 Enterprise Language Pack for the SharePoint Server Team ...
0
votes
1answer
39 views

Unable to modify Views on MSSQL server

I have recently had to take ownership of a MSSQL 2005 install. There is only one database, with several tables and views, and I should have full permissions to everything, as far as I can tell. ...
0
votes
1answer
45 views

Add Windows User Account to Ubuntu Server

I have a Ubuntu Server v. 13.04 that I am using as a file server (amongst it being a LAMP stack). I have a samba share let's call it /shares/SQLDatabases I have a Windows 2008 R2 Server in the same ...
1
vote
1answer
462 views

Medialayout Silent installation sp1 sql2012

My silent installation for SQL Server 2012 SP1 is failing and giving an error as below. Any ideas? TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: ...
0
votes
2answers
462 views

Port forward an incoming SQL connection over TeamViewer VPN

I have a remote server which in turn has access to a SQL Server instance running in the same network. I am developing tools to use this SQL server, but have no backup or rights to backup/copy the ...
3
votes
1answer
666 views

vCenter SQL Express Database Maintenence

After performing a simple install of vCenter 5.1 with all default chosen including the sql express database, what should we do to ensure continued operation without manual intervention? Currently we ...
-1
votes
2answers
75 views

SQL 2012 Server Database Transaction Replication performance issue [duplicate]

We have configured SQL 2012 Server Database Transaction Replication for our client's .NET Web application to distribute SQL transaction and reporting on different SQL servers. We had implemented ...
1
vote
1answer
68 views

MSSqlServer 2008 how to migrate sys.message to another server ? (eventID 18054)

Recently I've replaced a sql server (2008R2). I've reinstalled hosted apps and restored backups of databases. All seems to work as expected except that these events are shown in the eventlog : id ...
0
votes
2answers
22 views

Looking for SSMS 2008 Express Only

I downloaded SQL Server 2008 Express from here..... But it still did not install the SQL Server Management Studio that I need to connect to my databases.....see image below....looking for this. ...
0
votes
2answers
67 views

azure websites backup strategy [closed]

I hope this is the right place to ask this question. I have a simple azure website with a linked sql azure DB. I want to be able to back up both the ftp files and the SQL DB. What is the best ...
0
votes
0answers
56 views

Insert copied row from Excel into Microsoft SQL Server Management Studio by replace

We copy a lot of data from MS Excel sheets into SQLServer database tables using simple copy + paste over Microsoft SQL Server Management Studio. This procedure works fine if the id of the row to copy ...
3
votes
1answer
110 views

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple ...
1
vote
1answer
27 views

sql server seems hung when updating a table

I have a task which I run from the MS SQL Server Management Studio. I would expect it to finish in an hour and it has finished before in such time frame. The input data has not changed dramatically ...
0
votes
1answer
424 views

“There are currently no logon servers available to service the logon request” when trying to remote desktop to a VM after a power failure

I have SQL Server 2008 R2 running on a virtual machine (vmware, Windows Server 2008 R2). I was connected to the SQL Server from another virtual machine via SQL Server Management Studio, then a power ...
1
vote
2answers
308 views

Creating shared folder between to servers

I need to create an SQL log shipping between 2 databases, The source is on an AWS EC2 instance running Windows Server 2008 R2 and SQL Server 2008 The destination is on an Azure VM running Windows ...