We have 2 different Windows 2008 that we are trying to install different applications on which require a SQL connection for creating a database, but neither work. The SQL Server is 2008 running SQL 2005.
One instance was installing Veeam and it failed to connect to the SQL database with error: "Error 27552: Error Creating database VeeamBackup. Server: Microsoft SQL Server BQSQL. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (1802). The work around was creating a local SQL Express database and then copying it to the SQL server and connecting it so the accounts are valid.
On another server we are trying a completely different application install and when we attempt to create a database I get "SQL Server Verification: Connect_Error"
The account I am using has all of the possible permissions assigned to it so I'm wondering if it's becasue I'm using the cluster name/ip to create the database that it isn't letting me.
I have 2 servers (SQL1 and SQL2 with SQLCluster as the instance name for the cluster and all with it's own IP). Please help?
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
by Mark Wills
Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server... So if you are the accidental DBA, or, simp…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …