0
votes
1answer
881 views

SQL Server database connections being dropped intermittently

Occasionally in one of our production environments (we have a dozen or so without different clients pointing to each) we get exceptions at different points in the process. The code doesn't do ...
1
vote
1answer
46 views

Installation folder of MSSQL server 2008?

How do I find the folder path where my MSSQL server 2008 R2 is installed, inside my C# code?
0
votes
1answer
233 views

Minimum permissions required for a SQL Server user account

I have a sql server user named SchoolTeacher to access my application. It has the following rights to my PrimarySchool database INSERT, UPDATE, DELETE, EXECUTE, CONNECT, SELECT The user must be ...
3
votes
2answers
202 views

SQL Server Express 2008 R2 or SQL Server 2008 R2 Web?

We have swtiched from MySql to SqlServer, but I don't know what version of SqlServer to use in production ... We have a webapplication (C# / ASP.NET) SqlServer Express 2008 R2 ? SqlServer Web 2008 ...
0
votes
2answers
242 views

How to make Sql Server 2005 run on port 1966?

When I'm trying to connect to MSSQL I get error that there is nothing running on the port 1966. when I look at processes I see 3 named sqlserver.exe, but when I see the PID's understand .. they are ...
4
votes
1answer
245 views

Backup database at certain intervals?

My client would like to have the database backed up several times per day, as well as the ability to backup the database manually. I've created a page to backup the database manually, it just calls a ...
0
votes
2answers
104 views

repair database [duplicate]

Possible Duplicate: repair suspect database my sql server 2008 told me that you database is suspect and I can't see my tables or my data what should I do ?
0
votes
1answer
74 views

Help with my application please! Can't open image(s) with error: External component has thrown an exception

I have an application written in C# I believe and it adds images to a SQL Server 2005 Database. It requires .NET 3.5 to be installed on my computer. I installed .NET 3.5 and setup a database. It runs ...
0
votes
1answer
206 views

Multi-Application Server Environment and Memcached Security

We are looking to integrate Memcached into our infrastructure, but have a security concern before we do. We run several platforms including ASP.NET and Coldfusion and have many app developers working ...
0
votes
2answers
508 views

SQL Server communication protocol issue

I am using VSTS 2008 + C# + ADO.Net + SQL Server 2008. My questions about what kinds of communication protocols SQL Server 2008 will be using, more details of my questions, If the connection string ...