When I install SQL Express on my XP Machine, the registry keys under local machine (ie, MSSQL.1, etc) show up, but on my Vista 64bit machine, the MSSQL.1 etc keys are not there. SQL Server still works, but the reg keys are missing.
View 1 RepliesI've been trying to re-install VS2005 & MS SQL Server express, and I've hit a snag trying to install SQL Server express.
I started by trying to use the automatic uninstaller for VS and had problems so I tried manually uninstalling it (bad idea), which didn't work either, so I re-installed VS completely, then uninstalled it using the automatic uninstaller. I then tried installing, which worked for VS2005, but it didn't work for SQL Server. I've tried 3 times now, and each time it says SQL Server 2005 failed to install.
I checked the summary.txt log found in C:Program FilesMicrosoft SQL Server90Setup BootstrapLOG and from what I understand, it seems that I don't have priveledges to change some registry keys. This has me really lost because I'm installing as Administrator, as you can see from the log below, so I should have access to the registry. Administrator is the only account on the computer so I know I haven't messed up priveledges from another account.
I've included the contents of the summary log below if anyone can make any sense of it and has any ideas I can try.
Code Block
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Sun Oct 07 10:12:41 2007
MRAWESOME : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.
Machine : MRAWESOME
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : MRAWESOME
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : MRAWESOME
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : MRAWESOME
Product : MSXML 6.0 Parser (KB933579)
Product Version : 6.10.1200.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : MRAWESOME
Product : SQL Server Database Services
Error : SQL Server Setup failed to modify security permissions on registry key SOFTWAREMicrosoftMicrosoft SQL Server90Replication for user Administrator. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that the registry key exists on the destination drive.
--------------------------------------------------------------------------------
Machine : MRAWESOME
Product : SQL Server Database Services
Error : SQL Server Setup failed to modify security permissions on registry key SOFTWAREMicrosoftMicrosoft SQL Server90Replication for user Administrator. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that the registry key exists on the destination drive.
--------------------------------------------------------------------------------
Machine : MRAWESOME
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup failed to modify security permissions on registry key SOFTWAREMicrosoftMicrosoft SQL Server90Replication for user Administrator. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that the registry key exists on the destination drive.
Error Number : 29508
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Sun Oct 07 10:18:00 2007
List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_Core(Patched).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_SQL.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_MRAWESOME_SCC.log
Hi,
I develop a software that stores few application settings in HKEY_LOCAL_MACHINESOFTWAREMy Companyetc... registry key. I only store things like Database server name etc in there, that are common to all users of the software. In XP I require an administrator to complete the installation so that he is able to store correct settings in the registry. Normal users do not store anything in HKLM, some settings are however stored in HKCU hive.
Now the problem is Vista and it's new registry virtaulization feature. For example my installation program (InstallShield) stores a "InstallSQL=1" value in registry if SQL Server 2005 needs to be installed at first lauch of the program. THen when the software starts for the very first time it installs SQL server and updates registry accordingly. The problem is that at that point the virtualization kicks in, meaning that only the Guy who runs the installation gets an updated registry settings, any other user would still have the InstallSQL=1 settings when they actually should have a InstallSQL=0 settings as the server has already been installed.
So the first question really is, what is the correct procedure for storing global settings like these in Windows Vista ? An INI file would have the same problem as the Program Files folder is also virtualized. Is there a way to set the registry key not to virtaulize itself ? I do not want to manifest the program to run under Admin rights as they are not needed for anything else that storing the few values necessary to access the server and track install state. Any other settings are stored on the database, so this is not the problem.
Any input is greatly apprecieted.
Kind Regards,
Petri
Hi im trying to install Sql Server 2005 but it says i need to Increment the Counter Registry Key for Setup in SQL Server 2005 before doing so. Im following the guide at http://msdn2.microsoft.com/en-us/library/ms143215.aspx but in my registry the folder HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflibdoesnt contain any keys"Last Counter"=dword:00000ed4 (5276)"LastHelp"=dword:00000ed5 (5277) or any key for that matter.How can i fix this?
View 1 Replies View RelatedIn the registry in Windows 10, I looked inside HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server. Is LoginMode still in some subfolder of that, or has it been moved to another place? Perhaps a differently named key is now used. Or perhaps it's configured in a config file for SQL Sever 2012 express.
View 3 Replies View RelatedThe last few lines of the log show:
View 4 Replies View RelatedI am having issues with adding a new database in vwd 2008 as i keep getting the error
“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.�
I have tried most of the tips on the net already including changing SQLEXPRESS Built-in account to Local System instead of Network Service, running as a administrator and going into surface area to add new admin and adding priveledges to my account. None of these have helped.
I can create a database in the management studio but can't create it in vwd and also the asp.net applications doesn't run either. can anyone help as i have no idea what to do.
Greetings!
I tried installing SQL Server 2005 Express on my VISTA Beta 2 Box but before doing so, I checked if IIS is already installed and running. During the assesment of my current configuration, SQL Server 2005 Express is still looking for IIS. Are the conflicts regarding IIS 7.0 to SQL Server Express or the feature is not yet available. I will be continuing to do experiments with this one and hope there will be people who can share their experiences too.
Thanks!
i can't install sql server express in vista, i 've downloaded sp2, and it's still not working... HELP!!!!
View 1 Replies View RelatedI have been trying to get Visual Basic 2005 Express and Visual Web Developer Express to work with SQL Server 2005 Express. I am using Windows Vista.
I am running VB as an administrator. SQL Server SP2 is installed and working, and I can use SSMSEE to connect to it, create databases etc.
But VB and Web Developer cannot connect to it. Can anyone tell me how to get these products working on Vista (or do they in fact simply not work on Vista)?
Hi there,
Can someone tell me what I need to get Express on Vista, I see a lot of contradictory information. Michael Otey notes in his column SP1, but then I here SP2.... Do I have something I can run today ...if not when..
Thanks.
ok, today i upgraded to Vista, but i can't create database.
create database permission denied in database master. ("Microsoft sql server Error 262")
it must be the Vista thing because i don't have any problem with xp. yes, i the patch installed. I use SQl server management studio with Windows Authentication
Code Snippet[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/04/07,21:30:34] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,03:21:33] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/04/07,21:30:34] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,03:21:33] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/05/07,03:21:39] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,11:30:05] Microsoft SQL Server 2005 Express Edition x86: [2] Error code 258 for this component means "The wait operation timed out.
"
[06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Return from system messaging: The wait operation timed out.
***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/04/07,21:30:34] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,03:21:33] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/05/07,03:21:39] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,11:30:05] Microsoft SQL Server 2005 Express Edition x86: [2] Error code 258 for this component means "The wait operation timed out.
"
[06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Return from system messaging: The wait operation timed out.
[06/05/07,11:30:10] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,11:52:13] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
***EndOfSession***
I try to install it from visual studio net professional 2005, every time it fails. Any idea?
Alright I glanced over the forums to see if there was an answer for this and I didn't see one. I saw a few similar issues however nothing that fixes my issue. Here is my problem.
I installed SQL Server 2005 Express on my Vista partition along with Visual C# Express. For some reason I cannot get the SQL Server 2005 Express to function correctly. Back when installed this on XP it worked flawlessly, and I don't even recall doing anything special...I installed it and it worked. I do know that you have to manually add the user account to the admin list for the SQL server on Vista, and I did that. I chose the option to have it do it during installation as well as through the SQL Server Surface Area Configuration just to be sure.
I am just trying to get the basics of it working right, and that is connecting to the server using C# and filling a dataset...it shouldn't be this hard. This morning when I started with this I could connect and fill my DataSet programmatically however it wouldn't pass the test through the Data Source Configuration Wizard. When I did it manually, as I said it worked and filled the DataSet with the info I asked for below in the code sample. After getting annoyed by it not working through the wizard I decided that maybe I had my permissions wrong and I may have messed up when installing it. So I uninstalled everything to do with SQL Server 2005 and reinstalled it fresh.
This time when I installed it I made sure to set it up to use Windows Authentication. Now it will pass the Test in the Data Source Configuration Wizard and everything is working by doing it that way. However now it doesn't work when I do it manually with the code below(same code as before when it worked...lol). When I use the code below it crashes with the error: "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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)". When I go through it with the debugger it throws that error at the call dataAdapter.Fill(...). The code is the following:
Code Snippet
string connStr = "server=localhost;Trusted_Connection=yes;database=northwind";
string commandStr = "Select CompanyName, ContactName from Customers";
SqlDataAdapter dataAdapter = new SqlDataAdapter(commandStr, connStr);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet, "Customers");
DataTable dataTable = dataSet.Tables[0];
foreach(DataRow dataRow in dataTable.Rows)
lbCustomers.Items.Add(dataRow["CompanyName"]+
" ("+dataRow["ContactName"]+")");
Why doesn't that work yet I can basically ask for the same information and it will work if I do it through the wizard? If it works 1 way I wouldn't think there could be any issues with the server being accessed remotely, right?
Thanks
Danny B
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).
Is it possible to install sql express on a 2 cpu Vista pc, even though this is stated to NOT be supported, by assigning CPU affinty, e.g., something similar to c:windowssystem32cmd.exe /C start /afinity 1 notepad.exe?
View 5 Replies View RelatedHi 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...
I am unable to install Business Contact Manager for Outlook 2007. I sought help in the BCM forum, but the developer who I spoke with came to the conclusion that it is a SQL Server Express problem that I am experiencing, and so he recommended that I come here for help.
I am running on Vista Ultimate.
Every attempt I have made to install BCM (and later SQL Express Server 2005 separately, see below) has failed at the same point, with the same error message:
"SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
Today I attempted to install SQL Express Server SP2 separately on its own, the idea being that if this worked, then I might be able to install BCM on top of it. I attempted the SQL EE SP2 installation after uninstalling all remnants of previous installations to the best of my ablity. The SP2 installation failed at the same point, and had the same appearance, as I saw in all prior attempts. (The installer reported no errors or warnings in its system checks prior to beginning the actual install.)
Here is the summary log from this trial:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Professional (Build 6000) Time : Tue Apr 03 15:39:02 2007 Machine : LUMACRAFT-1 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : LUMACRAFT-1 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : LUMACRAFT-1 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : LUMACRAFT-1Product : SQL Server Database ServicesError : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.--------------------------------------------------------------------------------Machine : LUMACRAFT-1 Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. Error Number : 29515 --------------------------------------------------------------------------------
The pertinent section from the SQLSetup0008_user_SQL.log seems to be:
MSI (s) (F0:88) [15:42:00:403]: Invoking remote custom action. DLL: C:WindowsInstallerMSI118F.tmp, Entrypoint: Do_sqlScript<Func Name='LaunchFunction'>Function=Do_sqlScript<Func Name='GetCAContext'><EndFunc Name='GetCAContext' Return='T' GetLastError='203'>Doing Action: Do_sqlScriptPerfTime Start: Do_sqlScript : Tue Apr 03 15:42:00 2007Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue Apr 03 15:42:00 2007SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connectionsService MSSQL$SQLEXPRESS started at Tue Apr 03 15:42:05 2007SQL_ERROR (-1) in OdbcConnection::connectsqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Error Code: 0x80074818 (18456)Windows Error Text: Source File Name: libodbc_connection.cppCompiler Timestamp: Wed Jun 14 16:28:15 2006 Function Name: OdbcConnection::connect@connectSource Line Number: 148---- Context -----------------------------------------------Connecting to SQL ServerExecuteSqlCommandsOriginial error was 80074818 (18456)iptSqlScriptHlprError Code: 18456Other things that I have tried include disabling UAC, and running BCM setup.exe 'as administrator'.
Any advice on how to get SQL EE installed, so that I can ultimately install BCM, will be greatly appreciated.
Thanks,
David A. Gilmour
Hi
I have installed the Beta version for Windows Vista and installed VS 2005 for Software Developers which includes SQL Server Express.
When installing the SQL Server express part compatibility issues appear. Do i need to install a fresh copy of SQL Server Express which inlcludes Service Pack 1?
I cannot connect to any mdf file through the data connection section in the VS 2005 IDE. Cant remember the exact error message, something like "Cannot find the entry or starting point".
I am running a fresh install off the latest Dotnetnuke starter kit and get a database compatibility error so my guess is this could also be as a result of SP 1 not being installed?
Any help or suggestions appreciated.
Thanks
I have a new laptop with VISTA. I've enabled IIS with all features turned on. When I install SQL Server 2005 Express I get a warning stating IIS is either not installed or disabled. Any ideas? Thanks.
View 4 Replies View RelatedHi all,
I am having problems with connecting to a SQL Express server running on server 2003. I can connect with the program concerned from a windows xp client without problems. I cannot however connect from a vista machine using the software. In the logs i see the client trying to logon, wich fails with Login failed for user: 'user'. [client: clientIP] severity 14 state 8. On the vista client i have tried everything from disabling the firewall, windows defender, running the app as admin etc. I can connect using sqlcmd or the management tools with the username the app is using. This is a SQL user, we are not using windows users to connect to the DB.I also ran a app like ethereal to see what is happening packet wise, i see the login failed packet on a windows client, from a XP client everything seems fine and it starts using RPC.
Any help appreciated,
FVader
Sorry.. but.. sql server express has compatibility with windows vista????
View 1 Replies View RelatedI am trying to install SQL Server Express - (the non ADV version) and get the following error.
"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_x64.msi'".
I have 64 bit Vista Ultimate running on an HP dv9000.
I am using the download from the bottom of the download page for SSX where it says 64 bit version.
Prior to this I got the. "64-bit ASP.net is registered. Required 32-bit ASP.NET to install Microsoft Reporting services 2005(32-bit)." messagd during the pre-install scan. From what I gather in the posts, the reporting issue is different from my installation package problem.
I have been trying to prove a point to friends about how far you can go with SSX but am having no luck installing it. This whole process took 1 hour in XP but I've been stymied for 2 days.
I would appreciate being pointed at the right downloads for what seems to be a simple install.
I have been trying to get Sql Server 2005 Express Advanced with SP2 installed and operating on my Vista machine. It seems to install ok but when I open Management Studio Express and try to create a new db or attach an existing one, I get error messages. So although it seems to be installed, I can't really use it.When I try to create a new database I get: TITLE: Microsoft SQL Server
Management Studio Express
------------------------------
Create failed for Database
'practice'.
(Microsoft.SqlServer.Express.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while
executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
CREATE DATABASE permission denied in
database 'master'. (Microsoft SQL Server, Error: 262)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
When I try to attach an existing database I get:
TITLE: Microsoft SQL Server
Management Studio Express
------------------------------
Failed to retrieve data for this
request. (Microsoft.SqlServer.Express.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while
executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
The server principal
"Dave-PCDave" is not able to access the database "model"
under the current security context. (Microsoft SQL Server, Error: 916)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I have tried following the links in the error messages but the result is: "We're sorry
There
is no additional information about this issue in the Error and Event
Log Messages or Knowledge Base databases at this time. You can use the
links in the Support area to determine whether any additional
information might be available elsewhere."I am successfully using both programs on my XP SP2 machines, so I know how to install and run them on XP, just not on Vista (yet). Any suggestions on how to proceed?
Getting error 1326.
I'm running SQL Express on Server 2003 SP1 (workstation - although, I did dcpromo promote and demote prior to installing SQL Express).
I'm trying to connect from SQL Studio Express on Vista.
TCP and Named Pipes are selected in Surface Area Config; sp_config remote, access..., 1 was run (per KB); ports 1433 & 1434 are open (I think 435 also was opened when I ran the KB instructions); Mixed mode is selected, user is set for SQL Auth, password is correct; all permissions are granted.
I found an article online which stated that mixed versions of MDAC can lead to the problem. The server has 2.82.1830 and the client has 6.0.5600.16834. Could this be the problem? If so, how to solve?
Thanks, John
Hi
I have a PC running the 64 bit version of vista home premium (will be soon upgrading to ultimate).
On the download page http://msdn.microsoft.com/en-au/express/bb410792.aspx for SQL Server Express under the section entitled SQL Server 2005 Express Edition SP2 it mentions at the bottom of the page (referred by * & **) that there is a 64 bit install version available for both SQL Server & management Studio.
However, under the section entitled SQL Server 2005 Express Edition with Advanced Services SP2, there is no * or **. As far as I can tell, the Advanced services has Reporting Services as well.
So, what I am wondering is, can I specifically download the 64 bit versions of SQL server express & management studio and as well, download just the reporting services part of Advanced Services?
Kind regards
Ross
Hi All,
I have an issue that's stopping me restoring a database on SQL Server Express 2005 running under Windows Vista. I'm installing a system that I've used several times before on other systems and part of the installation procedure is to use the 'restore' function to install a database from a backup file. So I'm essentially restoring but to a db that doesn't yet exist in my SQL Server, this normally goes without a hitch. However on attempting this on a Vista system, I get the following error message -
System.Data.SqlClient.SqlError: The operating system returned the error '5(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLiCasework.mdf'. (Microsoft.SqlServer.Express.Smo)
where iCasework is the name I've given in the restore dialogue as the DB to restore to (which as I said, doesn't exist at the moment).
Things I've tried so far: -
I have a feeling this is down to a permissions problem, so I've tried the following already
1) Running Management Studio Express as Administrator - exact same error message
2) During the initial install, I set up the default admin user to use SQL Server authentication, having read threads about vaguely similar errors I used the Surface Area Config tool to add my windows login as an admin with admin rights and tried connecting to the Server with those credentials then running the restore - exact same error message
and
3) I also tried manually creating an empty db called iCasework and then restoring the external backup into that existing backup, which just gave a different error stating that the backup file didn't match the structure of the existing db. I could create the whole db structure manually but that would entirely negate the purpose of restoring from the backup and, more to the point, has never been necessary on any other system we've done this one.
Has anyone got any ideas that I could try next please?
I cannot copmlete the installation because the error prompted as "Install error and error code is 29506".
Is it cannot be supported Vista ?
Best Regards
KennethCCL
When I was trying to SQL Server 2005 Express SP2 (November CTP) on Vista RTM, setup failed on the Database Services component with the following log messages:
SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connectionsService MSSQL$SQLEXPRESS started at Sat Nov 18 09:21:28 2006SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connectsqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'default language' changed from 0 to 0. Run the RECONFIGURE statement to install.sqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'default full-text language' changed from 1033 to 1033. Run the RECONFIGURE statement to install.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.SQL_ERROR (-1) in OdbcStatement::execute_batchsqlstate=42000, level=11, state=1, native_error=15401, msg=[Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.sqlstate=42000, level=16, state=1, native_error=15007, msg=[Microsoft][SQL Native Client][SQL Server]'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' is not a valid login or you do not have permission. Error Code: 0x80073c29 (15401)Windows Error Text: Source File Name: libodbc_statement.hCompiler Timestamp: Wed Aug 2 16:21:02 2006 Function Name: OdbcStatement::execute_batch@CnfgSQL@80Source Line Number: 91---- Context -----------------------------------------------Connecting to SQL ServerExecuteSqlCommandsUSE [master ]<Started SQL statement: Sat Nov 18 09:21:28 2006>declare @ServerName nvarchar(255) if not exists (select * from sysservers) begin select @ServerName = Convert(nvarchar(255), SERVERPROPERTY(N'ServerName')) execute sys.sp_addserver @ServerName, local end<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>ALTER DATABASE model SET RECOVERY SIMPLE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sp_configure N'show advanced options', 1 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>DECLARE @Name AS nvarchar(128), @LangID AS smallint SELECT @Name=name, @LangID=langid FROM syslanguages WHERE lcid=1033 EXEC sp_defaultlanguage N'sa', @Name EXEC sp_configure N'default language', @LangID EXEC sp_configure N'default full-text language', 1033 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sp_configure N'show advanced options', 0 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'BUILTINAdministrators' EXEC sys.sp_addsrvrolemember N'BUILTINAdministrators', N'sysadmin'<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'NT AUTHORITYSYSTEM' EXEC sys.sp_addsrvrolemember N'NT AUTHORITYSYSTEM', N'sysadmin'<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' EXEC sys.sp_addsrvrolemember N'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS', N'sysadmin'Originial error was 80073c29 (15401)Do_sqlScriptSqlScriptHlprError Code: 15401MSI (s) (98:50) [09:21:30:219]: I/O on thread 3236 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3300 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3652 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3424 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3244 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3544 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3064 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3428 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 2000 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 1740 could not be cancelled. Error: 1168MSI (s) (98!78) [09:21:30:219]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS exists and contains NT AUTHORITYNETWORK SERVICE when the error occurs.
Any suggestions on how to get SQL Server to install on Vista?
Hi all Pros I am transfering from windows2003 server and MS SQL 2000 to Windows Vista and SQL Express ...... Before I allways created a database manually and I could allways use as many databases I needed so in that way I could have several versions of a database for a certain software during development. Can you use separeted databasenames when developing in SQL Express? I am using a dotnetnuke installation file and inside the project there is a file /App_Data/Database.mdf should this file be renamed everytime I make a new testinstallation or setting up a separate dev environment /Johan
[Moderator Edit: unrelated links removed from post body.]
I'm running Vista Business edition on 2005 Virtual PC.Installed SQL Server 2005 Express latest download, with instance ofMSSQLSERVER and service accounts running under "NT AUTHORITYSYSTEM".Mixed mode authentication specified and sa password specified.Used server manager to create user login with sysadmin role.Login using windows authentication.Run my application and database is created and populated with defaultrecords.However, my application executes the stored procedure "sp_helpdb"which fails with "Invalid object name '#spdbdesc'" error.If I run a query in server manager to execute same procedure loggedinas the same person it runs ok and returns a table of information.All this was working ok on XP with MSDE2000A previously.I'm programming in .NET C# CLR2.0, any body know what's going wrong?
View 3 Replies View RelatedI have recently updated from XP to Vista Home Premium. Now when I try to install SQL Serve Express SP2 I get :
"setup has detected problem with .net framework installation
and cannot proceed. Microsoft .net framework 2.0 is either not installed or
is corrupt."
I have tried to run sfc /scannow to make sure my .NET 2.0 was not corrupted and also was running as an administrator but could not get it installed. Anyone has any ideas?
dear friends, I installed Sql ServerExpres SP2 spanish vertion in Vista home basic, I Cant Attach a data base, it reports me the error cant access to Model data base, error 916, and when I try to Create a new data Base it Reports me, Permition denied to create a data base in master, error 262
I am trying to download English Vertion, but When I download it olways try to download me the sqlexpres32_ESN.EXE which have these problems.
if any can help me,
Regards in advance Santiago