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.
0
votes
1answer
20 views
TCP/IP connection to SQL Express works on HALF of the clients in a WORKGROUP
So far I have learned the following facts about Microsoft SQL Server Express, including version 2012, and earlier versions like 2008R2, and 2008, and for the most part all the way back to SQL Server ...
0
votes
0answers
10 views
Migrating from SQL 2008 to SQl express on the same VM
I have a windows 2008 r2 VM running SQL std 2008. I want to migrate my database from SQL server to SQL express which is a free product. Since I have one VM, I plan to install SQL express alongside SQL ...
0
votes
0answers
18 views
Tracking down program from Event Viewer [migrated]
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 ...
-4
votes
2answers
32 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
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?
0
votes
0answers
17 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
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, ...
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 ...
1
vote
0answers
21 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
24 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 . ...
0
votes
2answers
32 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
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
0answers
25 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
24 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
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
36 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
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
0answers
10 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 ...
1
vote
2answers
51 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 ...
-3
votes
0answers
20 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
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
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 ...
0
votes
4answers
37 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 ...
0
votes
0answers
30 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
1answer
27 views
SQL Server with one ethernet output and Webserver with another ethernet output
Scenario:
I have one server which is virtualizated using VMWare ESXi. Specs:
Windows Server 2008 R2
SQL Server Standard 2012
IIS 7.5
Hosting a MVC and a Webform application (using Reporting ...
0
votes
1answer
24 views
Remote servers replicating data to a Master server for reporting
I have Windows servers that are running SQL Server 200(5/8) in many remote locations on the east coast. At our corporate office, we are trying to set up a reporting server that can get as real-time as ...
0
votes
0answers
20 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 ...
1
vote
0answers
55 views
SQL Server: Worse performance on a new server
We've been on a dedicated server (single quad-core, 6 GB RAM) and are moving to a new dedicated server (2x hex-core, 32 GB RAM). Both are Windows Server 2008, SQL Server 2008 R2. The performance on ...
2
votes
1answer
58 views
SQL Server cannot be reached by name only by IP
I have several computers (XP) connected to domain controller (2008R2). Last time I had to change IP address of the SQL Server 2008 R2 (simple instance, no clustering or replication). DNS has been ...
0
votes
1answer
34 views
MSSQL Datafile on DFSR
I have 2 Storage Server use DFS-R to sync the content.
MSSQL Server using UNC path the connect to the DFS-R namespace for datafiles.
Now the problem is MSSQL with lock the datafile while server is ...
-2
votes
0answers
34 views
Searching for the best Database solution [closed]
I am new to this field and trying to learn the best possible way to maintain a database for my company. I am looking for the best option (cheap and reliable) to manage all the documents and contacts.
...
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 ...
0
votes
0answers
40 views
Can't connect to Windows Internal Database with SQL Server Management Studio 2012
I'm trying to connect using the following connection string, and Windows Authentication (Trying both to log in using the Administrator account, and the account I used when setting up the SQL Server ...
1
vote
3answers
88 views
TCPing reports 20ms latency between Web Farm and DB
We have a IIS web farm sitting in a DMZ connecting to a MSSQL DB(Windows Cluster). After troubleshooting some performance problems we stumbled upon strange network behavior.
We wanted to test network ...
2
votes
2answers
46 views
Where does data go during a SQL mirroring failover?
I'm just about to setup a SQL mirror but there's one thing I haven't managed to work out yet. If I'm mirroring DBA (principal) to DBB (mirror), and DBA goes offline, it will automatically switch over ...
0
votes
2answers
48 views
Windows Server 2003 Restarts after bootscreen
Im working with a dell server with windows server 2003, after installing SQL Server, the system restarts after bootscreen everytime.
On options menu (when you press F8) I disabled "restart on ...
0
votes
1answer
45 views
Compare two values in a single column SQL Server [closed]
I have a SQL Server database in which I ran a query that collects the data about two different tournamnets and the number of people enrolled in the tournament. So for instance the output is:
Name of ...
0
votes
2answers
30 views
In sql-server, how do I give server-level permission to user to make backups on any database
I need to give a user server-level permissions, once and for all time, to back-up any existing or future database on the server instance, without making the user sysadmin. How can I do that?
I've ...
2
votes
1answer
91 views
MSSQL 2012 usage of the CPU cores?
I am on decision border which processors I shall go for, and I need an information on "how actually works MSSQL 2012 with the CPU cores ?"
basically my question is follow :
1 query which extracting ...
0
votes
1answer
76 views
MySQL stopped working - Error 2002 - Unknown Instance
MySQL server was installed and was running just fine. Today we can't connect to the database via our websites. Command line access using mysql -u username -p also fails. Finally, phpmyadmin fails. ...
1
vote
2answers
49 views
MSSQL 2000 sa user account
Everytime I try to install an application that requires the 'sa' user account for installation to allow creation of a database and admin user account I receive the following message:
Reason: Not ...
0
votes
1answer
35 views
Get permissions in fixed or user-defined server roles in SQL Server 2012
I'd like to know how to get a list of permissions that belong to fixed and/or user-defined server roles in SQL Server 2012.
In previous versions there was an sproc sp_srvrolepermission but this is ...
0
votes
1answer
51 views
Can't connect to my AWS EC2
I have an AWS server (MS SQL SERVER EXPRESS 2008 R2 with IIS), with an elastic IP of 54.214.8.111, security groups configured with HTTP, MS SQL and FTP, and I can connect to the remote virtual machine ...
1
vote
2answers
46 views
Automating the creation of SQL servers
VMWare has a tool called vFabric Data Directory which allows you to automate building SQL, Postgress and Oracle servers using VMWare. Is there something simular to this that will work for Hyper-V? I ...
0
votes
1answer
35 views
MAXDOP and Interesting Performance Experiences
i would like to receive an advice on the following topic.
With one of our products from our company we "connect" to an existing database on customers side and import orders into our own SQL Server to ...
0
votes
2answers
50 views
Upgrade Windows Server Standard Edition 2003 to Windows Server Enterprise Edition 2003
Our client wants to expand RAM to its maximum on HP BL490c G6 server, but the issue is that MS Windows Server 2003 with Service Pack 2 (SP2) Standard Edition is installed there and it supports only ...
-1
votes
1answer
41 views
Connect to SQL Server installed on vmware from outside
I have windows server 2008 r2 sp1 on my vmware, SQL Server 2012 Express installed there.
I want to use Sql Server management studio to connect to the Sql Server from outside (host, and other machines ...
