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.
1
vote
0answers
23 views
Trying to connect to a SQL Server 2000 instance via SSMS 2012
All --
I have a development VM server with Windows Server 2008-R2 and on it I have the following versions of SQL Server Installed:
SQL 2000 - Developer Edition
SQL 2005 - Enterprise Edition
...
0
votes
0answers
18 views
Tracking down program from Event Viewer
The event log has hundreds of login failed errors for SQL Server. How do you find out the application generating them?
There are lots of potential candidates on the server and since it's logging in ...
0
votes
3answers
4k views
DBCC CheckDB The operating system returned error 21(The device is not ready.)
The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x0000000001c000 in file 'E:\SQL Database\S***d\NewAdvWorks.mdf'. Additional messages in the SQL ...
1
vote
1answer
943 views
sqlsrv not showing up in my phpinfo [closed]
I have just installed php 5.3 on windows server 2008 R2 running IIS7.
phpinfo() is working fine.
now I want to see if I have correctly installed the Microsoft Drivers for PHP for SQL Server.
I ...
6
votes
3answers
6k 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
3answers
42 views
How to connect to ms sql express?
I have sql express on my local network computer, I created new account, I enabled server auth, and when I am trying to connect to this account from local machine, everything works fine. But when I try ...
3
votes
1answer
682 views
netlogon errors
I have two instances of mssql 2005 and am using CA XOSoft replication. The master is a failover cluster and the replica is a standalone server. They are all running Server 2003 sp2 x64. Same patch ...
0
votes
0answers
6 views
SQL agent job step's connection managers [migrated]
Is there any way with T-SQL to list the connection managers that are used in an SQL Agent Job step?
-4
votes
2answers
30 views
Where to get SQL Server 2012 Developer Edition [closed]
Can some one please tell me if the edition even exists?
I am unable to find any downloads at MS not any specific information regarding the edition...
Anyway, in case it is not available to DL, can ...
0
votes
0answers
26 views
Should we periodically 'refresh' the mirrored copy of a SQL Server database? [migrated]
When you have SQL Server mirroring set up, do you trust that your mirror database will stay the same as the primary, even after months and months or mirroring? I know we all check the status, ...
4
votes
4answers
587 views
Should SQL Server MDF/LDF files always be on separate physical disks, even on databases that are barely used?
I'm trying to plan the SQL data and log file locations within a new SAN. I have a few databases that are hardly used at all. They are mainly metadata repositories for applications that run once or ...
0
votes
0answers
16 views
Understanding the costs and constraints of the AWS Free Usage Tier [closed]
I am new to the cloud and trying to understand the particulars of the AWS Free Tier - Windows Instance(s). Our application’s main requirement is maximum availability.
I have read much about AWS and ...
0
votes
2answers
796 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
2answers
80 views
Why Virtualize? [closed]
I am looking at expanding the hardware behind our .NET web application from a single box running the Web Server and SQL Server to two separate units with the web server on one and SQL Server on the ...
0
votes
1answer
848 views
Export Import error 'SSIS Data Flow Task could not be created' … registering DTSPipeline.dll, cannot create task “STOCK:PipelineTask”
I'm about to throw in the towel on this one.
Running SQL Server 2008 enterprise on Windows 7 x64. Can't get past this issue.
When I try to Import / Export Data from databases through SQL Server ...
1
vote
2answers
1k views
where can I find php_mssql.dll?
I'm trying to get PHP set up to connect to a SQL Server database. I'm looking for the php_mssql.dll file to put in my extensions directory but for the life of me can't locate it online. Can anyone ...
2
votes
2answers
3k 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 ...
0
votes
1answer
109 views
SQL Server database refuses to back up to USB disk
I have few databases on a SQL Server 2005/WS 2003 platform, and I have a curious situation that has arisen.
I have been manually backing up the databases to a USB hard disk until about a week ago ...
0
votes
2answers
31 views
Unable to Connect to a Remote SQL Server
I can connect to a remote sql server at home but not in the office. The server where the SQL Server is hosted is a VPS (Arvixe). How can I check if a firewall is making me not able to connect on that ...
1
vote
0answers
19 views
Configuring IIS application pool to access SQL Filestream with ApplicationPoolIdentity
I have an IIS 7.5 server with a number of applications in a single Application Pool.
Some of these applications access a SQL Server 2008 R2 Filestream on a remote machine, on the same domain.
The ...
1
vote
1answer
2k views
How can we recover/restore lost/overwritten data in our MSSQL 2008 table?
I am in serious trouble and I am seeking professional advices here.
We are using MSSQL server 2008. We removed primary key, replaced exiting data with new data resulted losing our critical business ...
1
vote
1answer
23 views
Error During adding existing ms sql server 2012 in plesk
Recently I install Ms SQL 2012 in Windows server 2008 R2 edition and I want to add this database in Plesk 11, I make a user db02 in MS SQL Server Management Studio after this I logon to plesk . ...
-1
votes
0answers
13 views
DateTime Procedure SQL SERVER [closed]
Have Procedure in sql server where i get last date
SELECT * FROM BalanceSessionData where
Date =(SELECT MAX(Date) FROM
BalanceSessionData)
Now i need compare current date with my last date an if ...
0
votes
0answers
9 views
excessive CPU utilization by SQL server [migrated]
I have an issue with SQL server 2000. Its CPU utilization is high from 9.00 AM to 5.00 PM. Three applications use this server through three different instances but when the CPU utilization is high one ...
1
vote
1answer
640 views
SQLServer 2008 BIDS On Windows 7 - 64bit
I am trying to install Sql Server 2008 Business Intelligence Development Suite on VS2008 in a Windows 7 (64bit) machine.
The installer is aborting with an unspecified error for which I have not been ...
1
vote
2answers
2k views
How do I grant a database role execute permissions on a schema? What am I doing wrong?
I am using SQL Server 2008 Express edition.
I have created a Login , User, Role and Schema.
I have mapped the user to the login, and assigned the role to the user.
The schema contains a number of ...
0
votes
0answers
23 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 ...
2
votes
1answer
875 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 ...
0
votes
1answer
10 views
SQL Server 2008 R2 on Windows Server 2003 - “ failed to initialize 0x84B10001”
I am trying to install SQL Server 2008 R2 Express on Windows Server 2003 and I get an error "failed to initialize 0x84B10001".
Googling got me the following link - ...
2
votes
1answer
29 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
1answer
707 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 ...
2
votes
5answers
1k views
SQL Server 2008 R2 transactional replication over VPN
I'm having difficulty setting up replication over a VPN.
I have a SQL Server 2008 R2, Enterprise Edition database on a Windows 2008 R2 Server.
SQL Server is running on a non-standard port. I have ...
1
vote
2answers
46 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
0answers
20 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
1answer
35 views
SQL Server Setup RAID 5, RAID 10
I am new to setting up SQL Servers and Vms. My predecessor used Raid 5 for C Drive where the SQL installation resided and RAID 10 for both database files and database logs.
I was wondering whether ...
0
votes
1answer
1k views
SQL Server 2008 R2 Transactional replication ports
http://technet.microsoft.com/en-us/library/cc646023.aspx states
Replication connections to SQL Server use the typical regular Database Engine ports (TCP port 1433 for the default instance, etc.)
...
0
votes
0answers
9 views
Error in trying to delete a local publication for DB replication
I logged in in db ad sa (super admin).
I want to remove a publication made using management studio wizard
(right click on Replication/Local Publications/ New publication)
After trying to delete I ...
0
votes
1answer
1k views
Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio
I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
0
votes
1answer
46 views
Does SQL Server Maintainance Cleanup consider exact times when deleting old backups?
Let's say I have a daily maintainance task that:
Backups all databases and then
removes backups that are older than 3 days.
Now let's say the first backup at day 1, starting at 10:00, results in ...
0
votes
2answers
689 views
Cannot access local database with IIS Manager
I've created a local .mdf database with Visual Studio 2010 and did a couple of modifications to it. Now I want to edit it in IIS Manager. However, I cannot access it neither by connection string, nor ...
0
votes
5answers
4k views
SQL Server Log File Won't Shrink due cause “log are pending replication” on non replicated DB?
I have a non Mission Critial DB 9am-5pm SQL Server database that I have set up to do nightly full backups and log backups every 30 minutes during business hours. The database is in full recovery and ...
1
vote
7answers
1k views
Nagios - host inherit from multiple templates?
Is it possible to have a host in Nagios use multiple templates?
I'm trying to monitor some MSSQL servers. Some of these are standalone single servers with a single instance, and others are using MSCS ...
1
vote
1answer
1k views
Can't install SQL Express 2008R2- caspol.exe application error - the application failed to initialize
I'm trying to install SQL Server Express 2008 R2 on Windows 2003 Server (enterprise edition).
I get the following error message:
Title: caspol.exe - Application Error
Text: The application failed ...
0
votes
2answers
581 views
Where are the SQLServer jobs stored?
I'd like to know what is the process a SqlServer job is executing, but I only can find that it calls DTSRun with an encrypted string.
After decoding the string, it results is just the name of the job ...
-3
votes
0answers
18 views
Run-time error "-2147467259 (80004005): [closed]
heloo dear ..
i am facing this error from last 4 days ...... please give me solution .
Run-time error "-2147467259 (80004005):
[Microsoft][ODBC Driver Manager]Data source name not found and no ...
1
vote
4answers
153 views
MS Sql Server Mirroring
We are looking at mirroring a MS SQL database (for a web application) due to the unique way the application was developed, each user has a SQL server Login user account which has permissions to our ...
0
votes
2answers
34 views
Unable to connect to SQL Server 2012 Enterprise local instance
Just installed SQL Server 2012 Enterprise on my work machine, and I'm unable to connect to my local instance (MSSQLSERVER). I get the "Login failed..." message.
I enabled the SQL Server Browser ...
1
vote
0answers
39 views
Consideration adding a server into domain [closed]
we just passed from eDirectory to Active Directory. All our computers are migrated (added to the domain). Now we planned to add our servers to the domain.
Servers are running MSSQL, Apache2, Lotus ...
0
votes
1answer
28 views
SQL Server 2008 mirroring on AWS
Building a application on Amazon Web Services (AWS) using SQL Server 2008 and don't have the budget for Enterprise Edition. It's a standard web app, nothing too fancy needed in the way of ...
0
votes
4answers
35 views
Allow IIS_USR to connect to SQL Server
I have a problem to connect to a SQL Server database with a web application that use ADO.
I have one server under Windows Server 2008 with domain controller role and another server under Windows ...
