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 (3)

0
votes
0answers
101 views

Network connection from old application to SQL Server 2008 R2 lost once in a while

We are trying to migrate an Axapta 2.5 database from SQL Server 2000 to 2008 R2. We are testing performance etc. on the new server, but once in a while, these two events are thrown on the Axapta ...
0
votes
0answers
200 views

Volume Shadow Copy Service error: Unexpected error calling routine XML document is too long. hr = 0x80070018

I have about 1400 SQL databases on my environment (on 3 different volumes). I've got follow errors during taking VSS snap. Also SQLWriter goes from stable to failed "nonretryable" *Event ID 8193, ...
0
votes
0answers
27 views

Password change to SQL user and SQL Agent user broke mail agent

We changed the passwords on the accounts which the SQL Server service and the SQL Server Agent use to log in. Both seem to be mostly working fine, however the mail agent is now having problems. It is ...
0
votes
0answers
160 views

Migrating SQL Server 2000 from Physical to Virtual

My team will be tasked with a Physical-to-Virtual migration of SQL Server 2000. The main requirement will be: Minimization of downtime and minimization of impact on operation. The action plan is as ...
0
votes
0answers
89 views

Biztalk 2010 BAM on SQL Server 2014

While running Biztalk 2010 Configuration targeting my local PC with MS SQL Server 2014, the BAM Tools indicate that it is unable to find "Microsoft SQL Server 2008 SP1 or later" on the machine. I've ...
0
votes
0answers
24 views

Unable to view SQL Server Agent while logged in as user

I apologize for asking with insufficient information. I have granted SQLAgentUserRole permission to one of the user in SQL server on msdb database, but when user login in to SSMS using his ...
0
votes
0answers
31 views

SQL Client failing SSL certificate encryption under a AD Domain

I have a client machine (web server) that is attempting to connect to a SQL server. The SQL server is 2008 and has the force encryption flag turned on. Both servers are joined to the domain. The ...
0
votes
0answers
40 views

SQL Reporting Denying Access to User After Move to New Group

We have a SQL Server 2008 server setup with reporting services so that users can log in and run certain reports. I have a user that was granted browse permissions to this as we had their initial ...
0
votes
0answers
30 views

MSSQL High Availability Advice Required

I'm looking to implement a high availability SQL installation using MSSQL2012 or 2014 and there is 1 part of this I'm not sure about. I plan to have a SQL cluster at site a, and a secondary SQL ...
0
votes
0answers
439 views

Actual minimum RAM usage of Windows 2012 Server + IIS + SQL Server 2014 Express + .NET application server

I currently have a physical server running Windows Server 2008 R2. I am planning to replace it with a cloud-hosted virtual machine running Windows Server 2012. The server needs IIS, SQL Server Express ...
0
votes
0answers
10 views

Connect to Cube without using Windows account

Is it possible to connect to OLAP Cube (SQL Server) without using Windows account. Currently, I need to be on the same domain in order to connect to a cube. Are there any other solutions?
0
votes
0answers
44 views

Password expiration in SQL/ODBC before AD

I have a script that emails users that their password expires in X days. Today a user got an alert that her password expires in 8 days. She was having problems with Excel and Access databases that ...
0
votes
0answers
117 views

Why is MSSQL 2008 saying @filter_clause is invalid and that articles do not exist when creating a new publication from a script?

I have a snapshot publication on a test server with a pull subscription set up on another test server (both SQL Server 2008 R2). This publication takes a snapshot of a few columns in a few tables for ...
0
votes
0answers
36 views

Issues installing MSSQL extension in IIS

Hello long time lurker first time poster, I'm running PHP 5.4 on IIS and have installed the extensions mssql (SQLSRV30.exe) and activated the extension in the PHP manager. However, whenever I use ...
0
votes
0answers
108 views

Transferring Windows server from Rackspace to AWS

I've had a Windows server hosted with Rackspace for a while. The same setup also hosts the SQL server, and has all the IIS configs, etc. Being a Windows server noob, I have no idea how I could ...
0
votes
0answers
31 views

SQL Server 2000: Monitor replication

starting with (Microsoft) SQL Server 2005, there are stored procedures available to monitor replication (http://www.g-productions.nl/index.php?name=sp_replmonitorhelppublication) But as we are a bit ...
0
votes
0answers
24 views

SSA sending false job failure emails MSSQL(10.0)

We have a job runs every 3 minutes. We have set up email failure notifications as we are not located at the site. Every few days or so we will receive a number of job failure emails regarding the job ...
0
votes
0answers
64 views

SQL Server 2014 Standard 2014 no access and bad preformance

My company looks after a server which is running SQL Server 2014 Standard Edition. The main application database on the server is replicated out to about 20 subscribers. The server has only been in ...
0
votes
0answers
91 views

Network Issues Connection to SQL database on MS server

Prior to asking this question, I followed this thread: Cannot telnet to SQL Server on port 1433 I am attempting to connect to a database on a server distinct from the computer upon which I am ...
0
votes
0answers
32 views

SQL Server Express Application Deployment Via CD

Our company has an ancient home-grown Win-32 application which uses a SQL Server Express db. We have a salesperson at a remote office who has no reliable internet and I need a way to package this app ...
0
votes
0answers
59 views

DPM Protection Groups & SQL Server

I've been tasked with moving our backup solution from standard sql backups to DPM backups. We have a fairly standard setup. Transaction logs backed up every 15 minutes. Daily backups which expire ...
0
votes
0answers
393 views

Getting Error: “Cannot open database \”DB PATH“ requested by the login. The login failed.\r\nLogin failed for user 'ACTADMIN' ”

Overview: OS: Tried on both win 7x64 and win8.1x64 Visual Studio version: Tried on VS 2013 (.net version 4.0 and 4.5), and VS 2010 (.net version 4.0) DB used: ACT2014Default Act version: Act! Premium ...
0
votes
0answers
113 views

Intermittent telnet connection issues on 1433

I have several windows server boxes running on the same subnet at a co-lo. I have a few sql servers instances running and some of the machines can talk to it just fine, but at least two of my web ...
0
votes
0answers
178 views

Cannot access Cluster Shares via Cluster Name

I got a serious problem here (thinking like so), the problem is I have a Windows 2012 R2 Cluster and I have the Disks shared to cluster nodes via Share the VHD option that is available in 2012 R2 ...
0
votes
0answers
86 views

Amazon EC2 SQL Server Connection Timeouts

I am currently having a problem with SQL server timeouts. I am running Windows Server 2008 R2 w/IIS and SQL 2008 R2 (Express) on an m1.small instance in EC2. We have custom services that monitor the ...
0
votes
0answers
178 views

Powershell Get-Counter not returning values for SQL counters

This is a cross-post from dba.stackexchange.com: http://dba.stackexchange.com/questions/64898/powershell-get-counter-not-returning-values-for-sql-counters I am attempting to use PowerShell to get ...
0
votes
0answers
564 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
0answers
687 views

SQL Server keep crashing, cannot connect with SSMS, Agent not starting

System Windows Server 2003 x64 SQL Server 2005 x64 Problems: 1) Cannot connect via SSMS - Tried both sa account and domain account (that is in sysadmin group) - If I supplied the wrong password, ...
0
votes
0answers
125 views

Running MS SQL Server DB for Ubuntu PHP site

I'm going to be developing a php site (actually more of a application), but the standards and restriction of what I'm building make MS SQL Server the most appropriate DB solution (will also be running ...
0
votes
0answers
254 views

sql server, group by then count, 25 million rows per month, feasibility

So. We are doing some analytics in a scale I have no experience with. We have to extract some aggregate numbers and data from a whole bunch of server logs. (Estimated at 2gig a month total). I'm ...
0
votes
0answers
34 views

Can't Find SQL Server 2008 R2 SP2 uninstall option

Supposedly, the method to uninstall a service pack to SQL Server 2008 R2 (and other versions after a certain point) is through Control Panel > Programs and Features. I think it's supposed to be ...
0
votes
0answers
198 views

SQL database instance cannot be set to SINGLE_USER

I am trying to make my database Single User Mode and I tried executing this: ALTER DATABASE [db] SET SINGLE_USER WITH NO_WAIT and it returned: Option 'SINGLE_USER' cannot be set in database ...
0
votes
0answers
825 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
0answers
99 views

Mail to Mailenable group sometimes bounces back because it cannot find one of the group members

I am using MailEnable Enterprise Edition 6.53. On one of my PostOffices I have a group address set up with 5 members in the group. Under normal circumstances when someone sends a mail to this group ...
0
votes
0answers
177 views

After installing MS SQL Server 2012 not able to log into SSMS

Okay, lot's of posts around the internet on this subject. But I haven't been able to find an answer I was looking for. I installed SQLS 2012 on Windows Server 2012. I installed the Engine and the ...
0
votes
0answers
580 views

Backup Exec 2012 not backing up SQL logs

I am unable to make BUE 2012 backup (and truncate) the SQL Logs from our Microsoft SQL 2005 and SQL 2008 database servers that are set to FULL mode. No errors are being reported, but the Transaction ...
0
votes
0answers
257 views

A connection was successfully established with the server, but then an error occurred during the pre-login handshake

While i was logged in SQL server following error was occurred : A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (Provider: SSL ...
0
votes
0answers
640 views

Event ID 5586 on SP Foundation and SQL Express

I have a brand new Hyper-V VM with Windows 2012, fully updated up to today (11 Sept 2013). I installed SharePoint Foundation 2013 and additionally MS SQL Express 2012 on the same instance. In my ...
0
votes
0answers
377 views

Unable to launch SQL Server Configuration Manager - WMI provider issue

Hoping you can help. I am having issues opening SQL Server Configuration Manager on Server 2k3 with the following error: Cannot connect to WMI provider. You do not have permission or the server is ...
0
votes
0answers
85 views

Errors after moving DB from server

I am moving a database (MS SQL Server) from a server to a new one (virtual machine). Running CHECKDB on the original server I get no errors, the DB is OK. After moving the DB to the new server and ...
0
votes
0answers
244 views

SQL Server Cannot see tables in Object Browser where Login = db_owner

A colleague is trying access a particular SQL Server over a remote link. He can login to the server (via SSMS) with the SQL Server credentials I supplied, but although he can view tables/etc in the ...
0
votes
0answers
78 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
42 views

Inserted 3k rows into MsSql, now querying them times out

I have a table which had about 4k rows, then I inserted 3k rows from another table into it. The import have caused me problems, querying for new data never seems to finish. And I cannot figure out how ...
0
votes
0answers
214 views

Can't select database for transaction log backup in maintenance plan

I am running into a problem while trying to save a transaction log database backup maintenance task: Add the 'Back Up Database Task' to the maintenance plan. Edit the task. Select backup type: ...
0
votes
0answers
29 views

SQL server Error

I am trying to load the data from text file to database table by running a job. Sometimes its giving an error like "Failed at split file".. Can anybody suggest on this how to overcome this error.
0
votes
0answers
243 views

to overwrite a table or update it?

I've had situations where there was a large feed I was taking in that basically overwrote a table in the db. This tabled information was queried a lot. If Sql Server uses memory to store the queried ...
0
votes
0answers
64 views

AppFabric vs AD LDS

I'm helping design a solution for a huge organization which relies on a SQL cluster. If this cluster is unavailable, the entire organization will not be able to authenticate to printers. there are ...
0
votes
0answers
381 views

Getting “error: 26 - Error Locating Server/Instance Specified” all of a sudden

Alright, a little explanation. I have two separate PCs, both of which have virtually an identical installation of SQL Server 2012 Express on them. During installation for both, I had chosen the ...
0
votes
0answers
81 views

Moving WSUS Content - Issue with SQL Server

Im trying to gain some space on the main partition on the C:\ drive of a Win 2008r2 SBS server. Im following this guide . However, after detaching the Db ,moving it to the new partition E:\ i can't ...
-1
votes
0answers
36 views

PCI DSS 3.1 compliance + SQL + Old browsers

Trustwave is complaining about TLS 1.0 on our server. Disabling TLS 1.0 breaks SQL and does not support old browsers. How do you become compliant while keeping SQL running and serving customer with ...