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)

0
votes
0answers
201 views

Very simple Update query hanged on one database but not on a mirror

A little background I am working with an ASP.NET MVC ERP-like Intranet application. It uses the Entity Framework technology for data access for a MS SQL server. We have 3 versions of the application ...
0
votes
0answers
15 views

BCM database accessable for all but ONE computer in domain

I have a small network of 6 computers running the latest version of good old WinXP and a Ubuntu Linux machine acting as PDC for the domain. All machines have MS Office 2010 Professional installed. ...
0
votes
0answers
129 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
225 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
44 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
30 views

error in business intelligence development studio while processing cube

What i have to do to fix the following error? The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the ...
0
votes
0answers
26 views

Copy Database Wizard Attach-Detach method executes forever

I have no reputation to post my screenshot I've been copying this database for about 4 hours now. It's a 30GB size, 29 data + 1 for logs (already Shrinked). The problem I see is that the ...
0
votes
0answers
43 views

Need UTF-8 support with PHP/MSSQL-Constellation (FreeTDS)

We have a PHP 5.2 installation and lacking of the FreeTDS support to use the UTF-8 compilance to the MSSQL-Database, is there a way to get FreeTDS into PHP ?
0
votes
0answers
44 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
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 ...
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 ...
0
votes
0answers
65 views

Server infrastructure for busy e-commerce site built on MVC4 using MSSQL and Solr

What kind of server architecture do I need for this kind of application to make it more reliable. eCommerce application with abt 100,000 product with moderate to heavy traffic. The site performs very ...
0
votes
0answers
79 views

SQL Server connection issue with ODBC Driver 11 for SQL Server

When creating a DSN's. I can create a DSN to our SQL Server (Windows Server 2003 with MS SQL Server 2005). With the SQL Server Native Client 11.0, however when i try to do the same thing with the ...
0
votes
0answers
59 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
89 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
43 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
36 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
85 views

Publishing BIDS Report to SSRS?SharePoint

I am having an issue deploying a report from BIDS to a SharePoint Integrated Report Services Server. I have set up SSRS and everything is successful from the configuration wizard, I am using a Domain ...
0
votes
0answers
56 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
98 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
47 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
221 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
0answers
91 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
58 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 ...
0
votes
0answers
1k 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
0answers
397 views

MSSQL 2012 Error 26 and remote connection

I'm trying to set up MSSQL 2012 for a school project and I need to be able to connect to it remotely as my teammates will also be working on it. I did a clean install of SQL Server 2012 Express. ...
0
votes
0answers
120 views

cannot connect to ssms local database windows7

i am running SQL Server 2012 Management Studio Express in windows 7, i am having issues connecting to the local db. i tried all the above mentioned solutions, didnt work. please help. thanks in ...
0
votes
0answers
191 views

Unique index failed?

Recently, we've been having some kind of memory leak in SQL Server. We do have a .NET assembly running to audit our tables, but this has ran for a few years without problems, so I doubt it's the ...
0
votes
0answers
990 views

SQL Server error: Error: 802, Severity: 17, State: 20

I'm randomly getting this error while running a script... Exception calling "ExecuteNonQuery" with "1" argument(s): "An exception occurred while executing a Transact-SQL statement or batch." ...
0
votes
0answers
60 views

Reporting Server and Multiple AD Domains

We have a Database sever running Microsoft Reporting Services on our network. The users with browser permissions on the server come from our AD Domain, and from a second AD Domain we share trust with ...
0
votes
0answers
267 views

How to migrate SharePoint List with attachments to SQL Server in untrusted domain?

As part of a larger effort to migrate LiveLink and older SharePoint sites to SharePoint 2010. At the moment, my customer has multiple SharePoint lists, whose data is divided by location. Ideally, ...
0
votes
0answers
74 views

strange web app errors possibly sql server related?

apologies if this is not a good place to post this, but we are experiencing some very strange things with our web ap which is running on a SQL 2005 instance. the application is a .net web app and ...
0
votes
0answers
375 views

SQL Server OPENROWSET/OPENQUERY Issue with Access DB

Server: Win Server 2003 R2 standard x64 MSSQL: Server 2005 Standard x64 Using SSMS on the database server itself I can execute a simple select on a linked server with OPENQUERY and I can also execute ...
0
votes
0answers
109 views

inLoox is unable to connect to SQL Server

I just installed InLoox and configured a connection to our MS SQL Server 2005. The connection should be fine - telnet works and I can connect to the inLoox database with my query analyzer. My ...
0
votes
0answers
88 views

SQL Server Management Studio Express 2008 is unresponsive

I use SQL Server Management Studio Express 2008 to manage SQL Server Express 2008. It (Management Studio) was working until recently, but now on opening it just hangs indefinitely, with all the panes ...
0
votes
0answers
347 views

Estimating SQL Server network bandwidth requirements for replication

We are starting to implement replication with four different database SQL SERVER 2008 R2. All standard editions and merge replication. The problem right now is how to estimate a minimum required ...
0
votes
0answers
42 views

How Can Unblock a 2003 Server from connecting to a Remote SQL Server via MDAC?

Am trying to set up an ODBC connection between a Windows 2003 server and a remote MS SQL 2005 server. We have already done this with multiple customers successfully, but we've encountered a ...
0
votes
0answers
178 views

Allow traffic from single IP address (server), block all other addresses

I'm trying to implement an IPSec policy that will block all the inbout traffic to port TCP 1433 (sql server 2008), but I need to allow the server itself to be able to connect to that port. I have ...
0
votes
0answers
354 views

Error 22272 Cannot load xpstar.dll

I hope someone can help me with this error. When i came in to work this morning i started to get an error when trying to view the "Jobs" in Enterprise Manager. Error Below Error 22272 cannot load DDL ...
0
votes
0answers
330 views

IIS ASP Configuration - Old ASP

We are using IIS 7.0. I have created a website, and set the permissions for share. I am able to read a text file remotely through IE using our URL to the website. However, I am not able to connect to ...
0
votes
0answers
68 views

Sql server Agent job

I have Added one Console application exe as step in job . Job still runs even when the console application .exe gets finished. How can i resolve this problem
0
votes
0answers
188 views

SQL 2008 R2 Memory Consumption

Following situation: VMWare with Microsoft Server 2008 Enterprice edition 64-bit (4CPU and 32 GB RAM) SQL server 2008 R2 64-bit enterprise. In the taskmanager the SQLServer only takes up about 12 ...
0
votes
0answers
26 views

Fail-over SQL Server databases. Which method

Good morning all I have been researching various methods of SQL Server recovery options. The scenario is simple and I want the same solution. I have 2 SQL Server databases on separate machines at ...
0
votes
0answers
127 views

SQL Server 2008 R2 Data Mirroring issue

I'm trying to setup Data mirroring between 2 servers. Error: “The server network address “TCP://servername:5022″ can not be reached or does not exist. Check the network address name and that the ...
0
votes
0answers
147 views

mssql backups to external device (external hdd, server, mapped drive)

I'm running Windows Server 2003 and SQL Server. Until recently, I've been able to backup to mapped drives or external hard drives. Now, when I go to run backups, the only available drive is the local ...
0
votes
0answers
476 views

Remote connections to SQL Server Express 2008 database through VPN

I'm currently trying to configure an installation of SQL Server Express 2008 R2 to allow remote connections but can't seem to get it to work remotely. To connect to the server I have to connect via a ...
0
votes
0answers
62 views

introduction to replication

each time i insert a record into a table on one database server, i need it to be inserted into a table on another server. how do i do this?
0
votes
0answers
223 views

Could not connect with Instance of SQL SERVER from LIVE server to server in office

Scenario: LIVE Server: 210.210.210.210 External IP of Office: 111.111.111.111 SQL server on a server machine in office, machine name: MyMachine Another SQL server on another server machine in ...
0
votes
0answers
46 views

Will this increase my Virtual private Server failing rate?

Will this increase my Virtual private Server failing rate if i :- install Microsoft Window Server 2008 Enterprise install SQL server enterprise 2008 install IIS 7.5 install ASP.Net Mvc 2 install ...