Search : in
By :

SQL Server 2005 intallation problem to Vista

Last answer on Nov 20, 2009 11:16:19 am GMT rehma, on Aug 12, 2008 7:23:09 am BST 
 Report this message to moderators

Hello,
I have installed SQL Server 2005 in my system, but I still have problem to in using it. I heard there is problems of installation of SQL in Vista, can somebody help me with ideas please

Configuration: Windows Vista
Firefox 3.0.1

Best answers for « SQL Server 2005 intallation problem to Vista » in :
Automatic backup of a Database in SQL EXPRESS 2005 ShowAutomatic backup of a Database in SQL EXPRESS 2005 If you want to automate a backup of a database in SQL Server Express, there is a simple solution using a .bat. file. Create a new text file. This file should contain the following...
Visual FoxPro and SQL Server ShowVisual FoxPro and SQL Server Visual Foxpro 9 and SQL Server 2005 Is there a better alternative than using Visual FoxPro to manage efficiently a SQL Server? Here's an interesting issue. For more information see the article:...
Visual FoxPro ShowVisual FoxPro Visual FoxPro (VFP) is a very powerful tool marketed by Microsoft since 1995. It includes a programming language, an engine for relational database and an integrated development environment (IDE), which allows developers...
Download Export Table To Text For Sql Server Show
Download SQL Server Backup ShowSQL Server Backup is a backup or recovery tool for Microsoft SQL Server. Its assistant will allow you to backup the SQL Server database on the local hard disk, in a shared network file or on a remote network. Easy to use, you can restore your...
Download SQL Script Builder Show
Backup ShowBackup Setting up a redundant architecture ensures that system data will be available but does not protect the data against user-introduced errors or against natural disasters such as fires, floods or even earthquakes. Therefore it is necessary to...
Ask your question Reply

1

Atul, on Aug 12, 2008 9:17:44 am BST

Hi rehma,

Actualy the SQL 2005 Server is compatible only with O/S Windows`s server 2003 and not with windows vista.

So please use windows server 2003 to installed the SQL server 2005

Regards
Atul

   
Reply to Atul

2

rehma, on Aug 12, 2008 2:22:35 pm BST
  • +1

Hi Atul
thanks
Do i have to uninstall Server 2005 before the installation of 2003?
ASP framework with Visual Studio got SQL, do i need to reinstall the SQL Server to make it work or i just have to configure the Connectivity thing? I'm so confused with this...
Please help me out.
Thank you for response
Regards
Rehma

   
Reply to rehma

3

Atul, on Aug 13, 2008 4:18:17 am BST
  • +1

Hi Rehma,

Yes you need to have Windows Server 2003 first and then you need to install the MSSQL server 2005 on it.

Hope this clear your confusion.

Cheer`s
Atul

   
Reply to Atul

4

murali, on Jan 5, 2009 7:01:49 pm GMT
  • +1

Hi....
Sql server 2005 sp1 won't work with Vista. so, download SQL 2005 sp2 to execute in vista

   
Reply to murali

5

Hema, on Jan 6, 2009 11:34:29 am GMT
  • +4

I Install Sql server 2005 on windows vista
No problem fro that
If any one want to know how
Just Send me mail at
anyounis@hotmail.com

   
Reply to Hema

7

Rav's, on Jan 27, 2009 12:01:43 pm GMT

Hi Hema,

am basically BI developer.
last week i tried to install sql server2005.it was success.
but when i try to connect the SSMS,i given default servername,but through the server name am unable to enter into the database.
i tried all possibilitieis.but coming to the BI-IDE,am able to connect.
SSAS is possible to connect to the server,but not possible to the database.
can you provide the best solution.
am waiting for youe reply.
Thanks in Advance,
Ravindra
(nv.ravindranathreddy@gmail.com)

   
Reply to Rav's

8

Jil, on Mar 6, 2009 9:11:54 pm GMT
  • +1

Open SSMS as adminstrator. It will connect to database then.

I had the same problem with SQL Server 2005 on Vista. I've un installed and installed it 3 times. but no use.

When I try to open ssms as adminstrator, it worked fine...Hope it will work for you too

   
Reply to Jil

9

Peter, on Apr 22, 2009 7:53:27 pm BST
  • +1

Hi

How do I open SSMS as an adminstrator?

Regards Peter

   
Reply to Peter

10

sasi, on Apr 27, 2009 9:16:54 am BST

Hello sir,
it is installing in vista but this is the error it is giving
can u help me out plz sir..

TITLE: Connect to Server
------------------------------

Cannot connect to SASI\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/...

can u help me out plzzz

   
Reply to sasi

6

ray, on Jan 13, 2009 2:31:22 pm GMT

Microsoft is withdrawing support for Sql server 2000

You can install Sqlserver 2005 on Vista, however before running,you should download Sql server 2005 Sp2 and run it.

Ray

   
Reply to ray

11

sam, on Apr 29, 2009 6:50:59 pm BST

I installed sql server 2005 enterprise edition trail and then downloaded service pack 2 but still doesn't work. any way around this?

   
Reply to sam

12

Slyy, on May 14, 2009 2:28:50 pm BST

All:

SQL is meant to be ran on Server OS' hence the poking SQL Server title. It is however possible to install SQL Server 2005 Developer Edition. This version of SQL can be installed under all the current versions of Windows XP thru Vista always you should install the latest service pack (SQL Server SP2).

good luck.

   
Reply to Slyy

13

Senthil, on May 17, 2009 10:18:47 am BST

After 3 weeks of search, i came to know that SQL Server 2005 enterprise edition wont work with Vista, instead of telling this in straight some websites made me to download sp2 unnecessarily.

Here's the conclusion: If you want to work with SQL server 2005 enterprise edition change you OS to Server 2003. Else be with Vista but install SQL server 2005 Developer Edition.

Even if you have Developer edition of SQL 2005 and vista, just make sure to check your computer name. There is a bug and your system name should be ALL caps for the SQL 2005 to install correctly.

   
Reply to Senthil

14

 zoubicom, on Nov 20, 2009 11:16:19 am GMT

Hi Everyone

i install SQL Server 2005 on Vista Home and it's worked ,no need to install anything except after install SQL Server go to SQL MANAGMENT STUDIO Located in Start Menu Right Click Choos Compatability The Check RUN THIS PROGRAM AS ADMINISTRATOR.

That's All.

Thank You

   
Reply to zoubicom
Ask your question Reply
They need your help