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)

1
vote
1answer
12 views

SQL/SSMS read only user who can only view a single database

I'm currently using SQL Server 2005 which has a number of databases on for individiaul clients. I need to create a single read only login for each of my clients, however I cannot allow them to see ...
0
votes
0answers
17 views

Windows Filtering Platform dropping SQL Server connections

I've been investigating connection issues between my web server (Web01) and a database server (Database01). My current setup: Web01 - two NICs, one external (firewalled), one internal (not ...
1
vote
1answer
1k views

SQL Server ODBC Connection via Command Line

I need to create a number of ODBC connections to a MS SQL Server, the clients are mainly XP machines. The connection has to use SQL server authentication - is there a way to do this remotely via ...
1
vote
1answer
895 views

No 'Instance Features' in installation setup of Sql Server 2012

I try to install SQL Server 2012 Express on my personal computer (fresh install of Win 8). I downloaded the installation files on the Microsoft Website. The filename is SQLManagementStudio_x86_ENU.exe ...
-1
votes
0answers
29 views

TRANSFORM VARIABLE - ADD OPERATOR OR [on hold]

I have a text box on a web application that allows the user to type what words they want to look. In the first version of the web application the user wrote the words he wanted and was wanted on the ...
3
votes
3answers
2k views

Can’t connect to SQL Server 2008 - looks like Shared Memory problem

I am unable to connect to my local instance of SQL Server 2008 Express using SQL Server Management Studio. I believe the problem is related to a change I made to the connection protocols. Before the ...
2
votes
1answer
1k views

Copy User Mappings for SQL Logins using SQLCMD - MS SQL Server

Is there a way to directly copy the User Mapping from one SQL Server login to another using SQLCMD? In SQL Server Management Studio Object Explorer | (local) | Security | Logins, Right-Click a user ...
0
votes
1answer
20 views

Debugging random SQL login failure from Web Server

This is a very basic level question, but it could really benefit from some extra help in the diagnosis. We have a 2005 SQL Server Named: SERVERNAME-PROD We have a Web Apps Server that's running IIS ...
0
votes
2answers
1k views

SQL 2008 install failed - Could not find the Database Engine startup handle

My SQL 2008 install failed, I'm getting this error: Could not find the Database Engine startup handle This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ...
0
votes
1answer
933 views

SQL Server NETWORK SERVICE account permissions

My SQL Server Windows service is set to use the NETWORK SERVICE account. The server is installed to C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL. However looking at the ...
3
votes
2answers
4k views

AclPermissionsFacet fault install SQL-2008-R2

While attempting to do an installation repair of SQL-2008R2, I'm failing the pre-check rules. Module that is failing is AclPermissionsFacet - with this message "The SQL Server registry keys from a ...
2
votes
2answers
2k views

How to undo assigning ownership of db_datareader/db_datawriter schema?

i meant to assign an SQL Server login to the db_datareader db_datawriter database roles. But if a moment of sore tummy and tiredness, i accidentally give that user schema ownership of them ...
0
votes
1answer
2k views

Firewall configuration for SQL Server 2012 Express on Windows Server 2008 R2 for Workgroup

We are attempting to configure a server application to run on Windows Server 2008 R2 using SQL Server 2012 Express. With the server firewall turned off completely the application can communicate just ...
0
votes
1answer
38 views

Does the amount of disks in a RAID10 matter for a Microsoft SQL server in regards of the block size?

We are planning to deploy a Microsoft SQL Server and to store the databases on a RAID10 (RAID1+0) block-level-storage. Does it matter how many drives altogether I put into the array for optimum ...
1
vote
2answers
2k views

Log In failed for user error 18456

I have two servers. Both of the servers have two different database that will be joined together using SQL Server Agent. However, during this activity SQL Server is throwing a Log In Failed Error. ...
0
votes
1answer
3k views

MSSQL 2008 is claiming the firewall is blocking ports even from local machine

I was just hoping to step through a couple queries to see how the temp tables are interacting and I'm getting this message. The windows firewall on this machine is currently blocking remote ...
5
votes
5answers
12k views
5
votes
3answers
37k views

How are SQL Server CALs counted? [duplicate]

Possible Duplicate: Can you help me with my software licensing question? Running a SQL Server, as far as I understand it, you need one CAL for every user who connects to the database ...
2
votes
1answer
4k views

The OLE DB provider “SQLNCLI10.1” has not been registered.; 42000

I have a SQL Server 2008 Analysis Services Project. In the Data Source View I have a Named Query which references a single Data Source containing three tables. The Project processes successfully and ...
1
vote
2answers
31 views

Automaticaly export Jobs and stored procedure from mssql server

I have MS SQL server with several jobs. Sometimes I and my colleagues change task. I want to export jobs, like at automaticaly so that put in mercurial and store version of jobs. I would also like ...
2
votes
1answer
5k views

Can't see all catalogs on a MSSQL Linked Server

On SqlServer 2000 I have created a Linked Server to a SqlServer 2005 machine, with "Server type" set to "SQL Server" (first radio button), and the linked server name set to the remote machine's ...
0
votes
0answers
10 views

Fatal error: Call to undefined function sqlsrv_connect() [migrated]

i am trying to connect to Microsoft database using the following code $connInfo = array("Database"=> '***', "UID"=> '***' , "PWD"=> '***', "CharacterSet" =>"UTF-8"); $conn = ...
0
votes
1answer
86 views

SQL Server Integrated Security without a Domain

This question potentially sits somewhere between ServerFault and DBA Admins but the Domain element of this as led me to put it here. We have been developing an SOA product and are thinking about ...
1
vote
2answers
2k views

How to set up Zabbix to monitor SQL Server Failover Active-Passive Cluster?

It should be simple, so it is just most likely my approach being totally off and someone will hopefully prod me into the right direction. We have a Zabbix 2.0.3 server instance set up monitoring a ...
1
vote
1answer
908 views

Uninstall Older Sql Server After Upgrade

Is it ok to uninstall older versions of SQL Server after an upgrade? I have 2008/2008 R2 installed, but using 2014 since it was just upgraded.
4
votes
5answers
30k views

Cannot login to SQL Server 2008 R2 with Windows authentication

When i try to connect to SQL Server (2008 R2) using Windows authentication: i cannot: Checking the Windows Application event log, i find the error: Login failed for user 'AVATOPIA\ian'. ...
0
votes
3answers
57 views

How can one use Reporting Services against a log shipped database?

Using MS SQL SERVER 2005. I have log shipped the ReportServer database to the secondary server in Standby/Readonly. I seem to be unable to use Reporting Services on the secondary database because it ...
0
votes
0answers
13 views

MS SQL Server 2008 Transaction log file back up failure [migrated]

I've done some reading around this subject here and on StackOverflow but nothing really answers my question enough for me to go forward. I'll explain we have a MS SQL 2008 server running, the ...
10
votes
4answers
10k views

How to detect if full text search is installed in SQL Server

I need to find out if full text search is installed on SQL Server 2005. I don't have permission to log into the box and fire up Setup to check. However I can run SQL Server Management Studio and ...
0
votes
1answer
955 views

Unable to run query in SQL Management Studio because of JIT debugging error

Recently I have built a Windows server 2008 and installed SQL Server 2008 and Dynamics CRM 2011 on it. Everything is working fine but when I open the SQL Server management Studio and try to open a new ...
0
votes
0answers
14 views

SQL Mirroring with Certificates and Domain?

We're replacing all our servers and wish to migrate a mirrored database running in one domain to the new servers in a different domain without downtime. Is it possible to turn off mirroring in the ...
2
votes
1answer
2k views

WSS Search fills 10 GB limit on SBS server 2011

I've got a SBS Server 2011 Standard SP1 that isn't very busy. 2 Users local and 2 remote. We have sharepoint that has maybe a dozen small documents at most. I've just started getting the following ...
1
vote
1answer
1k views

Red Hat 6 connect to MS SQL server 2005 using freetds; pdo_dblib and php

I'm having a problem connecting to my Microsoft SQL Server 2005 from a Red Hat box using freetds. My end goal is to be able to connect using php's PDO, but I don't appear to be able to connect when ...
0
votes
1answer
1k views

Performance Issue Between SQL and IIS on Seperate Machines

First time OP on serverfault, but an avid user of stackoverflow. We have two high-specification boxes, both running Windows Server 2008 R2 Standard. On one we have IIS 7.5, the other SQL Server 2008 ...
0
votes
1answer
2k views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
4
votes
2answers
2k views

March 10th Patch Tuesday appears to cause SQL Server client connection problems

Since applying the full set of patches on a Win 7.1 Pro desktop and a Windows 2012 R2 Datacenter Azure server running SQL 2014, SQL Management Studio (2008 and 2014 versions) won't connect to the SQL ...
0
votes
1answer
1k views

SQL Server Timeout issues at random times causing performance degradation

I am having random timeout during a brief period of time on certain days. My CPU, Memory looks fine. So I ran Performance Monitor during these spikes and found my average disk sec/read was 5.8 ...
2
votes
0answers
11 views

Reclaiming free space in filegroup with single chronological partition

-moved here from SO (no coments there) Question: what is a proper way of reclaiming space in big (hundreds of GBs) filegroup with single partition of table that is chronologically ordered and has no ...
1
vote
1answer
890 views

Setup ejabberd with SQL Server 2008

Here's what I have got so far. Windows 2008 Server 64 bit. Installed the latest version of ejabberd, ejabberd-2.1.8-windows-installer.exe. The windows service starts up fine but seems ineffective. ...
0
votes
1answer
1k views

Cancel/Kill SQL-Server BACKUP in SUPSPENDED state (WRITELOG)

I have a SQL 2008 R2 Express on which backups are made by executing sqlmaint from windows task planer. Several backups ran into an error and got stuck in state SUSPENDED with wait type WRITELOG. How ...
1
vote
1answer
2k views

MS SQL Server configured for secure (SSL) connection allows non-secure connection from JDBC Client

I need to connect to the MS SQL Server 2008 r2 using the secure communication. I have been able to do the same using the following connection string: jdbc:sqlserver://<<db server ...
1
vote
1answer
1k views

SharePoint 2010 Server Configuration Error -> “Cannot connect to database master”

I recieve the following error when I try to configure SharePoint 2010 Server: "Cannot connect to the database master at SQL server at [computer.domain]. The database might not exist, or the current ...
0
votes
2answers
16 views

SQL Server Autonumber or @@identy or a.n. Other

I have suddenly had an older system landed back in my lap and currently having to cast my mind back about 6 years. The system is accessed from 3 different offices and as such each users from these ...
1
vote
1answer
21 views

SQL SSMS Window Dissappear

When I open SSMS, I choose windows authentication, but the window just goes away; it doesn't say I'm not allowed. I've accessed these db servers before, the exact same way, and it has worked. Now, ...
2
votes
1answer
1k views

SQL Full-Text indexing not populating

We installed a clustered SQL 2005 installation on windows 2008 and reattached our san drives from another machine and restored to do a migration to new hardware. There have been a few minor issues, ...
0
votes
0answers
20 views

4624/4634 logon/logoff events from SQL Server machine to local PC

I've noticed that in my Security event log on my local PC there are lots of 4624 logon and 4634 logoff events relating to the machine account of servers on our network that have SQL Server installed. ...
0
votes
1answer
19 views

MSSQL Update: Backup-Restore vs Detach-Attach (different new servers and different new disks)

I am amidst of migrating an SQL Server 2005 database to an SQL Server 2012. Both environments are on different servers, and they both have different separated disks for the datafiles and logfiles. My ...
2
votes
3answers
5k views

Read SQL Server Backup File on Mac OS X

I have a .bak file from an SQL Server database on an old hosting account, is there any way to view this file with an application on Mac OS X? All I need to do is get the data out of it. Thanks, Kyle ...
1
vote
1answer
36 views

“Unknown host machine name.” on FreeBSD + unixODBC + FreeTDS

I got some issues connecting to a Microsoft SQL Server 2012 from my FreeBSD 10.1 server. I installed FreeTDS and unixODBC via ports. I compiled FreeTDS with unixODBC support. This ist my ...
1
vote
2answers
48 views

What is RAID 5 write logic with 8 drives running SQL 2008?

We recently had a raid array fail on a SQL 2008 server with 8 x 73GB drives. (Dell 2950). There were two drives that went bad (one had been bad for a few months it seems and was not caught...). To ...