Hello all,
Quick question. I know that SQL Developer Edition works on XP sp2. Anyone
know if SQL Developer Edition will work on Vista Business. I'm ordering a
new notebook and don't want to have to remove the OS if I don't have to.
Thanks
JohnI'm running Dev Ed on Vista (Ultimate), no real problems. SQL Books Online lists what OS are
supported for each SQL Edition, and Vista with Business should be fine. Just install SQL 2005 sp2
after initial install, so you are supported (etc).
You are in for some work if you want to install RS. Basically, you need to make Vista "present " IIS
6. It was a while since I did this, but with some help from Google etc it wasn't that tough.
I should add that I disabled UAC. I ran it for a couple of days, but it annoyed me too much. I don't
think it caused any particular SQL Server problems, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:DED2615C-7B03-489F-A288-A5350FA2F6F4@.microsoft.com...
> Hello all,
> Quick question. I know that SQL Developer Edition works on XP sp2. Anyone know if SQL Developer
> Edition will work on Vista Business. I'm ordering a new notebook and don't want to have to remove
> the OS if I don't have to.
> Thanks
> John|||I agree with Tibor. I've been using SQL Server 2005 DE since Vista Business
released and no problem at all.
Regarding to IIS, IIS is not being fully installed by default so you need to
add some components to its installation so that you'll be able to use it for
your RS or anything else.
You may want to check out the following link to learn about exactly what
components of IIS should be installed to make RS checkbox enabled when in
SQL Server Setup.
http://support.microsoft.com/default.aspx/kb/934164
--
Ekrem Önsoy
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:DED2615C-7B03-489F-A288-A5350FA2F6F4@.microsoft.com...
> Hello all,
> Quick question. I know that SQL Developer Edition works on XP sp2.
> Anyone know if SQL Developer Edition will work on Vista Business. I'm
> ordering a new notebook and don't want to have to remove the OS if I don't
> have to.
> Thanks
> John|||Thanks for your input guys. I really appreciate it. Vista it is.:-)
John
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:DED2615C-7B03-489F-A288-A5350FA2F6F4@.microsoft.com...
> Hello all,
> Quick question. I know that SQL Developer Edition works on XP sp2.
> Anyone know if SQL Developer Edition will work on Vista Business. I'm
> ordering a new notebook and don't want to have to remove the OS if I don't
> have to.
> Thanks
> John|||"John Holt" wrote:
> Thanks for your input guys. I really appreciate it. Vista it is.:-)
> John
> "John Holt" <johnh@.regionv.k12.mn.us> wrote in message
> news:DED2615C-7B03-489F-A288-A5350FA2F6F4@.microsoft.com...
> > Hello all,
> > Quick question. I know that SQL Developer Edition works on XP sp2.
> > Anyone know if SQL Developer Edition will work on Vista Business. I'm
> > ordering a new notebook and don't want to have to remove the OS if I don't
> > have to.
> >
> > Thanks
> > John
>
I'm having problem installing SQL Reporting Server on Vista Business without
success. Microsoft Vista said 1% incompatiability problem. It is a real
nightmare!
Showing posts with label vista. Show all posts
Showing posts with label vista. Show all posts
Friday, March 9, 2012
Friday, February 24, 2012
Developer limitation under SQL 2005 under Vista Ultimate 64 bit
Just to be clear, I would like to know if a problem I face is due to an error on my part or a limitation on Microsoft's. In my experience (several hours-long installations, removals, reinstallations, using the skuupgrade=1 parameter from the command line, ad nauseum) I have concluded that the best one can do installing SQL Server 2005 Developer Edition from the Visual Studio 2005 Professional Edition package is to get the Express Edition, (actually styled MSSMLBIZ). In particular, what I'm hoping to be able to do is program to a test database that I have from my client, which I was able to do on my XP Professional machine. But on my new Vista Ultimate 64 bit machine (which will only let me install the x64 version of SQL Server 2005), I get an instance that is characterized as SQL Server Express and generates the following error message when I try to attach to the same MDF file to which I was able to attach under my prior, XP-Pro based configuration:
TITLE: Microsoft SQL Server Management Studio
Attach database failed for Server 'ZAPHOD42\MSSMLBIZ'. (Microsoft.SqlServer.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=Attach+database+Server&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft SQL Server, Error: 1827)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=1827&LinkId=20476
BUTTONS:
OK
===================================================================================
The following is the Help obtained when clicking on the button on the error msg and the references in the error msg:
===================================================================================
Details
ID: Attach database Server
Source: Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText
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.
--
Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.
Currently there are no Microsoft Knowledge Base articles available for this specific error or event message. For information about other support options you can use to find answers online, see http://support.microsoft.com/default.aspx.
==================
Details
ID: 1827
Source: MSSQLServer
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.
Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.
==========End of reproduction of error messages and help text ====================================
The Developer Edition, of course, is supposed to enable us to program to all levels of the database, and I would hate to think it is really crippled in this way, but after uninstalling everything, reinstalling multiple times (devoting several days to the process), it sure beats me how I can overcome this problem short of going back to my old machine. Any definitive answers on this apparent limitation, or useful procedural advice on installation quirks, would be appreciated (and, yes, I've spent a lot of time going through the installation/setup forum -- if the answer is there I can't find it).
Seems as you want to attach a user database to a Express instance ? What is the output if you connect to the mentioned server and execute the following command: SELECT @.@.Version ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
Microsofty SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Express Ediition on Windows NT 6.0 (Build 6000
I must say the X86 reference surprises me. I hope this means more to you than it does to me.
Bob
|||
Using a SQL Server Express edition you are limited to 4GB database size (all databases in sum of the instance)
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||I face the same problem... I have a Vista ultimate x64 and I tried to attach a small MDF to SQLexpress and I had an error. It's the same if I try to create a new db?
could you give me some help
Developer limitation under SQL 2005 under Vista Ultimate 64 bit
Just to be clear, I would like to know if a problem I face is due to an error on my part or a limitation on Microsoft's. In my experience (several hours-long installations, removals, reinstallations, using the skuupgrade=1 parameter from the command line, ad nauseum) I have concluded that the best one can do installing SQL Server 2005 Developer Edition from the Visual Studio 2005 Professional Edition package is to get the Express Edition, (actually styled MSSMLBIZ). In particular, what I'm hoping to be able to do is program to a test database that I have from my client, which I was able to do on my XP Professional machine. But on my new Vista Ultimate 64 bit machine (which will only let me install the x64 version of SQL Server 2005), I get an instance that is characterized as SQL Server Express and generates the following error message when I try to attach to the same MDF file to which I was able to attach under my prior, XP-Pro based configuration:
TITLE: Microsoft SQL Server Management Studio
Attach database failed for Server 'ZAPHOD42\MSSMLBIZ'. (Microsoft.SqlServer.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=Attach+database+Server&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft SQL Server, Error: 1827)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=1827&LinkId=20476
BUTTONS:
OK
===================================================================================
The following is the Help obtained when clicking on the button on the error msg and the references in the error msg:
===================================================================================
Details
ID: Attach database Server
Source: Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText
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.
--
Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.
Currently there are no Microsoft Knowledge Base articles available for this specific error or event message. For information about other support options you can use to find answers online, see http://support.microsoft.com/default.aspx.
==================
Details
ID: 1827
Source: MSSQLServer
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.
Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.
==========End of reproduction of error messages and help text ====================================
The Developer Edition, of course, is supposed to enable us to program to all levels of the database, and I would hate to think it is really crippled in this way, but after uninstalling everything, reinstalling multiple times (devoting several days to the process), it sure beats me how I can overcome this problem short of going back to my old machine. Any definitive answers on this apparent limitation, or useful procedural advice on installation quirks, would be appreciated (and, yes, I've spent a lot of time going through the installation/setup forum -- if the answer is there I can't find it).
Seems as you want to attach a user database to a Express instance ? What is the output if you connect to the mentioned server and execute the following command: SELECT @.@.Version ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
Microsofty SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Express Ediition on Windows NT 6.0 (Build 6000
I must say the X86 reference surprises me. I hope this means more to you than it does to me.
Bob
|||
Using a SQL Server Express edition you are limited to 4GB database size (all databases in sum of the instance)
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||
I face the same problem... I have a Vista ultimate x64 and I tried to attach a small MDF to SQLexpress and I had an error. It's the same if I try to create a new db?
could you give me some help
Subscribe to:
Posts (Atom)