The sql-server tag is for general questions related to Microsoft SQL Server and its various technologies. SQL Server is a very broad topic, much of which is perfectly suited for Server Fault. SQL Server programming questions, however, will be generally be better suited for Stack Overflow. ...
1
vote
1answer
31 views
Windows Server 2008 Memory Usage with SQL Server 2008?
I have the following kit:
windows server 2008r2
Microsoft SQL Server 2008r2
Dual Quad Core Xeons
52GB Ram
The Ram usage on the server is currently at 98% which is fine, SQL server is happily ...
1
vote
2answers
19 views
Improve automatic failover scenarios in SQL Server 2008
We have SQL Server 2008 set up in with a principal, mirror and monitor server, the mirror is synchronized and set to automatic failover. We recently saw a situation where we ran out of space on the ...
-4
votes
1answer
57 views
How to setup a multi-server network for a web application [closed]
I am experienced with development, but not with servers and networking. I am developing an application and stability is critical. What I am wondering is how my network should be structured and how it ...
0
votes
0answers
12 views
Why can't I attach TFS to a Project Collection that was restored to SQL Server correctly?
We tried moving a TFS Project Collection from one TFS 2010 server to another.
Detached the collection in TFS Console
Backed up the collection, Tfs_DefaultCollection, in SQL Server 2008 Standard ...
1
vote
2answers
67 views
Ridiculously slow queries on Microsoft SQL Server 2008 R2
I'm getting really slow queries in MS SQL Server 2008 R2 on my dev machine. This problem has been plaguing me for about a month. Other developers don't have the same problem, but we all run the same ...
0
votes
2answers
36 views
SQL Server 2005: Move account from one server to another while maintaining unknown password
There is a user account that someone set up on one of our database servers long ago, that no-one any longer knows the password for. However some apps have the password (for various reasons we cannot ...
0
votes
1answer
29 views
Why can't I defragment my SQL 2008 .mdf file?
I am defragmenting a badly (95%) fragmented drive upon which large (35 gig) SQL Server 2008 .mdf files live. After defragmenting and viewing the exception report, I see that the production .mdf ...
1
vote
2answers
32 views
Possible to regularly export MS-SQL tables to another DB format on Linux without complete dumps?
We have a production server running SQL-Server, which holds our backend data, e.g., customer information, sales invoices etc. The nature of this data is that "old" data can change, e.g., a customer ...
0
votes
4answers
30 views
MS SQL server port questions
I am very confused as tcpview shows sqlservr.exe listening on these ports 49371, 49373, 52732, but in the SqlServer Configuration Manager->SQL Native Client 10.0 Confgiuration->Client Protocols and ...
0
votes
1answer
20 views
Best practice for transfering MSSQL Databases and all accounts to new server?
One of our customers has installed a new SQL server and needs to take down the old SQL box. Both servers are running Microsoft SQL Server 2008. The applications all access the current SQL server via ...
2
votes
2answers
36 views
Encrypting an Azure database?
We have a database hosted by SQL Azure, and accessed via a REST service that itself is accessible only via https. We wonder though whether we should encrypt all or part of the database in case it was ...
0
votes
0answers
15 views
Schedule replication of MSSQL Views to MySQL Remote database
I have a Microsoft SQL Server 2005 Database inhouse i've to publish some information on the internet and i can't (for security policy) query this database from the web server.
So i come up with the ...
0
votes
1answer
28 views
How to trust a non Domain PC over a VPN connected via a Domain Account for SQL Windows Authentication
We are trying to enable a windows login to SQL Server from an untrusted laptop.
The SQL Server has been enabled to allow the domain account to login and browse the data
When a domain user connects ...
2
votes
3answers
164 views
Windows update keeps doing the same updates
I have searched relentlessly for a solution to my problem, but to no good end.
I have a server which is having problems (almost) every night and the IT guy does not seem to be able to determine why ...
0
votes
2answers
18 views
Safely Execute Stored Procedure Via DMZ Server
I'd like to execute a stored procedure via web application that connects to SQL Server. The procedure is to be activated by clicking a link in an email. The link will have to be accessible from a ...
0
votes
0answers
15 views
SQL Service and Duplicate Service Principal Names
When I run setspn.exe -X on my SQL Server box I get a bunch of entries but all are similar and resemble this --> MSSQLSvc/username.ourdomain.org:1293 is registered on these accounts:
...
0
votes
1answer
27 views
FTP/SFTP client that can store sessions in MSSQL
I'm looking for a FTP/SFTP client that can store all the session information in a central SQL server, so all employees always have an up-to date list of FTP sites they can connect to.
I've been using ...
0
votes
0answers
24 views
Running two Magentos installations, one of which has 3 stores set up as multi-store. Which server?
I want to run 4 Magento stores in 2 different installations. 1 is a standalonne installation with 3 languages. The other is a multi-store with 3 different online stores in different domains.
At the ...
0
votes
1answer
19 views
MSSQL: running update usage after restoring database
Why do we need to run dbcc updateusage(0) after restoring a SQL Server database on a different server? What are the implications of not running it?
1
vote
0answers
18 views
SQL Server related perfmon counter porting 0 on remote machine
I'm trying to monitor a remote SQL Server via perfmon but all SQL related counters are reading 0.
What works:
On the target Windows Server 2008 running Microsoft SQL Server 2008 R2, reading both ...
0
votes
1answer
23 views
Can Reporting Services 2008 be installed on an existing web farm?
I have a question regarding whether Reporting Services can be installed on an existing web farm, at least the front end portion.
The situation is that we have a limited number of servers available to ...
0
votes
1answer
70 views
Win Server 2008 R2 with Hyper-V and SQL Server
I'm putting together a new server which will be running a couple of light weight web applications and a fairly lightly used SQL Server 2008 database. I've specified a machine that is significantly ...
-1
votes
1answer
43 views
Difference between SQL Server 2008 Express and Workgroup in regards to CAL's
I am currently using SQL Server Express edition, and am thinking of upgrading to SQL Server Web or Workgroup edition.
My question is what restrictions will I experience with the introduction of CAL ...
1
vote
1answer
53 views
Local network speed appears to be being limited
I have a dedicated server setup that has just started causing us issues.
Our immediate problem, is that last week, could log into an admin page of one of our websites just fine, now we can't.
It does ...
2
votes
3answers
69 views
Server RAID and Partition Config for Small SQL Environment
I've got 5 databases that run on separate servers using SQL Express. Some of these include a Citrix Datastore, Citrix Edgesite Server, an AV db, Time and Billing App, and a document management ...
3
votes
1answer
23 views
Not sure if SQL Server 2008 Express was upgrade to Web Edition
I have SQL Server 2008 Express Edition and I needed to upgraded to either Express Edition R2 or R2 Web edition.
So I ran the set up of R2 Web and go to the maintenance and select Edition Upgrade. ...
3
votes
2answers
69 views
How to change max server memory in SQL Server
I was trying to change the max server memory for my database server, and I accidentally saved it as "4" instead of the number I wanted to enter.
Now I can't even connect to the server.
Is there a ...
0
votes
2answers
92 views
Fresh SQL Server DB restore works most times, but fails sometimes
I'm working on an automated setup of a Windows Server 2008 R2 Core with IIS and SQL Express
I'm starting with a fresh (just installed) OS in a VM (virtualBox in this test case)
My scripts then ...
1
vote
1answer
46 views
Can SQL Server run over WAN?
Will SQL Server be able to serve workstations over a WAN?
I'm talking about the kind of WANs that a very large organisation (such as a large company or government department) would utilise to create ...
0
votes
2answers
57 views
Is there any way to block an specific product from Microsoft Update?
I have a scenario where an SQL Server update makes an app fail.
I would like to disable SQL Server updates.
I don't want to disable all other Updates. I would like to keep Windows Update.
Is there ...
1
vote
1answer
54 views
Can't connect to named SQL Server 2008 R2 instance remotely
I have a Windows Server 2008 R2 machine with SQL Server 2008 R2 Enterprise installed. The SQL Server is setup as a named instance, so its full name is "ATLANTA3\FOO" ("Atlanta3" being the machine ...
0
votes
5answers
53 views
How much memory should I put in our SQL server 2008 server?
Currently our SQL server 2008 machine has 24 gb of memory.
After analyzing some reports (PAL) and performance counters, I came to the conclusion that the server could use some more memory.
What is a ...
0
votes
1answer
53 views
How do I limit MS SQL Server memory usage?
I've heard MS SQL Server takes up as much RAM as it can to cache results. Well, it's not leaving enough bargaining room for our little server's RAM.
How do I change the settings to limit the amount ...
0
votes
1answer
21 views
Can a Sql Server standard edition backup be restored to web edition
If I have two instances of Sql Server 2008 R2. One is standard edition, one is web edition.
If I take a backup of a database from the standard instance can I restore it to the web edition instance?
0
votes
1answer
68 views
Can I downgrade SQL Server 2008 R2 Standard To Web Edition?
We are running a SQL Server 2008 R2 Standard Evaluation version. The client has decided they don't want to pay for full SQL Server standard and feel the Web edition is suitable. Can I downgrade SQL ...
4
votes
1answer
40 views
Should I Use the Default SQL Server 2012 Accounts or Make Specific Ones?
I'm installing the 180 day trial of SQL Server 2012 on a virtual machine with the intent of buying a license for it later on. From past experiences with installing SQL Server I would always make ...
0
votes
0answers
7 views
How to update SQL Server 2012 from Evalutation to Developer edition? [migrated]
During the installation of a new development infrastructure, I had to install many SQL Server instances on different machines. Some were of course dedicated for production and some other for ...
0
votes
0answers
13 views
SQL Server DB Mail Content-Disposition header is missing
My question is basically identical to this one from StackOverflow, but the MIME Type is different.
Is there a way to get SQL Server to include the Content-Disposition header for attachments?
If not, ...
0
votes
0answers
33 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
1answer
40 views
Cannot login SQL Server after changing machine name
After installing and setting up new machines in a domain, we decided to rename one of them which had a SQL Server instance installed. So I changed the hostname, everything went fine regarding the ...
-1
votes
0answers
42 views
Are SQL Server Licenses Transferable? [closed]
Possible Duplicate:
Can you help me with my software licensing issue?
If I own a SQL Server license, can it later be sold and transferred to another party?
1
vote
2answers
41 views
SQL Server 2008 - Service account for backups
I am setting up a backup software to backup all the databases on my MS SQL Server 2008.
I want to configure a service account with administrator rights on the database. The service account have ...
0
votes
0answers
34 views
MS SQL 2008 - Restoring a Differential backup [closed]
I do backups of every single database on an MS SQL server 2008.
A full once every 2 weeks, and between fulls, I do a differential every day.
For the backups, everything is fine. But I would like to ...
2
votes
1answer
47 views
Are Previous Microsoft SQL Installations Needed After SQL 2012 Upgrade?
Are the older installations of Microsoft SQL Server needed after you installed Server 2012?
I've been doing some cleaning and noticed I've a whole list of SQL Server installation.
When I installed ...
0
votes
1answer
33 views
Create ODBC Connection from Access to SQL Server
I need help connecting from a blank access 2010 database to my remote SQL Server 2005 database. This is because I'm going to write all my client apps in Access, and store everything on the server with ...
0
votes
2answers
47 views
SQL Server 2008 - Backup Databases with more than 50 characters
I am using T-SQL to backup my MS SQL 2008 databases:
BACKUP DATABASE @name TO DISK = @fileName
The problem occurs when it comes to the databases with their name length greater than 50 characters ...
1
vote
1answer
61 views
Strange Server Problems
I'm having some server issues, hopefully someone might have some insight.
There is one server in my workplace which is set up strangely and I don't understand it. Every machine can ping/access/share ...
0
votes
1answer
22 views
exe hangs when scheduled from SQL Agent, but fine when run by user
I have a SQL Agent job on a clustered SQL 2008R2 server on Windows 2003 Enterprise. It's an Operating System (CmdExec) step, running an executable. When it runs on schedule, the process does start up, ...
1
vote
2answers
59 views
Create a Public SQL Server
I have a testing environment that I would like my team members to access just to develop on. It is not linked to any other server system or network, however it is open to the Internet. What I would ...
1
vote
2answers
42 views
Error Connection to SQL Server using [HOSTNAME]\instance or [FQDN]\Instance, [IP]\instance working
This one's kind of weird, at least to me.
I've got MSSQL server 2k5 (STD) installed on Server 2k3 R2 SP2 (on account of some legacy software that doesn't yet support x64 or Server 2008), using ...
