I'm a complete newbie when it comes to SQL, and to be honest it frightens the hell out of me too.
I've been running a version of SQL 2008 Express for sometime, however after getting some free software off Microsoft I updated my version of Visual Studio to professional and then tried to update my Express version of SQL to 2008 R1.
I downloaded it from the MS site and proceeded to work through the pre-installation instructions, however I wasn't offered the opportunity of installing a new instance and was then advised there was nothing to upgrade on the version I had installed.
When I go into SQL management studio I can see the database I used to be able to access but can't expand it. My version of SQL is 10.0.2531.whats happening or how to work around it?
Part of it's function will be to write files to other servers accessable via file share on the same domain. With that in mind I enabled impersonation and set up the account. I now get the following error:
The current identity ([domainuseraccount]) does not have write access to 'C:WindowsMicrosoft.NETFramework64v2.0.50727Temporary ASP.NET Files'.
I have gone into the security tab for this directory and added this user with FULL CONTROL, I can reboot the server and re-look at the security tab for this directory and I can SEE that the permission are there.
If I take the impersonation account and make it an administrator it all works fine. Obviously that is NOT what I want to do.This is a windows 2008 R2 server running on a domain. The impersonation account is a domain account not a local account. The impersonation account has been added to the local 'Users' group.
I am stumped. I can see that the account DOES have full permissions on the directory, but the error message persists.Back in the days of Windows 2000 there were steps that had to be taken to set ntfs permissions that would allow impersonation (or even the asp.net) accounts to work properly. I have not found a similar document for Windows 2008 R2.
SQL Server Express 2008 R2 installation is failed...plese see the error log ...i gave the password "sa"..please guide me Overall summary Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup. Exit message: The specified sa password does not meet strong password requirements. For more information about strong password requirements, see "Database Engine Configuration - Account Provisioning" in Setup Help or in SQL Server 2008 R2 Books Online.
I am looking at developing using Visual Studio 2010/2008 and SQL Server 2008 on Windows 7. Should I be able to do this on Windows 7 Professional, or do you need Windows 7 Ultimate?
I need to ask this question.I registered websitespark program and I have some tools.I have Server 2008, VS 2008 etc.I want to install Server 2008 and VS 2008 but I never use them together before. What are the advantages and disadvantages and also performance? We are developing web and win applications.
I am working on the migration of the server. Our new server is Windows server 2008 with IIS7.0 I have a great difficulty in browsing the pages hosted in virtual directories. I have followed the proper steps of creating a virtual directories and converting them into applications. But when i try to browsing the pages of the virtual directory, i get the 404 error. Note: The .Net Framework 4.0 is installed on the server and the web applications which i am trying to configure in the virtual directories are developed in Visual Studio 3.0. Even the http://localhost also don't work.
i'm getting error while installing sql server on xp sp2. i have already installed visual studio sp1. while installing sql server it install hotfix for xp KB942288-v3 and KB954550-v5 after show following error message. SQL Server Setup has encountered the following error: Object of type 'Microsoft.SQL.Chainer.Package.PropertiesTypeProperty' cannot be converted to type 'Microsoft.SQL.Chainer.Package.PropertiesTypeProperty'..
I have Sqlserver2008 setup. It is work in wndows Xp. But I have to Install it on Windows 7 ,during installation process it requires some patch and I am unable to get it.
i was normally using VS2005 and SQL server 2005... i upgraded to SQL Server 2008... and then... i could not build my project anymore... because of this error: 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.
My company is looking to upgrade the web server from Server 2003 to 2008 (along with IIS of course). Currenty the websites are built using ASP.NET 3.5 (and a blog in PHP), is there anything that needs to be done to ensure the sites (forget the blog) still work on the new server? I'll no doubt upgrade the sites over time to use .Net 4 or MVC, but for the moment the transition needs to be almost seamless.
I'm having difficulties with a clean SQL Server 2008 + SP1 (64 bit) install. I'm using Windows 7 Ultimate 64 bit with VS2010. The Microsoft SQL Server 2008 Service Pack 1 (KB968369) is installed via Windows Update. I installed SQL Server Management Studio (64 bit) via the Microsoft website. When I open SSMS and try to login with Windows Authentication to (local)/localhost/[computername] I get the following error:
[Code]....
I don't understand this because I opened the inbound/outbound ports for 1433/1434. As wel as inbound/outbound exceptions for the programs
i have a simple questions. I am programming in Visual studio using vb.net. As Database i am using mysql with the .Net connector and using the membership provider. Do i need to install microsoft sql server 200X too ? (although i will not use it)
I am trying to install SQL Server 2008 R2 by installing MS WebMatrix from web[URL].After Installation the WebMatix platform I tried to install the the SQL Server 2008 R2 but there is no new installation option on SQL Server installation Center and I have "New Installation or add features to an existing installation" and the problem is when I click on this option installer prompts me to "Browse For SQL Server 2008 R2 Installation Media" As I mentioned I download the web platform from Microsoft/WebMatrix web page and I have not any installation media!
Question on installing SQL Server 2008 reporting services.
I have Visual Studio 2008 express edition installed, with the corresponding SQL Server 2008 express edition installed. Is it practical to use SQL Server 2008 Reporting Services with the express edition, or is it just to restrictive with the express edition to be practical? Keep in mind I just need to use it with my local database connection. What type of restrictions will there be, i.e. what can I and what can't I do with express edition? What would be the more ideal setup and what would the costs generally look like?
I am running a web application in vs-2008 on windows 2003 server.While execution of .net application, I am getting an error as"Unable to start debugging on the web server. Unable to connect to the web server. Verify that web server is running and that incoming HTTP requests are not blocked by firewall."
I follow the instruction of installing a new feature with the application SQLManagementStudio_x86_ENU.exe and I get to a fail telling me that VS 2008 needs to be upgraded to SP1.
This I have done several times with the final message saying successfully installed yet 'About' shows only
We are trying to install VWD 2010 on a windows 2008 server. We already have installed the 2008 version as well as SQL 2005, 2008 and 2008 R2. The Web Platform installer is not installing VWD 2010 however.At first it notified us that the OS does not allow it, after running tons of updates on the OS (some of which failed) it is still not doing it, not even donwloading it. The latest message simply asked us to post the error on the forum
I recently bought a new computer, so I want to copy the projects into current system which has visual studio. I have a project developed in VWD 2008. I copied the folder into a flash drive and copied it back into the new system.
Knowing the location, how I do import the project into new system?
I am not sure this is the forums but I dont know where to write this and this is an EMERGENCY ::I had windows 2003 server. on C: and I have installed windows 2008 server.I had SQL server installed and all of the database files stored inside c:program filessql server....PROBLEM is that after I installed 2008 server I can see 2 folders of program files one for x86 and the other for 64 bits.
I just downloaded and installled the Microsoft Windows Azure SDK yesterday for the first time and I am having issues running the application as I all I am getting is 503 errors. I run Windows Server 2008 R2 on my development machine and even tested it on another co-workers 2008 R2 and couldn't even compile the application. He got this error instead "A problem occurred while trying to set the "References" parameter for the IDE's in-process compiler. Error HRESULT E_FAIL has been returned from a call to a COM component."
From within my Windows Server 2008 R2 Hyper-V Virtual Windows 7 x86 enviroment, I was able to successfully build and run the Windows Azure SDK and it even showed the base ASP.NET application.So my question is, does the Windows Azure SDK for Visual Studio 2010 w/ Visual Studio 2010 SP 1 installed not work under Microsoft Server 2008 R2?
Ive recently got a new development machine with windows 7 64 bit. On loading up a website and opening default.aspx, the whole ide just freezes. Nothing responds, I have to shut it down from the task manager. This happens every time (ive tried it 4 times so far)The site was fine on my old machine (windows xp 32 bit) are there any compatibility issues with windows 7 64 bit and vs 2008 ?
We need to get MVC 2.0 installed on multiple servers. When we use the exe file AspNetMVC2_VS2008.exe to install MVC 2.0 it checks for prereqs. One of the prereqs ins VS 2008 SP1.
Now when we use the MSI file AspNetMVC2.msi to do the installation, MVC 2.0 is installed without complaining about VS 2008 SP1.
The exe file checks for prereqs, while the msi doesn't.
My questions is, do we really need VS 2008 SP1 installed along side MVC 2.0? If so why?
