View Complete Post
Hi,i am running MS SQL Server 2005 Enterpreis Edition x64.There are several local disks on the server of sql: ?:\ , X:\ ...The SQL Server is installed on C:\Program Files\Microsoft SQL Server\The SP3 was installed on SQL Server using WSUS.Recently i have found out that there is a folder on disk X:\ (X:\596166c4744e026ff11d) with a lot of files and folders like "hotfixsql", "hotfixdts" etc.I have tried to remove this folder but I got an error message:Cannot delete sqlrun_tools: Access is denied. Make sure the disk is not full or write-protected and that the file is not currently in use.In file X:\596166c4744e026ff11d\1033\eula.txt I have found the following info:MICROSOFT SQL SERVER 2005 SERVICE PACK 3So these hotfixes have to do with SQL Server.I have to move disc X:\ but I can not do it because of these strange files...But why are these files not on disk C:\?And why are they necessary for SQL Server?Please help me..Thank you for your timeEvgeniya
Hi, I have done some research and tried to find answers on how to integrate forms authentication with ASP.NET but all I can find is for 2.0. I don't mean to sound ignorant or annoying about it, but does anyone have a quick link to somewhere where I could find out how to integrate a custom SQL Server DB (with username, password, id, etc columns for user) with ASP.NET 4.0?
My application is actually a Silverlight Business Application where I am trying to log in/register users in a separate Database in a SQL Server 2008 engine.
If you don't have a link, but instead suggestions, anything would be much appreciated! Thanks,
Auto updates picked up this update to install but it wouldn't install. I tried doing it manually with no success. Anyone run across this?I have the service pack 2 with updates already. What would cause this?Johnny
We currently install SQL Server 2005 Express silently during our installation, using the following switches
/qn ADDLOCAL=all REBOOT=ReallySuppress DISABLENETWORKPROTOCOLS=2 SQLAUTOSTART=1 SECURITYMODE=SQL SAPWD=123
We also attach a 2005-created database immediately after using the following command line (^ is a path concat operator in Installshield):
sqlcmd.exe -S .\\SQLEXPRESS -E -i \"" + svConfigPath ^ "SetupUapDB.sql\" -vmdfpath=\"" + svConfigPath ^ "UapCfg.mdf\" -vldfpath=\"" + svConfigPath ^ "UapCfg_log.ldf\" -o \"" + svConfigPath ^ "SqlCreateDB.txt\" -e
Note that we do not specify an instance name. We ran into a situation where someone had installed SQL Server 2008 on a box using a default instance name and our install then failed. I am considering 2 possible fixes, and have questions for both.
Fix #1: Specify an instance name. Ideally this would install SQL Server 2005 Express side by side with SQL Server 2008, create a unique instance name and we'd be good to go right? If yes, what is the accepted convention for specifying instance
Fix #2: Not sure if this is possible. Can we detect if SQL Server 2008 is on the box, and if yes, apply our 2005 database to it instead? In this case (tell me
Trying to copy a SQL2000 database on server TUNA to destination server MOJITO which runs default instance of SQL2008 (at ServicePack1) via the CD Wizard. Resulting job fails on MOJITO with this in application log:
SQL Server Scheduled Job 'CopyDatabaseWizard_TUNA_MOJITO_1' (0x64AB69F2880A7E4DA3708546C33DFF40) - Status: Failed - Invoked on: 2010-09-23 17:05:04 - Message: The job failed. Unable to determine if the owner (CBMIWEB\johna) of job CopyDatabaseWizard_TUNA_MOJITO_1
has server access (reason: Could not obtain information about Windows NT group/user 'CBMIWEB\johna', error code 0x5. [SQLSTATE 42000] (Error 15404)).
There is a credential on MOJITO defined for CBMIWEB\johna. There is a proxy on MOJITO that uses that credential. The job has one step and in the properties I have set the RUN AS value for the job to be the name of the Proxy. The proxy is established for
The "owner" of the job is also CBMIWEB\johna which is a domain userid in the local Administrators group of each machine (both TUNA and MOJITO). This userid has been granted the permission to
Logon as a Batch Job on both servers.
TUNA is a Windows 2000 standalone server; MOJITO is Windows 2003. I can logon to each server as CBMIWEB\johna.
I don't know what else to do.