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.
"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
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
>
"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.
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.
"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
>>
SQL Express installation 
Linear Mode
