Windows Vista And Setup Question
Feb 21, 2007
Hi,
I was finally able to get my hands of Vista so I excitely upgraded my PC to it yesterday.
After the installation goes smoothly and I ran the setup files from my SQL Server 2005 Developer Edition and I found that the setup script cannot detect IIS (perhaps it is due to the fact that Front Page extension is no longer part of IIS 7.0?) - So I faced with the problem of not able to setup Reporting Service on my PC....
Does anybody faced the same problem and how to fix this issue?
Thanks for the information in advance!
Mark
View 6 Replies
ADVERTISEMENT
Feb 13, 2007
Hello,
I cannot install SQL Server 2005 Express Edition on Windows Vista (Build 6000). I am logged on as the administrator. I tried to setup SP1 version, but it didn't work. Neither did after applying SP2 version.
What can be the reason? On the Problem Reports and Solutions panel it tells me to update to SP2. But it doesnt work.
View 5 Replies
View Related
Jul 19, 2007
Hi,
I just installed SQL Server 2005 on Windows Vista Basic platform with just windows authentication, installation went pretty well, but when I tried to logon to the server, it gave me error "Logon failed with error code 18456".
I logged on as administrator, service for SQL server is started, but I can't logon. Can you please help.
regards
Rajat Aneja
View 2 Replies
View Related
Jun 12, 2006
Miscrosoft SQL Server Management Studio Express (SQLServer2005_SSMEE.msi) don't complete setup on Windows Vista Beta 2 with Sql Server 2005 Express installed.
Error Code 29506.
C:Program FilesMicrosoft SQL server\90Tools,
Alberto
What mean (Alberto is my Windows account)?
View 21 Replies
View Related
Mar 26, 2008
Hallo there,
I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.
My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.
I enabled all the protocols and all the ports
I disabled windows firewall and antivirus (eset nod32)
I installed all service packs available
I have also installed Visual Studio 2005 without installing sqlexpress
But nothing happens!
Please i am very desperate, any information will be gratefully accepted.
This is my installation Information
Code Snippet
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.1434
Operating System 6.0.6001
Thank you in advance,
Patonios
View 3 Replies
View Related
Sep 14, 2007
Hello,
Unit tests in our project make use of cp utility to import data into database. But the performance of running unit tests under XP and Vista differs much. The difference that I was able to notice is in CPU percentage usage: approximately 5% (XP) against 10% (Vista).
What can be the reason for bcp run slower under Vista?
View 1 Replies
View Related
Jul 18, 2007
There is no ASPNET account on Windows Vista. Wich account do I need to use on ASPState database ?
Thanks
View 1 Replies
View Related
Sep 4, 2007
I would like to know if this is possible?
First, I am a consultant and have several clients. Before upgrading to Vista, I used Windows XP and was able to use SQL Server Management Studio to connect to SQL Servers (2000 and 2005) using my saved network passwords. I would establish a connection to the remote SQL Server by doing a Start - Run "\sqlservernamec$" and when prompted for credentials, I would give the domain account that the client has provided me and password and select the "Save password" checkbox. This would put these credentials in my saved credentials list for my user account. After doing this, I would be able to connect to the SQL Server via Windows Authentication in SSMS and Integrated Security (SSPI in connection strings) from applications (ASP and .Net). Everything worked happily with locked down SQL Servers and Windows Authentication.
Then comes Vista...
None of this works. It seems the stored credentials in Vista do not get honored when connecting to a SQL Server, other than the instance installed on my local machine. I have been able to connect to a remote instance via Named Pipes, but most of my clients have that disabled because of incompatibility with Distributed Transactions. So, I ask, is there any way to connect to a remote SQL Server instance (2000 or 2005) from Vista via TCP and Windows Authentication when the client Vista workstation is not in the same domain as the server?
I have tried so many things, I am not sure where to continue from. I have looked into setting SPNs for domain accounts, upgraded servers to latest service packs, etc.
Bottom line, this is the only thing i have found with SQL Server that ALWAYS worked in Windows XP does not work in Vista and, at this point, is getting close to being a killer causing me to go back to XP.
View 22 Replies
View Related
Aug 8, 2007
I HAVE A PROBLEM
MY PC IS WINDOWS VISTA HOMBRE PREMIUM
2GB RAM
2.7 GHZ
250 HD
I HAVE INTALEDD VB6 AND SQL2005 AND AND HAVE DEVELOMENT ONE APLICATION IN VB6 BUT NO CONCET CONECT VERY LOW, PRESENT ERROR I DONT STAN
AND XP NO PROBLEM PRESENT FUNCIONALIRY IS NORMAL,
View 3 Replies
View Related
Apr 13, 2007
Hi,
my VB6 programs that use ADO to access SQL or Access databases do not work in Windows Vista. While they run smoothly in all older Windows versions, they fail in Windows Vista environments. Especially, the ADO connection does not work anymore. The same connection strings that work perfectly in all older Windows versions, do not work in Windows Vista. The error message sent by ADO is this: Runtime error -2147217887 - "Multiple-step OLE DB operation generated errors". And, not only I get this error message on my development systems, but all other users of my programs on all Windows Vista systems.
I have been playing around with alternative connections strings, but no alternative works.
Can anybody explain this? And is there a remedy?
Any help is highly appreciated.
Hermann
View 8 Replies
View Related
Feb 7, 2008
I'll install SQL Server Express SP2 on Vista during my Setup.
But the setup beaks with error 110.
In other articles it sounds like an folder access problem.
On a Custom Action Type 210 i start a application which execute the sqlexpress.exe.
I tried some other codes to impersonate or noImersonate but without success.
But i can not use the unpacked files because size is to large(170MB)
An good Idea would be unpack the setup files during setup to an custom folder with right permissions.
But I dont know how unpack files without GUI (SQLEXPRESS x always show the GUI).
Any Idea???????????
Here are the corresponding logfiles:
------------------------------------------------------------------------------------------------
Core.log
...
Unattended=true
WorkDir=e:a3d45fa9ced92ee76a8e8275
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:384}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=e:a3d45fa9ced92ee76a8e8275
QuietMode=true
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=e:a3d45fa9ced92ee76a8e8275
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:384}
<Func Name='SnacComp::InstallImp'>
Failed to install SNAC
Failed to install SNAC : (110) {e:sql9_sp2_tsqlsetupsqlcudllsnaccomp.cpp:251}
SCU_SetupMgr:vc() caught exception: Failed to install SNAC : (110) {e:sql9_sp2_tsqlsetupsqlcudllsnaccomp.cpp:251}. SetupMgr: state=ERROR, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=e:a3d45fa9ced92ee76a8e8275
QuietMode=true
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=e:a3d45fa9ced92ee76a8e8275
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:520}
<EndFunc Name='UpdateComponents' Return='1603' GetLastError='0'>
Component update returned a fatal error : 110
Error Code: 0x8007006e (110)
Windows Error Text: Das System kann das angegebene Gerät oder die angegebene Datei nicht öffnen.
Source File Name: sqlncli.msi
Compiler Timestamp: Thu Oct 5 12:22:33 2006
Function Name: Unknown
Source Line Number: 1583
Error: Failed to add file :"E:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DEVELOPMENT-PC_.NET Framework 2.0.log" to cab file : "E:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2008/1/7 8:3:25
Failed to launch Watson with error code : 123
Message pump returning: 110
-----------------------------------------------------------------------------------------------------------------------------------------------
SNAC.log
=== Verbose logging started: 07.02.2008 08:03:24 Build type: SHIP UNICODE 4.00.6000.00 Calling process: E:Windowssystem32msiexec.exe ===
MSI (c) (ACC) [08:03:24:840]: Resetting cached policy values
MSI (c) (ACC) [08:03:24:840]: Machine policy value 'Debug' is 0
MSI (c) (ACC) [08:03:24:840]: ******* RunEngine:
******* Product: e:a3d45fa9ced92ee76a8e8275setupsqlncli.msi
******* Action:
******* CommandLine: **********
MSI (c) (ACC) [08:03:24:840]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (ACC) [08:03:24:840]: Grabbed execution mutex.
MSI (c) (ACC) [08:03:24:871]: Cloaking enabled.
MSI (c) (ACC) [08:03:24:871]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (ACC) [08:03:24:903]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (E4:98) [08:03:24:918]: Grabbed execution mutex.
MSI (s) (E4:5C) [08:03:24:918]: Resetting cached policy values
MSI (s) (E4:5C) [08:03:24:918]: Machine policy value 'Debug' is 0
MSI (s) (E4:5C) [08:03:24:918]: ******* RunEngine:
******* Product: e:a3d45fa9ced92ee76a8e8275setupsqlncli.msi
******* Action:
******* CommandLine: **********
MSI (s) (E4:5C) [08:03:24:918]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (E4:5C) [08:03:24:934]: SRSetRestorePoint skipped for this transaction.
MSI (s) (E4:5C) [08:03:24:934]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionPoliciesExplorer 3: 2
MSI (s) (E4:5C) [08:03:24:934]: Note: 1: 1309 2: 5 3: e:a3d45fa9ced92ee76a8e8275setupsqlncli.msi
MSI (s) (E4:5C) [08:03:24:949]: MainEngineThread is returning 110
MSI (s) (E4:98) [08:03:24:949]: No System Restore sequence number for this installation.
Das System kann das angegebene Gerät oder die angegebene Datei nicht öffnen.
MSI (c) (ACC) [08:03:24:949]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (ACC) [08:03:24:949]: MainEngineThread is returning 110
=== Verbose logging stopped: 07.02.2008 08:03:24 ===
Regards Sven
View 1 Replies
View Related
Mar 13, 2007
Hi
We have a problem installing SQL Express Edition SP1 on Vista. The installation stops during installation of setup support files with the following message:
Errors occurred during the installation:Error 2 installing Microsoft SQL Server 2005 Setup Support Files. See log file for more detailed information.Det går inte att hitta filen. (translated: File not found)
The log file points to the support.log file with the following content:
=== Verbose logging started: 2007-03-13 17:34:23 Build type: SHIP UNICODE 4.00.6000.00 Calling process: C:cd nät40..SQLEXPRSetup.exe ===MSI (c) (C4:F4) [17:34:23:450]: Resetting cached policy valuesMSI (c) (C4:F4) [17:34:23:450]: Machine policy value 'Debug' is 0MSI (c) (C4:F4) [17:34:23:450]: ******* RunEngine: ******* Product: C:cd nät40..SQLEXPRSetupSqlSupport.msi ******* Action: ******* CommandLine: **********MSI (c) (C4:F4) [17:34:23:450]: Client-side and UI is none or basic: Running entire install on the server.MSI (c) (C4:F4) [17:34:23:450]: Grabbed execution mutex.MSI (c) (C4:F4) [17:34:23:591]: Cloaking enabled.MSI (c) (C4:F4) [17:34:23:591]: Attempting to enable all disabled privileges before calling Install on ServerMSI (c) (C4:F4) [17:34:23:607]: Incrementing counter to disable shutdown. Counter after increment: 0MSI (s) (00:10) [17:34:23:622]: Grabbed execution mutex.MSI (s) (00:1C) [17:34:23:622]: Resetting cached policy valuesMSI (s) (00:1C) [17:34:23:622]: Machine policy value 'Debug' is 0MSI (s) (00:1C) [17:34:23:622]: ******* RunEngine: ******* Product: C:cd nät40..SQLEXPRSetupSqlSupport.msi ******* Action: ******* CommandLine: **********MSI (s) (00:1C) [17:34:23:622]: Machine policy value 'DisableUserInstalls' is 0MSI (s) (00:1C) [17:34:23:669]: SRSetRestorePoint skipped for this transaction.MSI (s) (00:1C) [17:34:23:669]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionPoliciesExplorer 3: 2 MSI (s) (00:1C) [17:34:23:669]: Note: 1: 1324 2: .. 3: 1 MSI (s) (00:1C) [17:34:23:669]: MainEngineThread is returning 2MSI (s) (00:10) [17:34:23:669]: No System Restore sequence number for this installation.MSI (c) (C4:F4) [17:34:23:669]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1MSI (c) (C4:F4) [17:34:23:669]: MainEngineThread is returning 2=== Verbose logging stopped: 2007-03-13 17:34:23 ===
The funny thing here is that it works fine when the installer is run from a network share, ie \testserversetupsetup.exe but when the same folder is burned to a CD or copied to a local folder it fails. I have verified that the folders are identical.
I'm not sure what info is required to pinpoint the problem but here are some log files and a screen shot of the message.
Any help or pointers would be greatly appreciated.
Regards,
Martin
View 5 Replies
View Related
Oct 6, 2007
i've a new laptop with windows vista and i've installed vwd express edition, framwork, asp.net and sql expresse edition, but once i try to use the sql connection from the vwd, i receive an error msg "Échec de la création d'une instance d'utilisateur SQL Server en raison d'une défaillance du démarrage de processus pour l'instance d'utilisateur. Fermeture de la connexion." it's in french sorry
sql can't creat a user instance because of a process startup....
is that any update i have to download for windows vista?
thanks
mehdi
View 3 Replies
View Related
Apr 30, 2008
Hi,
Unfortunately I'm still running windows 2000 as my development box here, since I'm unable to install so many things now, I am forced to upgrade.
I'm wondering if I can run sql2005 on my new windows vista box if I get it ? I won't go ahead if I can't so its a pretty big deal :)
I'm reading mixed answers so far from googling. Thought it would be best to ask here!
thanks very much!
mike123
View 3 Replies
View Related
Nov 6, 2007
Hi,I've just purchased a new machine with Windows Vista, and the cd Ihave for SQL Enterprise Manager (that works perfectly on Windows XP)no longer works.Is there a version for Windows Vista? Could someone provide me with alink to download?Many thanksSam
View 1 Replies
View Related
Nov 19, 2007
Hello, I am deploying SSRS 2005 on Windows Vista and was wondering if there was a way to automate the following three tasks so that my end-users would not have to do them?
Add a URL to the Trusted Sites for the current computer name?
Change the Security Level setting for User Authentication for the Trusted Site added in step #1 to be automatic logon with current username and password?
Change the properties on IE7 to run with Administrative privileges?
I think, but am not sure that some of these can be done with VBScript? If these can't be automated, then end-users of my application will have to go through these 3 steps manually in order to view the SSRS reports that I have written without being prompted to log in, or encountering error messaged due to insufficient privileges.
Thanks in advance!
Tim
View 5 Replies
View Related
May 28, 2007
On windows XP there is a Synchronize program in Accessories. When I run our replication scripts on a SQL Server Express on the XP machine and start the Synchronize program there are items there that allow me to replicate as well as set a schedule, etc.
On Windows Vista there is a Sync Center, but replication doesn't show up here.
I've searched high and low on Google and am not coming up with anything useful, which leads me to believe this is something very simple that I'm overlooking...
Does anyone know how to make your replication show up on the Sync Center in vista, or is there another application that I should download?
Thanks,
Brian
View 4 Replies
View Related
Sep 18, 2007
I am having trouble with 3 delete queries in my c# application, two other Delete queries run fine. All the Delete queries run fine on Win XP, just not in Vista(Vista's User Account Control off). Here is the simple query
DELETE FROM [tableName] I get error SQL Execution error 3640. I get this error whether I am debugging in msvs2005, or running in the Query Designer or if I just run the application outside of msvs2005.
I can get a Delete Query to work if i use the key columns like
DELETE FROM Horse
WHERE (CODE = @p1) AND (Stable = @p2) AND (HorseName = @p3)
Hope some has an idea
If not is there any other way I can delete all rows from a data table?
View 4 Replies
View Related
Jun 7, 2007
On windows XP there is a Synchronize program in Accessories. When I run our replication scripts on a SQL Server Express on the XP machine and start the Synchronize program there are items there that allow me to replicate as well as set a schedule, etc.
On Windows Vista there is a Sync Center, but replication doesn't show up here.
I've searched high and low on Google and am not coming up with anything useful, which leads me to believe this is something very simple that I'm overlooking...
Does anyone know how to make your replication show up on the Sync Center in vista, or is there another application that I should download?
View 1 Replies
View Related
Sep 5, 2007
Dear All,
Hope everyone is doing well.
I want to ask a question, I am using Windows Vista Home Premium Edition in my notebook, I installed Visual Studio 2005 in it, it is working properly. Now I want to install SQL Server 2005 Enterprise Edition in it, in the begining it was giving me errors while installing Sql Server 2005 Enterprise Edition, but then it installed properly, but the problem is I cant see the "SQL Server Management Studio" in installed SQL Server, I think it is not installed properly.
Can anyone help me regarding this?
Thanks & Regards
Rafiq
View 3 Replies
View Related
May 15, 2008
Hi Guys,
I was struggling with installing reporting services from Sql 2005 dev edition on windows vista. I somehow managed to install the SQLExpress edition for Reporting Services, but now i want to unistall it and install Sql Reporting Services from Sql 2005 Dev edition CD.
When I try to unistall the SQlExpress Reporting Servie instance, the screen which says unistalling components disappears in a couple of secs and when i refresh the list of programs installed under Programs and features, i can still see SQLExpress Reporting Servies, i do not understand why this is happening and probably this is the reason behind not able to see the Reproting Services check box ungreyed when installing SQL 2005 dev edition.
CAN SOMEONE HELP ME ON THIS PLEASE?
View 1 Replies
View Related
Aug 1, 2007
Hi!
My C++ programm that use ADO to access SQL Server 2005 Express do not work in Windows Vista. Programm code works in Windows XP, but fails in Vista.
_bstr_t strCnn = L"Provider = 'SQLNCLI'; Data Source='SERVERSQL';Uid=sa;Pwd=devel; ";
ADODB::_CommandPtr _command;
TESTHR(_command.CreateInstance(__uuidof(ADODB::Command)));
_command->PutActiveConnection(strCnn);
Error:
Unhandled exception in test.exe (secur32.dll) 0xC0000005. Access Violation.
Help Me please.
cmd-connection
C:>OSQL.exe /S USER123-VISTA\SERVERSQL /U sa /P devel /i c:\test1.sql
error
[SQL Native Client]Client unable to establish connection due to prelogin
failure
View 4 Replies
View Related
Apr 10, 2008
Hi much appreciate any advise given on this query I have. I am using a user instance to manage my DB which is management studio express, when I right click and select attach DB the attach window open I go and select my DB from the default location and then it gives me the details of what I'm about to attach and when I click OK to complete it throws an exception and says cannot attach DB as the you cannot attach a DB with the same name which is already in the DB. only problem is is that there is no other DB in there with a dupe name and I just installed this DB and I was just following the Tutorials, any info would be great Thanks
Séan
View 1 Replies
View Related
Mar 10, 2008
Hi to All,
I want to choose between Windows Vista editions. Please help me I should go for Windows Vista Business or Windows Vista Home Premium as I intend to install SQL Server 2005.
Thanks to All
View 3 Replies
View Related
Apr 16, 2008
Hi All,
I have installed SQL Server 2005 Express in windows vista. I am trying to create database it is giving me error
"CREATE DATABASE Permission denied in database 'master'".
I read some article and they told, have to add an administrator account from SQL Server 2005 Surface Area Configration.
But, I cannot find any option in SQL Server 2005 Surface Area Configuration called "Add New Administrator".
What could be reason for this?
Any Idea....??
Thanks,
Narayana Ayyagari
View 6 Replies
View Related
Nov 14, 2007
Hi,
I am getting an compatibility error when I am installing SQL: Server 2005 on my machine which has WIndos Vista OS.
Regards,
Vicky
View 1 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
Mar 3, 2007
I am trying to install RS on Vista. I notice that the list of IIS features to turn on, listed in the KB article and blog entries, mentions a "Windows Authentication" IIS feature to check under Security. I don't have that (although I have one labeled "Basic Authentication") -- I'm on a "workgroup" computer at home.
Does this mean that you simply can't install RS on Vista unless you're joined to a domain? Thanks,
-Doug
View 18 Replies
View Related
May 1, 2007
Sorry.. but.. sql server express has compatibility with windows vista????
View 1 Replies
View Related
Dec 26, 2007
hi,
Can we install SQL Server 2005 on MS Windows Vista Home Edition???
Please guide..
Thanks
View 4 Replies
View Related
May 19, 2008
Hi,
I am using Windows vista ultimate 32 bit. I installed SQL Server 2005 developer edition on my machine it installed ok but i cant open sql management studio. I have just installed SQL Server 2005 and SP2. but didnt get it working. I dont have any SQL Server Express or visual studio installed on the machine. I can see an icon of sql management studio in the programms menu When i try to open sql management studio it gives me an error saying "Progarm is closing" and it closes the whole SQL Server. Can any one help me please what is going wrong and where thanks in advance.
View 1 Replies
View Related
Jan 17, 2008
Hey
Ive read on some pages that it is in fact possible to install and run SQL Server 2000 on Vista. In my university, SQL Server 2000 is still used to teach us about databases and how to administrate them. The computers run Windows 2000 Professional. I need to be able to use 2000 so I can not only have compatibility but also know the steps and all possible conditions and solutions to problems.
Would installing and running SQL Server 2000 on Vista be possible or am I better off using 2005? Is there much difference between these 2 versions?
View 11 Replies
View Related
Mar 31, 2007
I'm currently running Windows Vista x64 and SQL server 2005 on an HP laptop with a AMD Turion 64 processor. I've install all of the Windows Vista x64 update so far with no issues. However, I'm unable to install SQL server 2005 SP2 via Windows updates.
I was able to successfully download the service pack with no issues and it is currenly on my machine ready to install. The system does take a check prior to the install process beginning to perform the install.
I continuely get and "Error Code A91" when the install process is running. As a result the install does not complete successfully. When I used the "Get Help" option I get a list of possible error conditions but none of them seem be useful. I checked each one and none of them provide any help with a solution.
I've successful installed SP2 on Vista x32 system with no problem. Is this a "Windows Update" issue?
Thanks
View 11 Replies
View Related
