SQL Server Management Studio Don't See Local SQL Server 2005 Developer Edition X64 On Vista Ultimate X64
SQL Server Management Studio don't see local SQL Server 2005 Developer Edition x64 on Vista Ultimate x64
Hi,
I have strange problem with SQL Server Management Studio on Vista Ultimate
x64. Nothing change after installing all newest service packs or hot fixes.
I have two running SQL servers on my local machine and all surrounding SQL
services running as well. I have turn on TCP/IP and Named pipes on both of
this servers. Actually I have reinstalled second server after first one
wasn't contactable in any way... After finished installation of second one
and after applying service packs I turn on SQL Server Management Studio and
still nothing in local servers pane when Browsing for servers to connect but
in network servers after few seconds I see one of my local servers (first one
installed) and one SQL Server 2000 on other machine (on this one I can't
connect because of time out error). Also when browsing for servers in Local
Servers I see my machine in Integration Services. Only difference between
this running services is that Integration service log on as Network Service
and all other SQL services log on as Local System account and on SQL Server
that is invisible I have also SQL Server Reporting Services running.
Services looks like this:
Name Status Startup type Log On AsSQL Server (KONGORA) Started Automatic Local System
SQL Server(MSSQLSERVER) Started Automatic Local System
SQL Server Active Directory Hel Automatic Network Service
SQL Server Agent (KONGORA) Started Automatic Local System
SQL Server Agent (MSSQLSERVER) Started Automatic Local System
SQL Server Analysis Services (KONG Started Automatic Local System
SQL Server Analysis Services (MSSQL Started Automatic Local System
SQL Server Browser Started Automatic Local System
SQL Server Full Text Search (KONG Started Automatic Local System
SQL Server Full Text Search (MSSQL Started Automatic Local System
SQL Server Integration Services Started Automatic Network Service
SQL Server Reporting Services (MSSQL Started Automatic Local System
SQL Server VSS Writer Started Automatic Local System
Thanks
Stjepan
View Complete Forum Thread with Replies
Related Forum Messages:
Cannot Install Sqlserver 2005 Developer Edition With Vista Ultimate
Currently I am just trying to completely remove all Vista Ultimate's knowledge of installed instances of SQLServer 2005 Developer edition. I cannot do this for some reason. This all began when I tried to install SQLServer 2005 and it installed but I could not connect to it. Now I have two installed instances that I cannot access, after removing all SQL programs from the Programs and Features icon in the control panel. I tried running "WIndows Installer CleanUp Utility" as I read in a thread on this forum. This did not help. After going thru and removing all SQLServer programs using the "programs and features" icon in control panel... The installation process shows two installed instances of SQLServer 2005. 1) How can I completely erase all Vista Ultimate's knowledge of any SQLServer 2005 install and start over? I have downloaded SQLServer 2005 SP 2, and run it, but clearly what I should do, and what Microsoft has asked me to do are not working... 2) What should I be doing to install SQLServer 2005 Developer Edition successfully? I have been a strong supporter of Microsoft, but this is getting me very frustrated. Please help, - Chaz
View Replies !
How Can I Install SQL Server 2005 Developer Edition's Management Studio On A Desktop Machine?
I have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!
View Replies !
Can You Install SQL Server 2005 On Vista Ultimate Edition?
Ive been told that you cant install SQL Server 2000/2005 on anything but a server OS (such as Windows Server 2003). How are people installing this into vista then as Longhorn is far from being released? When i try and install it into Ultimate, i only get the option to install client tools... which makes sense as the machine isnt a server. Surely people can install SQL Server 2005 in Vista though? All of the features are green ticked except the OS which has a compatabilty warning (which i expected). I feel im missing something really simple here.... Cheers Rob Macnair
View Replies !
SQL SERVER 2005 ENTERPRISE EDITION Installing Problem On Vista Ultimate RTM
when i was installing ss2005 i got two warnings: - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility I-IS Feature Requirement (Warning) Messages IIS Feature Requirement then in the next step ,there was only one option i could choose(workstation components,books online and develop tools), all the services were grey and not selected ,here 's the log file Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Professional (Build 6000) Time : Wed Dec 06 13:01:54 2006 TJM-PC : The current system does not meet the minimum hardware requirements for this SQL Server release. For system requirements, see Hardware and Software Requirements, in the readme file or in SQL Server Books Online. TJM-PC : Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online. Machine : TJM-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft Visual Studio 2005 Premier Partner Edition - ENU Product Version : 8.0.50727.42 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_PPESku_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_OWC11_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft SQL Server 2005 Books Online (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_BOL_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_BackwardsCompat_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : SQLXML4 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLXML4_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft SQL Server 2005 Tools Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_Tools.log -------------------------------------------------------------------------------- could any one tell my how could i intall the sql server database services and other services? thanks
View Replies !
Can't Connect To Local Server Instance MSSQLSERVER In SQL Server Management Studio (SQL2005 Sp2/Vista)
Can't connect to local server instance MSSQLSERVER in SQL Server Management Studio (SQL2005 sp2/Vista). SQL Server Configuration Manager reports SQL Server2005 services: SQL Server (MSSQLSERVER) Running. This would indicate the name of the SQL server is "MSSQLSERVER" correct? I chose "default" instance during the install and that is the name it gave itself. I tried connecting to the server using the following for the Server Name: MSSQLSERVER and .MSSQLSERVER neither works. The only thing that works for my installation is just plain "." (no quotes) and nothing else. Can this be correct because I can't find any reference to this. Thanks.
View Replies !
Steps To Install 64 Bit Sql Server 2005 Standard Edition In Windows Vista 64 Ultimate
Hi I have just take my system back to the factory defaults after some unsuccessful attempts to install 64 bit and 32 bit sql server on my notebook. I am looking to use either 32 or 64 bit (I have disks for both) and I would like to get a step by step guide that will help me through the process. I tried an install of the 64 bit version, applied SP2, and it went smoothly but the report services browser didn't work. I tried to change some IIS settings but I didnt document what I changed so i was unable to undo the changes that i made when these didnt work. I tried several combinations of things but then decided that a clean install on a clean system was the best option. I need the SQL engine , reporting services, analysis services - and possibly integration services - i am not sure if i need notification services (dont know what it does anyway!) I also have vs2005 - should i install that first or after sql server 2005 SP2? Thanks Doug
View Replies !
Updating To SQL Server Management Studio Developer Edition Is Not Working
I got VS Pro which came with SQL Server Management Studio Developer Edition. Very exciting! However, when I go to update from SQL Server Management Studio Express to Dev Edition it says that there are tools / components already installed. I completely uninstalled everything having to do with SQL Server from my machine and tried again. It still says that the tools / components are installed. I see that there are still several instances of SQL Server still on my machine. So I tried reinstalling Express again. However, now the Configuration Manager has a snap-in that won't start. Any help would be much appreciated. Thanks
View Replies !
SQL Server 2005 (Developer Edition) W/ SP2 Won't Install On Vista
I'm trying to install SQL Server 2005 (Developer edition) on my Vista Ultimate machine. I've got the IIS 7 features turned on; I've got the SP2 patch CD; and I've run every install as administrator. I've run the SQL Server setup before and after the SP2 patch I'm doing a named instance using the built-in system account with windows authentication mode. Is there any COMPLETE guide as to how to work through all these installation problems? I've gotten same results after about six attempts. These always install: SQL Setup Support Files SQL Native Client SQL VSS Writer SQL Server Backward Compatibility Files SQLXML4 SQL Server Books Online These always fail: OCW11 SQL Server Database Services Analysis Services Reporting Services Notification Services Integration Services Workstation Components; Books Online
View Replies !
Developer Limitation Under SQL 2005 Under Vista Ultimate 64 Bit
Just to be clear, I would like to know if a problem I face is due to an error on my part or a limitation on Microsoft's. In my experience (several hours-long installations, removals, reinstallations, using the skuupgrade=1 parameter from the command line, ad nauseum) I have concluded that the best one can do installing SQL Server 2005 Developer Edition from the Visual Studio 2005 Professional Edition package is to get the Express Edition, (actually styled MSSMLBIZ). In particular, what I'm hoping to be able to do is program to a test database that I have from my client, which I was able to do on my XP Professional machine. But on my new Vista Ultimate 64 bit machine (which will only let me install the x64 version of SQL Server 2005), I get an instance that is characterized as SQL Server Express and generates the following error message when I try to attach to the same MDF file to which I was able to attach under my prior, XP-Pro based configuration: TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'ZAPHOD42MSSMLBIZ'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft SQL Server, Error: 1827) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=1827&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ =================================================================================== The following is the Help obtained when clicking on the button on the error msg and the references in the error msg: =================================================================================== Details ID: Attach database Server Source: Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText We're sorry There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere. -------------------------------------------------------------------------------- Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information. Currently there are no Microsoft Knowledge Base articles available for this specific error or event message. For information about other support options you can use to find answers online, see http://support.microsoft.com/default.aspx. ================== Details ID: 1827 Source: MSSQLServer We're sorry There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere. Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information. ==========End of reproduction of error messages and help text ==================================== The Developer Edition, of course, is supposed to enable us to program to all levels of the database, and I would hate to think it is really crippled in this way, but after uninstalling everything, reinstalling multiple times (devoting several days to the process), it sure beats me how I can overcome this problem short of going back to my old machine. Any definitive answers on this apparent limitation, or useful procedural advice on installation quirks, would be appreciated (and, yes, I've spent a lot of time going through the installation/setup forum -- if the answer is there I can't find it).
View Replies !
SQL Server 2005 Developer Edition On Vista Home Premium??
I could not install SQL Server 2005 Developer edition on my notebook with os Vista Home Premium. I know about the SP2 thing...but before coming that point, I can not either install the SQL Server 2005... When installing,when the database services point comes it gives an error about user thing...and then installation starts to rollback... I check the IIS configuration from the net...And see that while activating IIS there is no option for Windows Auth. in Home Premium in Control Panel>Program...>Windows Programs.....etc.... SO ON VISTA HOME PREMIUM is SQL SERVER 2005 Dev. Edition can be installed or not?
View Replies !
Error - Installing SQL Server Developer Edition 2005 On Vista Home Premium
Hi, I have Vista Home premium edition and trying to install SQL Server developer edition 2005 as local administrator. I have already enabled IIS 7 and have Office Ultimate 2007 installed. When I run the set up program, I get a warning titled "Program Compatibility Assistant" that my Operating system may not be compatible with the version of sql server I am installing. It says after setup is complete, I should run SP2 of SQL Server 2005 with 3 buttons as "Check for solutions online", "run this program" and "cancel"... My question, should I select "run this program" and after the setup completes, download SP2 and apply the patch? I read some articles in forums that sounds like lot of issues to get sql server working on vista. Can some one direct me to correct options. This is my wife's machine so I dont want to experiment too much and blow her machine away. Please help. Thanks, Gaja
View Replies !
SQL Server 2005 Management Studio On Vista Issue.
Here is my setup. I have SQL Server 2005 Dev Edition with SP2 installed on Windows Vista Ultimate on my local computer. I have a development cluster running 2000 as well as several production clusters running 2000. The production clusters are accessed through an encrytped tunnel. The dilemna. I am able to connect to the clusters fine. I am also able to access the each DB without incident. My problem comes when I try to connect to DB's with a large number of tables. DB's on the same clusters with around 20 tables come back fine. I am able to start to click on the views drill down and press the stop action and it will display a small list of views. The tables view however, goes into la la land. My local Dev cluster has all the same DB's as my production clusters and has no problems returning the tables in any of the DB's. I get an "IS BUSY: Micorsoft SQL Server Managment Studio is waiting for an internal operation to complete." error and the managment studio never completes. Any help on this would be greatly appreciated.
View Replies !
SQL Server Management Studio Cannot Connect To Local Instance Of SQL Server 2005 SP2
Hello, I just installed SQL Server 2005 Enterprise edition from my company's DVD. It was installed with the setting of using both Integrated windows authenitication as well as basic named authenication. I installed all the options too: Database Engine, Analysis Services, Reporting Services, SQL Server compact edition, and Integration Services. When I look at services there are: SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Browser. All of which are running. Something that took me offguard was the installation did not ask me to provide an SA password. Other than that, the install looked like it went good. I was able to connect to the local instance of the SQL Server 2005 using the SQL Server Management Studio. I could connect with SA, or connect with Integrated Windows Authenication. Whoohoo. Off and running! As a matter of fact, for the SA account I could use any password and it would still log me in. First thing I did was I went in to the copy wizard to attempt to copy a database from a server on our network to my local box. First it asked me for the remote server. Then when I specified my local instance in the wizard, the wizard complained that my local instance was NOT SQL Server 2005. Doh! This I didn't understand. I figured maybe I need to check for MS updates. Sure enough, I found that ther was a SP2 and then a hot-fix for that SP2. I applied both. Now I cannot connect from SQL Server Management studio to my local instance of SQL Server 2005 database server. I get the following error: "An error occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)" However, I went in to see what other services I could connect to, and here's the results: Analysis Services : OK! Reporting Services (Windows Auth/Basic/Forms) : NG "The reporting Services Instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)" SQL Server Compact Edition : NG "The database cannot be found. Check the path to the database. [ File Name = CCG092 ] (SQL Server Compact Edition ADO.NET Data Provider) Integration Services : OK! I can connect to other SQL Server databases on our network. However, just not my local one. No one on the network can connect to me either. I even turned off my windows firewall and still no luck connecting to my own. So something really went wrong when I applied SP2, however, admittedly from the error message when I tried to use the copy wizard, something was probably already wrong. Any ideas? Thanks!
View Replies !
SQL 2008 Developer Edition Management Studio Does Not Work For Compact Edition 3.5 Databases
I am attempting to use the SQL Server 2008 Developer Edition (Management Studio) to create/manage a Compact Edition 3.5 database. My problem is that I cannot even create/open the compact database in Management Studio. Any help would be GREATLY appreciated. TIA Problem Creating the Compact Database: Open 2008 Management Studio From menu choose File | Connect Object Explorer... Choose SQL Server Compact Edition as the Server type. Choose <New Database...> as the Database file. Browse to folder where file will be created (C:MyDatabase#1.sdf was used in my example) Leave all other field as default selections OR make changes, either way it does not work. Click OK. At this point the OK button just becomes disabled and nothing happens. Problem Opening An Existing Compact Database: Open 2008 Management Studio From menu choose File | Connect Object Explorer... Choose SQL Server Compact Edition as the Server type. Choose <Browse for more...> as the Database file and locate a ".sdf" file that I created using VS2008. Enter password, if any. Click OK. The following exception is displayed: TITLE: Connect to Server ------------------------------ Cannot connect to C:Documents and SettingsdarrinbMy DocumentsVisual Studio 2008ProjectsTestSQLCompactEdition35TestSQLCompactEdition35AFS.sdf. ------------------------------ ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Could not load file or assembly 'Microsoft.SqlServerCe.Enumerator, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (mscorlib) ------------------------------ BUTTONS: OK ------------------------------
View Replies !
Vista X64 Ultimate + SQL 2005 Enterprise Edition (fresh Install)
Hi Everyone, I was playing around with SQL2k5 Express, but decided to download Enterprise using my MSDN subscription. I installed it, but none of the services are running. I don't understand why? I've checked the requirments and I notice that Vista x64 is not on the list for compatible OS's. I do get this when trying to install: - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online. Also, during the install, Componoents to Install: All the services are greyed out... is that because they can't be installed or because they're going to be installed by default? Anyone else have it running on Vista Ultimate x64? Am I doing something wrong or does it just not install on this version of Vista? Cheers, Mike Avelar
View Replies !
Sql Server 2005 On Vista Ultimate
Hey All, I have a notbook with vista ultimate and i am trying to install sql server 2005 (developers edition ) on it. The setup fails during the installation giving the message thaht the database service didnot start succesfully. I ahve tried a number of solutions for the issue but all in vain. The user i am using to install the server is an admin user.Plus i am very sure taht there are no h/w dependencies taht are causing the problem. Can some one please help me . I have been banging my head withteh issue for the past 4-5 days and some some will be reallyy appreciated ========================A section of the SQL.Log file============================== <EndFunc Name='Do_sqlServiceSDDL' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlServiceSDDL : Thu Aug 23 16:25:37 2007 MSI (s) (8C:14) [16:25:37:484]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:37:486]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof) MSI (s) (8C:70) [16:25:37:491]: Invoking remote custom action. DLL: C:WindowsInstallerMSI7517.tmp, Entrypoint: Do_sqlMofcomp <Func Name='LaunchFunction'> Function=Do_sqlMofcomp <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlMofcomp PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:37 2007 <Func Name='InstallMOF'> MOF data compiled from C:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof <EndFunc Name='InstallMOF' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:39 2007 MSI (s) (8C:14) [16:25:39:605]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:39:607]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL Server90SharedResources1033sqlmgmprovider.mfl) MSI (s) (8C:2C) [16:25:39:612]: Invoking remote custom action. DLL: C:WindowsInstallerMSI7D61.tmp, Entrypoint: Do_sqlMofcomp <Func Name='LaunchFunction'> Function=Do_sqlMofcomp <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlMofcomp PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:39 2007 <Func Name='InstallMOF'> MOF data compiled from C:Program FilesMicrosoft SQL Server90SharedResources1033sqlmgmprovider.mfl <EndFunc Name='InstallMOF' Return='0' GetLastError='14007'> PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:40 2007 MSI (s) (8C:14) [16:25:40:091]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='14007'> MSI (s) (8C:14) [16:25:40:093]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnsqlwep-uni.mof) MSI (s) (8C:CC) [16:25:40:098]: Invoking remote custom action. DLL: C:WindowsInstallerMSI7F46.tmp, Entrypoint: Do_sqlMofcomp <Func Name='LaunchFunction'> Function=Do_sqlMofcomp <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlMofcomp PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:40 2007 <Func Name='InstallMOF'> MOF data compiled from C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnsqlwep-uni.mof <EndFunc Name='InstallMOF' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:42 2007 MSI (s) (8C:14) [16:25:42:371]: Executing op: ActionStart(Name=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:42:373]: Executing op: CustomActionSchedule(Action=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_sqlMofcomp,CustomActionData=010Installing WMI registration50000\. ootMicrosoftSqlServerServerEventsMSSQLSERVERC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnsqlwep-uni.mof) MSI (s) (8C:14) [16:25:42:374]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) MSI (s) (8C:14) [16:25:42:375]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnetwcls.mof) MSI (s) (8C:2C) [16:25:42:380]: Invoking remote custom action. DLL: C:WindowsInstallerMSI882D.tmp, Entrypoint: Do_sqlMofcomp <Func Name='LaunchFunction'> Function=Do_sqlMofcomp <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlMofcomp PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:42 2007 <Func Name='InstallMOF'> MOF data compiled from C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnetwcls.mof <EndFunc Name='InstallMOF' Return='0' GetLastError='14007'> PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:47 2007 MSI (s) (8C:14) [16:25:47:173]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='14007'> MSI (s) (8C:14) [16:25:47:230]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\. ootMicrosoftSqlServerServerEvents(A;CI;CCDCLCSWRPWPRCWD;;;BA)) MSI (s) (8C:A4) [16:25:47:236]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9B21.tmp, Entrypoint: Do_WMISecurity <Func Name='LaunchFunction'> Function=Do_WMISecurity <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_WMISecurity PerfTime Start: Do_WMISecurity : Thu Aug 23 16:25:47 2007 <Func Name='Do_WMISecurity'> Configuring ACL for WMI namespace \. ootMicrosoftSqlServerServerEvents ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA) <Func Name='SecureWMINamespace'> <EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'> <EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'> PerfTime Stop: Do_WMISecurity : Thu Aug 23 16:25:47 2007 MSI (s) (8C:14) [16:25:47:286]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:47:288]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\. ootMicrosoftSqlServerServerEventsMSSQLSERVER(A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CCDCRC;;;[SQLServer2005SQLAgentUser$ADNAN-PC$MSSQLSERVER])) MSI (s) (8C:4C) [16:25:47:292]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9B61.tmp, Entrypoint: Do_WMISecurity <Func Name='LaunchFunction'> Function=Do_WMISecurity <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_WMISecurity PerfTime Start: Do_WMISecurity : Thu Aug 23 16:25:47 2007 <Func Name='Do_WMISecurity'> Configuring ACL for WMI namespace \. ootMicrosoftSqlServerServerEventsMSSQLSERVER ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CCDCRC;;;S-1-5-21-3043782012-3745310101-388358720-1076) <Func Name='SecureWMINamespace'> <EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'> <EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'> PerfTime Stop: Do_WMISecurity : Thu Aug 23 16:25:47 2007 MSI (s) (8C:14) [16:25:47:348]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:47:349]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\. ootMicrosoftSqlServerComputerManagement(A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD)) MSI (s) (8C:40) [16:25:47:354]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9BA0.tmp, Entrypoint: Do_WMISecurity <Func Name='LaunchFunction'> Function=Do_WMISecurity <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_WMISecurity PerfTime Start: Do_WMISecurity : Thu Aug 23 16:25:47 2007 <Func Name='Do_WMISecurity'> Configuring ACL for WMI namespace \. ootMicrosoftSqlServerComputerManagement ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD) <Func Name='SecureWMINamespace'> No need to protect the namespace security <EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'> <EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'> PerfTime Stop: Do_WMISecurity : Thu Aug 23 16:25:47 2007 MSI (s) (8C:14) [16:25:47:387]: Executing op: ActionStart(Name=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:47:389]: Executing op: CustomActionSchedule(Action=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=AddCertificate,CustomActionData=C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn) MSI (s) (8C:54) [16:25:47:394]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9BD0.tmp, Entrypoint: AddCertificate FTECa.DLL: INFO: FTE: AddCertificate(), Entering... FTECa.DLL: INFO: FTE: AddCertificate: CustomActionData: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn MSI (s) (8C:14) [16:25:47:452]: Executing op: ActionStart(Name=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,,) FTECa.DLL: INFO: FTE: AddCertificate: Succeeded. Added Certificate from C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnmsfte.dll MSI (s) (8C:14) [16:25:47:453]: Executing op: CustomActionSchedule(Action=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=InstallPerfCounters,CustomActionData=C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn MSI (s) (8C:14) [16:25:47:458]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9C0F.tmp, Entrypoint: InstallPerfCounters FTECa.DLL: INFO: FTE: InstallPerfCounters(), Entering... FTECa.DLL: INFO: InstallPerfCounters: CustomActionData: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn: FTECa.DLL: INFO: InstallPerfCounters: Instance name obtained: FTECa.DLL: INFO: InstallPerfCounters: Instance home path: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn FTECa.DLL: INFO: Setting acls on C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnmsfte.dll FTECa.DLL: INFO: successfully allowed access to PerfLoggingUsers and PerfMonitoringUser on C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnmsfte.dll FTECa.DLL: INFO: InstallPerfCounters: Patching C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnfdcntrs.ini -> C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnifdcntrs.ini, msftesqlFD -> msftesqlFD, MSFTESQL -> MSFTESQL FTECa.DLL: INFO: InstallPerfCounters: Patching C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnftecntrs.ini -> C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniftcntrs.ini, msftesql -> msftesql, MSFTESQL -> MSFTESQL FTECa.DLL: INFO: InstallPerfCounters: Patching C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnidxcntrs.ini -> C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniindctrs.ini, msftesqlidx -> msftesqlidx, MSFTESQL -> MSFTESQL FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnifdcntrs.ini have been installed. FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniftcntrs.ini have been installed. FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniindctrs.ini have been installed. MSI (s) (8C:14) [16:25:51:273]: Executing op: ActionStart(Name=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,,) FTECa.DLL: INFO: FTE: InstallPerfCounters(), Exiting... MSI (s) (8C:14) [16:25:51:274]: Executing op: CustomActionSchedule(Action=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=SetLaunchPermissions,CustomActionData={68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITYSYSTEM) MSI (s) (8C:78) [16:25:51:279]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAAFE.tmp, Entrypoint: SetLaunchPermissions MSI (s) (8C:14) [16:25:51:327]: Executing op: ActionStart(Name=StartServices,Description=Starting services,Template=Service: [1]) MSI (s) (8C:14) [16:25:51:329]: Executing op: ProgressTotal(Total=2,Type=1,ByteEquivalent=1300000) MSI (s) (8C:14) [16:25:51:329]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) MSI (s) (8C:14) [16:25:51:330]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.ldf00) MSI (s) (8C:14) [16:25:51:332]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) MSI (s) (8C:14) [16:25:51:333]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.ldf00) MSI (s) (8C:C4) [16:25:51:338]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAB2E.tmp, Entrypoint: Do_sqlFileRename <Func Name='LaunchFunction'> Function=Do_sqlFileRename <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlFileRename PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 <Func Name='Do_sqlFileRename'> <EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 MSI (s) (8C:14) [16:25:51:370]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:51:371]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.mdf00) MSI (s) (8C:14) [16:25:51:373]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) MSI (s) (8C:14) [16:25:51:375]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.mdf00) MSI (s) (8C:28) [16:25:51:380]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAB5E.tmp, Entrypoint: Do_sqlFileRename <Func Name='LaunchFunction'> Function=Do_sqlFileRename <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlFileRename PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 <Func Name='Do_sqlFileRename'> <EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 MSI (s) (8C:14) [16:25:51:426]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:51:427]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.ldf00) MSI (s) (8C:14) [16:25:51:429]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) MSI (s) (8C:14) [16:25:51:430]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.ldf00) MSI (s) (8C:04) [16:25:51:435]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAB9D.tmp, Entrypoint: Do_sqlFileRename <Func Name='LaunchFunction'> Function=Do_sqlFileRename <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlFileRename PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 <Func Name='Do_sqlFileRename'> <EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 MSI (s) (8C:14) [16:25:51:477]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:51:478]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.mdf00) MSI (s) (8C:14) [16:25:51:480]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) MSI (s) (8C:14) [16:25:51:502]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.mdf00) MSI (s) (8C:C0) [16:25:51:508]: Invoking remote custom action. DLL: C:WindowsInstallerMSIABDD.tmp, Entrypoint: Do_sqlFileRename <Func Name='LaunchFunction'> Function=Do_sqlFileRename <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlFileRename PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 <Func Name='Do_sqlFileRename'> <EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 MSI (s) (8C:14) [16:25:51:526]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1]) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:51:527]: Executing op: CustomActionSchedule(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=100Configuring Microsoft SQL Server30329600lpc:ADNAN-PC) MSI (s) (8C:14) [16:25:51:528]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1]) MSI (s) (8C:14) [16:25:51:532]: Executing op: CustomActionSchedule(Action=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=9217,Source=BinaryData,Target=**********,CustomActionData=**********) MSI (s) (8C:C8) [16:25:51:537]: Invoking remote custom action. DLL: C:WindowsInstallerMSIABFD.tmp, Entrypoint: Do_sqlScript <Func Name='LaunchFunction'> Function=Do_sqlScript <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Aug 23 16:25:51 2007 Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Aug 23 16:25:51 2007 Service failed unexpectedly (1067) Error Code: 0x8007042b (1067) Windows Error Text: The process terminated unexpectedly. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Fri Sep 16 13:20:12 2005 Function Name: sqls:ervice:tart Source Line Number: 301 ---- Context ----------------------------------------------- Setting status of unmanaged components and removing unmanaged resources Do_sqlScript SqlScriptHlpr Start service MSSQLSERVER Error Code: 1067 MSI (s) (8C!B0) [16:28:16:318]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. . Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. . <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Aug 23 16:28:16 2007 Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Aug 23 16:28:16 2007 Service failed unexpectedly (1067) Error Code: 0x8007042b (1067) Windows Error Text: The process terminated unexpectedly. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Fri Sep 16 13:20:12 2005 Function Name: sqls:ervice:tart Source Line Number: 301 ---- Context ----------------------------------------------- Setting status of unmanaged components and removing unmanaged resources Do_sqlScript SqlScriptHlpr Start service MSSQLSERVER Do_sqlScript SqlScriptHlpr Start service MSSQLSERVER Error Code: 1067 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5520 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 4116 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 2800 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5220 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 532 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5320 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5836 could not be cancelled. Error: 1168 MSI (s) (8C!B0) [16:28:22:408]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. . Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. .
View Replies !
SQL Server 2005 On Vista Ultimate
Hello Everyone, A've installed Visual Studio 2005, SQL Server 2005 and all the SP's necessary. My Problem is I do not have the possability to install a SQL Server Instance of any kind, therefore it is not possible to start any of the SQL Server 2005 Configuration Tools. I Get the Warnings during the Installation process: Edition Change Check SQl Server Edition Operating System Campatibility Any help at all is very much appreciated, thanks a lot.
View Replies !
Local SQL Server Instances Not Showing Up On Local Servers Tab Of Management Studio Logon Screen
We have a 64-bit VM server running SQL Server 2005. The SQL Server on this particular VM server has 6 local instances installed. On the Management Studio logon screen I can type the full name of the local instance and connect to it, however if I press the drop down in the Server name field, choose Browse and select the Local Servers tab there is nothing listed under Database Engines. Any idea why the 6 local instances don't show up under Database Engines? This is preventing me from installing a vendor application because their installer looks for local SQL Server instances on this server, but if SQL Server won't even show the local instances then the installer doesn't see them either. Any help is greatly appreciated. Thanks, Craig
View Replies !
Sql Server 2005 Installation On Vista Ultimate
Ok guys, I am trying to install Sql server 2005 on Vista but I am still stuck with this warning message in the System Configuration Check during Sql server 2K5 installation : SQL Server Edition Operating System Compatibility (Warning) Messages * SQL Server Edition Operating System Compatibility * Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online. Now, I know I need to install SP2 but how the hell I am going to install SP2 if Sql server 2005 doesn't install any of the components including Sql server Database services, Analysus services, Reporting integration services( only the workstation component is available for installation)? Any work around for this issue? P.S.: I didn't install VS.NET 2005 yet, can this solve the problem? I am running on Vista Ultimate and Installing Sql Server 2k5 enterprise edition Thanks.
View Replies !
Stopping SQL Server 2005 Via Local Management Studio Throws Error &&"RPC-server Is Not Available&&"
Hi everybody, I use my local installed Management Server to stop SQL Server 2005 instances. I use the context menu of the "registered Servers" window. That works fine several times. Today I suddenly got error message "RPC-server is not available. (As we run a german version the exact error message is : "Der RPC-Server ist nicht verfügbar (Exception from HRESULT: 0x800706BA) (mscorlib)"). I checked the services of the machine hosting the SQL Server, but verything seems to be OK. I rebooted the maschine without success. I don't know what happened. But I installed a lot of Updates from MS update site. I think it has something to do with one of these updates. By the way, it is no problem to stop SQL Server via Management Studio installed on the maschine that host the SQL Server! Anyone experience the same problem ? Wolfgang
View Replies !
Installing SQL Server 2005 On Windows VISTA ULTIMATE
Hi, Trying to install SQL Server 2005 on Windows VISTA Ultimate, received following error: - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online. Please help.
View Replies !
Sql Server Dev 2005 Install Problem On Vista Ultimate
I am getting the error message below when installing sql server 2005 dev edition on windows vista ultimate. I just bought a new hp notebook and installed visual studio 2005 pro and office 2007. Works very well. Then I'm trying to install sql server 2005 dev edition and get the error below. Please help SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'SAVIOURSQLServer2005MSSQLUser$SAVIOUR$MSSQLSERVER' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29521&EvtType=lib%5codbc_statement.h%40Do_sqlScript%40OdbcStatement%3a%3aexecute_batch%40CnfgSQL%4080%40x3c29
View Replies !
Unable To Install SQL Server Express 2005 Sp2 On Vista Ultimate
I have been trying to install BCM 07 and Accounting Pro 07 for a couple days now with the same SQL Server Express eroor. I've also attempted to install SQL Express sp2 alone to no avail either. Here is the log file from my last BCM install attempt. Any advise would be GREAT! I have already tried changing my PC name to CHARLIE which did not resolve it either. Thanks for the help! Charlie Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Professional (Build 6000) Time : Thu Jul 26 21:21:43 2007 Machine : CHARLIE Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server VSS Writer Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : CHARLIE Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.1.2047.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}Shared Memory Provider: Timeout error {258}. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. Error Number : 29515 -------------------------------------------------------------------------------- SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt. Time : Thu Jul 26 21:23:43 2007 List of log files: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Core(Local).log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLSupport_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLNCLI_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SqlWriter_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQL.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Datastore.xml C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_.NET Framework 2.0.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SNAC.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Core.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Support.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SCC.log c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
View Replies !
Difficulty In Installing SQL Developer On Vista Ultimate
I have a real installation mess n my hands. I'm attempting to install Sql Server Developer edition on a new Thinkpad with Vista Ultimate. There are no issues with limited resources. This copy of Vista Ultimate came with a trial copy of Office 2007 and SQLExpress was intalled with it. I unistalled SQLExpress being unaware of the Vista Compatibility problems. SQL Developer did not install after I removed SQLE. After researching this on the net, I read that developer could be installed as an upgrade if SQLE is on the system. So Installed SQLE with advanced tools deliberately not installing the tools. That installation went well. So then I tried to reinstall SQL Developer and received a message about having to setup via command line because of an exisiting instance. So I installed Developer with the folowing command line from an MSDN DVD. E:ENGLISHSQL2005DEVELOPERSQL Server x86Servers>start /wait setup.exe ADDLOC AL=SQL_Engine INSTANCENAME=MHASQLE UPGRADE=SQL_Engine SKUUPGRADE=1 /qb I chose the advanced options specifiying that the tools be installed. That installation failed to install the tools and I believe there was an error in the core data engine installation. I received an error message to check the logs but to be honest, there are meagbytes of log files and I don't really know what to check. The core log looked like this: Microsoft SQL Server 2005 Setup beginning at Mon Oct 29 11:11:04 2007 Process ID : 4816 E:ENGLISHSQL2005DEVELOPERSQL Server x86Serverssetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/9/29 11:11:3 Complete: LoadResourcesAction at: 2007/9/29 11:11:3, returned true Running: ParseBootstrapOptionsAction at: 2007/9/29 11:11:3 Loaded DLL:E:ENGLISHSQL2005DEVELOPERSQL Server x86Serversxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/9/29 11:11:4, returned true Running: ValidateWinNTAction at: 2007/9/29 11:11:4 Complete: ValidateWinNTAction at: 2007/9/29 11:11:4, returned true Running: ValidateMinOSAction at: 2007/9/29 11:11:4 Complete: ValidateMinOSAction at: 2007/9/29 11:11:4, returned true Running: PerformSCCAction at: 2007/9/29 11:11:4 Complete: PerformSCCAction at: 2007/9/29 11:11:4, returned true Running: ActivateLoggingAction at: 2007/9/29 11:11:4 Complete: ActivateLoggingAction at: 2007/9/29 11:11:4, returned true Running: DetectPatchedBootstrapAction at: 2007/9/29 11:11:4 Complete: DetectPatchedBootstrapAction at: 2007/9/29 11:11:4, returned true Running: LaunchPatchedBootstrapAction at: 2007/9/29 11:11:4 Error: Action "LaunchPatchedBootstrapAction" threw an exception during execution. Error information reported during run: "c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1706 Aborting queue processing as nested installer has completed Message pump returning: 1706 I believe residual office files are throwing the installation off but that could be an erroneous conclusion as the OWC portion always fails with a 1706. What I need is basic SQL functionality and it's really important that I have the Studio Management Console. Does anyone have any suggestions as to what log to check toward getting a core data engine installed along with the olls and documentation for SQL Developer?
View Replies !
SQL Server Management Studio && Vista
Hello all, I'm trying to install "SQL Server Management Studio Express" on a PC running Vista and I get the following message. "Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation." Can anyone help me on this? Tks!
View Replies !
Failure Installing Sql Server 2005 Express On Vista Ultimate X64, Error 29506
Whenever I try to install SQL Server 2005 Express Edition on my Vista Ultimate x64 platform I get error 29506. All I could find on the web was that this is probably due to an access control problem. I have tried installing it as the local administrator, as a member of domain admins, and as the domain administrator. All get the same error. My domain is a Small Business Server domain. This may be part of the problem, but I can't imagine how. When trying to force access to the domain administrator, I also seem to get an access problem. Any suggestions?
View Replies !
SQL Server 2005 Express Edition With SQL Server Management Studio Express (SSMSE)
Hi all, I have installed SQL server 2005 express edition with SQL server Management studio express (SSMSE). I have installed also SQLce and I would know how I can manage sql compact edition databases (.ldf) with sql SSMSE, if it is possible! I would be grateful if you could explain it trought a detailed guide (I am a beginner user of sql server tools) or trought a link to useful sites. I'm Looking forward for your reply and still trying... Alessandro
View Replies !
Help With Running Sql 2005 Developer Edition On Vista
hi i have installed sql 2005 developer edition on my lap top windows vista home premium interl core 2cpu 1.66 ghz with 2 gig of ram but when i try to start the database i get the following error unable to start the service mssqlserver on server andy-pc the mssqlserver service on andy-pc started and then stopped i have installed sql service pack 2. can someone please advise as i need to get it working on my laptop
View Replies !
Installing SQL Serer 2005 Developer Edition On Windows Vista
Dear friends... I am having this problem since I installed the new windows Vista. I am trying to install the SQL Server 2005 developer edition on Windows Vista, but After installation finish successfuly I open the start menu to surprise that I could not find the Shortcuts to open the SQL Server and create new database and tables etc... I opened the full path of the exe files "C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDE" but there are not any file there, even that I searched for the exe files names but they are not existed. It looks that after instalation complete that the SQL Server is not installed on Windows Vista. So, my question is: After installing the SQL Server 2005 SP2 for windows Vista, will the problem be solved? Or there is something else to do ON WINDOWS VISTA. Please, I need the answer for this problem, because I need to work on SQL Server 2005 very hard. Thanks in advance for your help...
View Replies !
How Can I Access SQL Server Compact Edition With SQL Server Management Studio Express?
Hello, I just installed SQL Server Compact Edition, since I am considering using it instead of SQL Server Express for a local database in my application. The documentation mentioned that I could use SQL Server Management Studio Express to connect to the Compact Edition and create and manipulate databases. To try to connect, I run Management Studio and bring up the "Connect to Server" dialog. Unfortunately, the pull-down list of "Server name"s does not include the SQL Server Compact Edition server. I do not know how to type in the server name manually, so I cannot connect. To install Compact Edition, I downloaded it and ran "SQLServerCE31-EN.msi". This installed, and I assume registered, a number of DLLs in "C:Program FilesMicrosoft SQL Server Compact Editionv3.1". Is there perhaps an additional step that I left out to complete the installation? Might I need an upgrade to some other components? My Management Studio Version is: - Microsoft SQL Server Management Studio Express 9.00.2047.00 I would appreciate any help you can provide. Thank you, WTW
View Replies !
Using SQL Server Management Studio Tools To Manage Dbs On SQL Server Express Edition
Hopefully a simple question: Is it possible to use Maintenance Plans created on SQL Server Management Studio (installed as part of an instance of SQL Server 2005 Standard Ed.) to back up databases running on an instance of SQL Server Express Edition with Advanced Services? I don't need directions, just whether or not it is permitted. I've been able to create the plans including establishing connections to from SSMS to the the SQL Express instance, but they keep erroring out. I just need to know if this is actually permitted since Maintenance Plans are not available on Management Studio Express Edition. Thank you in advance for your help.
View Replies !
Error Installing SQL Server Management Studio Express On Windows Vista RC1
Hello NG, After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message: "Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506." Where can I find more infos about this error-code? Anybody knows this problem? Thank in advance for every help.
View Replies !
Cant Install SQL Standard Edition On VISTA Ultimate
I ve been coping with the follwing Error for 2 months , and i desperately need sb helping me out with a practical solution. the error has become a real pain in the neck 4 me .I want to install SQL 2005 standard edition on a vista ultimate however the error appears at almost the end of installation proceess .and the sql server database services fails to be installed on vista????? and doesnt get a check mark. this is the Error: sQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'computer-nameSQLServer2005MSSQLUser$computer-name$MSSQLSERVER' not found. Check the name again..
View Replies !
SQL Server CE And SQL Server Management Studio Express Edition Yet Again
When I try to open a CE database from SSMSEE, I get the dreaded "You are trying to access an older version of a SQL Server Compact Edition database" error, with "Db version = 3505053, Requested version = 3004180." I am using what I believe to be the latest version of SSCE (3.5) and the latest version of SSMSEE (2005 SP2, Help|About reports the version as 9.00.3042.00). The database is created without error, compacted, repaired, and so forth, with no change to the error. Do I need to install or reinstall something, and if so what? Thanks.
View Replies !
Compact Edition V3.5 And SQL Server Management Studio
Is it possible to use SQL Server Compact Edition v3.5 with SQL Server Management Studio? When I attempt to connect to a 3.5 database I get the following error: "You are trying to access an older version of a SQL Server Compact Edition Database..." I am using v3.5 beta 2. If not, is there anything out there that provides a Query Analyzer like interface for viewing data that works with v3.5? Thanks.
View Replies !
Can I Use Sql Server 2005 Developer Edition With Windows Xp Home Edition SP2 For MCTS Exam 70-431 Preparation?
Hi I am interested in taking MCTS exam 70-431 for sql server 2005 implementation and maintainance. I have been reading the hardware requirements for the instalation of sql server versions and realise that enterprise and developer editions have same minimum requirements for the operation system. I understand that the Developer Edition includes all the functionality of SQL Server 2005 Enterprise Edition, but it is licensed for use as a development and test system, not as a production server. Also I undestand that the developer edition supports the Windows XP Home Edition with SP2 or later but the enterprise edition does not support this operating system. The evaluation/trial version is for the enterprise edition. Can I use the developer version of sql server 2005 for my practice exercises instead of using the trial version? I have all hardware requirements for the trial enterprise version except that I am using Microsoft windows Xp home edition version 2002 with SP2. I am trying to see if I can use the developer version of sql server 2005 as it is cheaper for me to buy this software than buying the new operating system for my computer. According to the microsoft book for the MCTS exam 70-431 there is a section which states that before you begin you should have Microsoft Windows Server 2003 running on your computer on an NTFS file system (NTFS) partition. Will I still be ok to use the book and be able to do all the tests in the book if i am using the developer version of sql server 2005 with my Microsoft windows Xp home edition than using the trial version which comes with the book? Thanks gifty
View Replies !
Change From Developer Edition To Enterprise Edition Of SQL Server 2005 64 Bit
We have an existing installation of SQL Server 2005 Developer Edition (64bit) that we are ready to go live with and would like to change the edition to Enterprise Edition (64bit). We have purchased all the appropriate licenses. We would like to avoid UN-installing the Developer Edition and RE-installing the Enterprise Edition. There must be some way to change a registry key, provide your serial number via a command line utility or re-run the setup with the license key provided and direct it to just change the edition from Developer to Enterprise and not change any of the other settings like service account, sa account, collation, etc. Any help is most appreciated. Thank you, Matt
View Replies !
SQL Server Management Studio Express On Vista Home Premium (Error On Attaching And Detaching .mdf)
I have SQL Express 2005 SP2 installed in my Vista Home Premium. I am using SQL Server Management Studio Express to manage .mdf. When I click "Add..." to attach .mdf database, I have this prompt error message : The server principal "My-PCMyName" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error: 916) I have elevated the rights, "Run as administrator", of my SQL Server Management Studio Express, but still having problem. I also encounter security error when detaching the existing .mdf : The EXECUTE permission was denied on the object 'sp_detach_db', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229) Please advice. Thanks.
View Replies !
|
TRACKER
