SQLNCLI Connection On Vista Business 32bit
Nov 16, 2007
I have a client/server app with a connection string:
Provier=SQLNCLI;Server=ServerIP;Database=DBName;UID=Name;PWD=Password
This connection string works for Vista 64bit but not for Vista Business 32bit...
What have I done so far to the Vista Business 32bit...
1. Downloaded/Installed SQLNCLI from Microsoft Site
2. Tested the connection string several ways with no luck...
3. Was able to get Vista Business 32bit to connect via a File DSN with the same credentials... DSN route is not an option for this app...
Any ideas?
View 1 Replies
ADVERTISEMENT
Oct 23, 2007
Does anyone have a successful prescribed sequence for installing VS2005 and Business Intelligence Reports Projects on a Vista Business workstation to be used to create reports for a server?
I've looked through everything I can find here and I don't seem to see a clear solution without a lot of trial and error.
Fact is, I've not been successful getting just the reports to install on a plain XP box. Of course, the report creation looks fine on the server but I don't want to work directly on the server.
Thank you
View 1 Replies
View Related
Jul 22, 2007
Hi,
I have a problem when i want to debug an ssis component under visual studio 2005.
I'm using sql 2005 with service pack 2 and i have already install patch for visual studio under vista.
When i put a breakpoint for exemple in the method "public override void PreExecute()" or in the other method. "public override void ProcessInput(int inputID, PipelineBuffer buffer)" and i execute the pgm.
however when i begin debugging,it's always skip breakpoint
However when i put a break point in the Validate method "public override DTSValidationStatus Validate()" it function.
When execute the the package it works fine.
I use this debug parametres :
Start external program :
C:Program FilesMicrosoft SQL Server90DTSBinnDTExec.exe
Command line arguments
/FILE "D:ProjectsIntegration Services Project1Integration Services Project1TestXmlParserPipe.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI
I execute visual studio 2005 as Administrator
Please, can some one help me!
View 6 Replies
View Related
Jun 13, 2007
We are still using SQL2k. I've installed the clients stuff for SQL. One thing I noted is that it was all but impossible to setup an ODBC connection because the driver does not appear in the list.
Every other driver shows up and works fine but not the SQL Server driver. A week or two ago I somehow found it and was able to create a system DSN. Now, I can't find the driver to save my life. I know it is there because my system DSN still works.
I've looked all over the internet and haven't found a thing except someone else having this same issue (and of course no replies). I've tried to install MDAC 2.8 and reapply SP4 with no results. I know Vista is new and all but SQL 2k still has a huge install base so I can't imagine this should not work much less not be supported. Microsoft's own website is of little use as well.
I have tried to create a DSN as my domain user, local admin and domain admin all with the same issue.
View 6 Replies
View Related
Dec 27, 2007
Dear All,
I am trying to install SQL 2005 Developer edition on my machine - Vista Business edition.
My machine has 2 GB RAM with 160 HDD. IIS is on. Still I am getting the following warring messages.
- Minimum Hardware Requirement
- IIS Feature Requirement
I am not able to proceed with the installation due to this.
Please help.
Regards,
Biju Varughese
View 4 Replies
View Related
Nov 7, 2007
I've just upgraded SQL 2005 Standard to Developer on Vista Business (actually had to uninstall whole SQL 2005 product in order for the upgrade process to work)
But it seems that RS didn't completely uninstall (the new install said it was still there).
I've reapplied SP2 and The DB Engine and SSAS seem to be fine - but unfortunately RS is now crippled.
I've re-attached the two RS databases - ReportServer and ReportServerTempDB
Everything looks OK in the RS Configuration Manager - the DB version is reported as C.0.8.54 in the Database Setup page, and all the options above are Green Ticked.
But when I try to browse to the ReportServer from IE (Started as Administrator) it gives "Server Application Unavailable"
The Application Error log says "A request mapped to aspnet_isapi.dll was made within an application pool running in Integrated .NET mode. Aspnet_isapi.dll can only be used when running in Classic .NET mode. Please either specify preCondition="ISAPImode" on the handler mapping to make it run only in application pools running in Classic .NET mode, or move the application to another application pool running in Classic .NET mode in order to use this handler mapping."
An earlier error from IE suggested running C:Windows>system32inetsrvAPPCMD.EXE migrate config "Default Web Site/ReportServer"
which was successful: "Successfully migrated section "system.web/httpHandlers"
Other than that I have changed nothing in the IIS setup from when RS was working fine.
When I try and connect to RS from SSMS it gives the error "
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
"
I'm sufferring all this nightmare because I need semi-additive measures in SSAS for a customer demo I'm trying to prepare - which wasn't available in the Standard Edition.
I've already had to wipe Vista off my laptop once before - in order to completely uninstall RS - I'd rather not have to do it again if possible. (I've also tried going back to XP, but my nice fast new Dell Inspiron 1721 doesn't have any XP display drivers and Dell say they only support Vista on this machine!)
Any help on getting RS going on Vista - much appreciated!
Clive (London UK)
View 3 Replies
View Related
Feb 24, 2008
Hi,
I'm installing SQL Server 2005 on VISTA business.
While Configuring SQL server database services, following error appears:
Description of error is attached herewith.
Please help..
Thanks in advance
vivpol
View 1 Replies
View Related
Oct 30, 2007
How do you reinstalling ODBC drivers in vista business?
I have installed SQL 2005 Express & SQL Server management Studio Express, with SP2
However, the required driver "SQL Server" is not showing up in the list when trying to add a datasource in System DSN.
Can someone help? please.
Regards
Solway
View 6 Replies
View Related
Jun 25, 2007
I'm trying to install SQL Server 2005 Express on my Vista Business x64 laptop and during install I keep getting the message:
- ASP.Net Version Registration Requirement (Warning)
Messages
ASP.Net Version Registration Requirement
Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS).
View 6 Replies
View Related
Sep 6, 2007
Hi y'all,
I just know that SQL Server Express Edition SP2 is being released by Microsoft recently, and from previous informations I gathered; it seemed that SQL Server 2005 Express Edition is not compatible with Windows Vista (any editions).
With the release of SP2, does this mean SQL Server 2005 Express Edition is now compatible with Windows Vista?
If so, do I have to install .NET Framework v2.0 first in my Windows Vista Business edition? BecauseI know that Vista Business edition already has .NET Framework v3.0 in it.
Thanks for your help! Appreciate it...
View 14 Replies
View Related
Jul 30, 2007
I have been trying to install SQL Server 2005 (Developer Edition) on a computer with Vista Business. I can't seem to be able to install SQL Server 2005 SP2 and when I attempt to login, I get the message.
Cannot connect to Server.
the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attemp failed because the connected party dd not properly respond after a period of time, or established connection failed because connect host has failed to respond) Microsoftw SQL Server Errore 10060
View 6 Replies
View Related
Apr 26, 2007
I've been attempting to install SQL 2005 Standar on my Vista Business laptop. I am able to install all the components except for Reporting Services - the checkbox for it is disabled. I have installed/activated IIS, so I don't know why this option is still unavailable to me. Can anyone assist me?
Thanks in advance!
View 1 Replies
View Related
Dec 1, 2007
Hi All,
I got an error while installing SQL Server 2005 SP2 Express Edition on my Laptop. I don't know how this error coming, I search lot in Web, but I did't get solution.
This is the error: alert box displaying with following error.
"this machine does not have a product that match this installation package"
Can any one help me on this.
Errorn
Thanks
Peter
View 1 Replies
View Related
Oct 1, 2007
I read your blogs regularly on SQL-Server Express 2005 which I have been actively deploying with my software product for about a year now. I have migrated most of my products to SQL-Server from Microsoft Access. I have found SQL-Express very stable and have had no significant problems. My products are mainly accounting based such as payroll systems, hotel management systems, school academic results management systems.
My favourite front ends tools are Visual Basic 6.0, and Microsoft Access. Typically, with MS Access I link to tables via the SQL-Server ODBC driver and all the client front ends share a common security file, an access work group file. I have been using this approach for up to a decade with no problems.
Currently I am deploying a hotel management system and payroll system in a hotel about to be opened. Against our advice, they purchased computer systems running Windows Vista Business instead of XP which we are sure our software suites, the wireless network and other software solutions such as CCTV work perfectly. This has caused a lot of problems.
On my side I had the extra task of dealing with Office 2007.
2 key problems arose.
After setting up a simple Ethernet network connecting the Vista computers I could not connect to SQL-Server Express in Windows Authentication mode via SQL Native Client and SQL Server ODBC drivers from another computer on the network (i could only connect locally); I could only connect to it from another machine using SQL Authentication mode, which is not my preference.
Secondly, I could not share the security file with more than one client of the network. The file seems to be locked exclusively by one client that first grabs the file, hence you cannot log on to software. This defeats clientserver idea. HEEEEELP.
A way round this was to have at least one computer on the network running XP (or any windows not Vista) and share the security file from it. I wish to know the reason for this behaviour on Vista.
As to the first problem of not being able to connect of SQL-Server Express 2005 via Windows Authentication mode from another machine on the network, I found the cause: The PASSWORD PROTECTED SHARING setting on Sharing and Discovery option for networking on Windows Vista.
When this setting is turn ON you cannot connect to the SQL-Server engine. The error Login failed for user ": Not associated with a trusted SQL Server connection is given. When I turn off this setting, I immediately could log on. I have validated this on several setups and this seems to the consistent. PLEASE SHARED THIS With others.
Thanks Dr Folami
View 2 Replies
View Related
Feb 19, 2008
Hi,
I am attempting to install SQL Server 2005 express with SP2 on Vista Business - as a requirement for a new software package. The installation fails at the point of installing performace counters - the errors are below. I have been unable to find any support entry for this error:
The error message:
The setup has encountered an unexpected error while Installing performance counters. The error is: Access is denied.
From the Summary Log:
Last Action : InstallFinalize
Error String : The setup has encountered an unexpected error while Installing performance counters. The error is: Access is denied.
Error Number : 29528
From SQLSetup00001 Log:
MSI (s) (40:E4) [22:03:08:261]: Note: 1: 1708
MSI (s) (40:E4) [22:03:08:261]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.
MSI (s) (40:E4) [22:03:08:262]: Windows Installer installed the product. Product Name: Microsoft SQL Server 2005 Express Edition. Product Version: 9.2.3042.00. Product Language: 1033. Installation success or error status: 1603.
Thanks in advance,
Sue
View 6 Replies
View Related
Jun 6, 2007
I just installed the 64bit Vista and than wanted to install the 64bit SQL 2005 Std. Server on it.
Note: I downloaded my license from https://licensing.microsoft.com/eLicense/L1033/ProductDetail.Asp?SKU=228-05338.
Installing from SQLSTDSEL.ISO file results in the warning that for the REPORT- Server the .NET version has to be 32bit.
Stopping the installation at this point and try to install from SW CD SQL Svr Standard Edtn 2005 64Bit X64 English #1 x64 MLF.x11-57664 + SW CD SQL Svr Standard Edtn 2005 64Bit X64 English #2 x64 MLF.x11-57665 does not give the above error but on the other hand installs no server at all since somehow the installation routine is not working at all.
Installing now - after at least analysis server and reports server are 64bit and installed - from the first mentioned ISO results in the installation of the DB- Server.... but as a 32bit installation.
Now I wonder what did not work out - so maybe someone here has an idea if and how this problem is solveable.
View 1 Replies
View Related
Feb 21, 2008
Hi,
I am attempting to install SQL Server 2005 express with SP2 on Vista Business - as a requirement for a new software package. The installation fails at the point of installing performance counters - the errors are below. I have been unable to find any support entry for this error: I am using the local administrator account - I am a home user and not part of a domain. I have also tried with UAC disabled.
MSI (s) (2C:EC) [23:07:30:153]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000QSRNVIVOMSSQL$QSRNVIVOC:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlctr.ini)
MSI (s) (2C:EC) [23:07:30:157]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (2C:EC) [23:07:30:189]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000QSRNVIVOC:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlctr.iniC:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlctr.hsqlctr90.dllMSSQL$QSRNVIVO1MSSQLServerSQLServerOpenSQLPerformanceData1CollectSQLPerformanceData1CloseSQLPerformanceData1)
MSI (s) (2C:F4) [23:07:30:224]: Invoking remote custom action. DLL: C:WindowsInstallerMSIF6B7.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Feb 19 23:07:30 2008
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='5' GetLastError='5'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Feb 19 23:07:31 2008
Gathering darwin properties for failure handling.
Error Code: 5
MSI (s) (2C!4C) [23:07:56:703]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: Access is denied.
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: Access is denied.
<EndFunc Name='LaunchFunction' Return='5' GetLastError='203'>
Best wishes,
Sue
View 1 Replies
View Related
Nov 27, 2007
I tried to install
SQLServer2005_SSMSEE in my notebook with vista business and nearly the end of installation the process is cancelled by an error.
its necessary install some application before? SQL Server Express is installed by default in the notebook.
thaks a lot and excuse for my bad english (bettr more for me is SPANISH)
View 3 Replies
View Related
Jan 23, 2008
Good day all, I wanted to get some feedback on what I think may be an issue between SQL Server 2005 Express and Vista. Specifically I use Vista Business edition and I was trying to execute the same bit of code on two different machines with the same exact database. The ONLY difference was Vista. See code below...what I doing in XP Professional SP2 was inserting an image into a table. This worked well on XP but the same code failed to actually insert the image. A row was created in 'myTable' but not binary data from the image insert. Can someone please advise or help me - it goes without saying that I an quite frustrated. ;-)
CREATE TABLE myTable(FileName nvarchar(60),
FileType nvarchar(60), Document varbinary(max))
GO
INSERT INTO myTable(FileName, FileType, Document)
SELECT 'titleist-dtsolo.jpg' AS FileName,
'.jpg' AS FileType,
* FROM OPENROWSET(BULK N'C:UsersBrian EvansDesktopgolfPremiumsgolfPremiumsProjectWebImages itleist-dtsolo.jpg', SINGLE_BLOB) AS Document
GO
Selecting from the results yields a row with no image data, and I did verify the path and image before and after running this sample.
View 6 Replies
View Related
Jul 19, 2007
I want to install SQL Server 2005 Developer Edition on a computer with Vista Business. It looks like a lot of issues. (1) Can I do this? (2) Does anyone have any instrucions?
Thanks for your help
View 3 Replies
View Related
Sep 12, 2007
Hello,
Firstly, can someone confirm that this can be done. Because I am starting to wonder.
I have downloaded the SQL Server 2005 Express install, and attempted to install. Everything goes well. Computer scan indicates that everything is in place, but then when it goes to install the components it states that the following components failed:
- SQL Native Client
- SQL Server Database Services
- Reporting Services
- Workstation Components, Books Online
(Successful items were SQL Setup Support Files, SQL VSS Writer, OWC11, SQL Server Backward-Compatibility Files, SQL Server Management Studio Express).
For those Items that failed, I just get a message stating "Setup failed. Refer to Setup Log'. The setup log tells me little to nothing about why these components failed.
I am also getting the following message part way through install "An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.mis'". Does anyone know what this means? I downloaded the install from microsoft.com just a few days ago, so if this isn't "valid", then where do I get a valid one.
I'm totally stuck. Have spent almost a day trawling documentation etc. to find why these have not installed, but cannot find any indication of why they wont install.. everything that needs to be in place is. Hoping someone has had similar issues and can help.
Many Thanks in Advance.
View 1 Replies
View Related
Oct 6, 2013
I have a very basic / stripped connection manager with only one property (SSIS 2012). It works fine in design time (you can open the connection manager editor and change the value), but in runtime it only works in 32bit mode. The runtime-validate-method does work, but if everything validates OK then in 64bit it throws an error when you run the package:
Exception deserializing the package "The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.
The 2 VS projects are .Net 4 class library projects with the Build Platform on "Any CPU"
I only add references to:
Microsoft.SqlServer.ManagedDTS - C:WindowsMicrosoft.NETassemblyGAC_MSILMicrosoft.SqlServer.ManagedDTSv4.0_11.0.0.0__89845dcd8080cc91
Microsoft.SqlServer.ManagedDTS.dll
Microsoft.SqlServer.Dts.Design -
[code]....
View 11 Replies
View Related
Dec 25, 2007
Hello,
I have successfully installed two instances SQL Server 2005 Standard Ed. 64. and integration services (for the MSSQLSERVER instance).
When I try to install SP2 x64 everything exept the Database services of the MSSQLSERVER instance was updated well.
Here is the part of the inst.summary:
Time: 12/25/2007 13:09:26.420
KB Number: KB921896
Machine: xxxxxxx
OS Version: Professional (Build 6000)
Package Language: 1031 (DEU)
Package Platform: x64
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
Unterstützungsdateien für das Setup DEU 9.2.3042 x64
Datenbankdienste (AUTODESKVAULT) DEU SP2 2005.090.3042.00 x64 STANDARD
Datenbankdienste (MSSQLSERVER) DEU SP2 2005.090.3042.00 x64 STANDARD
Integration Services DEU SP2 9.00.3042.00 x64 STANDARD
SQL Server Native Client DEU 9.00.3042.00 x64
Clientkomponenten DEU SP2 9.2.3042 x64 STANDARD
SQLXML4 DEU 9.00.3042.00 x64
Abwärtskompatibilität DEU 8.05.2004 x64
Microsoft SQL Server VSS Writer DEU 9.00.3042.00 x64
----------------------------------------------------------------------------------
Product : Datenbankdienste (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Fehler
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29504
Error Description : MSP Error: 29504 SQL Server-Setupfehler beim Analysieren von SQL-Skript 'c:ProgrammeMicrosoft SQL ServerMSSQL.1MSSQLInstallsysdbupg.sql'. Fehlercode: Zugriff verweigert
. Beheben Sie das Problem, und führen Sie dann das SQL Server-Setup erneut aus, um den Vorgang fortzusetzen.
----------------------------------------------------------------------------------
Any ideas ? Olaf
View 3 Replies
View Related
Oct 27, 2007
Hi,
Is there any one knows how to fix this, please help! This is urgent.
In the configuration checking, there was only one warning message about operation system (this warning should be ignored according to some advice). When coming to the Component checkboxes, there is only one checkboxe checkable at the last item.
Thanks!
View 6 Replies
View Related
Mar 7, 2007
Hi all,
I'm a newbie to Reporting Services so please forgive my ignorance...
I've recently installed SQL Server Express 2005 with Reporting Services on my Vista Business Notebook (with no network connections) and have installed VS C# Express as well as the Business Intelligence Studio to create reports.
My C# application can connect to SQL Server fine, however, the reports I created with Business Studio refuses to deploy to the server due to the following reason:
"The permissions granted to user 'localhostJenny' are insufficient for
performing this operation".
I find this odd as I've been able to deploy reports on my other Windows XP machine (with SQL Server Express) no probs at all. Additionally, I cannot see the 'Site settings' link within Report Manager (Web) that I'd normally get with an admin account (i.e. on my Win. XP machine). Various sources indicate that my account has insufficient access rights to view this.
Having browsed through seemingly endless blogs and forums, I suspect that my local account has not been configured to access the Report Manager web client to publish, manage and administer the site.
I have tried the surface area tool for SQL Server, but I suspect that this is relevant only to SQL Server DB access and management. Adding an administrator here does nothing.
The question is, how can I grant access to myself (local account) to allow me to publish reports via business studio, and at the same time - administer Report Manager Site Settings - on my vista notebook??
I would be extremely grateful for any help on this matter - I've tried ceaseless reinstallations, but to no avail!
Many thanks in advance,
Jenny
View 5 Replies
View Related
Feb 11, 2008
I watched and followed the Intro to VB 2008 Express, but in the final part of the video, when you add a database, i did everything as the video says, still i get:
An error occurred creating the form. See Exception.InnerException for details. The error is: Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Ive tried the fix stated in another forum, the one about changing the "Target CPU" but the option doesn appear, what does appear its the "Platfrom" dropdown list, but its fixed to "Any CPU" and dont have any more options.
Ive also downloaded Microsoft SQL Server Compact 3.5 ENU and "re-installed" and selected repair, followed the steps, rebooted and still nothing.
The problem persists, any ideas, please?
View 6 Replies
View Related
May 15, 2008
Hello, I've a problem with a software developed in C# with the framework 2.0. This is the error I receive : The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "XXX_LINKED_SERVER" was unable to begin a distributed transaction. OLE DB provider "SQLNCLI" for linked server "XXX_LINKED_SERVER" returned message "No transaction is active.". If I try directly to restart the process, it works fine. Is there someone who can help me ? This is the process 1. In C# --> Call of a Query : select from the linked server (db in sql 2005) and insert into a table SQL 2005 2. In the C# --> using (TransactionScope scope = new TransactionScope()) and insert in a table in SQL 2005 which is link server Thank in advance.
View 1 Replies
View Related
Mar 4, 2008
Hi All,
We are using the Windows Task Scheduler as a substitute for the SQL Server Agent, which isn't available in the Express edition. The scheduled task just calls a batch file, which in turn, runs a stored procedure using osql with the -E option for a Trusted Connection.
SQL Server Express has been installed using the defaults, which means the service is running in the "NT AUTHORITYNETWORK SERVICE" account. The scheduled task we create is set to run using the "NT AUTHORITYSYSTEM" account.
Now we find that on Windows Vista (tested using Ultimate Edition) that the scheduled task fails to run the stored procedure until the machine is rebooted the first time after installing SQL Server Express. When I say "fail", I mean that the stored procedure isn't executed. The scheduled task however completes and reports no errors. On Windows XP, we do not run into this problem so I suspect it has something to do with the UAC in Vista?
We further found that after installing SQL Server Express and creating the scheduled task in the "NT AUTHORITYNETWORK SERVICE" account, the scheduled task (and stored procedure) runs fine WITHOUT requiring a reboot.
Can anyone explain why a reboot is needed to get SQL Server Express to run the scheduled task correctly under Windows Vista and the SYSTEM account?
Any help or thoughts greatly appreciated.
View 2 Replies
View Related
Oct 8, 2007
Hi,
Just upgraded some development desktops to Vista Business. However we need
to still connect to some older remote windows 2000/SQL 2000 servers.
Trying to setup an ODBC system DSN on our Vista Business local desktop we get the
following errors -
-START ERROR WINDOW-
Connection Failed:
SQLState: '01000'
SQL Server Error: 772
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(SECDoClientHandshake()0.
Connection failed:
SQLState: '08001'
SQL Server Error: 18
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SSL Security Error
-END ERROR WINDOW-
Any help greatly appreciated as this is stopping us from making
database/table connections etc. We've checked the firewall setup and all is well there.
PS - we can still connect fine using XP or windows 2000 desktops and their
local DSNs.
View 8 Replies
View Related
May 7, 2008
I installed sql server 2005 sp2 including business intelligence development suite , however I got a message
some client components not compablitable .This morning I searched my programs and found that I have new
visual studio 2005 on my computer (before I just had vs 2008) as well as business intelligence
developer (which does not work) It seems I I would like to get rid of vs 2005 also
fix business intelligence studio . Previously I deleted vs 2005 express off my computer........(I have vista
and I would only like to keep tools meant for sql standard 2005 reporting services etc
here is a list of my sql sp2 install package
By the way I doubled clicked sql_tools.msi and did not run as administrator
Does that make a difference? I wonder if this is a problem with vs 2008 and sql 2005......
Time: 05/06/2008 20:49:23.437
KB Number: KB921896
Machine: BILLPREC690
OS Version: Professional (Build 6000)
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.00.1399.06 x86
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD
Analysis Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD
Reporting Services (MSSQLSERVER) ENU RTM 9.00.1399.00 x86 STANDARD
Notification Services ENU RTM 9.00.1399.00 x86 STANDARD
Integration Services ENU RTM 9.00.1399.00 x86 STANDARD
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU RTM 9.00.1399.06 x86 STANDARD
SQLXML4 ENU 9.00.1399.06 x86
Backward Compatibility ENU 8.05.1054 x86
Microsoft SQL Server VSS Writer ENU 9.00.1399.06 x86
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
SQLWriter Microsoft SQL Server VSS Writer Service 2700
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB921896_sqlrun_rs.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1054
Product Version (Final) : 2004
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
Success, Reboot Required
Exit Code Returned: 3010
View 2 Replies
View Related
Feb 20, 2007
Got windows Vista Business edition, installed Visual Web Developer Express, SQL Server 2005 Express SP2, SQL Server Management Studio SP1 in that order. I was developing in VWD express without problems using WinXP but now on Vista Business, the local connection to SQL server appears to be a problem.
I know there's nothing wrong with my web.config or anything like that as it was working perfectly prior to running under Vista. If i specify the database on the live website, it works fine. If I specify the test database in app_data folder, I get the following exception:-
Server Error in '/UKSD' Application.
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException (0x80131904): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +736211
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1959
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +237
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +374
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +192
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlRoleProvider.GetRolesForUser(String username) +771
System.Web.Security.RolePrincipal.IsInRole(String role) +272
System.Web.Configuration.AuthorizationRule.IsTheUserInAnyRole(StringCollection roles, IPrincipal principal) +120
System.Web.Configuration.AuthorizationRule.IsUserAllowed(IPrincipal user, String verb) +300
System.Web.Configuration.AuthorizationRuleCollection.IsUserAllowed(IPrincipal user, String verb) +191
System.Web.Security.UrlAuthorizationModule.OnEnter(Object source, EventArgs eventArgs) +3509206
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Version Information: Microsoft .NET Framework Version:2.0.50727.312; ASP.NET Version:2.0.50727.312
I am taking a guess it's somerthing to do with access issues, but can't find anything out on searching the forums etc..
I am setup as an administrator, running VWD as an administrator and for the record, SQL Server Management Studio express works fine.
Another small issue, when I run the application from VWD, I always have to minimise the application and restore it as the graphics get corrupt.
Please help!! I cannot debug when running of the live website.
View 9 Replies
View Related
Aug 13, 2007
I can't connect from a Vista Client to a SQL 2005 Server.
I have been stuck on this problem over a week so any help would be greatly appreciated.
Overview:
I cannot connect from my client (vista business) except with SQL Server Management Studio.
I have tried Red Gate SQL Compare connection from a machine running XP and it connects ok.
I have tried connecting using ODBC from another machine running Vista Home and it connects ok.
I have no problem connecting to my local SQL Server (on my client).
I have tried using Windows Auth and a SQL login.
Environment:
Both the client and server are on the same domain and the user is a domain user.
Client:
Vista Business, SQL Server 2005 SP1 Client tools and Server, RedGate tools, Visual Studio 2005 SP1
Windows Firewall ON (but have tried it off with no difference)
Norton virus protection ON ((but have tried it off with no difference)
UAC is turned off.
Server:
SQL Server 2005 SP1, Remote connections allowed over TCP/IP Port 1433 (IPAll TCP Port 1433, not dynamic)
No windows firewall, Mcaffee virus running.
I get the errors below (or similar) connecting from:
SQL Profiler
Database engine tuning advisor,
Redgate SQL Compare (or any redgate software)
Setting up an ODBC connection
Visual Studio 2005 SP1
The only application that current connects is SQL Server Management Studio!??
If I apply SQL Server 2005 SP2 to the client it stops even SQL Server Management Studio from working.
I either get the following error:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake.
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:0 - No process is on the other end of the pipe.)
or (if I force the port and/or method e.g. TCP:192.168.130.3,1433)
A connection was successfully established with the server, but then an error occurred during the pre-login handshake.
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: TCP Provider, error:0 - No connection could be made because the target machine actively refused it.)
Again any help would be much appreciated as I just can not seem to solve this.
Thanks
View 1 Replies
View Related
Aug 13, 2007
I can't connect from a Vista Client to a SQL 2005 Server.
I have been stuck on this problem over a week so any help would be greatly appreciated.
Overview:
I cannot connect from my client (vista business) except with SQL Server Management Studio.
I have tried Red Gate SQL Compare connection from a machine running XP and it connects ok.
I have tried connecting using ODBC from another machine running Vista Home and it connects ok.
I have no problem connecting to my local SQL Server (on my client).
I have tried using Windows Auth and a SQL login.
Environment:
Both the client and server are on the same domain and the user is a domain user.
Client:
Vista Business, SQL Server 2005 SP1 Client tools and Server, RedGate tools, Visual Studio 2005 SP1
Windows Firewall OFF
Norton virus protection OFF
UAC is turned OFF
Server:
SQL Server 2005 SP1, Remote connections allowed over TCP/IP Port 1433 (IPAll TCP Port 1433, not dynamic)
No windows firewall, Mcaffee virus running.
I get the errors below (or similar) connecting from:
SQL Profiler
Database engine tuning advisor,
Redgate SQL Compare (or any redgate software)
Setting up an ODBC connection
Visual Studio 2005 SP1
The only application that current connects is SQL Server Management Studio!??
If I apply SQL Server 2005 SP2 to the client it stops even SQL Server Management Studio from working.
I either get the following error:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake.
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:0 - No process is on the other end of the pipe.)
or (if I force the port and/or method e.g. TCP:192.168.130.3,1433)
A connection was successfully established with the server, but then an error occurred during the pre-login handshake.
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: TCP Provider, error:0 - No connection could be made because the target machine actively refused it.)
Again any help would be much appreciated as I just can not seem to solve this.
Thanks
View 1 Replies
View Related
