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 (http://blog.SQLAuthority.com)

About these ads

13 thoughts on “SQL SERVER 2005 – Vista Ultimate and SQL Server 2005 DEV Edition

  1. Pingback: SQL SERVER 2005 - FIX Error: 18456 : VISTA Windows Authentication Journey to SQL Authority with Pinal Dave

  2. 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.

    Like

  3. Pingback: SQL SERVER - Create Database Error in Windows Vista Journey to SQL Authority with Pinal Dave

  4. 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.

    Like

  5. 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.

    Like

  6. 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

    Like

  7. 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.

    Like

  8. 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.

    Like

  9. 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?

    Like

  10. 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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s