SQL SERVER 2005 – Vista Ultimate and SQL Server 2005 DEV Edition

I have been asked many times before “Does SQL Server Dev edition can be installed on Vista operating system?”

I decided to find out the answer of this myself. I have just got new system which has Vista Ultimate Installed on it. I installed SQL Server 2005 dev edition on it. While installing it suggested that there are few component will not work with Vista and to make them work make sure to install SQL Server 2005 SP2. I was any way planning to install that. Once installation of SQL Server 2005 over, I installed SQL Server 2005 SP2. After restart I ran SQL Server 2005 and it just worked fine.

I am loving the combination of SQL Server 2005 and Vista Ultimate.

Reference : Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
SQL SERVER – How to Rename Database Objects to Comply With Naming Conventions
Next Post
SQL SERVER – 2000 – SQL SERVER – Delete Duplicate Records – Rows – Readers Contribution

Related Posts

11 Comments. Leave new

  • Allan Svelmoe Hansen
    May 13, 2008 11:12 am

    Have had a developer edition installed on Vista x64 Home Premium for quite a while now, without any problems what so ever.

    Reply
  • I have installed vista ultimate and sql server 2005 devloper edition in my computer.I also connect sql 2005 in window authentication but when I CREATE any database in following query
    CREATE DATABASE MANEESH
    USE MANEESH
    Its give me everytime following error:-
    Msg 262, Level 14, State 1, Line 1
    CREATE DATABASE permission denied in database ‘master’.
    &
    Msg 911, Level 16, State 1, Line 1
    Could not locate entry in sysdatabases for database ‘maneesh’. No entry found with that name. Make sure that the name is entered correctly.
    But i entered ev name correctly.and i am not making anytype tabels in sql2005.Solve these problem please.

    Reply
  • please give me a link where I can download predefinded database table
    like
    Employee, Publisher, Candidate, Toys and other
    who make my query execute more faster.
    and also tell me how can I can install these databaese table in sequence databse master,and model etc.
    and also thankyou for your previous reply.

    Reply
  • K. Brian Kelley
    June 6, 2008 12:12 am

    The only real issue I had was on the SSRS side. Data Engine, Analysis Services, Integration Services all installed without issue and were fine once SP2 was applied.

    Reply
  • Hi,
    I have installed SQL Server 2005 on a Vista Business. I am able to connect to SQL Server instance on Vista machine from Management Studio on other machine (Running on Xp).
    But I am not able to connect to Analysis Services default instance on Vista Business machine from Management Studio on other machine (Running on Xp).
    I did all settings with Vista firewall exceptions, SQL Surface area configuration, Security, everything.
    Please tell me do I need to modify something else on ‘Vista Business’.

    Thank you.

    Reply
  • rolly L hernando
    July 19, 2009 7:37 pm

    i’ll find to try it soon

    Reply
  • TITLE: Microsoft SQL Server 2005 Setup (Developer Edition – 32bit)
    ——————————

    SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 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.

    Any idea how to fix this error? I really need to install MSSQL Server 2005.

    My System Spec. btw:
    OS: WIndows Vista Ultimate – SP1
    Processor: AMD Dual Core – 2GB RAM

    Please help.

    Thanks,
    Brainiacs

    Reply
  • Anyone find a fix for this yet?

    SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 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.

    Reply
  • I have installed windows vista ultimate and SQL Develpoer edition. Now i’m facing the error “Microsoft SQL Server,Error:18456” please help me on this.

    Reply
  • Hi,

    We are trying to install SQL SERVER 2005 Developer Edition on windows 7 32 bit.
    There is no error during the installation but SQL Server Management Studio is not shown. Can you please highlight on this?

    Reply
  • Hi,
    Need Help.

    I have tried to install SQL server 2005 Enterprise Edition on windows 7 ultimate.

    On the “Components to Install” screen it shows all options Disabled (greyed out). Only available option is “Work Station Components”. All other options like SQL Server database Services, Analysis Services, Reporting Services are not available.

    Can someone tell me whats wrong?

    I want to use Full Text Search for my project on search indexing.

    So installing SQL Express is not usefull i have to install SQL 2005 Enterprise.

    Thanks

    Maulik

    Reply

Leave a Reply

Menu