Problem Attaching DB SQL Svr 2008 On Windows Vista OS
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
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.
Doing some testing with Vista and SQL Server Express 2005..
I'm logging into Vista under a Windows admin account, UAC turned on. If I run SSMSE, log into my default server via Windows Authentication, thus using my Windows admin account, I'm unable to attach a database to the server. I'm getting the error message - Unable to open the physical file...Operating system error 5: Access is denied (error 5120), etc.
My Windows admin user is a member of the sysadmin server role for my server instance, and I'm running SP2.
To get around the problem, I can either choose to launch SSMSE with "Run as administrator", or give the Windows Users group full permissions on the database file. Detaching, deleting, etc is no problem with this admin user (e.g. do not need to select "Run as a administrator" on SSMSE launch).
Any ideas, or is this is behaving as expected? Thanks
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
I have SQL Express 2005 SP2 installed in my Vista Home Premium. I am using SQL Server Management Studio Express to manage .mdf.
When I click "Add..." to attach .mdf database, I have this prompt error message :
The server principal "My-PCMyName" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error: 916)
I have elevated the rights, "Run as administrator", of my SQL Server Management Studio Express, but still having problem.
I also encounter security error when detaching the existing .mdf : The EXECUTE permission was denied on the object 'sp_detach_db', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
Hello! Recently, I set up server with Windows Web Server 2008 RC1, SQL 2008 Express beta, .NET 3.5, IIS 7. I'm running ASP.NET web application with SQL database. Everything works fine until the first application state on the server expires. After that, any postback that starts a new application state on the server and connects to the database, results in the following 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. Is this a bug that will be fixed in release of Windows / SQL or am I doing something wrong? Many thanks for help, Jan
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?
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.
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.
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
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
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.
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?
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.
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?
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?
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?
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.
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?
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.
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".
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...
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,
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.
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?
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.
