... which are currently attached to the Express Edition. So determine which of these instances is the Express Edition using serverproperty('edition') command and then...if databases are attached to the Express Edition then right click on the...attach those detached databases from the Express Edition, to the Enterprise Edition. ... (I'm talking about your Express Edition here) then it's ...
... a database? No. So, I stopped the SQL2005ENT service (red square on the server box) in the Configuration Manager. Lo, and Behold, I can still connect to that 'instance' (or 'named instance') in Management Studio Express. I think there is still some confusion here, and without logging on to the box to see for myself, I'm afraid I can't help you figure out what it is. A
... 'install'? Or is it another name for another 'named instance' (two names pointing to the same installation)? It looks like your server architecture is x64 and you installed your first instance of SQL Server as a 32Bit ... on the server box) in the Configuration Manager. Lo, and Behold, I can still connect to that 'instance' (or 'named instance') in Management Studio Express.
... (This may not be the issue, but I wanted to explain it) It looks like your server architecture is x64 and you installed your first instance of ... want to keep using the Enterprise Edition, then detach your databases from the Express Edition and then attach them to the Enterprise Edition. And then you can uninstall the Express Edition as it's (probably) going to be useless. -- Ekrem Ö...
... as SQL2005ENT I assume this is an Enterprise Edition of SQL Server 2005. Regarding to SQL Server Express Edition with Advanced Services, I don't recall if it'd install the entire RS stuff or not... stopped do not have a problem. I just have not started them yet. Now, SQL Server Express with Advanced Services supposedly gave me Reporting Services via VS2005, but I don't see that ...
... Edition. If you need this edition you install it, if you don't then simply you don't install it. What's wrong with this? SSMSE = SQL Server Management Studio Express SSMS = SQL Server Management Studio (whih comes with Workgroup, Standard, Developer and Enterprise Editions of SQL Server) -- Ekrem Önsoy "Brian Smither" <bsmitherINVALID@INVALIDcitlink.net> wrote in message ...
... Server Agent (SQL2005ENT)(stopped) SQL Server (SQL2005ENT) SQL Server Full Text Search (SQL2005ENT)(stopped) SQL Server Analysis Services (SQL2005ENT)(stopped) The services that are stopped do not have a problem. I just have not started them yet. Now, SQL Server Express with Advanced Services supposedly gave me Reporting Services via VS2005, but I don't see that listed. Ekrem
...>> 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.2 (Build ...Service Pack 2) With serverproperty('edition'), I get: Express Edition with Advanced Services The setup was quite extensive and ...>>> Ensure the SQL Server instance you work on is Express or Enterprise Edition by using the following command line: ...
... 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.2 (Build ...: Service Pack 2) With serverproperty('edition'), I get: Express Edition with Advanced Services The setup was quite extensive and I... Ensure the SQL Server instance you work on is Express or Enterprise Edition by using the following command line: ...
... 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.2 (Build 3790: Service Pack 2) With serverproperty('edition'), I get: Express Edition with Advanced Services The setup was quite extensive and I truly believe I got Enterprise X64 installed. ...
