Hi theres,
I have installed SP2 on my server (Window server 2003 and SQl Server 2005 standard Edition both are 64 bit). But when i query SELECT @@VERSION. i got that latest installed SP is SP1.Even i have installed SP2 successfully and interactively then where m wrong(Window server have Sp2)
Hi,I have an application that's running fine on development servers (weband database-sql server 2000). I'm updating a record through a thirdparty component but I don't think the component is the problem. What'shappening is that I'm updating fields that are part of view. I'm onlyupdating fields in one table of the view and this works fine in thedevelopment environment.What happens in the production environment when I try to update(using the third party component) I get the following message:"Current recordset does not support updating. This may be a limitationof the provider or of the selected locktype."As an experiment I took the same code but removed the view, leavingonly the table I want to update as the record source. In that case theupdate worked. So it seems that something in the production databasedoesn't like me updating a view. However I can do that in the databasein the development environment.The third party component is dbnetgrid which works fine in thedevelopment environment. I can only conclude it's something about thedatabase that prevents me from updating this same table if it's in aview. I've talked to our DBA but he says there's no difference betweenthe databases. Any ideas would be appreciated.Neil
View 2 Replies View RelatedWindows Update gave a 0X65B error when installing SQL Server 2K5 Express SP2. The solution said to copy the summary.txt data below to this forum:
Time: 05/08/2007 11:06:22.102
KB Number: KB921896
Machine: WA10015USG93127
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU SP1 2005.090.2047.00 x86 EXPRESS
Express Database Services (SQLExpress) ENU SP2 x86 EXPRESS
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
Error Number : 1627
Error Description : Unable to install Windows Installer MSI file
----------------------------------------------------------------------------------
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1627
Any help would be appreciated in getting this service pack installed.
Thanks,
Marty
I am unable to update the data using record by record below scenario.
Required output:
patient will able to Admit/Re-admit multiple times in hospital, if a patient readmitted multiple times in hospital after the first visit, first visit record will get Re-admission=0 and Index=1. This visit should cal Index_Admission of that patient. using this index_admission should calculate the 30-day readmission.
Current Output:
Calculation: From index_admission discharge date to next admit_visit date,
1) if the diff is having less than 30 days, readmission=1 and Index=0
else readmission=0 and Index=1 should be update.
For checking this every time should check using the latest index_admission discharge_date.
To get this result i written below logic, but it's updating readmission=0 and Index=1 after 30-day post discharge of using first index admission.
UPDATE Readmission
SET Index_AMI = (CASE WHEN DATEDIFF(DD, (SELECT Sub.Max_Index_Dis FROM
(SELECT Patient_ID, MAX(Discharge_Date_Time) Max_Index_Dis FROM Readmission
WHERE Index_AMI = 1 AND FPR.Patient_ID = Patient_ID GROUP BY Patient_ID) Sub)
, FPR.Admit_Date_Time) between 0 and 31 THEN 0 ELSE 1 END),
[Code] ....
Expected Result:
Hi,
I have VS Pro 2005 and SQL Server Express 2005 installed on an XP Pro machine. When using VS 2005, in the 'Server Explorer' window I can see and attach to two SQL Server databases that I have set-up. But if I attempt to access the same databases from withn the 'Solution Explorer' window I get the following dialog box message,
"
Required Component Missing (Dialog box heading)
Connections to SQL Server Files (*.mdf) require SQL Server Express to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251
"
I have uninstalled and then reinstalled both VS 2005 and SQL Server Express twice but it has helped.
I don't understand why I'm getting this error because all of the server configuration tools and connection utilities seem to work fine but VS say's that SQL Server Express is not installed.
Thanks,
CLN
P.S.
I had another application that required MSDE 2000A to be installed. When I removed the other application I also removed MSDE 2000A and that's when the problem began.
I'm having some problems debugging SQL Server stored procedures on a SQL Server 2005 server. I have installed Visual Studio 2005 on a workstation running Windows XP, now I'm trying to debug a ASP.Net web application that has some code that executes the stored procedures on a Windows 2003 Server running SQL Server 2005.
I opened VS2005 ... created a connection to the SQL Server 2005 instance ... open the Stored procedure ... right click the stored procedure name and selected Step into Stored Procedure and the following message is displayed:
Unable to start T-SQL debugging.Could not attach to SQL Server process on 'ServerName'.
Any ideas.
Thanks,
i have a DVD set of Visual Studio 2005 Professional Addition. I copy all of its components on my hard disk and then start downloading Visual Studio 2005 Professional Addition from the folder that i have copied on my hard disk. The installation process installs every think visual studio, .net framework 2.0, parser etc but when it reached to insatll SQL Server 2005 , it displays an error "Microsoft SQL Server 2005 setup has encountered an error and will end" and The following components falied to install " Microsoft SQL Server Express Edition x86". I then uninstall the whole visual studio using autorun and then reinstall it, but the problem remain there. Then i search this issue on net and i found an article according to which, i uninstall visual studio again but now this time i manually uninstall the components by folowing the sequence which is given in the that article. Then i delete all the folders and files from the temp folder and again install the visual studio but the problem still exists. I dun know why it is not installing. Please, if anybody knows the solution, reply me soon.
Thanks ...
and sorry for my english.
Hi, I'm not a DBA and our DBA is not available.
I get the following error for my connection string when I try to connect to a specific database on the SQL Server 2005:
Below is the connection string:
cnn = "data source=" & CompanyT & ";driver=VPC-002BALGORD\SQLEXPRESS;AttachDBFilename=" & ArInvoice.FilePath & ";username=sa;password=balgord;Trusted_Connection=no"
SQLdb.Open cnn
I get the following error:
[Microsoft][SQL Native Client][SQL Server]Login failed for user. the user is not associated with a trusted SQL Server connection
Mixed mode is set in the Server Security properties (SQL Server authenticaion and Windows Authentication).
I searched googled and everyone says set the authentication to mixed mode... It is set to mixed mode so I'm all out of ideas. I think if there was an error in the connection string it would give me a different error right? I dont know I'm all out of ideas, any help will be greatly appreaciated.
Thank you.
Regards,
Irena V.
Previously, I have installed SQL 2005 developer edition simplyfied chinese
successfully. But yesterday, I tried to install mobile client software
factory. The installation process create a database as following:
Create DATABASE [AdventureWorksMobileStaging] ON PRIMARY
( NAME = N'AdventureWorksMobileStaging', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging.mdf' , SIZE = 195584KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
( NAME = N'AdventureWorksMobileStaging_log', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging_log.ldf' , SIZE = 265344KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
But today, when I start my notebook, SQL server could not be started.
Then I uninstalled the SQL instance by start->control panel->uninstall...The uninstall
process seems OK. Note that I only uninstalled the instance.Then I tried to reinstall
SQL 2005. However it was reported a Performance Monitor Counter registry key mismatch
error occures. I tried to fix it but failed. The problem is as following:
1, The installation process report a warning of low memory.
My notebook has 512M memory. I have reinstalled SQL 2005 once successfully. At that
time, the warning also shows, but it seems that this warning does not affect installation.
2, User type problem.
The OS of my notebook is XP professional, which is upgraded from XP home edition.
I login it using a domain user such as: "my company's domainmyaccount". I found it
curiously that although I assign myaccount as an Administrator, it will automaticly
changed to "SQL$...." account. I don't know why and when the account property is
changed. But everytime, when I found, I will assign myaccount as an Administrator
back.
3, Performance Monitor Counter registry key problem.
To fix the problem, I firstly tried to run lodctr.exe in cmd window but failed.
When I cd to c:windowssystem32 dir, I can ran lodctr.exe correctly.
I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib,
the result is:
"Last Counter"=dword:0000149c (11128)
"Last Help"=dword:0000149d (11129)
Then I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib 09
and 004, the result is confusing. I can find counter and help key,but both keys contains
really a lot of stuff as:
(1) first page of Counter key:
1
1847
2
System
4
Memory
6
% Processor Time
10
File Read Operations/sec
12
(2) first page of Help key:
3
The System performance object consists of counters that apply to more than one instance of a component processors on the computer.
5
The Memory performance object consists of counters that describe the behavior of physical and virtual memory on the computer. Physical memory is the amount of random access memory on the computer. Virtual memory consists of the space in physical memory and on disk. Many of the memory counters monitor paging, which is the movement of pages of code and data between disk and physical memory. Excessive paging, a symptom of a memory shortage, can cause delays which interfere with all system processes.
7
% Processor Time is the percentage of elapsed time that the processor spends to execute a non-Idle thread. It is calculated by measuring the duration of the idle thread is active in the sample interval, and subtracting that time from interval duration. (Each processor has an idle thread that consumes cycles when no other threads are ready to run). This counter is the primary indicator of processor activity, and displays the average percentage of busy time observed during the sample interval. It is calculated by monitoring the time that the service is inactive, and subtracting that value from 100%.
9
% Total DPC Time is the average percentage of time that all processors spend receiving and servicing deferred procedure calls (DPCs). (DPCs are interrupts that run at a lower priority than the standard interrupts). It is the sum of Processor: % DPC Time for all processors on the computer, divided by the number of processors. System: % Total DPC Time is a component of System: % Total Privileged Time because DPCs are executed in privileged mode. DPCs are counted separately and are not a component of the interrupt count. This counter displays the average busy time as a percentage of the sample time.
11
File Read Operations/sec is the combined rate of file system read requests to all devices on the computer, including requests to read from the file system cache. It is measured in numbers of reads. This counter displays the difference between the values observed in the last two samples, divided by the duration of the sample interval.
I could not find the maximum value of the Counter key and help key, so I could not repair
Last Counter and Last Help key as discribed at SQL 2005 help. Which item correspond to
maximum value of the Counter key and help key?
I tried to correct Last Counter and Help key as:
"Last Counter"=dword:0000149c (5276)
"Last Help"=dword:0000149d (5277)
But it also doesn't work.
Hi,
I€™m unable to install SQL Server 2005 on Win XP Professional 2002 SP2. I tried both with SQL Enterprise and Express editions nothing works. It seems to be installed but I can not find the management studio. Some one PLZZZZZZZZ suggest what to do in order to get it installed.
Thanks,
Hari
Hello,
i cant installthe service pack 2 for sql server 2005.
i get this error code 1063.
what does that mean ?
thank you
I get to the point of starting the services and receive the following message after about 4 minutes of trying to start. I tried in Mixed Mode and Windows Authentication Mode. Message:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
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."
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=29503&EvtType=sqlsetuplib%5cservice.cpp%40Do_sqlScript%40sqls%3a%3aService%3a%3aWaitForServiceState%40x41d
------------------------------
BUTTONS:
&Retry
Cancel
------------------------------
Previously, I have installed SQL 2005 developer edition simplyfied chinese
successfully. But yesterday, I tried to install mobile client software
factory. The installation process create a database as following:
Create DATABASE [AdventureWorksMobileStaging] ON PRIMARY
( NAME = N'AdventureWorksMobileStaging', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging.mdf' , SIZE = 195584KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
( NAME = N'AdventureWorksMobileStaging_log', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging_log.ldf' , SIZE = 265344KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
But today, when I start my notebook, SQL server could not be started.
Then I uninstalled the SQL instance by start->control panel->uninstall...The uninstall
process seems OK. Note that I only uninstalled the instance.Then I tried to reinstall
SQL 2005. However it was reported a Performance Monitor Counter registry key mismatch
error occures. I tried to fix it but failed. The problem is as following:
1, The installation process report a warning of low memory.
My notebook has 512M memory. I have reinstalled SQL 2005 once successfully. At that
time, the warning also shows, but it seems that this warning does not affect installation.
2, User type problem.
The OS of my notebook is XP professional, which is upgraded from XP home edition.
I login it using a domain user such as: "my company's domainmyaccount". I found it
curiously that although I assign myaccount as an Administrator, it will automaticly
changed to "SQL$...." account. I don't know why and when the account property is
changed. But everytime, when I found, I will assign myaccount as an Administrator
back.
3, Performance Monitor Counter registry key problem.
To fix the problem, I firstly tried to run lodctr.exe in cmd window but failed.
When I cd to c:windowssystem32 dir, I can ran lodctr.exe correctly.
I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib,
the result is:
"Last Counter"=dword:0000149c (11128)
"Last Help"=dword:0000149d (11129)
Then I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib 09
and 004, the result is confusing. I can find counter and help key,but both keys contains
really a lot of stuff as:
(1) first page of Counter key:
1
1847
2
System
4
Memory
6
% Processor Time
10
File Read Operations/sec
12
(2) first page of Help key:
3
The System performance object consists of counters that apply to more than one instance of a component processors on the computer.
5
The Memory performance object consists of counters that describe the behavior of physical and virtual memory on the computer. Physical memory is the amount of random access memory on the computer. Virtual memory consists of the space in physical memory and on disk. Many of the memory counters monitor paging, which is the movement of pages of code and data between disk and physical memory. Excessive paging, a symptom of a memory shortage, can cause delays which interfere with all system processes.
7
% Processor Time is the percentage of elapsed time that the processor spends to execute a non-Idle thread. It is calculated by measuring the duration of the idle thread is active in the sample interval, and subtracting that time from interval duration. (Each processor has an idle thread that consumes cycles when no other threads are ready to run). This counter is the primary indicator of processor activity, and displays the average percentage of busy time observed during the sample interval. It is calculated by monitoring the time that the service is inactive, and subtracting that value from 100%.
9
% Total DPC Time is the average percentage of time that all processors spend receiving and servicing deferred procedure calls (DPCs). (DPCs are interrupts that run at a lower priority than the standard interrupts). It is the sum of Processor: % DPC Time for all processors on the computer, divided by the number of processors. System: % Total DPC Time is a component of System: % Total Privileged Time because DPCs are executed in privileged mode. DPCs are counted separately and are not a component of the interrupt count. This counter displays the average busy time as a percentage of the sample time.
11
File Read Operations/sec is the combined rate of file system read requests to all devices on the computer, including requests to read from the file system cache. It is measured in numbers of reads. This counter displays the difference between the values observed in the last two samples, divided by the duration of the sample interval.
I could not find the maximum value of the Counter key and help key, so I could not repair
Last Counter and Last Help key as discribed at SQL 2005 help. Which item correspond to
maximum value of the Counter key and help key?
I tried to correct Last Counter and Help key as:
"Last Counter"=dword:0000149c (5276)
"Last Help"=dword:0000149d (5277)
But it also doesn't work.
Hello all,
I have tried to install SQL Server 2005 Standard edition with CLUSTERING. I faced a problem and everything rolls back.
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup was unable add user domain1xyz to local group domain1IT Security Admin-Group.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29512&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroupMember%40Do_sqlGroupMember%40x6ba
I have refered to PostI=1659185 posted by Fly and it still won't be able to fix my problem.
I have added LOCAL SERVICE into the local group (SQLServer2005MSFTEUser$AAA$MSSQLSERVER), but it still can't work.
Please can someone help me on this. Thank a lot....
I have deployed some reports on the reporting server, i have noticed that every one in the domain in which the reports are published can access the reports, except one user. when he tries to access the report he got the following error message or the blank report.
"An error occured during report processing"
"can no read the next data row for the data set dataset1".
Although this user has all the roles on the reporiting server kike browser,content manager etc.
i tried many things but still problem persists.
Can anyone tell me the exact reason for this ?
I shall be extremely thankfull.
Hi,
I'm trying to set up a transactional replication from SQl Server 2005 to SQl server 2000. The Distributor and the publisher are on our server and the subscription is supposed to be on a SQL 2000 server on a different location. Before upgrading to 2005 I didn't have problems - the replication from 2000 to 2000 was working perfectly.
After I succesfully created the distributor and the publication the first problem that I encountered was that when I tried to create the subscription it was giving me an error that I cannot use an IP to acces the server. I realized to fix that issue by creating an Alias in the SQL Server Configuration Manager for the server where I wanted to create the subscription (a push subscription).
Now when I try to add the subscriber it gives me another message "Execute permission denied on object 'sp_MS_replication_installed', database 'master', owner 'dbo'" - so I cannot create the subscriber.
The user that I use to create the subscriber on the 2000 server is dbo for the subscriber database but it doesn't have rights on the master database. Also I realized that on the 2000 server I still have the old subscription but I cannot delete it - for the same reason - no access on the master database. Before upgrading to 2005 I had the exact same rights on the 2000 server.
Any help would be appreciated.
Thanks.
Hello Experts,
I have been unable to install SQL Express 2005 Server on my Windows 2003 Server (with SP2 installed). I keep getting an error message saying that Microsoft Windows Installer 3.1 is not installed.
Click here for image
So, I downloaded Microsoft Windows Installer 3.1 v2 (WindowsInstaller-KB893803-v2-x86.exe) but whenever I try to install it I get an error message saying that "the Service Pack version of this system is newer than the update you are applying" and that there is no need to install the update and it stops there.
Click here for image
Is there a workaround to this? How can I get Microsoft Windows Installer 3.1 installed? I tried going to the Windows Update site, I already have everything installed and I even started the Windows Installer service manually. Has anyone else experienced this?
How can I get SQL Server 2005 Express installed if not how can I install SQL Server 2000 on tihs machine? The only reason I am trying to install SQL Server 2005 is because wanted to try it so I uninstalled SQL Server 2000 now I can no longer install SQL Server 2000 again because it won't let me because of the SP2 patch.
Help! :(
Hi,
I€™ve developed a BI system using the SQL Server 2005 Developer€™s Edition.
SSAS, SSIS and SSRS have been added to a SQL Server 2005 Standard Edition Server in preparation for delivering the developed database to this live environment.
So I am able to connect directly to the Database Engine, SSAS, SSIS and SSRS successfully from the actual SQL Server 2005 Standard Edition box which is sat on a Windows 2003 Server operating system.
However when I launch SQL Server Management Studio from a desk top PC which is connected to the SQL Server Standard Edition box I can€™t connect to either SSIS or SSRS, however I can connect to the Database Engine and it also seems that I can connect to SSAS OK.
I am using Windows Authentication where the I used a SQL Server account which exists with €śsysadmin€? permissions and this SQL Server account has the same login name as the Windows Server 2003 desktop login.
What do I do next please?
I am developing an app in VB.Net 2005, and I installed SQL Server 2005 locally on my machine. My app access multiple databases on SQL and has worked like a charm in the past. Today, when I go to access my app, I receive an error when trying to connect to the SQL database.
"An error has occured 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 connection"
As I said before, this is a local install and worked fine until today. I checked the services running and Here is what I have:
SQL Server Integration Services - Running
SQL Server FullText Search - Stopped
SQL Server(SQLEXPRESS) - Running
SQL SERVER (MSSQLSERVER) - Stopped <---------- I tried restarting this and it times out
SQL Server Analysis Services (MSSQLSERVER) - Stopped
SQL Server Reporting Services (MSSQLSERVER) - Stopped
SQL Server Browser - Stopped
SQL Server Agent (MSSQLSERVER) - Stopped
I am unable to start any of these services... they all time out. Any help would be greatly appreciated!
When I try to un install SQL Server Express (VS 2005 Beta 2), which is not functional, I get an error message:
View 5 Replies View RelatedNot sure if this is the right forum to post this...
After going through lot of old posts in various forums and changing lot of settings, i'm still not able to access my Server remotely.
This is Windows 2003 Server machine with Sonicwall Firewall, i have allowed Port 1433 in both Firewall and ISA and call is getting through but i'm getting following error msg :-
{"An error has 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"}
This machine is also having Sql Server 2000, and the SQL Server 2005 is installed with named instance.
My connection string is :-
"Data Source=192.168.0.1MYSERVER;Initial Catalog=MyDatabase;Integrated Security=True"
In example above, i'm showing dummy values but actual string is having the actual live IP address and correct named instance and database.
If i use a local address like 192.168.0.1 then i'm able to connect.
My TCP/IP Address in Sql configuration is having my Live IP Address and the port 1433.
Any help will be highly appreciable..
I have completed the uninstallation instructions for my beta versions of SQLExpress (repeatedly). I have used the manual unistall procedures also. I have physically removed the SqlServer directory from the the Program Files directory. The result is the same. This message appears every time I try to to install the MS SQL Advanced package:
"SQL Server 2005 setup has detected incompatible components from beta versions of Visual Studio, Net Framework, or SQL 2005. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme."
The detailed instructions are NOT detailed enough.
I have uninstalled the .NET 2.0 package and re-installed it. The SERVICES window still lists the SQL Server as present even though it is not started.
Any suggestions?
I'm attempting to install SQL Server 2005 Standard, on my personal PC which isn't on a network, there are no user accounts besides myself, I'm signed-on as admin.
The logs from C:Program FilesMicrosoft SQL Server90Setup BootstrapLOG, all appear successful, although there are many more logs.
When I look under Control Panel/Administrative Tools/Services, I see no service at all for SQL Server.
I attempted to use the SQL Server Surface Area Configuration Tool, which told me no instances of the data-base had been loaded.
I must admit, the install went a bit too fast for me to believe it was correct. I was never even asked for the product-key.
This particular copy, was bundled with Visual Studio 2005 Pro, which was given to me by someone who attended a Microsoft seminar/demo of some sort.
I've never used SQL Server before, and know nothing about it, so I hope I'm posting in the right forum.
Any help would be appreciated, and I can provide listings of any log-file if needed.
Thanxxxxxxxxxx in advance for any replies. I'm studying for MCTS, and am trying to work through ADO.Net Step by Step.
Hi,
We recently installed Sql 2005 server and it was working fine. But today one of our user reported that they could not able to connect the sql server 2005 from the application. When I checked the error log, I found the following error for every one minute. We restarted the sql service on this sql 2005 instance but still we are getting the same error.
SSPI handshake failed with error code 0x80090311 while establishing a connection with integrated security; the connection has been closed.
Could any one help us on that?
Regards,
Sankar
This just happened today and I dont know why. I have a database on a SQL server 2005 database, that has a table called photos. It contains image data, but not the column says <Unable to read data>. But before that I get an error when I try to execute the table to retreive the data. The error is below. SQL Execution Error:Executed SQL statement: SELECT ID, AlbumID, Caption, BytesOriginal, BytesFull, BytesThumb FROM PhotosError Source: System.DataError Message: Invalid attempt to Read when reader is closed. This happens with SQL Server Management Studio, and Visual Studio 2005 when I try to access it. I tried two computers so its not that. Any help or insight would be appreciated.
View 2 Replies View RelatedHi, I am using Microsoft Visual Web Developer 2008 Express Edition. I wanted to add a database to the Project. When i add it, it says "An error occured while extablishing an 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: SQL Network Interfaces, error:26- Error locating server / instance specified). Please let me know what is the cause of this error. Initially i downloaded Microsoft Adventure works database and saved the file as .mdf and tried to access it through the data grid. I got the same error message as above. I changed the settings in SQl server to enable remote access and also changed firewall settings to allow SQL server exe files. Then i uninstalled works db and now have disabled remote access and still have the firewall settings to allow SQL server on. Thanks,Vidhya
View 2 Replies View RelatedHi everybody my problemis that i cannot create data base in vwd xpress edition when i right click on data connection the only enabled option it show is .."Add connections"create date base option is disable tell me or advised me what to do now ..???waiting for guru replies.regardsHussain
View 2 Replies View RelatedI am using sql server 2005 and unable to restore backup file(.bak) file when i ry to restore it to other database it shows following error
restore failed for server (microsoft.sqlserver.smo)
additional information:
system.data.sqlclient.sqlerror : the media set has 2 media families but only 1 are provided.All members nust be provided.(microsoft.sqlserver.smo)
Ran the SP2 locally on a Windows Server 2003 SP1 box that had SQL Server 2005 SP1 install on it. Problem was I ran out of C: drive and it failed in the middle of upgrading the server.
I'm unable to start the SQL Server at all now. Is there any way to back this out? Don't think I can reapply any patches since the service is dead.
Eventlog now shows:
One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.
The log shows it's unable to start SQL (blames it on permisions but it's because SQL can no longer start)
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29538
Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmssqlsystemresource1.mdf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
I'm guessing its reinstall time but not sure how the attached databases will like that idea.
Thanks in advance for any ideas.
Now that everyone helped me install SQL Server, it's time to use it... then...
I'm trying to work my through the MS Press book ADO.Net Step by Step. After installing the practice files, there is a step to attach the sample database provided. Within the folder which contains the sample files, I'm told to execute an app which I believe was called "Config.exe". This app brings up a form with 3 text-boxes, to collect the Server Name, Database Name, as well as the Database MDF Filename. There are also 2 buttons, "Attach" and "Detach".
This book assumes, that SQL Server Express is installed. In the book, the author does mention that if this isn't the case, to adjust the Server Name as necessary.
(The following do not include the quotes, but you probably already knew that...)
In the form mentioned above, the default Server Name is "(local)SQLEXPRESS",
I changed this to "(local)MSSQLSERVER".
The next text-box for Database Name contains: "AdoStepbyStep"
The last text-box for Database MDF Filename contains: "c:ADO.NET 2.0 SBSSampleDBsAdoStepbyStep_Data.MDF"
The path/spelling of the text in the above is indeed correct. Clicking the "Attach" button, results in the following:
--- ERROR ---
Function: AttachDB
Description: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]InvalidConnection.
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (ParseConnectParams()).
I've never used SQL Server, so please any advice needs to be at a relatively elementary level. I've primarily been a mainframe programmer, so this is new to me.
Thanxxxxxxxxxxxxx in advance for any replies!!!
I am trying to install SQl Server 2005 SP2 but it was throwing an unexpected error when trying to install "setup support files".
O/s: Windows Server 2003 SP1
Product: SQL Server 2005 Standard Edition
Log file shows:
+++++++++++++++++++
=== Verbose logging started: 2/20/2007 16:05:42 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: F:SQL2005sp2hotfix.exe ===
MSI (c) (74:68) [16:05:42:635]: Resetting cached policy values
MSI (c) (74:68) [16:05:42:635]: Machine policy value 'Debug' is 0
MSI (c) (74:68) [16:05:42:635]: ******* RunEngine:
******* Product: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (c) (74:68) [16:05:42:635]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (74:68) [16:05:42:635]: Grabbed execution mutex.
MSI (c) (74:68) [16:05:42:729]: Cloaking enabled.
MSI (c) (74:68) [16:05:42:729]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (74:68) [16:05:42:745]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (20:70) [16:05:42:792]: Grabbed execution mutex.
MSI (s) (20:68) [16:05:42:792]: Resetting cached policy values
MSI (s) (20:68) [16:05:42:792]: Machine policy value 'Debug' is 0
MSI (s) (20:68) [16:05:42:792]: ******* RunEngine:
******* Product: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (s) (20:68) [16:05:42:792]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (20:68) [16:05:42:823]: File will have security applied from OpCode.
MSI (s) (20:68) [16:05:42:901]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi' against software restriction policy
MSI (s) (20:68) [16:05:42:901]: SOFTWARE RESTRICTION POLICY: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi has a digital signature
MSI (s) (20:68) [16:05:43:151]: SOFTWARE RESTRICTION POLICY: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (20:68) [16:05:43:151]: End dialog not enabled
MSI (s) (20:68) [16:05:43:151]: Original package ==> C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
MSI (s) (20:68) [16:05:43:151]: Package we're running from ==> C:WINDOWSInstaller1348fe1.msi
MSI (s) (20:68) [16:05:43:151]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
MSI (s) (20:68) [16:05:43:151]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (20:68) [16:05:43:167]: MSCOREE not loaded loading copy from system32
MSI (s) (20:68) [16:05:43:182]: Opening existing patch 'C:WINDOWSInstaller1553df86.msp'.
MSI (s) (20:68) [16:05:43:182]: Note: 1: 2203 2: C:WINDOWSInstaller1553df86.msp 3: -2147287038
MSI (s) (20:68) [16:05:43:182]: Couldn't find local patch 'C:WINDOWSInstaller1553df86.msp'. Looking for it at its source.
MSI (s) (20:68) [16:05:43:182]: Resolving Patch source.
MSI (s) (20:68) [16:05:43:182]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (20:68) [16:05:43:182]: User policy value 'DisableMedia' is 0
MSI (s) (20:68) [16:05:43:182]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Looking for sourcelist for product {EE92F683-5F5C-4970-BB0B-9AC591B60268}
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Adding {EE92F683-5F5C-4970-BB0B-9AC591B60268}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Now checking product {EE92F683-5F5C-4970-BB0B-9AC591B60268}
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Media is enabled for product.
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Trying source \TESTf$cff417a74df5a718124f2a95bdecdc32HotFixSqlSupportFiles.
MSI (s) (20:68) [16:05:43:213]: Note: 1: 2203 2: \TESTf$cff417a74df5a718124f2a95bdecdc32HotFixSqlSupportFilesSqlSupport.msp 3: -2147287037
MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (20:68) [16:05:43:213]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msp
MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Processing net source list.
MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Trying source \TESTf$a81c0730a34f964148HotFixSqlSupportFiles.
MSI (s) (20:68) [16:05:43:213]: Note: 1: 2203 2: \TESTf$a81c0730a34f964148HotFixSqlSupportFilesSqlSupport.msp 3: -2147287037
MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (20:68) [16:05:43:213]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msp
MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Processing media source list.
MSI (s) (20:68) [16:05:44:245]: SOURCEMGMT: Resolved source to: 'SqlSupport.msp'
MSI (s) (20:68) [16:06:14:619]: Note: 1: 1314 2: SqlSupport.msp
MSI (s) (20:68) [16:06:14:619]: Unable to create a temp copy of patch 'SqlSupport.msp'.
MSI (s) (20:68) [16:06:14:619]: Note: 1: 1708
MSI (s) (20:68) [16:06:14:619]: Note: 1: 2729
MSI (s) (20:68) [16:06:14:619]: Note: 1: 2729
MSI (s) (20:68) [16:06:14:619]: Product: Microsoft SQL Server Setup Support Files (English) -- Installation failed.
MSI (s) (20:68) [16:06:14:619]: MainEngineThread is returning 1635
This patch package could not be opened. Verify that the patch package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer patch package.
C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
MSI (c) (74:68) [16:06:14:729]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (74:68) [16:06:14:729]: MainEngineThread is returning 1635
=== Verbose logging stopped: 2/20/2007 16:06:14 ===
+++++++++++++++++++++++
I can't install the client tools of SQL Server 2005 SP2. I'm doing it on a fresh re-install of SQL Server 2005 Developer Edition (without SP1). It's been a rollercoaster -- I tried it on SP1 and that didn't work, so I decided to uninstall altogether, then couldn't re-install; I had to install most pieces of SQL Server 2005 individually (executing each msi file separately), then I had to install most pieces of SP2 individually, too.
I could get everything to work except for the SP2 client tools. I get this error in the event log:
Product: Microsoft SQL Server 2005 Tools -- Error 1721. There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup
followed by this one:
Product: Microsoft SQL Server 2005 Tools - Update 'Service Pack 2 for SQL Server Tools and Workstation Components 2005 ENU (KB921896)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log.
Here is my summary.txt file:
Time: 02/04/2008 23:06:40.328
KB Number: KB921896
Machine: KRISTER
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.2.3042 x86
Database Services (MSSQLSERVER) ENU SP2 2005.090.3054.00 x86 DEVELOPER
Analysis Services (MSSQLSERVER) ENU SP2 2005.090.3054.00 x86 DEVELOPER
Reporting Services (MSSQLSERVER) ENU SP2 9.00.3054.00 x86 DEVELOPER
Notification Services ENU SP2 9.00.3054.00 x86 DEVELOPER
Integration Services ENU SP2 9.00.3054.00 x86 DEVELOPER
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU RTM 9.00.1399.06 x86 DEVELOPER
MSXML 6.0 Parser ENU 6.10.1129.0 x86
SQLXML4 ENU 9.00.3042.00 x86
Backward Compatibility ENU 8.05.2004 x86
Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x86
**********************************************************************************
Products Disqualified & Reason
Product Reason
Database Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates.
Analysis Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates.
Reporting Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates.
Notification Services The product instance NS been patched with more recent updates.
Integration Services The product instance Integration Services been patched with more recent updates.
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance MSSQLSERVER been patched with more recent updates.
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance MSSQLSERVER been patched with more recent updates.
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance MSSQLSERVER been patched with more recent updates.
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance NS been patched with more recent updates.
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance Integration Services been patched with more recent updates.
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 1721
Error Description : MSP Error: 1721 There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor.
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 1129
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 2004
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1721
Here is an error message from my hotfix.log file:
02/04/2008 17:37:49.921 MSP Error: 1721 There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor.
02/04/2008 17:40:06.468 MSP returned 1603: A fatal error occurred during installation.
02/04/2008 17:40:06.625 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
02/04/2008 17:40:06.671 Registry: Cannot read registry key value "Debug"
02/04/2008 17:40:07.984 Copy Engine: Error, unable to install MSP file: C: empdownloadsMicrosoftSQLServer2005SP2-KB21896-x86-ENUHotFixToolsFilessqlrun_tools.msp
02/04/2008 17:40:08.031 The following exception occurred: Unable to install Windows Installer MSP file Date: 02/04/2008 17:40:08.031 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 800
02/04/2008 17:40:15.562 Watson: Param1 = Unknown
02/04/2008 17:40:15.625 Watson: Param2 = 0x6b9
02/04/2008 17:40:15.796 Watson: Param3 = Unknown
02/04/2008 17:40:16.000 Watson: Param4 = 0x6b9
02/04/2008 17:40:16.078 Watson: Param5 = copyengine.cpp@800
02/04/2008 17:40:16.140 Watson: Param6 = Unknown
02/04/2008 17:40:16.171 Watson: Param7 = SQLTools9
02/04/2008 17:40:16.250 Watson: Param8 = Hotfix@
02/04/2008 17:40:16.343 Watson: Param9 = x86
02/04/2008 17:40:16.500 Watson: Param10 = 3042
02/04/2008 17:40:16.625 Installed product: SQLTools9
02/04/2008 17:40:16.750 Hotfix package completed
02/04/2008 17:40:16.781 Attempting to continue the 32 bit ngen queue
There is a value 3 in my SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log, but I don't really see anything more descriptive in that file. These are the lines above the value 3 that look interesting:
MSI (s) (1C:30) [17:37:49:000]: Note: 1: 1721 2: CA_HxMerge_SQLCC.3643236F_FC70_11D3_A536_0090278A1BB8 3: C:WINDOWSInstallerMSI1C7B.tmp 4: ms-help://MS.SQLCC.v9
MSI (s) (1C:30) [17:37:49:078]: Transforming table Error.
MSI (s) (1C:30) [17:37:49:078]: Transforming table Error.
MSI (s) (1C:30) [17:37:49:078]: Note: 1: 2262 2: Error 3: -2147287038
Info 1721.There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: CA_HxMerge_SQLCC.3643236F_FC70_11D3_A536_0090278A1BB8, location: C:WINDOWSInstallerMSI1C7B.tmp, command: ms-help://MS.SQLCC.v9
MSI (s) (1C:30) [17:37:49:093]: Note: 1: 1721 2: CA_HxMerge_Hx.3643236F_FC70_11D3_A536_0090278A1BB8 3: C:WINDOWSInstallerMSI1C7C.tmp 4: ms-help://Hx
MSI (s) (1C:30) [17:37:49:171]: Transforming table Error.
MSI (s) (1C:30) [17:37:49:187]: Transforming table Error.
MSI (s) (1C:30) [17:37:49:187]: Note: 1: 2262 2: Error 3: -2147287038
Info 1721.There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: CA_HxMerge_Hx.3643236F_FC70_11D3_A536_0090278A1BB8, location: C:WINDOWSInstallerMSI1C7C.tmp, command: ms-help://Hx
MSI (s) (1C:08) [17:37:49:234]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1C7D.tmp, Entrypoint: Set_CommitFlag
<Func Name='LaunchFunction'>
Function=Set_CommitFlag
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='87'>
Doing Action: Set_CommitFlag
PerfTime Start: Set_CommitFlag : Mon Feb 04 17:37:49 2008
<Func Name='Set_CommitFlag'>
Set_CommitFlag called successfully.Committed
<EndFunc Name='Set_CommitFlag' Return='0' GetLastError='0'>
PerfTime Stop: Set_CommitFlag : Mon Feb 04 17:37:49 2008
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (1C:30) [17:37:49:859]: Note: 1: 1721 2: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A 3: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe 4: /setup
MSI (s) (1C:30) [17:37:49:906]: Transforming table Error.
MSI (s) (1C:30) [17:37:49:906]: Transforming table Error.
MSI (s) (1C:30) [17:37:49:906]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (1C:30) [17:37:50:031]: Transforming table Error.
MSI (s) (1C:30) [17:37:50:046]: Transforming table Error.
MSI (s) (1C:30) [17:37:50:046]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (1C:30) [17:37:50:046]: Product: Microsoft SQL Server 2005 Tools -- Error 1721. There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup
Error 1721. There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup
I see lots of other people with problems posted online, but no answer has helped me. So, any help would be greatly appreciated.
Thanks!
Hi,
I have installed SQL Server 2005 express edition on Windows 2003 Server, but i am unable to make a connection using
sqlcmd -S <servnameinstancename> -U <loginID> -P <pwd> -d <dbname>
but i am able to make the connection using
sqlcmd -S <servnameinstancename>,<portnumber> -U <loginID> -P <pwd> -d <dbname>
What could be the possible reason for this and how can i configure sql
server 2005 express edition to make connections without specifying any
portnumber in the connection string. Both the sqlserver database
service and browser services are running.
Regards
Salil