0
votes
0answers
98 views

Getting Error: “Cannot open database \”DB PATH“ requested by the login. The login failed.\r\nLogin failed for user 'ACTADMIN' ”

Overview: OS: Tried on both win 7x64 and win8.1x64 Visual Studio version: Tried on VS 2013 (.net version 4.0 and 4.5), and VS 2010 (.net version 4.0) DB used: ACT2014Default Act version: Act! Premium ...
0
votes
1answer
1k 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
49 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
254 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
209 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
247 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
257 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
108 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
80 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
214 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
515 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 ...