SQL Express installation

Posted: 10-24-2007, 10:55 PM
I have a database application which installs an instance of SQL Express and a
database schema with no actual data. The installation completes and I can
see that SQL and the database have bee installed in C:\Program Files but when
I try to run the application I could not login to the database - the error is
that the user (Windows authorization) is not permitted to login.

I downloaded and installed SQL management studio express in hopes that I
would be able to see what logins had been setup for the database. When I
started SQL management studio it could not find any database engine instance
to connect to even though I know one exists.

This all works on an XP Pro system so I think I have missed something
regarding all the new permissions issues with Vista.

What have I done wrong? Thanks.
--
Alan Bower

SQL Express installation


Responses to "SQL Express installation"

Richard G. Harper
Guest
Posts: n/a
 
Re: SQL Express installation
Posted: 10-24-2007, 11:04 PM
Ah - did you note that it is not supported on Vista?

--
Richard G. Harper [MVP Shell/User] rgharper@gmail.com
* NEW! Catch my blog ... http://msmvps.com/blogs/rgharper/
* PLEASE post all messages and replies in the newsgroups
* The Website - http://rgharper.mvps.org/
* HELP us help YOU ... http://www.dts-l.org/goodpost.htm


"Alan" <Alan@discussions.microsoft.com> wrote in message
news:EDC1399D-B5F3-4511-9850-95C51B89095E@microsoft.com...
>I have a database application which installs an instance of SQL Express and
>a
> database schema with no actual data. The installation completes and I can
> see that SQL and the database have bee installed in C:\Program Files but
> when
> I try to run the application I could not login to the database - the error
> is
> that the user (Windows authorization) is not permitted to login.
>
> I downloaded and installed SQL management studio express in hopes that I
> would be able to see what logins had been setup for the database. When I
> started SQL management studio it could not find any database engine
> instance
> to connect to even though I know one exists.
>
> This all works on an XP Pro system so I think I have missed something
> regarding all the new permissions issues with Vista.
>
> What have I done wrong? Thanks.
> --
> Alan Bower
Alan
Guest
Posts: n/a
 
Re: SQL Express installation
Posted: 10-24-2007, 11:31 PM
What's not supported on Vista?

The application source says their application will operate on Vista.

I assume SQL Express and SQL Management Studio will.

--
Alan Bower


"Richard G. Harper" wrote:
> Ah - did you note that it is not supported on Vista?
>
> --
> Richard G. Harper [MVP Shell/User] rgharper@gmail.com
> * NEW! Catch my blog ... http://msmvps.com/blogs/rgharper/
> * PLEASE post all messages and replies in the newsgroups
> * The Website - http://rgharper.mvps.org/
> * HELP us help YOU ... http://www.dts-l.org/goodpost.htm
>
>
> "Alan" <Alan@discussions.microsoft.com> wrote in message
> news:EDC1399D-B5F3-4511-9850-95C51B89095E@microsoft.com...
> >I have a database application which installs an instance of SQL Express and
> >a
> > database schema with no actual data. The installation completes and I can
> > see that SQL and the database have bee installed in C:\Program Files but
> > when
> > I try to run the application I could not login to the database - the error
> > is
> > that the user (Windows authorization) is not permitted to login.
> >
> > I downloaded and installed SQL management studio express in hopes that I
> > would be able to see what logins had been setup for the database. When I
> > started SQL management studio it could not find any database engine
> > instance
> > to connect to even though I know one exists.
> >
> > This all works on an XP Pro system so I think I have missed something
> > regarding all the new permissions issues with Vista.
> >
> > What have I done wrong? Thanks.
> > --
> > Alan Bower
>
Carey Frisch [MVP]
Guest
Posts: n/a
 
Re: SQL Express installation
Posted: 10-24-2007, 11:40 PM
For your application to work under Vista, you need the SP1
version of SQL Express, not the original one.

Microsoft SQL Server 2005 Express Edition Service Pack 1
http://www.microsoft.com/downloads/d...displaylang=en

--
Carey Frisch
Microsoft MVP
Windows Shell/User

---------------------------------------------------------------

"Alan" <Alan@discussions.microsoft.com> wrote in message news:EDC1399D-B5F3-4511-9850-95C51B89095E@microsoft.com...
I have a database application which installs an instance of SQL Express and a
database schema with no actual data. The installation completes and I can
see that SQL and the database have bee installed in C:\Program Files but when
I try to run the application I could not login to the database - the error is
that the user (Windows authorization) is not permitted to login.

I downloaded and installed SQL management studio express in hopes that I
would be able to see what logins had been setup for the database. When I
started SQL management studio it could not find any database engine instance
to connect to even though I know one exists.

This all works on an XP Pro system so I think I have missed something
regarding all the new permissions issues with Vista.

What have I done wrong? Thanks.
--
Alan Bower
Richard G. Harper
Guest
Posts: n/a
 
Re: SQL Express installation
Posted: 10-25-2007, 09:37 AM
I checked the download page and the SQL Server Management Studio Express
Edition says it only supports Windows 2000 SP4, Windows XP SP2 and Windows
Server 2003 SP1 - no Vista support listed.

--
Richard G. Harper [MVP Shell/User] rgharper@gmail.com
* NEW! Catch my blog ... http://msmvps.com/blogs/rgharper/
* PLEASE post all messages and replies in the newsgroups
* The Website - http://rgharper.mvps.org/
* HELP us help YOU ... http://www.dts-l.org/goodpost.htm


"Alan" <Alan@discussions.microsoft.com> wrote in message
news:5921C244-D481-4CB2-983F-0A989842D996@microsoft.com...
> What's not supported on Vista?
>
> The application source says their application will operate on Vista.
>
> I assume SQL Express and SQL Management Studio will.
>
> --
> Alan Bower
>
>
> "Richard G. Harper" wrote:
>
>> Ah - did you note that it is not supported on Vista?
>>
>> --
>> Richard G. Harper [MVP Shell/User] rgharper@gmail.com
>> * NEW! Catch my blog ... http://msmvps.com/blogs/rgharper/
>> * PLEASE post all messages and replies in the newsgroups
>> * The Website - http://rgharper.mvps.org/
>> * HELP us help YOU ... http://www.dts-l.org/goodpost.htm
>>
>>
>> "Alan" <Alan@discussions.microsoft.com> wrote in message
>> news:EDC1399D-B5F3-4511-9850-95C51B89095E@microsoft.com...
>> >I have a database application which installs an instance of SQL Express
>> >and
>> >a
>> > database schema with no actual data. The installation completes and I
>> > can
>> > see that SQL and the database have bee installed in C:\Program Files
>> > but
>> > when
>> > I try to run the application I could not login to the database - the
>> > error
>> > is
>> > that the user (Windows authorization) is not permitted to login.
>> >
>> > I downloaded and installed SQL management studio express in hopes that
>> > I
>> > would be able to see what logins had been setup for the database. When
>> > I
>> > started SQL management studio it could not find any database engine
>> > instance
>> > to connect to even though I know one exists.
>> >
>> > This all works on an XP Pro system so I think I have missed something
>> > regarding all the new permissions issues with Vista.
>> >
>> > What have I done wrong? Thanks.
>> > --
>> > Alan Bower
>>
 
LinkBack Thread Tools Display Modes
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server Express - installation failure freesing Windows XP Embedded 1 03-11-2008 12:58 AM
Outlook Express installation RMK Windows XP Embedded 1 08-23-2006 03:06 PM
Outlook Express after XP installation Ed Conroy Windows XP Basics 0 09-25-2003 05:32 AM
installation of Outlook Express Dorothy Windows XP 3 08-17-2003 04:59 AM
Installation Problem WinXP SP1 (Express) Fred Bowers Windows XP 0 07-29-2003 06:31 PM